Administrator's Reference

QUERY DB (Display Information on the Database)

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