HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

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.

MPE/iX 5.0 Documentation