Pay attention on Pass-king C1000-078 Practice Materials, clear exam 100% for sure

IBM C1000-078 Exam Syllabus Topics:

IBM Db2 12 for z/OS Administrator Sample Questions:

1. Which of the following is required to successfully issue the -ACTIVATE command in a data sharing environment?

A) All active members must be running DB2 12
B) The member on which the command is issued must be started in maintenance mode
C) Only one member may be active when the command is issued
D) The command must be issued with installation SYSADM authority

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

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

3. Which lEAOPTxx parameter and value determines that processes will be routed from zllP to general processors when the zllP engines have no more capacity?

A) IIPHONORPRIORITY = YES
B) IFAHONORPRIORITY = YES
C) IFAHONORPRIORITY = NO
D) IIPHONORPRIORITY = NO

4. 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) Execute a -DISPLAY STATS command to identify the workload which is causing the high CPU
C) Check that the WLM settings are set correctly
D) Start a system-wide performance trace to identify the workload which is causing the high CPU

5. Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?

A) -STOP DATABASE
B) -ACCESS DATABASE
C) -START DATABASE
D) -DISPLAY DATABASE

Solutions: