Administrator's Reference
Use this command to display statistical information about the
database.
Privilege Class
Any administrator can issue this command.
Syntax
.-Format--=--Standard-----.
>>-Query DB----+-------------------------+---------------------><
'-Format--=--+-Standard-+-'
'-Detailed-'
Parameters
- 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 statistical information about the database.
- Command:
- query db
- Output:
-
+--------------------------------------------------------------------------------+
|Available Assigned Maximum Maximum Page Total Used Pct Max. |
| Space Capacity Extension Reduction Size Pages Pages Util Pct |
| (MB) (MB) (MB) (MB) (bytes) Util |
|--------- -------- --------- --------- ------- ------ ----- ----- ----- |
| 8 4 4 0 4,096 1,024 94 9.2 9.2 |
+--------------------------------------------------------------------------------+
See Task 2 for parameter definitions.
Task 2
Display statistical information about the database in detail.
- Command:
- query db format=detailed
- Output:
-
+--------------------------------------------------------------------------------+
| Available Space (MB): 8 |
| Assigned Capacity (MB): 4 |
| Maximum Extension (MB): 4 |
| Maximum Reduction (MB): 0 |
| Page Size (bytes): 4,096 |
| Total Usable Pages: 1,024 |
| Used Pages: 94 |
| Pct Util: 9.2 |
| Max. Pct Util: 9.2 |
| Physical Volumes: 3 |
| Buffer Pool Pages: 64 |
| Total Buffer Requests: 4,702 |
| Cache Hit Pct.: 97.68 |
| Cache Wait Pct.: 0.00 |
| Backup in Progress?: No |
| Type of Backup In Progress: |
| Incrementals Since Last Full: 0 |
|Changed Since Last Backup (MB): 0.37 |
| Percentage Changed: 100.00 |
|Last Complete Backup Date/Time: |
+--------------------------------------------------------------------------------+
where:
- Available Space (MB)
- Specifies the amount of space available, in megabytes.
- Assigned Capacity (MB)
- Specifies the assigned storage capacity, in megabytes.
- Maximum Extension (MB)
- Specifies the maximum amount the database can be extended, in
megabytes.
- Maximum Reduction (MB)
- Specifies the maximum amount the database can be reduced, in
megabytes.
- Page Size (bytes)
- Specifies the page size, in bytes.
- Total Usable Pages
- Specifies the total number of pages available. The total number of
pages will always be a multiple of the Assigned Capacity value, by a factor of
256 (1 megabyte/256 pages).
- Used Pages
- Specifies the total number of pages currently being used.
- Pct Util
- Specifies the current utilization as a percentage of the assigned
capacity.
- Max. Pct Util
- Specifies the maximum occupancy for the database, as a percentage of the
available space. This value is the greatest utilization
percentage.
- Physical Volumes
- Specifies the number of database volumes and copies.
- Buffer Pool Pages
- Specifies the number of pages in the database buffer pool.
- Total Buffer Requests
- Specifies the cumulative number of requests for database pages since the
last RESET BUFPOOL command (or since the server was last started).
- Cache Hit Pct.
- Specifies, as a percentage of the total number of requests, the number of
requests for a database page that are already in the buffer pool.
- Cache Wait Pct.
- Specifies, as a percentage, the number requests for a database buffer pool
page that was unavailable (because all buffer pool pages are occupied).
- Backup in Progress?
- Specifies if a backup is in progress.
- Type of Backup in Progress
- Specifies a full or an incremental backup.
- Incremental Since Last Full
- Specifies the number of incremental backups run since the last full
backup.
- Changed Since Last Backup (MB)
- Specifies the database pages, in megabytes, that have changed since the
last backup.
- Percentage Changed
- Specifies, as a percentage, the number of pages that have changed since
the last backup.
- Last Complete Backup Date/Time
- Specifies the date and time of the last complete backup.
Related Commands
Table 160. Commands Related to QUERY DB
Command
| Description
|
BACKUP DB
| Backs up the TSM database to sequential access volumes.
|
DEFINE DBCOPY
| Creates a volume copy of a database volume.
|
DEFINE DBVOLUME
| Assigns a volume to be used for database storage.
|
EXTEND DB
| Extends usable database storage within the volumes previously allocated
for its use.
|
EXTEND LOG
| Extends usable log storage within the volumes previously allocated for
its use.
|
REDUCE DB
| Attempts to free up a database volume by reducing usable storage within
the volumes defined.
|
REDUCE LOG
| Attempts to free up a log volume by reducing usable storage within the
volumes defined.
|
RESET BUFPOOL
| Resets the buffer pool statistics for the database.
|
RESET DBMAXUTILIZATION
| Resets the maximum utilization statistic for the database.
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]