IBM C2090-612 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-612
Exam Name/Title: DB2 10 DBA for z/OS
Certification Provider: IBM
Corresponding Certification: DB2

Exam Questions: 134
Updated On: Jun 02, 2026

Question #37

DB2 does not take system checkpoints in which circumstance?

A. When switching from one active log data set to another.

B. At the end of a successful restart.

C. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.

D. During an application rollback.

Discussion 0

Correct Answer: D Vote an answer

Question #38

What is the maximum levels of backup that DB2 plan stability can support?

A. 2

B. 4

C. 3

D. 1

Discussion 0

Correct Answer: C Vote an answer

Question #39

To monitor the storage used above and below the 2GB bar, what must occur?

A. Start a monitor class 1 & 2 trace.

B. Start a statistics class 1 trace.

C. Start an audit class 3 trace.

D. Start accounting class 7 & 8 traces.

Discussion 0

Correct Answer: B Vote an answer

Question #40

In order to retain an access path across a rebind which of the following commands could be used?

A. REBIND PACKAGE (PK1) PLANMGMT(BASIC)

B. BIND PACKAGE (PK1) EXPLAIN(YES)

C. REBIND PACKAGE(PK1) REOPT(ONCE)

D. BIND PLAN

Discussion 0

Correct Answer: A Vote an answer

Question #41

In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?

A. SCA

B. LOCK

C. GBP0

D. GBP32

Discussion 0

Correct Answer: A Vote an answer

Question #42

Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)

A. FASTSWITCH YES

B. LOG NO

C. DRAIN_WAIT & RETRY

D. AUTOESTSPACE YES

E. SORTKEYS 16

Discussion 0

Correct Answer: A,C Vote an answer

Question #43

Which of the following statements is NOT correct?

A. Clone table allows replacing data without renames and rebinds to support online load replace.

B. UNLOAD with NOPAD improves performance.

C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.

D. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).

Discussion 0

Correct Answer: D Vote an answer

Question #44

Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pendingstate AND creates an entry in SYSIBM.SYSCOPY?

A. Run the REPAIR SET NOCOPYPEND utility.

B. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.

C. Run the BACKUP SYSTEM utility.

D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.

Discussion 0

Correct Answer: B Vote an answer

Question #45

What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?

A. Run a Point In Time RECOVER or the LOAD REPLACE utility.

B. Recover the table space to current.

C. Run the REORG utility with SHRLEVEL NONE.

D. Issue command -START DB(yourdb) SP(yourtbspace) ACCESS(FORCE).

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM C2090-612 Demo

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