What do the various abbreviations in the PRINT INDEX utility mean?
Article ID: 54694
Updated On:
Products
Issue/Introduction
The PRINT INDEX FULL utility report has several abbreviations not explicitly documented in the Utilities guide.
Environment
IDMS - All Supported Releases
Resolution
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.
PRINT INDEX EMP-NAME-NDX SEGMENT EMPDEMO USING EMPSS01 FULL;
*+ Status = 0 SQLSTATE = 00000
*+ SET=EMP-NAME-NDX
*+ OWNER=SR7 PAGE GROUP=0 RECORDS PER PAGE=255
*+ ODBK=0124FA01 SR8 N0124FA03 SR8 P0124FA02 ASC CUSH=33 SYM TKL=24 COMP
*+ COMP
*+ MEMBER=EMPLOYEE PAGE GROUP=0 RECORDS PER PAGE=255
*+ L1 0124FA03 NUME=2 U=FFFFFFFF N=0124FA04 P=0124FA01
*+ RECL=1388 SPA=1388
*+ 0124FA04 JENSON RUPERT
*+ 0124FA02 ZEDI BETSY
*+ L0 0124FA04 NUME=25 U=0124FA03 N=0124FA02 P=0124FA03
*+ RECL=632 SPA=1388
*+ 0125110D ANDALE ROY
*+ 01250F0A ANGELO MICHAEL
*+ 01252204 ARM HARRY
*+ 01251A01 BANK MONTE
*+ 01251101 BLOOMER JUNE
*+ 01251F05 BOWER CHARLES
*+ 0125150A BREEZE C.
*+ 01252402 BRENDLINGER SUSAN
*+ 01250701 CLOTH TERRY
*+ 01252601 CRANE HERBERT
*+ 01251A04 CROW CAROLYN
*+ 0125050A DONOVAN ALAN
*+ 01250401 DOUGH JANE
*+ 01251B01 FERNDALE JANE
*+ 01250C01 FONRAD GEORGE
.
.
.
*+ MEM 0125110D U=0124FA04
*+ 01250F0A U=0124FA04
*+ 01252204 U=0124FA04
*+ 01251A01 U=0124FA04
*+ 01251101 U=0124FA04
*+ 01251F05 U=0124FA04
*+ 0125150A U=0124FA04
*+ 01252402 U=0124FA04
*+ 01250701 U=0124FA04
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, Index Management
CA IDMS Utilities Guide, PRINT INDEX
Feedback
