Use this command to display information about the database.
Any administrator can issue this command.
.-Format--=--Standard-----. >>-Query DB--+-------------------------+----------------------->< '-Format--=--+-Standard-+-' '-Detailed-'
query db
Database Name Total Pages Usable Pages Used Pages Free Pages
------------- ----------- ------------ ---------- ----------
TSMDB1 32,776 32,504 24,220 8,284
See Field descriptions for
field descriptions.query db format=detailed
Database Name: TSM_DB2
Total Size of File System (MB): 1,748,800
Space Used on File System (MB): 2,304,355
Space Used by Database(MB): 448
Free Space Available (MB): 235,609
Total Pages: 32,776
Usable Pages: 32,504
Used Pages: 24,220
Free Pages: 8,284
Buffer Pool Hit Ratio: 99.3
Total Buffer Requests: 204,121
Sort Overflows: 0
Package Cache Hit Ratio: 89.8
Last Database Reorganization: 05/25/2009 16:44:06
Full Device Class Name: FILE
Number of Backup Streams: 4
Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 05/18/2009 22:55:19
Compress Database Backups: Yes
See Field descriptions for field descriptions.Command | Description |
---|---|
BACKUP DB | Backs up the Tivoli Storage Manager database to sequential access volumes. |
EXTEND DBSPACE | Adds directories to increase space for use by the database. |
QUERY DBSPACE | Displays information about the storage space defined for the database. |