DB2 10 for z/OS Database Administrator — Question 9

Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

Answer options

• A. CONNECT TO mydb PRUNE HISTORY TO /outdir
• B. db2trc on –db mydb –m "backup,load" run the desired operations db2tc dump db2trc.dmp db2tc format db2tc.dmp db2tc.fmt db2tc off
• C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
• D. db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed). Run the desired operations.

Correct answer: B

Explanation

The correct answer, B, utilizes the db2trc command to trace and log database backup and load operations, capturing the necessary metadata. Option A is not relevant as it prunes history rather than backing up metadata. Option C attempts to back up the database without tablespaces, which does not address the metadata specifically. Option D sets a configuration parameter but does not execute the necessary operations to back up metadata.