To display detailed statistical information about the database. Issue the command:
query db format=detailed
or QUERY DB F=D
Out sample:
Database Name: TSM_DB2
Total Space 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 Database Backup Streams: 4
Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 05/18/2009 22:55:19
Compress Database Backups: Yes
Protect Master Encryption Key: No
Incorrect Answers:
A: QUERY DBSPACE (Display database storage space)
Use this command to display information about the directories used by the database to store data.
Example: Display database storage space information
Display information about database storage space. Issue the command: query dbspace Location Total Space of Used Space on Free Space File System (MB) File System (MB) Available (MB)
------------------ ---------------- --------------- ---------------
d:\tsm\db001 1,748,800 1,513,191.125 117,804.422
e:\tsm\db002 1,748,800 1,513,191.125 117,804.422
References:
https://www.ibm.com/support/knowledgecenter/SSEQVQ_8.1.2/srv.reference/
r_cmd_db_query.html