Using the Catalog Synchronization Utility › Using the Catalog Synchronization Utility Reports › Using the CADB2SY2 Reports › CADB2SSV—Synchronization Control Statement Report › CADB2SCP—Extract Exception Trace

CADB2SCP—Extract Exception Trace

The CADB2SCP report (Extract Exception Trace) provides exception information for each batch of synchronization control statements. The report header shows the batch number. Exceptions occur when the synchronization utility cannot find users or resources the input control statements request. The exception information included in this report lists:

• Users and DB2 resources that do not exist
• Selection criteria for which no matches were found.

A sample extract exception trace report is shown below.

‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
04/11/99 10.05              CADB2SCP DB2 SYNCHRONIZATION UTILITY ‑ EXTRACT EXCEPTION TRACE         BATCH   1  PAGE   1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑

         KEYWORD       KEYWORD                           EXCEPTION
         TYPE          VALUE                             REASON
         ============  ================================  =======================================================
         USER          ARDUV03                           USER NOT IN LOGONID DATABASE
         USER          WGGAB01                           USER NOT IN LOGONID DATABASE
         TBL           ACCTPAY.XREF                      TABLE NOT IN DB2 CATALOG
         TBL           ORDER.DV‑                         NO TABLE IN DB2 CATALOG MATCHING THIS MASK

This report is empty if no exceptions were found.