HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET DBEFILESET 

Determines which DBEFileSets are included on a screen

Scope 

SQLMON Only

SQLMON Syntax 

SET DBEF[ILESET] [DBEFileSetName]
                 [OFF           ]
Parameters 

DBEFileSetName          Displays information only on DBEFileSetName.

OFF                     Displays information on all DBEFileSets.

Description 

   *   SET DBEFILESET affects the following screens:
          *   SampleIO
          *   SampleIO Indexes
          *   SampleIO Objects
          *   SampleIO Tables
          *   Static Cluster
          *   Static DBEFile
          *   Static Hash
          *   Static Indirect
          *   Static Size

   *   When you are interested in a single DBEFileSet, you can use the
       SET DBEFILESET command to remove unwanted information and make the
       screens easier to read.

   *   You can use the SET DBEFILESET command in the Static subsystem to
       improve SQLMON's performance.  When you access a screen in the
       Static subsystem, SQLMON performs multiple serial scans on each
       DBEFileSet, which can be very time-consuming.  However, when you
       specify a DBEFileSet with SET DBEFILESET, SQLMON scans only the
       DBEFileSet you name.

Examples 

In the following example, the information displayed is limited to the
OrderFS fileset:

     SQLMONITOR  STATIC => SET DBEF OrderFS 

If you omit the DBEFileSetName, SQLMON prompts for it, as follows:

     SQLMONITOR  STATIC => SET DBEFILESET 

     DBEFILESET NAME <or OFF>: OrderFS 

MPE/iX 5.0 Documentation