Actualtests offers free demo for C2090-317 exam. "DB2 11 System Administrator for z/OS", also known as C2090-317 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-317 exam, will help you answer those questions. The C2090-317 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-317 exams and revised by experts!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-317 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-317 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-317-exam-dumps.html
Q11. The -ALTER UTILITY command changes the values of certain parameters of a utility.
Which two utilities can this command be issued against?
A. COPY
B. REORG
C. MODIFY
D. REBUILD
E. RECOVER
Answer: B,D
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.admin/src/tpc/ db2z_monitronlineutilities.dita
Q12. What utility can benefit from the additional zllP (IBM System z Integrated Information Processor) enablement inDB2 11?
A. COPY
B. RUNSTATS
C. CHECK INDEX
D. MODIFY STATISTICS
Answer: B
Q13. For migration to DB2 11, we must implement the early code (ERLY).
What DB2 library contains the early code for DB2?
A. prefix.SDSNLINK
B. prefix.SDSNEXIT
C. prefix.SDSNLOD2
D. prefix.SDSNLOAD
Answer: A
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.inst/src/tpc/db 2z_chooselinklistopts.dita
Q14. Local buffer pool updated pages are queued by data set until they are written out to DASD when which event occurs?
A. A page is added.
B. A COMMIT is executed.
C. When VPSEQT is reached.
D. A system checkpoint is taken.g
Answer: B
Q15. Which utility can be used to reset the copy-pending status?
A. REPAIR
B. DSNJU003
C. DSN1COPY
D. COPYTOCOPY
Answer: A
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_resetindexspacestatus.dita
Q16. Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?
A. RESTORE_TAPEUNITS
B. SYSTEM_LEVEL_BACKUPS
C. UTILS_DUMP_CLASS_NAME
D. RESTORE _RECOVER_FROMDUMP
Answer: D
Q17. The use of the work file database for RID list processing is controlled by the value of which
subsystem parameter?
A. MAXRBLK
B. WFDBSEP
C. MAXTEMPS
D. MAXTEMPSRID
Answer: A
Q18. Program Authorization does NOT work in which environment?
A. IMS
B. CICS
C. DSN command processor
D. Programs that run in stored procedure address spaces
Answer: C
Q19. Which trace can be helpful in determining the resources involved with locking (i.e. deadlocks, timeouts) at a subsystem level?
A. Statistics trace class 1
B. Statistics trace class 3
C. Accounting trace class 1
D. Accounting trace class 3
Answer: B
Q20. You wish to enable automatic clean-up of committed pseudo-deleted index entries for all indexes in the DB2 subsystem. You have verified that system table SYSIBM.SYSINDEXCLEANUP has no rows.
Without taking any other action, which action will accomplish this?
A. Set subsystem parameter INDEX_CLEANUP_THREADS to 10.
B. Set subsystem parameter INDEX_CLEANUP_THREADS to YES.
C. Issue an ALTER INDEX statement against all indexes with ERASE YES.
D. Issue an ALTER INDEX statement against all indexes with FREEPAGE 0.
Answer: A
Explanation:Reference:http://www.gsebelux.com/system/files/GSE%20DB2%20DB2%2011%20Availabi lity%20endhancements.pdf(slide 20)