image


C2090-317 Dumps

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


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

image

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


image

6$03/( 48(67,216


7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV


.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP


$FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP


([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP


3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV


*XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\


'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU

.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG