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
In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?
Correct Answer: B Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Which of the following utilities would produce information needed to identify UNDO information for a transaction?
Correct Answer: B Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
What are the appropriate actions that can be taken to reduce false contention in a data sharing environment?
(Choose two)
Correct Answer: B,E Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Which stored procedures need to be set up in order to register an XML schema?
Correct Answer: A Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?
Correct Answer: A Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
DB2A and DB2B are in the same data sharing group on separate LPARs There are two coupling facilities CF01 and CF02. CF01 contains the Lock and SCA structures and CF02 contains the GBP structures. The group buffer pools are not duplexed. The structures can reside on either CF01 or CF02 as specified in the CRFM policy PREFLIST and AUTOREC is set to YES.
CF02 fails and DB2A or DB2B can no longer connect to it. Once they are able to reconnect, what action is necessary in order to minimize loss of data availability?
Correct Answer: D Vote an answer
0
0
0
10