Exam Code: C2090-737 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 9 System Administrator for z/OS Exam
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-737 Exam.
2021 May C2090-737 Study Guide Questions:
Q31. Which single DB2 system parameter must be enabled to allow system level backups to be used for object level recovery?
A. RESTORE_SYSTEM
B. RESTORE_ RECOVER_FROMDUMP
C. SYSTEM_LEVEL_BACKUPS
D. RESTORE_BACKUP
Answer: C
Q32. Which trace type can only be started with a "-START TRACE" command?
A. statistics
B. accounting
C. audit
D. performance
Answer: D
Q33. Your non-data sharing DB2 has a current system parameter DSMAX value of 10,000 and has only page sets with the CLOSE YES attribute. In DB2 statistics reports, you encounter many openings and closings of the VSAM data sets. Which action would relieve this situation?
A. Alter the page set attributes to CLOSE NO.
B. Double the system parameter DSMAX value.
C. Double the JCL parameter DYNAMNBR in DBM1 procedure.
D. Increase the system parameters values for PCLOSEN and PCLOSET.
Answer: B
Refresh C2090-737 answers:
Q34. Within which two DB2 address spaces may the execution of a DB2 stored procedure occur? (Choose two.)
A. Workload Manager SPAS
B. Database Services (DBM1)
C. DB2-established SPAS
D. Distributed Data Facility (DDF)
E. System Services (MSTR)
Answer: A,B
Q35. Which statement is true regarding disaster recovery scenarios?
A. When using the RESTORE SYSTEM utility, each DB2 member must use the same SYSPITRvalue when creating conditional restart control records (CRCR).
B. When using an advanced disk mirroring solution, a conditional restart of DB2 must still beperformed at the disaster site.
C. With a synchronous peer to peer replication solution, a group restart is not required for a datasharing group since everything is synchronously mirrored.
D. A backup taken from the BACKUP SYSTEM utility cannot be used for object level recovery forthe catalog/directory during a disaster recovery scenario.
Answer: A
Q36. Which three statements are correct for automatic management of buffer pool storage in DB2 9?
(Choose three.)
A. You do not need to ALTER BUFFERPOOL with AUTOSIZE(YES) to enable thi functionality.
B. DB2 provides sizing information to WLM.
C. DB2 communicates to WLM each time allied agents encounter delays due to read I/O.
D. DB2 periodically reports BPOOL size and random read hit ratios to WLM.
E. The automatic altered buffer pool sizes are resized to the original with the recycle of thesub-system.
Answer: B,C,D
Guaranteed C2090-737 braindumps:
Q37. Your shop has a mixture of REXX, COBOL and native SQL procedures. For performance reasons the COBOL stored procedures must be configured to allow more than one concurrent stored procedure execution for each address space started by WLM. What is the minimum number of different WLM stored procedure address space JCL set(s) that must be defined to accomplish this?
A. 1 -- they can all be executed in the same WLM address space.
B. 2 -- one for COBOL plus one for REXX.
C. 2 -- one for REXX / COBOL plus one for native SQL stored procedures.
D. 3 -- one for each type of stored procedure.
Answer: B
Q38. A selected DB2 workload which is processed as an enclave SRB can be partially dispatched by WLM to a zIIP. Which two types of DB2 workload are eligible for zIIP offload? (Choose two.)
A. Check index with SHRLEVEL CHANGE option.
B. External stored procedures called remotely over a TCP/IP connection.
C. Native stored procedures called remotely over a TCP/IP connection.
D. Rebuild index with SHRLEVEL CHANGE option.
E. Runstats index with SHRLEVEL CHANGE option.
Answer: C,D
Q39. Which two actions must be performed for a data sharing traditional image copy disaster recovery? (Choose two.)
A. Use STARTRBA=ENDRBA for the conditional restart control record.
B. Start DB2 using the LIGHT(YES) keyword.
C. Use DEFER=ALL in the system parameters during the first restart.
D. Modify the IRLM start up proc to specify SCOPE=LOCAL.
E. Use the SETXCF FORCE command to delete DB2 CF structures.
Answer: C,E
Q40. Under which condition would the -RECOVER INDOUBT command be necessary?
A. When a thread has failed and has single phase commit scope.
B. When the commit coordinator is not available to notify DB2 of the correct commit or abortaction.
C. When the commit coordinator is not able to determine if threads should be committed oraborted.
D. When in-doubt threads have been resolved and DB2 cannot synchronize with the commitcoordinator.
Answer: B