[Free] 2017(Oct) CollectDumps Dumpsleader IBM C2090-317 V13 Dumps with VCE and PDF Download 11-20

CollectDumps 2017 Oct IBM Official New Released C2090-317 V13
100% Free Download! 100% Pass Guaranteed!
http://www.CollectDumps.com/C2090-317 V13.html

DB2 11 System Administrator for z/OS

Question No: 11

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?

  1. Start DB2 using DEFER ALL.

  2. Use DSNJU003 with the ENDRBA option.

  3. Use DSNJU003 with the STARTRBA option.

  4. Start DB2 using DEFER on catalog and directory.

  5. Recover the subsystem to the last known system checkpoint in BSDS.

Answer: D,E

Question No: 12

Which subsystem parameter setting allows connection queuing?

  1. IDTHTOINgt;0

  2. CONDBATgt;0

  3. POOLINACgt;0

  4. MAXCONGN gt; 0

Answer: D

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.inst/src/tpc/db 2z_zparmnotonpanels.dita(see MAXCONQN)

Question No: 13

A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the phone starts ringing and people complain that transactions accessing table space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by the member that just abended.

What is the recommended way to resolve this problem?

  1. -START DB(DBA) SP(TSA) ACCESS(FORCE)

  2. Restart the failed DB2 member with the LIGHT(YES) option.

  3. Delete all the failed persistent connections to the lock structure with the SETXCFFORCE,CONNECTION,STRNAME=lock_strname.CONNAME=ALL command and force the deallocation of the lock structure by issuing SETXCFFORCE,STRUCTURE.STRNAME=lock_strname

  4. Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}

Answer: C

Question No: 14

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

format?

  1. Greater RECOVER utility concurrency.

  2. Reduction of the potential for an RBA rollover.

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

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

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

Answer: C

Question No: 15

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?

  1. XSR_REGISTER

  2. XSR_REGISTER, XSR_COMPLETE

  3. No stored procedures need to be created.

  4. XSRREGISTER. XSRCOMPLETE. XSRADDSCHEMADOC

Answer: B

Question No: 16

A given buffer pool is to be used for sequentially accessed pages only.

Setting which buffer pool attribute to 0 (zero) will disable parallel processing operations in this buffer pool?

  1. DWQT

  2. VDWQT

  3. VPSEQT

  4. VPPSEQT

Answer: D

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc

/db2z_cmd_alterbufferpool.dita(vppseqt)

Question No: 17

Which information uniquely identifies a distributed thread?

  1. The #39;ID#39; field in the -DISPLAY THREAD output.

  2. The #39;REG#39; field in the -DISPLAY THREAD output.

  3. The #39;ASID#39; field in the -DISPLAY THREAD output.

  4. The TOKEN#39; 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 No: 18

In adata-sharingenvironment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time?

  1. Stop all DB2 members.

  2. Stop one DB2 member.

  3. Do not stop any DB2 members.

  4. Stop only the member where RESTORE SYSTEM will run.

Answer: D

Question No: 19

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 No: 20

One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that 90% of the class 2 elapsed time consists of class 3 suspension time.

Which statement describes the behavior of the application?

  1. The application is the victim of excessive performance tracing.

  2. The application spends the majority of its time waiting on the network.

  3. The application contains complex SQL statements that are CPU intensive.

  4. The application spends the majority of its time waiting for buffer pool I/O and log I/O.

Answer: C

100% Free Download!
Download Free Demo:C2090-317 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 CollectDumps C2090-317 V13 Full Exam PDF and VCE

CollectDumps ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 CollectDumps IT Certification PDF and VCE