Download DB2 11 System Administrator for z-OS.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

Download Exam

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

Which utility can be used to reset the copy-pending status?

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

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

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

CONNECT US

HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset