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

CADB2SCP—User ID Extract Trace

The CADB2SCP report (User ID Extract Trace) provides the reason for including or excluding each logonid in a synchronization batch. CADB2SY2 extracts from the Logonid database all logonids requested in the synchronization control statements. The result can be a series of specifically defined logonids, a list of all logonids that match a masked value in a control statement, or a combination of both specifications.

If you masked even one entry in your input control statement, the report lists all values in alphanumeric order. If you used no masked entries in this synchronization, the values are listed in the order in which you specified them, with the exception of the PUBLIC user ID. PUBLIC is listed last if your input contained no masks or if there is no PUBLIC user ID in the Logonid database.

For each entry, CADB2SCP displays:

1. Whether the logonid matched the INCLUDE statement or the EXCLUDE statement
2. The reason (the pertinent keyword) that the logonid matched the statement.

   ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
   04/11/99 10.05               CADB2SCP DB2 SYNCHRONIZATION UTILITY ‑ USERID EXTRACT TRACE           BATCH   1  PAGE   2
   ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
   
                                 CA‑ACF2        INCLUDE  KEYWORD   KEYWORD
                                 LOGONID        EXCLUDE  REASON    VALUE
                                 =============  =======  ========  ========================
                                 RRUS8          INCLUDE  IF        SECURITY
                                 USER1          INCLUDE  USER      USER‑
                                 USER2          EXCLUDE  USER      USER2
                                 USER3          EXCLUDE  USER      USER3
                                 USER4          EXCLUDE  UID       ********RESEARCH
                                 USER5          INCLUDE  IF        DB2PROD
                                 USER6          INCLUDE  USER      USER‑
                                 USER7          INCLUDE  USER      USER‑
                                 TEST1          INCLUDE  USER      TEST*
                                 TEST2          INCLUDE  USER      TEST*
                                 PUBLIC         INCLUDE  <SYSTEM>  <GRANT TO PUBLIC>
   

This report is empty if no users were included or excluded.