Download DB2 11 System Administrator for z-OS.C2090-317.SelfTestEngine.2017-09-07.37q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-317 |
| Exam Name: | DB2 11 System Administrator for z/OS |
| Date: | Sep 07, 2017 |
| File Size: | 128 KB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
In a data-sharing environment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time?
- Stop all DB2 members.
- Stop one DB2 member.
- Do not stop any DB2 members.
- Stop only the member where RESTORE SYSTEM will run.
Correct answer: D
Question 2
Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?
- RESTORE_TAPEUNITS
- SYSTEM_LEVEL_BACKUPS
- UTILS_DUMP_CLASS_NAME
- RESTORE _ RECOVER_ FROMDUMP
Correct answer: D
Question 3
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?
- Set subsystem parameter INDEX_CLEANUP_THREADS to 10.
- Set subsystem parameter INDEX_CLEANUP_THREADS to YES.
- Issue an ALTER INDEX statement against all indexes with ERASE YES.
- Issue an ALTER INDEX statement against all indexes with FREEPAGE 0.
Correct answer: A
Explanation:
Reference: http://www.gsebelux.com/system/files/GSE%20DB2%20DB2%2011%20Availability%20endhancements.pdf (slide 20) Reference: http://www.gsebelux.com/system/files/GSE%20DB2%20DB2%2011%20Availability%20endhancements.pdf (slide 20)
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!