Free IBM C2090-318 Exam Dumps Questions & Answers


Exam Code/Number:	C2090-318Join the discussion
Exam Name:	DB2 12 System Administrator for z/OS
Certification:	IBM
Free Question Number:	60
Publish Date:	Jul 16, 2026
# of views:	1675
Rating 100%

Page: 1 / 12
Total 60 questions

Question 1

Which subsystem parameter specifies whether DB2 is to create new table spaces and indexes to use a basic or extended log record format?

A.EXTSEC
B.UTILITY OBJECT CONVERSION
C.CHKLOGR
D.OBJECT_CREATE_FORMAT

Question 2

Which one of the following buffer pool thresholds determines the percentage of the buffer pool that might be occupied by sequentially accessed pages?

A.DWQT
B.VPSEQT
C.VDWQT
D.VPPSEQT

Question 3

Which of the following commands can be used to show the client correlation token in order to find details such as the ip-address. port-address and unique-id to identify the distributed transaction?

A.-DISPLAY DDF DETAIL
B.-DISPLAY FUNCTION SPECIFIC
C.-DISPLAY LOCATION OB.
D.-DISPLAY THREADH DETAIL

Question 4

To simulate a new buffer pool size, what buffer pool parameter is used?

A.SPSIZE
B.VPSIZE
C.PGFIX
D.AUTOSI2E

Question 5

Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?

A.-START DATABASE
B.-STOP DATABASE
C.-DISPLAY DATABASE
D.-ACCESS DATABASE