Batch report parameters

When you run Db2 Query Monitor batch reports, you must edit several parameters.

Specify the PARM field of the appropriate EXEC statement using the following syntax:

PARM='DB2_SSID,PLAN'

DB2_SSID

Specifies the name of the Db2 subsystem (SSID) on which theDb2 Query Monitor tables reside.

PLAN

Specifies the name of the plan that was bound for batch reports.

Example:

//CQM@RDSC  EXEC  PGM=CQMDSC,REGION=5M,PARM='DB01,CQMDSC'

Update the HOSTVARS in-stream data set to specify start and end timestamps in the format yyyy-mm-dd-hh.mm.ss. Both values are required.

Example:

//HOSTVARS  DD    *
0001-01-01-00.00.00
3001-01-01-00.00.00
/*