Which command is used to display the last complete backup Date/Time of the IBM Spectrum Protect Database?
A. QUERY DBSPACE
B. QUERY DB F=D
C. LIST DATABASE ALL
D. SHOW DBINFO
Correct Answer: B
Explanation/Reference:
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:tsmdb001 1,748,800 1,513,191.125 117,804.422 e:tsmdb002 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
Download Printable PDF. VALID exam to help you PASS.
|
|