C2090-317 Latest Exam (Jan 2018)

[Free] 2018(Jan) EnsurePass Passguide IBM C2090-317 Dumps with VCE and PDF 11-20

January 31, 2018

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-317
100% Free Download! 100% Pass Guaranteed!

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?


  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


  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?



  3. No stored procedures need to be created.


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



Answer: D

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


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% Ensurepass Free Download!
Download Free Demo:C2090-317 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-317 Dumps

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