Creating Batch Reports

To generate a batch report containing SQLMON screen displays, create a file of SQLMON commands that will be used as input to SQLMON. The command file must include a SET CYCLE command to stop the display of the screens after some number of refresh intervals, and a SET OUTPUT command to specify the name of the file to which output will be sent.

For example, you can copy the Static screen to an output file named Report1. To do so, use a text editor to create a file named BatchIn, and add the following SQLMON commands to it:

   SET ECHO ON

   SET DBENVIRONMENT PartsDBE

   SET CYCLE 1

   SET OUTPUT Report1

   STATIC

   EXIT

Before you run SQLMON, remove any earlier versions of Report1:

   % rm Report1

Run SQLMON, using BatchIn as input and redirecting output to /dev/null to prevent the screens from appearing on standard output:

   % sqlmon < BatchIn > /dev/null

When SQLMON finishes executing, you can print Report1 to create a hard copy of the Static screen:

   % lp Report1