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

SET DBENVIRONMENT
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

Specifies which DBEnvironment SQLMON monitors

Scope

SQLMON Only

SQLMON Syntax

SET DBEN [VIRONMENT] [ DBEnvironmentName [MAINT=MaintenanceWord] OFF ]

Parameters

DBEnvironmentName

The name of the DBEnvironment to be monitored. DBEnvironmentName is case sensitive.

MaintenanceWord

The maintenance word of the DBEnvironment, required if you are not the DBEnvironment creator or superuser.

OFF

The default value, indicating that no DBEnvironment has been specified.

Description

  • You cannot display an SQLMON screen until you issue SET DBENVIRONMENT.

  • SQLMON can monitor just one DBEnvironment at a time.

  • The SET DBECONNECT and SET DBEINITPROG commands affect the behavior of the SET DBENVIRONMENT command.

Examples

The following example shows how to monitor the PartsDBE DBEnvironment:

   SQLMONITOR OVERVIEW => SET DBENV PartsDBE

If you omit the DBEnvironment name or the maintenance word, SQLMON prompts for them, as follows:

   SQLMONITOR OVERVIEW => SET DBENVIRONMENT



   DBENVIRONMENT NAME <or OFF>: PartsDBE



   MAINTENANCE WORD:


SET DBEINITPROG
  		 


SET DISPLAYSAMPLES  
Feedback to webmaster