Previous Topic: Sample JCLNext Topic: Object Consistency Analyzer Sample Report

SQL Object Consistency Analyzer and Upgrade Rebind Utilities › SQL Object Consistency Analyzer › Running the SQL Object Consistency Analyzer › Sample JCL › General Utility Sample Report

General Utility Sample Report

Following are two pages of a General Utility report. For a sample header for this report, see Sample Report Headers.

CONSTRAINT REBIND  SUCCESSFUL  FOR TABLE sysadm.testplan1
CONSTRAINT REBIND  SUCCESSFUL  FOR TABLE sysadm.testplan2
CONSTRAINT REBIND  SUCCESSFUL  FOR TABLE sysadm.testplan3
SUCCESSFULLY REBOUND VIEW sysadm.testview1
SUCCESSFULLY REBOUND VIEW sysadm.testview2
SUCCESSFULLY REBOUND VIEW sysadm.testview3
SUCCESSFULLY REBOUND PLAN sysadm.testplan1
REBIND FAILED FOR PLAN    sysadm.testplan2 - SEE PXX FOR ERRORS
SUCCESSFULLY REBOUND PLAN sysadm.testplan3
SUCCESSFULLY REBOUND PLAN sysadm.testplan4


 
                                **** RELEASE BOUNDARY UPGRADE REBIND SUMMARY *********
                                *                                                      *
                                ********************  CONSTRAINTS  *********************
                                *                                                      *
                                * CONSTRAINED TABLES ALREADY REBOUND       : nnnnnnnnn *
                                * CONSTRAINED TABLES SUCCESSFULLY REBOUND  : nnnnnnnnn *
                                * CONSTRAINED TABLES WITH REBIND ERRRORS   : nnnnnnnnn *
                                * TOTAL CONSTRAINED TABLES                 : nnnnnnnnn *
                                *                                                      *
                                ********************  VIEWS   **************************
                                *                                                      *
                                * VIEWS              ALREADY REBOUND       : nnnnnnnnn *
                                * VIEWS              REBOUND               : nnnnnnnnn *
                                * VIEWS              WITH REBIND ERRORS    : nnnnnnnnn *
                                * TOTAL VIEWS                              : nnnnnnnnn *
                                *                                                      *
                                ********************  PLANS   **************************
                                *                                                      *
                                * PLANS             ALREADY REBOUND        : nnnnnnnnn *
                                * PLANS             REBOUND                : nnnnnnnnn *
                                * PLANS             WITH REBIND ERRORS     : nnnnnnnnn *
                                * TOTAL PLANS                              : nnnnnnnnn *
                                *                                                      *
                                ********************************************************