Labour Day Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

Note! C2090-312 has been withdrawn.

C2090-312 Practice Exam Questions with Answers IBM DB2 11 DBA for z/OS Certification

Question # 6

What is necessary in order to enable optimization hints?

A.

ASYSIBM.PLAN_TABLEtable.

B.

INSERT authority on SYSIBM.SYSQUERY table.

C.

A required index on the PLAN_TABLE used for optimization hints.

D.

ADSN USERQUERY TABLE table under the schema in which hints will be created.

Full Access
Question # 7

You want to determine which objects of your database DB1 are in LPL. What command should be used?

A.

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(')

B.

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(')

C.

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(") SCOPE(GROUP)

D.

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(') SCOPE(GROUP)

Full Access
Question # 8

Given the following output:

DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS -

DSNV402I _DB2D ACTIVE THREADS -

NAME ST A REQ ID AUTHID PLAN ASID TOKEN

DB2CALL T 17039 BBISS BBISS 00AF 19855

TSO T * 3 KSTTEST KSTTEST 0135 20172

A51OTEST N* 13 CICSTEST 0125 19625

You receive a call that user KSTTEST is holding resources and needs to be canceled.

Which command should be issued?

A.

-CANCEL THREAD( 3)

B.

-CANCEL THREAD(20172)

C.

-CANCEL USER(KSTTEST)

D.

User KSTTEST does not hold an active connection, no way he blocks anything.

Full Access
Question # 9

The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE(FORCE).

Where can this be verified?

A.

In the DSN1PRNT job output of the header page.

B.

In the DB2 MSTR address space joblog as all DB2 commands are shown there.

C.

In the DB2 recovery log as all DB2 commands are written to the DB2 recovery log.

D.

In the z/OS system log (SYSLOG), as all commands including DB2 commands are written to the z/OS system log.

Full Access
Question # 10

What is required before you begin your installation of DB2 11?

A.

Data sets for catalog and directory tables must be user-managed.

B.

Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format.

C.

Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.

D.

Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.

Full Access