Creating Batch Reports

When running SQLMON in batch mode, use the following commands in the job before invoking the screens:

SET ECHO ON: Echoes SQLMON commands on the $STDLIST.
SET DBENVIRONMENT: Specifies the DBEnvironment to be monitored.
SET CYCLE 1: Stops the display of screens after one refresh interval.
SET OUTPUT: Specifies the name of the file containing the batch report.

The following batch job runs SQLMON and copies the Static screen to an output file named Report1:

   ! JOB username.acctname

   !

   ! PURGE Report1

   !

   ! SQLMON

   SET ECHO ON

   SET DBENVIRONMENT PartsDBE

   SET CYCLE 1

   SET OUTPUT Report1

   STATIC

   EXIT

   !

   ! FCOPY FROM = Report1; TO = *LP

   !

   ! EOJ

Since SQLMON issues a prompt if the output file already exists, the PURGE statement purges the Report1 file before SQLMON is run. The FCOPY command prints the Report1 file.

Creating Batch Reports

Technical documentation

» Table of Contents

» Index