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 #25

When using a persistent thread bound with RELEASE(DEALLOCATE), which subsystem parameter setting will permit a REBIND PACKAGE at a COMMIT or ROLLBACK in this thread?

A. APPLCOMPAT=YES

B. ABIND=COEXIST

C. BINDNV=BIND

D. PKGREL COMMIT=YES

Discussion 0

Correct Answer: D Vote an answer

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

Question #26

Which of the following is an advantage of role-based security?

A. Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization

B. If you DROP a role that owns objects, those objects will also be dropped

C. Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time

D. If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement

Discussion 0

Correct Answer: B Vote an answer

Question #27

Considering the following command:
-CANCEL THREAD {*) FORCE
In which of the following situations can it be used?

A. If you are terminating a distributed thread that is part of a global transaction

B. If the CANCEL THREAD command without the FORCE option does not terminate the thread

C. On application threads that update NOT LOGGED table spaces

D. On local threads that are not in DB2

Discussion 0

Correct Answer: B Vote an answer

Question #28

DB2 just abended unexpectedly and needs to be restarted as quickly and consistently as possible. Which of the following restart method do you pick?

A. Create a conditional restart record using option ENDRBA and then restart DB2

B. Create a conditional restart record using option STARTRBA and then restart DB2.

C. Perform a cold start

D. Issue the-START DB2 command

Discussion 0

Correct Answer: C Vote an answer

Question #29

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 FUNCTION SPECIFIC

B. -DISPLAY DDF DETAIL

C. -DISPLAY LOCATION OB.

D. -DISPLAY THREADH DETAIL

Discussion 0

Correct Answer: D Vote an answer

Question #30

Beginning with function level V12R1M500. what would be the maximum data set size of an active log?

A. 255 GB

B. 4 GB

C. 768 GB

D. 123 GB

Discussion 0

Correct Answer: B 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.