Skip to Content

Default language.

SYSIN syntax in a separate data set

You can include all or part of the SYSIN syntax in a separate data set.

The following figure shows SYSIN syntax that includes a separate file as part of a BMC AMI Log Master filter. This technique allows you to dynamically generate a list of tables for each run of a job without changing your JCL.

Related topic

Specifying-Log-Master-syntax


JCL with SYSIN syntax in a separate data set

//SYSIN     DD *
 /* DB2DBA.$$WORKID0010                                              */
 /* DB2DBA 2022-02-18 14.21.58                                       */

  OPTION
     FILTERREL AND EXECUTION MODE CURRENT

  SORTOPTS
     FILSZ NONE
     HISTORY WRITE

  WORKID DB2DBA.$$WORKID0010
     DESC 'DB2DBA 2022-02-18 14.21.58 MIGRATE'

  LOGSCAN
     REPORT TYPE SUMMARY
        SYSOUT
           CLASS(*) NOHOLD
     DB2CATALOG NO
     FROM  DATE(2022-02-18) TIME(12.39.00.000000)
     TO  DATE(2022-02-18) TIME(13.50.00.000000)
     WHERE
        TABLE NAME IN (
//          DD DSN=DB2DBA.TABLIST.DATA,DISP=SHR
//          DD *,DLM=##
                       )
##
//SQLCODES DD DUMMY


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Log Master for Db2 13.1