Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Apptune for Db2 13.1.

SYSIN control statement parameters

Parameters for SYSIN control statements are described in the following table:

Examples using DATASOURCE

In the following example that uses DATASOURCE, the statement generates the Plan Analysis report (SQMCACTP) from the archive data set that is allocated to the DD ARCHDD:

Example
DATASOURCE (ARCHIVE_DD(ARCHDD))
REPORT(NAME(SQMCACTP))      

In the following example that uses DATASOURCE, the statement generates the same report from the active data sets for the DOM1 Data Collector (waiting no more than 30 minutes for a connection):

Example
DATASOURCE (COLLECTOR(DOM1) MAX_WAIT(30))
REPORT(NAME(SQMCACTP))   


(SPE2006 applied) In the following example that uses DATASOURCE, the statement generates the same report from both the archive data sets and the active data sets for the DOM1 Data Collector (waiting no more than 30 minutes for a connection):

Example
DATASOURCE (COLLECTOR(DOM1) MAX_WAIT(30) INCLUDE_ARCH)
REPORT(NAME(SQMCACTP))     

In the following example that uses REPORT_DD, the statement generates two reports, routing SQMCACTS to the ddname FIRST and SQMCACTP to the ddname SECOND:

Example
DATASOURCE (COLLECTOR(DOM1) MAX_WAIT(30))   
REPORT(NAME(SQMCACTS REPORT_DD(FIRST))  )   
REPORT(NAME(SQMCACTP REPORT_DD(SECOND)) )  

Related topic

SYSIN-control-statements


 

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