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 58 discussion

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

Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

  • A. It does not apply to table space backups.
  • B. It specifies the compression mode to use for DB2 backups.
  • C. It only has effect when applied to a database in which all tables have been compressed.
  • D. If set, backup images created with the BACKUP command are automatically compressed.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by db2tester at Nov. 26, 2019, 2:53 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
IVIEIRA
4 years, 5 months ago
The correct answer is B "DB2_BCKP_COMPRESSION Operating system: All Default: COMPRESS, Values: COMPRESS, NX842 Specifies whether backups are compressed with the common Db2 compression or with NX842 compression. NX842 compression is only available on AIX (see Hardware accelerated backup and log file compression for details)." Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.regvars.doc/doc/r0005669.html
upvoted 1 times
...
db2tester
4 years, 12 months ago
The answer D is correct, How to use this as backup To start a backup using the hardware compression, it is necessary to specify the library: backup database databasename compress comprlib libdb2nx842.a The backups can be compressed by default with NX842. To achieve this the registry variable DB2_BCKP_COMPRESSION has to be set to NX842. Afterwards, issue the command: backup database databasename compress. The image will then be compressed using the NX842 hardware compression. Using the solution for log archive compression The NX842 hardware compression can also be used for log archive compression. To activate this, change the database configuration parameter LOGARCHCOMPR1 or LOGARCHCOMPR2 to NX842 using this command: update database configuration for databasename using LOGARCHCOMPR1 NX842 REFERENCE : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.ha.doc/doc/c0062003.html
upvoted 2 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