Printable of C2090-737 test questions materials and secret for IBM certification for IT candidates, Real Success Guaranteed with Updated C2090-737 pdf dumps vce Materials. 100% PASS DB2 9 System Administrator for z/OS Exam exam Today!
2021 May C2090-737 Study Guide Questions:
Q21. A customer is performing a traditional image copy disaster recovery test. The systems programmer creates a conditional restart control record (CRCR) but detects an error before starting DB2. Which action should be performed to correct the CRCR record?
A. First use CRESTART,DELETE to delete the error CRCR record then CRESTART,CREATE toadd a new one.
B. Start DB2, reply "M" to the WTOR that is displayed from the first CRCR record to modify theCRCR parameters.
C. Use CRESTART,MODIFY to modify the parameters of the error CRCR record.
D. Use CRESTART,CREATE to create a new CRCR record.
Answer: D
Q22. The command -START DB2 LIGHT(YES) was entered. Which two main objectives were achieved by this command? (Choose two.)
A. to quickly bring up DB2 for the user access
B. to use less storage
C. to prohibit access to any users other than installation SYSADM and SYSOPR
D. to release retained locks
E. to start DB2 without allowing for in-doubt thread resolution
Answer: B,D
Q23. Which system parameter will lower the DBM1 storage requirements (below the 2 GB bar), if the value was reduced?
A. MAXDBAT
B. EDM_SKELETON_POOL
C. MXDTCACH
D. MINSTOR
Answer: A
Renovate C2090-737 answers:
Q24. What will enable WLM assisted buffer pool management?
A. WLMUSE(YES)
B. AUTOSIZE(YES)
C. VPSIZEAUTO(YES)
D. BPWLM(YES)
Answer: B
Q25. Your administrative scheduler shows message DSNA679I indicating that one or both copies of your task lists is not accessible or is corrupted. Your analysis shows that only the VSAM file is corrupt, but the ADMIN_TASKS table is still operational. Which statement describes how to correct this situation?
A. Create an empty version of the VSAM task list and let DB2 perform an autonomic recoveryusing the content of the ADMIN_TASKS table.
B. Create an empty version of the VSAM task list and use REPRO utility to copy the contents ofthe VSAM cluster containing the ADMIN_TASKS table.
C. Create an empty version of the VSAM task list and use DB2 command -RECOVER TASKLISTto recover the content of the ADMIN_TASKS table.
D. No manual interaction is needed as long as the ADMIN_TASKS table is still accessible.
Answer: A
Q26. A distributed task fails with a DSNL511I error, a TCP/IP conversation has failed. This problem was not reported until a few days after the problem actually occurred.. Where would you find the IP address, TCP/IP port, the DB2 module that issued the message, and the TCP/IP error condition as you begin resolution of this issue?
A. a current dump of the DBM1 address space
B. the SYS1.LOGREC
C. the JES2 job log for the MSTR address space
D. the JES2 job log for the DIST address space
Answer: C
Exact C2090-737 braindumps:
Q27. The DB2-supplied SQL Procedure Processor stored procedure DSNTPSMP requires which two for execution? (Choose two.)
A. DB2 for z/OS REXX Language Support
B. Workload Manager SPAS with NUMTCB=1
C. Workload Manager SPAS with NUMTCB > 1
D. Optimization Service Center
E. Java Virtual Machine
Answer: A,B
Q28. An index, originally defined with COPY YES and in buffer pool BP8K0, is altered to a compressed index and rebuilt. Which statement is true?
A. The index requires less space on disk and in the buffer pool.
B. The index requires less space on disk only.
C. The index requires less space for an image copy created with CONCURRENT NO.
D. The index requires less space in the log records.
Answer: B
Q29. A user job runs a very long time without commit and then the application bends. The job pdated a critical table that is used by many applications. The back out is taking a long ime. Hichstatement describes the appropriate action to take?
A. Cancel the DB2 system since this is a critical resource that is needed by many applications.
B. Issue the -CANCEL THREAD(token) NOBACKOUT.
C. Let DB2 continue with the back out.
D. Restart the system using the LBACKOUT=AUTO system parameter.
Answer: C
Q30. The group buffer pool structures, GBP0, GBP1, and GPB2 reside in CF1 for a data sharing group DG0P. The LOCK and the LIST structures reside in CF2. AUTOREC is set to YES. The group buffer pools are not duplexed. CF1 fails due to a microcode problem and noneof the GBPs are available. Which statement is true?
A. DB2 automatically rebuilds the GBPs based on information kept in the local buffer pools.
B. DB2 automatically recovers since AUTOREC is set to YES.
C. DB2 initiates automatic GRECP recovery, after it has been restarted.
D. DB2 is able to continue without the GBPs.
Answer: B