Which subsystem parameter specifies the action that DB2 takes when a problem occurs with the resource limit specification table during execution of a local, static SQL statement?
A. RLFERRD
B. RLFERRSTC
C. RLFERRDSTC
D. RLFERR
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
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?
A. Execute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on
B. Start a system-wide performance trace to identify the workload which is causing the high CPU
C. Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU
D. Check that the WLM settings are set correctly
正解:B
質問 3:
Which of the following commands can be used to show the client correlation token in order to find details such as the ip-address. port-address and unique-id to identify the distributed transaction?
A. -DISPLAY LOCATION OB.
B. -DISPLAY FUNCTION SPECIFIC
C. -DISPLAY DDF DETAIL
D. -DISPLAY THREADH DETAIL
正解:D
質問 4:
Which of the following is required to successfully issue the -ACTIVATE command in a data sharing environment?
A. The member on which the command is issued must be started in maintenance mode
B. All active members must be running DB2 12
C. Only one member may be active when the command is issued
D. The command must be issued with installation SYSADM authority
正解:D
質問 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?
A. No action is needed. The GBP structures are automatically rebuilt in CF02
B. Manually rebuild the GBP structures on CF01
C. Stop members DB2A and DB2B and initiate a group restart
D. No action is needed. Each member performs automatic GRECP recovery
正解:B
长谷** -
本当に助かりました。読み易く、飽きずに楽しくC2090-318試験対策問題を学べています。