C2090-317 Online Practice Questions and Answers

Which statement regarding DSN1LOGP is FALSE?

A. DSN1 LOGP does not require DB2 privileges.

B. DSN1 LOGP runs on archive data sets when DB2 is running.

C. DSN1 LOGP can read logs that have been compressed by DFSMS.

D. DSN1 LOGP can print the log records for both base and clone table objects.

Which utility can be used to reset the copy-pending status?

A. REPAIR

B. DSNJU003

C. DSN1COPY

D. COPYTOCOPY

Which statement regarding migration from DB2 10 for z/OS to DB2 11 for z/OS is true?

A. All packages must be rebound with application compatibility set to V10R1.

B. The DB2 catalog and directory must be changed to reside on SMS managed DASD.

C. All packages last bound prior to DB2 9 for z/OS must be rebound in DB2 10 or DB2 11.

D. The size of the DB2 bootstrap datasets must be increased to accommodate a larger LRSN and RBA length.

A given buffer pool is to be used for sequentially accessed pages only. Setting which buffer pool attribute to 0 (zero) will disable parallel processing operations in this buffer pool?

A. DWQT

B. VDWQT

C. VPSEQT

D. VPPSEQT

In an environment with a large amount of dynamic SQL, which subsystem parameter should be adjusted to increase the amount of memory available for caching statements in the global dynamic statement cache?

A. EDMPOOL

B. EDMDBDC

C. MAXKEEPD

D. EDMSTMTC

DB2 can use RUNSTATS profiles for autonomic statistics maintenance. Which catalog table holds the options specified for the profiles?

A. SYSIBM.SYSAUTOALERTS

B. SYSIBM.SYSSTATFEEDBACK

C. SYSIBM.SYSTABLES_PROFILES

D. SYSIBM.SYSTABLESPACESTATS

When might image copies be needed in a data mirroring environment during disaster recovery?

A. To resolve outstanding units of recovery.

B. If the RBA in the BSDS is higher than the RBA in the active log.

C. Image copies would never be needed when using data mirroring.

D. If a LOAD or RECOVER utility was active at the time of the disaster.

You are facing a severe locking problem with a specific application using plan PLANB. To identify what is going on you need to start a detailed locking trace. However, you want to limit the scope of the trace somewhat to reduce the trace overhead and trace volume. (IFCID 21 traces each lock request and is part of performance trace class 7).

Which is the most appropriate command to use ?

A. -STA TRA(P) CLASS(7) DEST(GTF) PLAN(PLANB)

B. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) PLAN(PLANB)

C. -STATRA(P)CLASS(30) IFCID(21) DEST(GTF) PLAN(PLANB)

D. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) XPLAN(PLANB')

For migration to DB2 11, we must implement the early code (ERLY). What DB2 library contains the early code for DB2?

A. prefix.SDSNLINK

B. prefix.SDSNEXIT

C. prefix.SDSNLOD2

D. prefix.SDSNLOAD

A z/OS Workload Manager (WLM) application environment must be created to enable which functionality in DB2?

A. Global dynamic SQL caching in the EDM pool

B. Service class assignments for dispatchable work in DB2

C. zllP redirect processing for enclave SRB workloads which are zllP redirect eligible

D. DB2 supplied routine SYSPROC.ADMIN_INFO_SYSPARM. which lists the settings of subsystem parameters