C2090-318 by IBM Actual Free Exam Q&As

Question 1

What resource is used to communicate BSDS and log data set names between DB2 members in a data sharing group?

A. DB2log B. Lock structure C. DB2 directory D. SCA

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?

A. DSNDB06.SYSDDF B. DSNDB01.SYSLGRNX C. DSNDB01.SYSSPT01 D. DSNDB01.SYSUTILX

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

Which one of the following modules, or its equivalent name, is optional for a successful DB2 start?

A. The DB2 connection authorization exit routine (DSN3@ATH) B. The user version of the access control authorization exit routine (DSNX@XAC) C. The default load module (DSNZPARM) D. The application default load module (DSNHDECP)

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

DB2 just abended unexpectedly and needs to be restarted as quickly and consistently as possible. Which of the following restart method do you pick?

A. Perform a cold start B. Create a conditional restart record using option STARTRBA and then restart DB2. C. Create a conditional restart record using option ENDRBA and then restart DB2 D. Issue the-START DB2 command

Discussion 0

Correct Answer: A Vote an answer

Question 5

CPU utilization for a DB2 subsystem suddenly increased by approximately 20% and is still at this high level after 24 hours. No increase in workload was expected. What would be the most efficient analysis to perform?

A. Execute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on B. Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU C. Start a system-wide performance trace to identify the workload which is causing the high CPU D. Check that the WLM settings are set correctly

Discussion 0

Correct Answer: C Vote an answer

Question 6

During DB2 restart, it is observed that it takes a significant amount of time to complete. Which of the following could be tuned to improve restart time?

A. Reduce system checkpoint interval B. Specify LOCKSIZE ANY for DB2 objects C. Specify LBACKOUT=NO D. Specify CURRENTDATA(YES)

Discussion 0

Correct Answer: A Vote an answer

IBM DB2 12 System Administrator for z/OS - C2090-318 Exam Practice Test