IBM C2090-318 Exam Practice Test Instant Access

Question 1

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 2

Considering the following command:

-CANCEL THREAD {*) FORCE

In which of the following situations can it be used?

AOn local threads that are not in DB2

BOn application threads that update NOT LOGGED table spaces

CIf you are terminating a distributed thread that is part of a global transaction

DIf the CANCEL THREAD command without the FORCE option does not terminate the thread

Answer : D

Question 3

Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0?

AParallelism for DPSI is disabled

BThe DB2 optimizer will not consider DPSI for access path selection

CDB2 creates multiple child tasks but works on one task at a time when DPSI is used to drive parallelism

DDB2 will use the value specified for the PARAMDEG subsystem parameter to control the degree of parallelism when DPSI is used

Answer : D

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?

APerform a cold start

BIssue the-START DB2 command

CCreate a conditional restart record using option ENDRBA and then restart DB2

DCreate a conditional restart record using option STARTRBA and then restart DB2.

Answer : C

Question 5

For a general application performance problem, which set of documentation would be most useful for diagnosis?

ASVC Dump

BRMF Monitor

CDIAGNOSE MEPL utility

DSMF accounting and statistics traces

Answer : B

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?

ASpecify LBACKOUT=NO

BSpecify CURRENTDATA(YES)

CReduce system checkpoint interval

DSpecify LOCKSIZE ANY for DB2 objects

Answer : C

Question 7

Beginning with function level V12R1M500. what would be the maximum data set size of an active log?

A4 GB

B123 GB

C255 GB

D768 GB

Answer : C

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