C2090-317 Online Practice Questions and Answers

In a data-sharing environment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time?

A. Stop all DB2 members.

B. Stop one DB2 member.

C. Do not stop any DB2 members.

D. Stop only the member where RESTORE SYSTEM will run.

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

A. REPAIR

B. DSNJU003

C. DSN1COPY

D. COPYTOCOPY

What will occur if the parameter PAGE PROTECT is set to YES?

A. MSTR log buffers (OUTBUFF) will be placed in page-protected storage.

B. IRLM is to load its common storage modules into page-protected storage.

C. DIST buffers related to TCPIP connectivity are loaded into page-protected storage.

D. DBM1 pages belonging to a buffer pool defined with PGFIX(YES) will be placed in page- protected

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

If a DB2 subsystem fails during start up in the log initialization phase, which two steps are needed in your corrective actions to minimize impact without completing a cold start?

A. Start DB2 using DEFER ALL.

B. Use DSNJU003 with the ENDRBA option.

C. Use DSNJU003 with the STARTRBA option.

D. Start DB2 using DEFER on catalog and directory.

E. Recover the subsystem to the last known system checkpoint in BSDS.

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.

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')

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

Which information uniquely identifies a distributed thread?

A. The 'ID' field in the -DISPLAY THREAD output.

B. The 'REG' field in the -DISPLAY THREAD output.

C. The 'ASID' field in the -DISPLAY THREAD output.

D. The TOKEN' field in the -DISPLAY THREAD output.

Which copy operation CANNOT be performed by DSN1COPY?

A. DB2 concurrent copies to DB2 VSAM data sets.

B. DB2 image copy data sets to DB2 VSAM data sets.

C. DB2 VSAM data sets to other DB2 VSAM data sets.

D. DSN1COPY sequential data sets to other sequential data sets.