IBM C2090-318 Exam Questions Instant Access

Question 1

Which one of the following buffer pool thresholds determines the percentage of the buffer pool that might be occupied by sequentially accessed pages?

ADWQT

BVDWQT

CVPSEQT

DVPPSEQT

Answer : C

Sequential Steal Threshold (VPSEQT) -- The percentage of pages that can be used for prefetch. Default is 70%. For pools with mostly sequential access, you can set this value as high as 100. For pools with mostly random access, set this value very low. Review the prefetch failure statistics to determine if applications attempt to use sequential processing against the objects allocated in this pool.

https://www.bmc.com/blogs/db2-for-zos-buffer-pools-the-basics/

Question 2

Which of the following utilities would produce information needed to identify UNDO information for a transaction?

ADSNJU003

BDSNJU004

CDSNJLOGF

DDSN1LOGP

Answer : A

Question 3

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 4

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 5

DB2A and DB2B are in the same data sharing group on separate LPARs There are two coupling facilities CF01 and CF02. CF01 contains the Lock and SCA structures and CF02 contains the GBP structures. The group buffer pools are not duplexed. The structures can reside on either CF01 or CF02 as specified in the CRFM policy PREFLIST and AUTOREC is set to YES.

CF02 fails and DB2A or DB2B can no longer connect to it. Once they are able to reconnect, what action is necessary in order to minimize loss of data availability?

AManually rebuild the GBP structures on CF01

BStop members DB2A and DB2B and initiate a group restart

CNo action is needed. Each member performs automatic GRECP recovery

DNo action is needed. The GBP structures are automatically rebuilt in CF02

Answer : A

Question 6

The -DISPLAY THREAD(') TYPE(PROC) command can be used to display information about which of the following?

AThe subset of system agent threads

BThreads executing under batch jobs

CAll threads that are actively being processed by DB2

DThreads executing stored procedures and user-defined functions

Answer : C

Question 7

In which phase of SMP/E processing is the DB2 software installed into the target libraries?

AAPPLY

BACCEPT

CRECEIVE

DAPPLY CHECK

Answer : B

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