DB2 10 for z/OS Database Administrator — Question 43

Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because when the DB2_BCKP_COMPRESSION variable is enabled, it ensures that any backup images created with the BACKUP command are compressed automatically. Option A is incorrect as the variable can apply to table space backups depending on the context. Option B is misleading because it does not solely define the compression mode, and Option C is incorrect since the variable can affect backups regardless of the compression status of the tables.