Administrator's Reference

QUERY SPACETRIGGER (Query the Database or Recovery Log Space Triggers)

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:                                               |
|                     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. This parameter is not used in the MVS environment.

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:                                               |
|                     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. This parameter is not used in the MVS environment.

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 176. 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 ]