Space banner

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Reporting

This topic describes the Next Generation Technology Check for DB2 for z/OS (NGT Check) product reports.

Reporting when no discrepancies are found

 If there are no discrepancies between the index and its table, NGT Check writes a report to that effect to the SUMMARY DD.
 

The number in parentheses indicates the partition number. If the message is for a nonpartitioning index, the number in parentheses is 0. The following figure illustrates a report for a two-partition table space with one partitioning index and two nonpartitioning indexes:

NGTB120 - CHECK SUCCESSFUL FOR INDEX C040IX01 (1), 500  ROWS.
NGTB120 - CHECK SUCCESSFUL FOR INDEX C040IX01 (2), 496  ROWS.
NGTB120 - CHECK SUCCESSFUL FOR INDEX C040IX03 (0), 996  ROWS.
NGTB120 - CHECK SUCCESSFUL FOR INDEX C040IX02 (0), 996  ROWS.

For details of the SUMMARY DD, see NGT Automation reference information .

Reporting when discrepancies are found

If there are discrepancies between an index and the table, NGT Check issues information about those discrepancies.
 

NGT Check writes a discrepancies summary report to the SUMMARY DD. The number in parentheses indicates the partition number. If the message is for a non-partitioning index, the number in parentheses is 0. The following figure illustrates an example discrepancies summary report:

NGTB120 - CHECK SUCCESSFUL FOR INDEX C040IX01 (1), 500  ROWS.             
NGTB120 - CHECK SUCCESSFUL FOR INDEX C040IX01 (2), 496  ROWS.             
NGTB120 - CHECK SUCCESSFUL FOR INDEX C040IX03 (0), 996  ROWS.             
                                                                          
NGTB990 - STARTING ERROR ANALYSIS:                                        
NGTB990 - INDEX = BI12DWW.C040IX02                                        
NGTB990 - TABLE = BI12DWW.TEST_TS0040_TBL0                                
NGTB990 - TBSPC = BI12DWW9.PART0040                                       
NGTB990 -                                                                 
NGTB990 - IXDSN = BI12V90V.DSNDBC.BI12DWW9.C040IX02.I0001.A001            
NGTB990 -                                                                 
                                                                          
NGTB909 - IX BI12DWW9.C040IX02 - 4 ERRORS, 4 RECORDED, MAXERROR = 7952,57

The SYSERROR output includes the discrepancies summary report and the additional details that appear in the following example:

NGTB909 - IX BI12DWW9.C040IX02 - 4 ERRORS, 4 RECORDED, MAXERROR = 7952,576                    
NGTB909 - 2 TSPC ROWS WITH NO MATCHING INDEX ENTRY                                            
NGTB909 - 2 INDEX KEYS WITH NO MATCHING TS ROW                                                
NGTB909 - TS ROW HAS NO IX ENTRY POINTING TO IT - TSPG 00000006, RW 26, IX C040IX02           
                                                                                              
NGTB909 -   TSKEY - 00C100E7C1 C3C5404040 C8C5D3D3D6 4040404040 20060428     A XACE   HELLO
                                                                                              
NGTB909 - TS ROW HAS NO IX ENTRY POINTING TO IT - TSPG 00000006, RW 27, IX C040IX02           
                                                                                              
NGTB909 -   TSKEY - 00C100E7C1 C3C5404040 C8C5D3D3D6 4040404040 20060428     A XACE   HELLO
                                                                                              
NGTB909 - IX ENTRY HAS NO MATCHING TS ROW, TSPG 0000000A, RW 2, IXPAGE 00000003, IX C040IX02  
                                                                                              
NGTB909 -   IXKEY - 00C200C3C4 C5D3E3C140 C5C3C8D640 4040404040 20070101     B CDELTA ECHO 
                                                                                              
NGTB909 - IX ENTRY HAS NO MATCHING TS ROW, TSPG 0000000A, RW 22, IXPAGE 00000003, IX C040IX02 
                                                                                              
NGTB909 -   IXKEY - 00C200C3C4 C5D3E3C140 C5C3C8D640 4040404040 20070101     B CDELTA ECHO 
                                                                                              
NGTB117 - RUN TERMINATED - 1 INDEXES WITH ERRORS.

This example report shows that NGT Check found four discrepancies.

You can use the +MAXPRINT parameter to limit the number of reported errors and reduce runtime. 

For details of the SUMMARY DD, see NGT Automation reference information .

Was this page helpful? Yes No Submitting... Thank you

Comments