IBM DB2 12 System Administrator for z/OS - C2090-318 Exam Questions [2026]

QUESTION NO: 1
Which of the following are TRUE regarding the DSN1PRNT utility? (Choose two)

A. lt can be executed when the DB2 subsystem is not operational B. It does not decrypt any encrypted data C. Compressed records cannot be printed in decompressed format D. The input can be a list of concatenated DB2 VSAM data sets E. lt can be executed on both image copies and concurrent copies

Correct Answer: A,B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
While processing a DB2 must-complete function, DB2 encountered an error during an attempt to access the required log data sets. Which of the following is TRUE?

A. DB2 will wait for a reply to message DSNJ154I before retrying the failed log-read request, or before abending B. DB2 abends C. The affected page sets will be put into RESTP restrictive state D. The affected page sets will be put into REFP restrictive state

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
What resource is used to communicate BSDS and log data set names between DB2 members in a data sharing group?

A. SCA B. DB2 directory C. DB2log D. Lock structure

Correct Answer: A

QUESTION NO: 4
With which authority can you create, display, activate, or inactivate DB2 audit policies?

A. SYSADM B. SECADM C. SYSCTRL D. SYSOPR

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
Before execution of the CHECK DATA utility, which of the following should be performed?

A. Start the object in question with FORCE to remove any CHECK PENDING status B. Execute the REPAIR utility with SET NOCHECKPEND C. Alter the object to remove any table or referential constraint definitions D. Execute CHECK INDEX on the primary key and foreign key indexes

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
Considering the following command:
-STOP DDF MODE(SUSPEND)
Which of the following, pertaining to DDF connections in a two-way data sharing environment, is TRUE?

A. It terminates currently executing distributed threads on the current member of the data sharing group B. It stops the DDF on all the members of the data sharing group where DDF has already been started C. It stops the DDF on the current member of the data sharing group if DDF has already been started D. It suspends DDF threads by preventing the outbound DDF work

Correct Answer: C