DB2 10 for z/OS Database Administrator — Question 13

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named
SAMPLE to AUTOMATIC?

Answer options

• A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
• B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
• C. CONNECT TO sample; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC IMMEDIATE; CONNECT RESET;
• D. ATTACH TO db2inst1; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;

Correct answer: C

Explanation

The correct answer is C because it establishes a connection to the SAMPLE database, allowing for the LOCKLIST parameter to be updated dynamically. Options A and B are incorrect as they contain typographical errors with 'LOOCKLIST' and do not follow the required connection steps. Option D is also incorrect because it uses 'ATTACH' instead of 'CONNECT', which is not suitable for the task at hand.