IDMS

Print Index - report output

  • 1.  Print Index - report output

    Posted Jan 14, 2007 10:59 PM
    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