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

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

book

Article ID: 54694

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

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