IBM C2090-318 Exam Practice Test Instant Access

Question 1

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?

ASpecify LBACKOUT=NO

BSpecify CURRENTDATA(YES)

CReduce system checkpoint interval

DSpecify LOCKSIZE ANY for DB2 objects

Answer : C

Question 2

At what point in the upgrade process is the catalog migrated to DB2 12?

ACompletion of DSNTIJTC job

BAt the completion of CATMAI NT in function level 500

CAfter issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100)

DAfter issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500)

Answer : A

Question 3

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 4

The amount of memory taken up by the local dynamic statement cache is extremely high. How can this be reduced?

ABind more packages using BIND option KEEPDYNAMIC(YES)

BReduce the value specified for subsystem parameter MAXKEEPD

CReduce the value specified for subsystem parameter EDMSTMTC

DReduce the value specified for subsystem parameter MAX_IN_MEMORY

Answer : A

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?

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 6

In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?

AThe ability to perform a RESTORE SYSTEM

BTime spent rebuilding indexes at disaster site

CThe amount of data that could potentially be lost

DThe total number of incremental image copies made

Answer : C

https://www.ibm.com/support/knowledgecenter/beta/bg/SSEPEK_11.0.0/admin/src/tpc/db2z_disasterrecoveryprep.html

In any disaster recovery scenario, system-wide points of consistency are necessary for maintaining data integrity and preventing a loss of data. A direct relationship exists between the frequency at which you make and send copies to the recovery site and the amount of data that you can potentially lose.

Question 7

Before execution of the CHECK DATA utility, which of the following should be performed?

AExecute the REPAIR utility with SET NOCHECKPEND

BExecute CHECK INDEX on the primary key and foreign key indexes

CAlter the object to remove any table or referential constraint definitions

DStart the object in question with FORCE to remove any CHECK PENDING status

Answer : D

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