IBM IBM Certifications C2090-317 Questions & Answers

• Question 1:

  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

  Correct Answer: A

• Question 2:

  What utility can benefit from the additional zllP (IBM System z Integrated Information Processor) enablement inDB2 11?

  A. COPY

  B. RUNSTATS

  C. CHECK INDEX

  D. MODIFY STATISTICS

  Correct Answer: B

• Question 3:

  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.

  Correct Answer: C

• Question 4:

  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

  Correct Answer: A

• Question 5:

  The statement cache table, DSN_STATEMENT_CACHE_TABLE. contains information about the SQL statements in the statement cache.

  Which SQL statement will NOT capture information from the DB2 dynamic statement cache into this table?

  A. EXPLAIN STMTCACHE;

  B. EXPLAIN STMTCACHE ALL;

  C. EXPLAIN STMTCACHE STMTID integer;

  D. EXPLAIN STMTCACHE STMTTOKEN string;

  Correct Answer: A

• Question 6:

  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

  Correct Answer: A

• Question 7:

  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.

  Correct Answer: A

• Question 8:

  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.

  Correct Answer: D

• Question 9:

  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

  Correct Answer: A

• Question 10:

  A DDF thread with a token of 56 needs to be cancelled but due to a very tight processing loop in the thread, a regular cancel thread command might not work. What action(s) would provide the best chance to initially attempt to cancel this thread?

  A. -CANCEL THREAD(56)

  B. -CANCEL DDF THREAD(56) FORCE

  C. -CANCEL THREAD(56)NOBACKOUT

  D. -CANCEL DDF THREAD(56)

  Correct Answer: B