HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 9 SQLMON Command Reference

SET OUTPUT

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Saves SQLMON screen images in a file

Scope

SQLMON Only

SQLMON Syntax

SET OUTP [UT] [ SystemFileName OFF ]

Parameters

SystemFileName

Echoes the screens that SQLMON displays on standard output to SystemFileName.

OFF

Does not echo screens to a file. The default value.

Description

  • If you issue a SET OUTPUT command with a filename, and if the file does not exist, SQLMON creates it.

  • If you issue a SET OUTPUT command with a filename, and if the file exists, SQLMON asks you if you want to overwrite it.

  • SQLMON appends information to the file until you issue SET OUTPUT OFF or terminate the SQLMON session.

  • For more information, see the "Examples" section or the section "Creating Batch Reports" in the chapter "Getting Started with SQLMON."

Examples

If you issue the commands

   SQLMONITOR OVERVIEW => SET OUTPUT Myfile



   SQLMONITOR OVERVIEW => OVERVIEW



   SQLMONITOR OVERVIEW => OVERVIEW SESSION



   SQLMONITOR OVERVIEW => SET OUTPUT OFF

SQLMON creates Myfile and adds images of both the Overview and Overview Session screens to the file.

If you then issue the commands

   SQLMONITOR OVERVIEW => SET OUTPUT Myfile



   System Filename already exists. Overwrite?  yes



   SQLMONITOR OVERVIEW => LOCK 



   SQLMONITOR OVERVIEW => LOCK OBJECT 



   SQLMONITOR OVERVIEW => SET OUTPUT OFF

SQLMON overwrites Myfile and then appends images of the Lock and Lock Object screens to the file.

To prevent accidental data loss, SQLMON prompts you before it overwrites the file, as in

   SQLMONITOR OVERVIEW => SET OUTPUT Myfile



   SystemFileName already exists.  Overwrite? ([NO],YES) no



   SystemFileName not overwritten.

If you omit the last parameter, SQLMON prompts for it, as in

   SQLMONITOR OVERVIEW => SET OUTPUT



   SystemFileName <or OFF>: OFF
Feedback to webmaster