Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Ibm Discussions
exam questions

Exam C2090-600 All Questions

View all questions & answers for the C2090-600 exam
Go to Exam

Exam C2090-600 topic 1 question 20 discussion

Actual exam question from IBM's C2090-600
Question #: 20
Topic #: 1
[All C2090-600 Questions]

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

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by db2tester at Oct. 9, 2019, 4:36 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
db2tester
5 years ago
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
upvoted 1 times
...
db2tester
5 years ago
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
upvoted 1 times
...
db2tester
5 years ago
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
upvoted 1 times
...
db2tester
5 years, 1 month ago
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.
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel