What do the various abbreviations in the PRINT INDEX utility mean?

Document ID : KB000054694
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

What do the various abbreviations in the PRINT INDEX utility mean?

Answer:

The IDMSBCF PRINT INDEX utility provides a report on the system-owned and user-owned indexes and indexed sets. The report contains abbreviations that are not documented in the CA IDMS Utilities Manual. This article provides the descriptions for the PRINT INDEX utility report abbreviations.

Figure 1

ASC = Ascending order
COMP = the index is defined to use key Compression
CUSH = Index cushion size, a field that?s the length of the largest possible index entry
DSC = Descending order
ODBK = Index owner?s dbkey
Ln = Level numbers
N = SR8 Next pointer dbkey
NUME = Number of index entries in the specified SR8
ORPH = Orphan count for the specified SR8 (the number of entries that have been moved to another SR8 due to splitting)
P = SR8 Prior pointer dbkey
RECL = Record Length of the SR8 (the prefix length + data length + line index [8 bytes])
SPA = Shows the space available count for the page where the SR8 is located
SYM = The index is sorted on a symbolic key.
TKL = The length of the symbolic key
U = SR8 up pointer dbkey
UNCM = The index is defined to NOT use key Compression
*ORPHAN*OF* = An indication that a member's index entry has been moved from the original SR8 to another due to splitting

Additional Information:

CA IDMS Database Administration Guide, Chapter 24, Indexing Efficiency, Useful Statistics to Monitor

CA IDMS Reports Guide, Chapter 9, SREPORT 003 IDMS-DC System Statistics, 11.3 Batch reporting facilities

CA IDMS Utilities Guide, Chapter 5: PRINT INDEX Sample Output, Chapter 6: IDMSDBAN utility report 5: Set Analysis