Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?

A. RESTORE_TAPEUNITS

B. SYSTEM_LEVEL_BACKUPS

C. UTILS_DUMP_CLASS_NAME

D. RESTORE _ RECOVER_ FROMDUMP

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.

In order to guarantee complete security for your DB2 subsystem, which statement is correct?

A. BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.

B. BSDS and catalog VSAM data sets should always be protected by the MSTR address space.

C. BSDS and catalog VSAM data sets should always be protected by an external security profile.

D. BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege

A member of a data sharing group is suffering from elongated response times. You suspect that sysplex workload balancing (WLB) is not working properly for the DDF work (not evenly distributing the work among the different members).

What is the simplest way to verify how the DDF threads are distributed amongst the different members?

A. Execute the-DIS GROUP command.

B. Execute the -DIS DDF DETAIL command on each member.

C. Execute the -DIS THDO DETAIL SCOPE(GROUP) command.

D. Executed the -DIS LOCATION(') DETAIL command on each member.

You wish to enforce a system-wide limit on the maximum number of parallel subtasks for utilities REORG TABLESPACE, REBUILD INDEX. CHECK INDEX. UNLOAD, and LOAD, to 16 parallel subtasks per utility execution.

Which action, if any will enforce this limit?

A. Set subsystem parameter PARAMDEG to 16.

B. Set subsystem parameter PARAMDEGJJTIL to 16.

C. Set subsystem parameter INDEX_IO_PARALLELISM to 16.

D. DB2 does not allow for a system level limit for parallel subtasks in these utilities. The limit can only be specified with the utility keyword PARALLEL n.

You use utility DSN1PRNT to print the header page of table space DB1TS1. Where do you find information about the various header page fields?

A. DB2 Messages

B. DB2 Utility guide

C. DB2 Diagnosis guide

D. DB2 Administration guide

How can you create a dynamic location alias?

A. Use the CREATE ALIAS statement.

B. Issue the -MODIFY DDF ALIAS ADD command.

C. INSERT a dynamic alias row into SYSIBM.LOCATIONS.

D. Execute the DSNJU003 utility with a DDF ALIAS statement.

What is the minimum level of authority needed to use the DETAIL keyword on a -DISPLAY THREAD command?

A. DBADM

B. SYSADM

C. SYSOPR

D. SYSCTRL

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

Which z/OS or DB2 component is required for stored procedures that run in a WLM-established address space?

A. Call attachment facility

B. TSO attachment facility

C. Distributed data facility

D. Resource recovery services