 |
» |
|
|
|
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: 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
|
|
