DB2 10 for z/OS Database Administrator — Question 14

Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

Answer options

• A. Select from the ADMIN_GET_ENCRYPTION_INFO table function
• B. Run the db2ckbkp command and verify the compression settings
• C. Check the encrypted database parameter in database configuration
• D. Check ENCROPTS database configuration parameter for encryption options

Correct answer: D

Explanation

The correct answer is D because the ENCROPTS parameter specifically indicates the encryption settings for the database. Option A is incorrect as it relates to retrieving information but not directly to current settings, while B focuses on compression rather than encryption, and C does not provide comprehensive details about encryption options.