PrepAway - Latest Free Exam Questions & Answers

Which is the correct way to back up only metadata about…

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

PrepAway - Latest Free Exam Questions & Answers

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.
Afterwards, issue db2trc dump <outfile>


Leave a Reply