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
i=
ncomplete or perhaps wrong.
=20
Steven Kuske,
The State of Iowa



The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] 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