C2090-317 Online Practice Questions and Answers

In complex DB2 recovery scenarios, it is important to understand the scope of which objects require recovery.

Which DB2 utility provides a list of the names of all table spaces in the table space set that is specified and a list of all the tables in those table spaces?

A. CHECK

B. REPORT

C. QUIESCE

D. RECOVER

Which combination of subsystem parameter values will enable connection pooling for idle distributed database access threads?

A. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT = MAXDBAT.

B. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT < MAXDBAT.

C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.

D. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT >MAXDBAT.

Your database administrators plan to start using XML and they plan to have the XML documents being

validated using type modifiers.

You must make sure that they are able to make XSR schemas available for this.

Which stored procedure(s), if any, must at least be created and functioning for that?

A. XSR_REGISTER

B. XSR_REGISTER, XSR_COMPLETE

C. No stored procedures need to be created.

D. XSR REGISTER. XSR COMPLETE. XSR ADDSCHEMADOC

How can conditional restarts affect sequence objects?

A. Gaps may exist.

B. Duplicate entries will be deleted.

C. All values will be reset beginning from 1.

D. All values will be reset beginning from 0.

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.

Which statement is true regarding DB2 definitions for SMF collection?

A. SMF collection is not required for DB2.

B. At the minimum, DB2 statistics class 1 trace is required.

C. At the minimum. DB2 accounting classes 1.2.3 are required.

D. The SMF subsystem does not have to be active for DB2 to write SMF trace records.

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.

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.

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.