Download of C2090-617 testing engine materials and keys for IBM certification for examinee, Real Success Guaranteed with Updated C2090-617 pdf dumps vce Materials. 100% PASS DB2 10 System Administrator for z/OS (C2090-617) exam Today!
2021 May C2090-617 Study Guide Questions:
Q61. When installing DB2 for the first time, which step is potentially optional?
A. Define DB2 to z/OS.
B. Define the TCP/IP port for this subsystem.
C. Define system data sets (e.g. prefix.RUNLIB.LOAD).
D. Define the SMS environment for the DB2 catalog and directory data sets.
Answer: B
Q62. Which command can be used to remove dynamic SQL statements from the access path repository?
A. FREE PLAN
B. FREE QUERY
C. FREE PACKAGE
D. FREE LOCATOR
Answer: B
Q63. A -STOP DB2 MODE (FORCE) command was used to terminate a DB2 subsystem with inflight remote units-of-work. What happens to the inflight DB2 work?
A. Runs to normal completion and DB2 will shutdown.
B. Runs to the next application checkpoint and DB2 will shutdown.
C. Runs to the next DB2 system checkpoint and DB2 will shutdown.
D. Possibly creates in-doubt units of recovery for threads that are between commit processing phases.
Answer: D
Up to date C2090-617 actual exam:
Q64. The parameter EDMSTMTC provides the sizing for global dynamic SQL cache. Monitoring and proper sizing of this storage area should have which benefit?
A. Reduce the volume of REORGs needed.
B. Reduce the volume of FULL PREPARES.
C. Reduce the volume of statements required.
D. Reduce the volume of DML SELECT activity.
Answer: B
Q65. You are required to include documentation and instructions for all possible fallback routes in your plan for migrating your DB2 subsystem from V9 NFM to V10 NFM. Which fallback route should you include?
A. V10 CM9 to V9 NFM
B. V10 NFM to V9 NFM
C. V10 ENFM to V10 CM
D. V10 NFM to V10 ENFM
Answer: A
Q66. To verify whether a long running remote DRDA TCP/IP query was able to offload some of its CPU cycles to a zIIP specialty engine, what report is used?
A. A DB2 statistics trace report.
B. A DB2 accounting trace report.
C. An RMF CPU activity report.
D. An RMF WLM activity report for the service class used by the query.
Answer: B
Accurate C2090-617 :
Q67. A problem is caused by an extremely large DB2 sort operation monopolizing the DB2 work files: programs which use declared global temporary tables (DGTTs) are failing with -904 SQLCODE due to unavailable space in the DB2 work files. Which option will provide relief?
A. Specify a higher value for MAXTEMPS DB2 DSNZPARM startup parameter.
B. Specify a smaller value for MAXTEMPS DB2 DSNZPARM startup parameter.
C. Decrease the number and size of table spaces in the work file DATABASE.
D. Allocate a set of DB2-managed work file table spaces with zero SECQTY and another set of DB2-managed work file table spaces with non-zero SECQTY and specify WFDBSEP=NO for DB2 DSNZPARM startup parameter.
Answer: B
Q68. Assume DB2 has two BSDSs and one is corrupted. Which statement is true?
A. If DB2 is up, DB2 abends.
B. If DB2 is down, DB2 automatically resynchronizes the BSDS during restart.
C. If DB2 is down, you must allocate a new BSDS and copy the current to the new allocated.
D. If DB2 is up, you must shut down DB2, allocate a new BSDS, start DB2 and do command RECOVER BSDS.
Answer: B
Q69. During monitoring of a group buffer pool over a period of time, a high volume of cross invalidations due to directory reclaims is observed. What action should be taken to reduce the cross invalidations due to directory reclaims? DSNB788I -DB2A CROSS INVALIDATIONS DUE TO DIRECTORY RECLAIMS = 4,489,485
A. Increase the lock structure.
B. Increase the coupling facility capacity.
C. Increase the size of the group buffer pool.
D. Increase VPSIZE for all of the local buffer pools in the data sharing group.
Answer: C
Q70. There is a mixed workload of local and remote requests in a DB2 subsystem. There is one critical remote application and several non-critical decision support queries. All these remote systems are stealing CPU resources from critical CICS transactions. Which action can relieve this contention in favor of all critical applications?
A. Lower the priority of the ssnmDIST address space below that of CICS.
B. Define WLM enclaves for the remote applications with appropriate service classes.
C. Make sure the ssnmDIST address space is in a service class below that of the ssnmDBM1 address space.
D. Enable I/O parallelism for the remote queries by having those remote applications set the CURRENT DEGREE special register.
Answer: B