You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares?
A. CONTSTOR
B. MAXTEMPS
C. MAXKEEPD
D. MAXRBLK
正解:C
質問 2:
Given the following output:
DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS DSNV402I _DB2D ACTIVE THREADS NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF 19855 TSO T * 3 KSTTEST KSTTEST 0135 20172 A51OTEST N* 13 CICSTEST 0125 19625 You receive a call that user KSTTEST is holding resources and needs to be canceled.
Which command should be issued?
A. -CANCEL USER(KSTTEST)
B. -CANCEL THREAD(20172)
C. -CANCEL THREAD( 3)
D. User KSTTEST does not hold an active connection, no way he blocks anything.
正解:C
質問 3:
When we use multilevel-security using a security label column, which sentence is true?
A. Multilevel security with row-level checking is enforced when DB2 checks a referential constraint.
B. A referential constraint is not allowed on a security label column.
C. A unique constraint is allowed on a security label column.
D. A check constraint is not allowed on a security label column.
正解:B
質問 4:
Which DB2 subsystem parameter limits the number of concurrent active TSO requests?
A. IDBACK
B. MAXDBAT
C. CONDBAT
D. IDFORE
正解:D
質問 5:
A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December.
Which type of table could be used to implement the time-based rate changes?
A. A range-based temporal table
B. A system-period temporal table
C. An application-period temporal table
D. A rate-period temporal table
正解:C
質問 6:
What is the least disruptive way of externalizing real-time statistics for table space DB1TS1?
A. -DISPLAY DB(DB1)SPACENAM(TS1)
B. -SET LOG LOGLOAD(O)
C. RUNSTATS TABLESPACE DB1TS1
D. -ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)
正解:C
質問 7:
Which component is NOT shared between DB2 data sharing members?
A. SCA
B. DB2 directory
C. IRLM
D. DB2 catalog
正解:D
小嶋** -
、辞書として使えるような構成になっていますので持っているだけで便利。見やすく、C2090-312勉強しやすい本だと思いました。