IBM C2090-317 dumps - 100% Pass Guarantee!

Which combination of subsystem parameter values will enable connection pooling for idle distributed database access threads?

A. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT = MAXDBAT.

B. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT < MAXDBAT.

C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.

D. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT >MAXDBAT.

A given buffer pool is to be used for sequentially accessed pages only. Setting which buffer pool attribute to 0 (zero) will disable parallel processing operations in this buffer pool?

A. DWQT

B. VDWQT

C. VPSEQT

D. VPPSEQT

Which DB2 catalog or directory table space CANNOT be reorganized?

A. DSNDB01.SCT02

B. DSNDB01.SYSUTILX

C. DSNDB06.SYSTSCPY

D. DSNDB06.SYSTSPDO

You are facing a severe locking problem with a specific application using plan PLANB. To identify what is going on you need to start a detailed locking trace. However, you want to limit the scope of the trace somewhat to reduce the trace overhead and trace volume. (IFCID 21 traces each lock request and is part of performance trace class 7).

Which is the most appropriate command to use ?

A. -STA TRA(P) CLASS(7) DEST(GTF) PLAN(PLANB)

B. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) PLAN(PLANB)

C. -STATRA(P)CLASS(30) IFCID(21) DEST(GTF) PLAN(PLANB)

D. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) XPLAN(PLANB')

A DDF thread with a token of 56 needs to be cancelled but due to a very tight processing loop in the thread, a regular cancel thread command might not work. What action(s) would provide the best chance to initially attempt to cancel this thread?

A. -CANCEL THREAD(56)

B. -CANCEL DDF THREAD(56) FORCE

C. -CANCEL THREAD(56)NOBACKOUT

D. -CANCEL DDF THREAD(56)