ca.portal.admin

Re:Re: IDMS-L Digest - 20 Apr 2010 to 21 Apr 2010 (#2010-63)

Discussion created by ca.portal.admin on Apr 22, 2010
Can anyone provide a calculation for integrated indexes that takes these 3 inputs;
Pagesize
Number of full SR8's per page( we usually choose 3 )
Maximum Keylength

and produces the correct value for;
Index Block Contains

Thanks. There are several formulas in the Listserve logs that seem to be incomplete or perhaps wrong.

Steven Kuske,
The State of Iowa
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Integrated index calculation request
"i have a CULPRIT (imagine that) that accepts keysize, load count,
runcount, and (optionally) page size

it shows the resulting index information (IBC, displacement, page reserve,
and other stuff)

I will post it shortly

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly






From:
""Cherlet, Gary (JTS)"" <Gary.Cherlet@SA.GOV.AU>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
04/21/2010 07:23 PM
Subject:
[IDMSVENDOR-L] Integrated index calculation request
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



If anybody has a spreadsheet that implements the formula requested below -
=
I would be glad to ""publish"" it on the IUA's User Contributed Library page
=
- please send to me offline - TIA - cheers - Gary =20

Here's original request from IDMS-L:

Can anyone provide a calculation for integrated indexes that takes these 3
=
inputs;
Pagesize
Number of full SR8's per page( we usually choose 3 )
Maximum Keylength

and produces the correct value for;
Index Block Contains

Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613
MailTo:gary.cherlet@sa.gov.au

This e-mail message and any attachments are qualified as follows:
Addressin=
g: If you have received this e-mail in error, please advise by reply
e-mai=
l to the sender. Please also destroy the original transmission and its
con=
tents. Confidentiality: This e-mail may contain confidential information
w=
hich also may be legally privileged. Only the intended recipient(s) may
ac=
cess, use, distribute or copy this e-mail. Individual Views: Unless
otherw=
ise indicated, the views expressed are those of the sender, not Justice
Tec=
hnology Services. Computer Viruses: It is the recipient's responsibility
t=
o check the e-mail and any attached files for viruses.

Outcomes