IBM C2090-318 Exam Practice Test Instant Access

Question 1

Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?

A-STOP DATABASE

B-START DATABASE

C-DISPLAY DATABASE

D-ACCESS DATABASE

Answer : D

TheDb2command ACCESS DATABASE forces a physical open of a table space, index space, or partition, or removes the GBP-dependent status for a table space, index space, or partition, or externalizes the real-time statistics and optimizer statistics recommendations from in-memory blocks to the appropriate catalog tables. The MODE keyword specifies the desired action.

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/comref/src/tpc/db2z_cmd_accessdatabase.html

Question 2

Which technique is best suited to determine whether a bigger VPSIZE for a buffer pool could be beneficial?

AAnalyze accounting trace records

BAnalyze performance trace records

CAnalyze buffer pool simulation results

DAnalyze the contents of table SYSIBM.SYSTABLESPACESTATS

Answer : A

Question 3

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

AThe default load module (DSNZPARM)

BThe application default load module (DSNHDECP)

CThe DB2 connection authorization exit routine (DSN3@ATH)

DThe user version of the access control authorization exit routine (DSNX@XAC)

Answer : A

Question 4

To initiate a system checkpoint without modifying the current LOGLOAD value, which of the following should be issued?

A-SET LOG BOTH

B-SET LOG RESUME

C-SETLOGLOGLOAD(O)

D-SET LOG BOTH CHKTIME(10) LOGLOAD(500000)

Answer : C

Question 5

Which stored procedures need to be set up in order to register an XML schema?

AXSR_VALI DATE and XSR_COMPLETE

BXSR_REGISTERandXSR_COMPLETE

CXSR_VALIDATE and XSR_ADDSCHEMADOC

DXSR ADDSCHEMADOCandXSR COMPLETE

Answer : B

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.xml.doc/doc/c0022711.html

When a database is created, the stored procedures used to register XML schemas are also created. To register XML schemas through the stored procedure method, invoke the XSR_REGISTER, XSR_ADDSCHEMADOC and XSR_COMPLETE stored procedures with the CALL statement.

Question 6

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?

ACheck that the WLM settings are set correctly

BStart a system-wide performance trace to identify the workload which is causing the high CPU

CExecute a -DISPLAY STATS command to identify the workload which is causing the high CPU

DExecute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on

Answer : B

Question 7

When must the IRLM address space be active?

ADuring start of DB2

BAfter startup of DB2

CAt the first lock request

DAt the first concurrent lock situation

Answer : D

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