C2090-317 Online Practice Questions and Answers

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

A. REPAIR

B. DSNJU003

C. DSN1COPY

D. COPYTOCOPY

Which method can be used to set the DB2 client information (workstation name, application name..) from a JDBC application using a type 4 connection?

A. Using the java.sql.Connection.setClientlnfo method

B. Using the SET_CLIENT_ID option during RRS SIGNON

C. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = 'MYWS*)

D. Setting up a profile using the SPECIAL_REGISTER attribute in SYSIBM.DSN PROFILE ATTRIBUTES table

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.

Which two features are the motivation behind the conversion to extended RBA/LRSN format?

A. Greater RECOVER utility concurrency.

B. Reduction of the potential for an RBA rollover.

C. More precise PIT recovery of the DB2 system catalog and directory.

D. Potentially faster UPDATE performance due to greater LRSN granularity.

E. Reduced p-Lock contention in the coupling facility due to greater LRSN granularity.

You wish to set the maximum allocation of sort storage to 5000 kilobytes for a query that contains an ORDER BY clause.

Which action will accomplish this?

A. Set subsystem parameter MAXRBLK to 5000.

B. Set subsystem parameter MAXSORTJNJV1EMORY to 5000.

C. Issue command-ALTER BUFFERPOOL(BP7) VPSIZE(5000).

D. DB2 does not allow for user control of this maximum allocation.

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

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.

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

Which statement about the castout process in data sharing is true?

A. The castout process is initiated by the coupling facility.

B. The castout process is performed using BPO of the less active member of the group.

C. The castout process is performed by the first member to express write interest in the data set.

D. The castout process is performed using a private buffer pool in the first member to join the group.