Start of change

Consolidating messages into a single file

Some batch interface jobs produce multiple output files, each of which contain a number of messages. To simplify troubleshooting, you can consolidate these messages into one file, or data set. You can do this consolidation for batch jobs for functions such as Change Management (CM) batch interface, ALT, Compare, and ADBTEP2.

About this task

Start of changeWhen you request that messages are consolidated into one file, the messages are still included in the original output files. They are just repeated in the consolidated file. This consolidated file also includes any warning messages about unsupported DML statements and any requested object comparison reports.End of change

Procedure

To consolidate messages into a single file, in the batch interface JCL procedure, add the ADBMSGS DD statement to specify the data set where you want the messages consolidated.

Example ADBMSGS DD statements:

  • //ADBMSGS DD SYSOUT=*
  • //ADBMSGS DD DISP=(MOD,CATLG),DSN=TS5781.SAMPLE.OUTPUT5,
// SPACE=(CYL,(2,1)) 
  • //ADBMSGS DD DISP=(MOD,CATLG),DSN=TS5781.SAMPLE.OUTPUT5,
// SPACE=(CYL,(2,1)),
// DCB=(LRECL=137,RECFM=VBA,DSORG=PS)

This data set that you defined to contain the consolidated messages is referred to as the ADBMSGS data set.

Tip: Start of changeADBMSGS always includes a list of the initial and profile values for CM batch parameters that are not blank. Additionally, if you want ADBMSGS to include the CM batch parameter values that were provided in an invocation override and the final CM batch parameter values that were used, set the CM batch parameter list_options to Y.End of change
Start of change

The following snippets show examples of content that is written to the ADBMSGS data set. Notice that messages in ADBMSGS include the module name, such as ADBCDTS or ADB2REE.

Start of changeThe following example shows how the Change Management (CM) batch parameter values are reported. Notice that in this example, three lists of parameter values are included, because the CM batch parameter list_options was set to Y. The beginning of each of these lists is identified by message ADB7957I.End of change

