Download IBM.C2090-317.TestBells.2018-06-02.35q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-317 |
| Exam Name: | DB2 11 System Administrator for z/OS |
| Date: | Jun 02, 2018 |
| File Size: | 122 KB |
Demo Questions
Question 1
Which utility can be used to reset the copy-pending status?
- REPAIR
- DSNJU003
- DSN1COPY
- COPYTOCOPY
Correct answer: A
Explanation:
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/db2z_resetindexspacestatus.dita Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/db2z_resetindexspacestatus.dita
Question 2
What will occur if the parameter PAGE PROTECT is set to YES?
- MSTR log buffers (OUTBUFF) will be placed in page-protected storage.
- IRLM is to load its common storage modules into page-protected storage.
- DIST buffers related to TCPIP connectivity are loaded into page-protected storage.
- DBM1 pages belonging to a buffer pool defined with PGFIX(YES) will be placed in page-protected
Correct answer: D
Question 3
The ALTER BUFFERPOOL command specifying the AUTOSIZE(YES) option enables DB2 to use WLM services to fine tune the buffer pools.
What is the result of issuing this ALTER?
- The immediate write threshold can be increased by 25%.
- A pool size can be increased by up to 25% over original pool size.
- The pool size can be increased in 25% increments base on sequential read hit ratio.
- Depending on the type of I/O performed, pool size can be increased or decreased.
Correct answer: B
Explanation:
Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db2z_enableautobpsize.dita Reference: http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db2z_enableautobpsize.dita
