Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
The correct command to back up only metadata about database backups, table space backups, and table load operations for database MYDB is 'BACKUP DATABASE mydb NO TABLESPACE TO /outdir'. This specifies a metadata-only backup, which does not contain any tablespace data but includes the necessary metadata such as the database's recovery history file. This ensures that only metadata is backed up without the actual data from the tablespaces.
The answer A is wrong because "CONNECT TO ... PRUNE" is wrong syntaxically. REFERENCE : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000906.html
The answer D is not correct because, DB2_BCKP_PAGE_VERIFICATION specifies whether DMS and AS page validation occurs during a backup. This registry variable is dynamic, that is, it can be set or unset without having to stop and start the instance. (See the Usage Notes of the Backup Command for more details.) REFERENCE : https://docs-db2w.mybluemix.net/docs/content/SSCJDQ/com.ibm.swg.im.dashdb.admin.regvars.doc/doc/r0005669.html
The answer B is wrong because "db2trc on –db mydb –m "backup,load"" is syntaxically wrong. REFERENCE : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002027.html
The correct answer is C. "BACKUP DB ... NO TABLESPACE" specifies a metadata-only backup. A metadata-only backup does not contain any tablespace data. Among the metadata that it does contain is the database's recovery history file. This file can be restored by using the HISTORY FILE option of the RESTORE DATABASE command. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001933.html The db2trc command controls the trace facility of a Db2® instance or the Db2 Administration Server (DAS). When the db2trc command runs, the trace facility records information about operations and formats this information into readable form.