Hi all,
I have some questions about how to interpret the output of the ""PRINT INDEX"" command. I've looked inside the manuals, and its still not very clear. See sample display below of the first output line:
ODBK=EC4FAA01 SR8 NEC5AF206 SR8 PEC72CC07 ASC CUSH=50 SYM TKL=41 UNCM
Q1: What does ODBK mean? Something database key?
Q2: What is ""NEC5AF206"", and ""PEC72CC07""? They refer to the SR8.
Q3: What is CUSH=50?
Q4: What is SYM TKL=41?
ASC means ascending. UNCM means uncompressed.
See sample display below of the second output line:
L4 EC5AF206 NUME=5 U=FFFFFFFF N=EC50B106 P=EC4FAA01
RECL=2332 SPA=4772
L4 means it is an SR8 at the fourth level.
EC5AF206 is presumably the Key of this SR8?
Q5: What does NUME=5 mean?
Q6: What is ""U=FFFFFFFF"", ""N=EC50B106"", and ""P=EC4FAA01""?
Q7: What is SPA=4772?
Thanks very much.
Mike.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Re: Print Index - report output
"Hello Mike:
The ODBK is the owner data base key, if this is a system owned index then
the owner is an SR7, the N is NEXT DBKEY and the P is PRIOR DBKEY in the SR8
Chain, the cushion is the number of data base key slots + 1 left in the last
SR8 in the chain, the SYM TKL is the symbolic total key length - 1. In you
example the symbolic key must be 40 bytes.
NUME=5 means that there are five keys in this SR8, U=FFFFFFFF would be the
data base key or up pointer to another SR8 if this SR8 had orphans, you might
also see ORPH= right next to NUME=, this is the number of orphans in the SR8,
the N= and P= next and prior in the SR8 chain, SPA=4772 is the number of
bytes left in this SR8. This appears to be a very large SR8 Record.
Remember that a system owned index has an SR7 record as the owner, it is
stored CALC and the CALC key is the set name, the SR8 is the member record and
it is stored VIA the SR7.
Bill Allen
ARCH Consulting Associates, Ltd.
In a message dated 1/15/2007 12:10:33 A.M. Eastern Standard Time,
mikebaker345@HOTMAIL.COM writes:
Hi all,
I have some questions about how to interpret the output of the ""PRINT
INDEX"" command. I've looked inside the manuals, and its still not very
clear. See sample display below of the first output line:
ODBK=EC4FAA01 SR8 NEC5AF206 SR8 PEC72CC07 ASC CUSH=50 SYM TKL=41 UNCM
Q1: What does ODBK mean? Something database key?
Q2: What is ""NEC5AF206"", and ""PEC72CC07""? They refer to the SR8.
Q3: What is CUSH=50?
Q4: What is SYM TKL=41?
ASC means ascending. UNCM means uncompressed.
See sample display below of the second output line:
L4 EC5AF206 NUME=5 U=FFFFFFFF N=EC50B106 P=EC4FAA01
RECL=2332 SPA=4772
L4 means it is an SR8 at the fourth level.
EC5AF206 is presumably the Key of this SR8?
Q5: What does NUME=5 mean?
Q6: What is ""U=FFFFFFFF"", ""N=EC50B106"", and ""P=EC4FAA01""?
Q7: What is SPA=4772?
Thanks very much.
Mike.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Print Index - report output
"Hi all,
I have some questions about how to interpret the output of the ""PRINT
INDEX"" command. I've looked inside the manuals, and its still not very
clear. See sample display below of the first output line:
ODBK=EC4FAA01 SR8 NEC5AF206 SR8 PEC72CC07 ASC CUSH=50 SYM TKL=41 UNCM
Q1: What does ODBK mean? Something database key?
Q2: What is ""NEC5AF206"", and ""PEC72CC07""? They refer to the SR8.
Q3: What is CUSH=50?
Q4: What is SYM TKL=41?
ASC means ascending. UNCM means uncompressed.
See sample display below of the second output line:
L4 EC5AF206 NUME=5 U=FFFFFFFF N=EC50B106 P=EC4FAA01
RECL=2332 SPA=4772
L4 means it is an SR8 at the fourth level.
EC5AF206 is presumably the Key of this SR8?
Q5: What does NUME=5 mean?
Q6: What is ""U=FFFFFFFF"", ""N=EC50B106"", and ""P=EC4FAA01""?
Q7: What is SPA=4772?
Thanks very much.
Mike.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Re: Tune Index
"Mike,
If you look at your shutdown stats before you run tune index you may get
a swag by seeing if the levels searched has changed. Last time I ran a
several tune index that adopted millions of orphaned sr8's I saw the
levels searched drop from like 9 to 3. Not much to go on but better than
nothing, may not even change if the one index you tune is not the one
doing max levels searched, like I said just swag...
Steve Harmeson