![]() |
![]() |
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
Examples
Task 1
Display detailed settings for the database space trigger.
query spacetrigger db format=detailed
+--------------------------------------------------------------------------------+ | DB Full Percentage: 80 | | DB Space Expansion: 20 | | DB Expansion prefix: /usr/lpp/adsmserv/bin/ | | Maximumsize: 1000 | | Last Update by (administrator): BF | | Last Update Date/Time: 12/31/1999 11:59:59 | +--------------------------------------------------------------------------------+
where:
Task 2
Display detailed settings for the recovery log space trigger.
query spacetrigger log format=detailed
+--------------------------------------------------------------------------------+ | Log Full Percentage: 80 | | LOG Space Expansion: 20 | | LOG Expansion prefix: /usr/lpp/adsmserv/bin/ | | Maximumsize: 1000 | | Last Update by (administrator): BF | | Last Update Date/Time: 03/31/1998 11:59:59 | +--------------------------------------------------------------------------------+
where:
Related Commands
Table 211. 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. |