Start of change
1ADB7956I ADBCCM   CM batch: Start of CM batch

 ADB7957I ADBCCM   CM batch parameters-init and PROF:
                   ADBTEP2_RETRY_DEPRECATED_OBJ='YES';
                   AUTH_SWITCH_USERID='<NONE>';
                   AUTH_SWITCHING_ENABLED='Y';
                   JOB_JCLLIB_LINE_1='//ADBPROC JCLLIB ORDER=TSLHC.CMBATCH.PROCLIB';
                   JOB_PARM_LINE_1='S=RS22';
                   LIST_OPTIONS='N';
                   LOAD_ACCELERATED_TABLES_LOCK_MODE='TABLESET';
                   PLAN_NAME_IS_ALTERNATE='Y';
                   SCOPE_WARNING='NO';
                   SSID='DC1A';
                   USE_DSNUTIL_SP='YES';
                   UTIL_CLONE_TEMPLATE_COPYDDN1_USE='S';
                   UTIL_CLONE_TEMPLATE_COPYDDN2_USE='S';
                   UTIL_CLONE_TEMPLATE_DISCARDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_ERRDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_FCCOPYDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_LOBCOL_USE='S';
                   UTIL_CLONE_TEMPLATE_MAPDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_PUNCHDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_RECOVERYDDN1_USE='S';
                   UTIL_CLONE_TEMPLATE_RECOVERYDDN2_USE='S';
                   UTIL_CLONE_TEMPLATE_UNLDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_UNLOAD_PUNCHDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_UNLOAD_PUNCHDDNC_USE='S';
                   UTIL_CLONE_TEMPLATE_UNLOAD_UNLDDN_USE='S';
                   UTIL_CLONE_TEMPLATE_UNLOAD_UNLDDNC_USE='S';
                   UTIL_CLONE_TEMPLATE_WORKDDN1_USE='S';
                   UTIL_CLONE_TEMPLATE_WORKDDN2_USE='S';
                   UTIL_CLONE_TEMPLATE_XMLCOL_USE='S';
                   UTIL_REORG_INDEX_SORTNUM='4';
                   UTIL_REORG_SORTNUM='4';
                   UTIL_TEMPLATE_COPYDDN1_USE='S';
                   UTIL_TEMPLATE_COPYDDN2_USE='S';
                   UTIL_TEMPLATE_DISCARDDN_USE='S';
                   UTIL_TEMPLATE_ERRDDN_USE='S';
                   UTIL_TEMPLATE_FCCOPYDDN_USE='S';
                   UTIL_TEMPLATE_LOBCOL_USE='S';
                   UTIL_TEMPLATE_MAPDDN_USE='S';
                   UTIL_TEMPLATE_PUNCHDDN_USE='S';
                   UTIL_TEMPLATE_RECOVERYDDN1_USE='S';
                   UTIL_TEMPLATE_RECOVERYDDN2_USE='S';
                   UTIL_TEMPLATE_UNLDDN_USE='S';
                   UTIL_TEMPLATE_UNLOAD_PUNCHDDN_USE='S';
                   UTIL_TEMPLATE_UNLOAD_PUNCHDDNC_USE='S';
                   UTIL_TEMPLATE_UNLOAD_UNLDDN_USE='S';
                   UTIL_TEMPLATE_UNLOAD_UNLDDNC_USE='S';
                   UTIL_TEMPLATE_WORKDDN1_USE='S';
                   UTIL_TEMPLATE_WORKDDN2_USE='S';
                   UTIL_TEMPLATE_XMLCOL_USE='S';
 ADB7957I ADBCCM   CM batch parameters-PARMS DD applied:
                   ACCEPT_FL='507';
                   ACTION_ANALYZE_CHANGE='Y';
                   ACTION_BUILD_RUN_JOB='Y';
                   ACTION_COMPARE='N';
                   ACTION_IMPORT_CHANGE='Y';
                   ACTION_RUN_CHANGE='Y';
                   ADBTEP2_RETRY_DEPRECATED_OBJ='YES';
                   AUTH_SWITCH_USERID='<NONE>';
                   AUTH_SWITCHING_ENABLED='Y';
                   CHANGE_NAME='ADB10376';
                   EXISTING_DATA_SET_ACTION='REPLACE';
                   IMPORT_PENDING_CHANGE_ACTION='S';
                   JOB_JCLLIB_LINE_1='//ADBPROC JCLLIB ORDER=TSLHC.CMBATCH.PROCLIB';
                   JOB_PARM_LINE_1='S=RS22';
                   LIST_OPTIONS='Y';
...
 ADB7957I ADBCCM   CM batch parameters-final:
                   ACCEPT_FL='507';
                   ACTION_ANALYZE_CHANGE='Y';
                   ACTION_BUILD_RUN_JOB='Y';
                   ACTION_CANCEL_CHANGE='N';
                   ACTION_COMPARE='N';
                   ...
                   LIST_OPTIONS='Y';
...
 ADB7956I ADBCCM   CM batch: Start of Import phase
1ADB7953I ADB2CID  ADB2CID - Import changes - 2020-07-06 19:05
 ADB7953I ADBCDTS  ADBCDTS - Create Version File from DDL File                           2020-07-06 19:05
 ADB7953I ADBCDTS  Using DB2 DECP Version 1215  startup parameters for SSID DC1A
...
End of change

The following example shows additional content that can be included in ADMSGS:

