C2090-317 Dumps

C2090-317 Braindumps C2090-317 Real Questions C2090-317 Practice Test C2090-317 Actual Questions


killexams.com


IBM


C2090-317


DB2 11 System Administrator for z/OS


https://killexams.com/pass4sure/exam-detail/C2090-317


QUESTION: 51

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?


  1. -CANCEL THREAD(56)

  2. -CANCEL DDF THREAD(56) FORCE

  3. -CANCEL THREAD(56)NOBACKOUT

  4. -CANCEL DDF THREAD(56)


Answer: B


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc/ db2z_cmd_stopddf.dita


QUESTION: 52

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


  1. DBADM

  2. SYSADM

  3. SYSOPR

  4. SYSCTRL


Answer: A


QUESTION: 53

Which information uniquely identifies a distributed thread?


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

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

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

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


Answer: D


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc/ db2z_cmd_cancelthread.dita(thread (token))


QUESTION: 54

Which copy operation CANNOT be performed by DSN1COPY?


  1. DB2 concurrent copies to DB2 VSAM data sets.

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

  3. DB2 VSAM data sets to other DB2 VSAM data sets.

  4. DSN1COPY sequential data sets to other sequential data sets.


Answer: A


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_utl_dsn1copy.dita


QUESTION: 55

For migration to DB2 11, we must implement the early code (ERLY). What DB2 library contains the early code for DB2?


  1. prefix.SDSNLINK

  2. prefix.SDSNEXIT

  3. prefix.SDSNLOD2

  4. prefix.SDSNLOAD


Answer: A


Reference:

http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.inst/src/tpc/db 2z_chooselinklistopts.dita


QUESTION: 56

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?


  1. EXPLAIN STMTCACHE;

  2. EXPLAIN STMTCACHE ALL;

  3. EXPLAIN STMTCACHE STMTID integer;

  4. EXPLAIN STMTCACHE STMTTOKEN string;


Answer: A


QUESTION: 57

A z/OS Workload Manager (WLM) application environment must be created to enable which functionality in DB2?


  1. Global dynamic SQL caching in the EDM pool

  2. Service class assignments for dispatchable work in DB2

  3. zllP redirect processing for enclave SRB workloads which are zllP redirect eligible

  4. DB2 supplied routine SYSPROC.ADMIN_INFO_SYSPARM. which lists the settings of subsystem parameters


Answer: A


QUESTION: 58

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


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

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

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

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


Answer: C


QUESTION: 59

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


  1. COPY

  2. RUNSTATS

  3. CHECK INDEX

  4. MODIFY STATISTICS

Answer: B


QUESTION: 60

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


  1. Call attachment facility

  2. TSO attachment facility

  3. Distributed data facility

  4. Resource recovery services


Answer: A