File Info
| Exam | DB2 11 System Administrator for z/OS |
| Number | C2090-317 |
| File Name | IBM.C2090-317.SelfTestEngine.2017-09-07.37q.tqb |
| Size | 128 KB |
| Posted | Sep 07, 2017 |
| Download | IBM.C2090-317.SelfTestEngine.2017-09-07.37q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With 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)
