Previous Topic: Example JCLNext Topic: Example Dump: INDOUBT Index Entries

VERINDEX (Verify Index) › Index to Data (INDEXDATA) › Sample Report: INDEXDATA

Sample Report: INDEXDATA

The following is a sample report of the INDEXDATA function.

Date: mm/dd/ccyy    ********************************************************************************         Page:     1
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ********************************************************************************
 
 FUNCTION=VERINDEX
                        DBID=00997
                        OPTION=INDEXDATA
                        TABLE=K01
 
 KEY RELATED STATISTICS:
  Œ               Ž                       
 KEYID   KEYNAME   MAST   MATCH_COUNT   ERROR_COUNT
     1     TST01      Y         21999             1
     2     TST02      N         21999             1
     3     TST03      N         21999             1
     4     TST04      N         21999             1
     5     TST05      N         21999             1
     6     TST06      N         21999             1
     7     TST07      N         21999             1
     8     TST08      N         21999             1
     9     TST09      N         21999             1
 FINAL STATISTICS:
   INDEX MATCHES        197991
   INDEX ERRORS              9
   I/O OPERATIONS        65688
                     DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)
Œ

KEYID displays the identification number of key.



KEYNAME displays the name of key.

Ž

MAST identifies whether the key is a Master Key. Set to Yes or No.



MATCH_COUNT displays the count of index entry key values found that matched data record key values.



ERROR_COUNT displays the count of the index entries that are in doubt. For each of the in doubt index values, a message and a dump of the key value are written to SYSLST. The following section displays an example of this output.