IBM Db2 12 for z/OS Administrator - C1000-078 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

In order to install the RACF access control module for a DB2 subsystem, to which of the following modules should DSNTIJEX refer?

A. DSNXRXAC B. DSNXSXAC C. DSN3@SGN D. DSN3@ATH

Discussion 0

Correct Answer: A Vote an answer

Question 2

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 THREADH DETAIL B. -DISPLAY FUNCTION SPECIFIC C. -DISPLAY DDF DETAIL D. -DISPLAY LOCATION OB.

Discussion 0

Correct Answer: A Vote an answer

Question 3

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. Manually rebuild the GBP structures on CF01 B. No action is needed. Each member performs automatic GRECP recovery C. No action is needed. The GBP structures are automatically rebuilt in CF02 D. Stop members DB2A and DB2B and initiate a group restart

Discussion 0

Correct Answer: A Vote an answer

Question 4

The amount of memory taken up by the local dynamic statement cache is extremely high. How can this be reduced?

A. Bind more packages using BIND option KEEPDYNAMIC(YES) B. Reduce the value specified for subsystem parameter EDMSTMTC C. Reduce the value specified for subsystem parameter MAX_IN_MEMORY D. Reduce the value specified for subsystem parameter MAXKEEPD

Discussion 0

Correct Answer: A Vote an answer

Question 5

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. Start a system-wide performance trace to identify the workload which is causing the high CPU B. Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU C. Execute a -DISPLAY TRACED command to check if there are additional traces running or if the global trace is on D. Check that the WLM settings are set correctly

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which subsystem parameter sets the maximum number of concurrent inbound DDF connections that are to be allowed?

A. CTHREAD B. MAXDBAT C. CONDBAT D. MAXKEEPD

Discussion 0

Correct Answer: D Vote an answer

Question 7

Which authority prevents unintended access to user data but allows installation or migration of a DB2 subsystem?

A. SYSADM B. Installation SYSADM C. Installation SYSOPR D. SYSCTRL

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).