ca.portal.admin

Print Index - report output

Discussion created by ca.portal.admin on Jan 15, 2007
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
" <<Picture (Enhanced Metafile)>>

<<Picture (Enhanced Metafile)>>


For system-owned index, the owner record type is SR7.
For user-owned index, the owner record type is another user-defined record

Using the above diagram as an example,

ODBK=EC4FAA01 SR8 NEC5AF206 SR8 PEC72CC07 ASC CUSH=50 SYM TKL=41 UNCM

Q1: What does ODBK mean? Something database key?
ODBK points to the dbkey of the owner record of the index set
Q2: What is ""NEC5AF206"", and ""PEC72CC07""? They refer to the SR8.
NEC5AF206 - First letter ""N"" is the next dbkey ""EC5AF206""
PEC72CC07 - First letter ""P"" is the prior dbkey ""EC72CC07""
Q3: What is CUSH=50?
CUSH=50 is the cushion in the SR8 record, the length in bytes of which can hold the largest possible index entry

Q4: What is SYM TKL=41?
SYM = symbolic key of total key length (TKL) of 41 bytes

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?
NUME=5 means the number of index entries in the SR8, e.g. 5
Q6: What is ""U=FFFFFFFF"", ""N=EC50B106"", and ""P=EC4FAA01""?
U = Up pointer dbkey, points to the SR8 that contains member index entry
N = Next dbkey, points to the next SR8
P = Prior dbkey, points to the prior SR8
Q7: What is SPA=4772?
SPA=4772 refers to the record length of the SR8 (pointers + data)

Regards,
Paul Mak
EDS | Australia ADU | Data Engineering Capability - DBA |
Level 1, 36-46 George Street, Burwood, NSW 2134 |
Office: +61 2 9012 5434 | Mobile: +61 419 398 116 |
Fax: +61 2 9012 6707 | Email: paul.mak@eds.com <mailTo:peter.forbes@eds.com> |

Outcomes