IBM C2090-318 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-318
Exam Name/Title: DB2 12 System Administrator for z/OS
Certification Provider: IBM
Corresponding Certification: IBM Data and AI

Exam Questions: 60
Updated On: May 31, 2026

Question #13

Which type of trace is used to record transaction-level data that is written when the processing for a transaction is completed?

A. Accounting

B. Statistics

C. Audit

D. Monitor

Discussion 0

Correct Answer: A Vote an answer

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

Question #14

Which of the following is TRUE about the SYSCTRL authority?

A. It is designed not to be a part of the administrative authorizations

B. It is designed to allow access to all data directly in DB2

C. It is designed so group privileges cannot be granted to SYSCTRL

D. It is designed to be an administrator in a system with sensitive data

Discussion 0

Correct Answer: D Vote an answer

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

Question #15

A down level page set is identified by the following error message:
DSNB232I UNEXPECTED DATA SET LEVEL ID ENCOUNTERED
Which of the following should be performed to correct the condition?

A. Replace the object with an appropriate data set at the proper level and confirm with DSN1PRNT of the header page

B. Execute a REORG on the object in question

C. Stop the object, set the DLDFREQ subsystem parameter to OFF. and then restart the object in RW status

D. Execute a REPAIR DBD REBUILD on the object

Discussion 0

Correct Answer: D Vote an answer

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

Question #16

DB2 has stopped working because it has problems archiving the last active log. Which of the following commands could be used to resolve the situation?

A. -SET LOG SUSPEND

B. -SET LOG RESUME

C. -SET LOG LOGLOAD

D. -SET LOG NEWLOG

Discussion 0

Correct Answer: D Vote an answer

Question #17

In order to install the RACF access control module for a DB2 subsystem, to which of the following modules should DSNTIJEX refer?

A. DSNXRXAC

B. DSN3@ATH

C. DSNXSXAC

D. DSN3@SGN

Discussion 0

Correct Answer: A Vote an answer

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

Question #18

Which of the following migration steps is optional?

A. Tailor the DB2 catalog

B. Define DB2 initialization parameters: DSNTIJUZ

C. Define DB2 12 to z/OS

D. Verify the integrity of the DB2 catalog and directory

Discussion 0

Correct Answer: D Vote an answer

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

Download Free IBM C2090-318 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2090-318 exam.