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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
db2tester
5 years, 5 months agodb2tester
5 years, 5 months agodb2tester
5 years, 5 months agodb2tester
5 years, 6 months ago