1ADB7956I ADBCCM   CM batch: Start of CM batch
...
 ADB7953I ADBCDTS  DB2 DSNHDECP values for this run :
 ADB7953I ADBCDTS  DB2 Version, Release and Mod Level : 1215            Default CCSID for EBCDIC SBCS      : 00037
 ADB7953I ADBCDTS  Decimal point option               : '.'             Default CCSID for EBCDIC Mixed     : 00002
 ADB7953I ADBCDTS  Subsystem ID                       : DC1A            Default CCSID for EBCDIC DBCS      : 00002
 ADB7953I ADBCDTS  Graphic for DBCS data              : No              Default CCSID for ASCII SBCS       : 00437
 ADB7953I ADBCDTS  Date format                        : USA             Default CCSID for ASCII Mixed      : 00002
 ADB7953I ADBCDTS  Time format                        : ISO             Default CCSID for ASCII DBCS       : 00002
 ADB7953I ADBCDTS  Default encoding scheme            : EBCDIC          Default CCSID for UNICODE SBCS     : 00367
 ADB7953I ADBCDTS  DB2 Version 12 New Function Mode   : No              Default CCSID for UNICODE Mixed    : 01208
 ADB7953I ADBCDTS                                                       Default CCSID for UNICODE DBCS     : 01200
 ADB7713I ADBCDTS  The DDL reader is processing under the authorization ID for the TSLHC schema. The authorization
                   ID can be changed by the SET CURRENT SCHEMA statement.
  
 ...

 ADB1057I ADB2REE  Copy Stogroup Grant(s)  : No
 ADB1058I ADB2REE  Copy Database Grant(s)  : Yes    Copy Table Space Grant(s): Yes    Copy Table Grant(s)  . . : Yes
 ADB1059I ADB2REE  Copy View Grant(s)  . . : Yes    Copy authorizations on referenced schema(s)  . . . . . . . : Yes
 ADB1060I ADB2REE  Copy U.def type Grant(s): Yes    Copy Function Grant(s) . : Yes    Copy Procedure Grant(s)  : Yes
 ADB1198I ADB2REE  Copy Sequence Grant(s)  : Yes    Copy Variable Grant(s) . : Yes
 ADB1079I ADB2REE  Insert COMMIT statement after every definition.
 ADB1085I ADB2REE  RE will generate all parameters even if they take default values.
 ADB1086I ADB2REE  RE will generate all implicitly referenced objects.
 ADB1095I ADB2REE  RE will convert auxiliary table requests to the respective base table.
 ADB1096I ADB2REE  DB2 pending changes will be merged into CREATE statements.
 ADB1101I ADB2REE  XML type modifiers defined using the following syntax
                   URI target-namespace LOCATION schema-location-uri
                   will be generated using the following syntax
                   ID registered-XML-schema-name
                   because the DB2 catalog does not have enough externalized information to distinguish between
                   these two types of syntax.
 ADB1609W ADB2REM  View DB2IVP0.VLE_FSA_REPORTING_BP not found
 ADB1609W ADB2REM  Alias DB2IVP0.VLE_FSA_REPORTING_BP not found
 ADB1609W ADB2REM  Table DB2IVP0.VLE_FSA_REPORTING_BP not found
 ADB1609W ADB2REP  Synonym DB2IVP0.VLE_FSA_REPORTING_BP not found
 ADB1176I ADB2REE  ADB2GEN - Summary of catalog records written
                   Number of catalog records written:       1
 ADB1024I ADB2REE  ADB2GEN - Ended with warnings
1ADB7956I ADBCCMM  ADBCCMM - Merge Version Files
 ADB8998I ADB2CMP  ==================  Start of Report  ============================================================

           Parameters for this run :

           ANALYZE mode produces change statements intended for the Analyze process of CM,
           report has content (messages and actions) that are unique to this mode.

           Suppress DROP of objects  : No
           Suppress DROP of columns  : No
           Suppress adding columns   : No


 ANALYZE OBJECT COMPARISON REPORT
 ================================

 Original values will be applied to ignored fields of new objects.

           Source:
                   Extracted from location                  at 2019-04-19 14:41 by TSLHC
           Target:
                   Extracted from location                  at 2019-04-19 14:41 by TSLHC

           Target system is DB2 Release 1215

 View DB2IVP0.VLE_FSA_REPORTING_BP not found on target
   New View DB2IVP0.VLE_FSA_REPORTING_BP will be added

 GOC2CMP - Ended normally in ANALYZE mode

 ADB8999I ADB2CMP  ==================  End of Report  ============================================================

1ADB9354I ADBCUPC  Analyze completed successfully.  The change status has been updated to
                   ANALYZED for change "TSLHC"."CM1_ADB2699" (ID= 2).
 ...
 ADB7956I ADBCCM   CM batch: End of CM batch
End of change
End of change