Administrator's Reference
Use this command to display the settings for the database or recovery log
space triggers.
Privilege Class
Any administrator can issue this command.
Syntax
.-Format--=--Standard-----.
>>-Query SPACETrigger--+-DB---+---+-------------------------+--><
'-LOG--' '-Format--=--+-Standard-+-'
'-Detailed-'
Parameters
- DB
- Specifies the database space trigger.
- LOG
- Specifies the recovery log space trigger.
- Format
- Specifies how the information is displayed. This parameter is
optional. The default is STANDARD. Possible values are:
- Standard
- Specifies that partial information is displayed.
- Detailed
- Specifies that complete information is displayed.
Examples
Task 1
Display detailed settings for the database space trigger.
- Command:
-
query spacetrigger db format=detailed
- Output:
-
+--------------------------------------------------------------------------------+
| DB Full Percentage: 80 |
| DB Space Expansion: 20 |
| DB Expansion prefix: j:\adsmserv\ |
| Maximumsize: 1000 |
| Last Update by (administrator): BF |
| Last Update Date/Time: 12/31/1999 11:59:59 |
+--------------------------------------------------------------------------------+
where:
- DB Full Percentage
- Specifies when TSM automatically allocates more space for the
database.
- DB Space Expansion
- Specifies the percentage of space by which the database is
expanded.
- DB Expansion prefix
- Specifies the prefix name for the files that TSM uses to create database
files when expanding the database.
- Maximumsize
- Specifies the maximum size, in megabytes, of the database.
- Last Update by (administrator)
- Specifies the name of the administrator who most recently updated the
database space trigger.
- Last Update Date/Time
- Specifies when the administrator most recently updated the database space
trigger.
Task 2
Display detailed settings for the recovery log space trigger.
- Command:
-
query spacetrigger log format=detailed
- Output:
-
+--------------------------------------------------------------------------------+
| Log Full Percentage: 80 |
| LOG Space Expansion: 20 |
| LOG Expansion prefix: j:\adsmserv\ |
| Maximumsize: 1000 |
| Last Update by (administrator): BF |
| Last Update Date/Time: 03/31/1998 11:59:59 |
+--------------------------------------------------------------------------------+
where:
- Log Full Percentage
- Specifies when TSM automatically allocates more space for the recovery
log.
- LOG Space Expansion
- Specifies the percentage of space by which the recovery log is
expanded.
- LOG Expansion prefix
- Specifies the prefix name for the files that TSM uses to create recovery
log files when expanding the recovery log.
- Maximumsize
- Specifies the maximum size, in megabytes, of the recovery log.
- Last Update by (administrator)
- Specifies the name of the administrator who most recently updated the
recovery log space trigger.
- Last Update Date/Time
- Specifies when the administrator most recently updated the recovery log
space trigger.
Related Commands
Table 196. Commands Related to QUERY SPACETRIGGER
Command
| Description
|
DEFINE SPACETRIGGER
| Defines the database or recovery log space trigger.
|
DELETE SPACETRIGGER
| Deletes the database or recovery log space trigger.
|
UPDATE SPACETRIGGER
| Changes attributes of the database or recovery log space trigger.
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]