IBM C2090-317 Online Practice Questions and Exam Preparation

IBM C2090-317 Online Questions & Answers

• Question 21:

  What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?

  A. DSNTIJIC
  B. DSNTIJXA
  C. DSNTIJTC
  D. DSNTIJPM
  C. DSNTIJTC

• Question 22:

  The ALTER BUFFERPOOL command specifying the AUTOSIZE(YES) option enables DB2 to use WLM services to fine tune the buffer pools. What is the result of issuing this ALTER?

  A. The immediate write threshold can be increased by 25%.
  B. A pool size can be increased by up to 25% over original pool size.
  C. The pool size can be increased in 25% increments base on sequential read hit ratio.
  D. Depending on the type of I/O performed, pool size can be increased or decreased.
  B. A pool size can be increased by up to 25% over original pool size.

• Question 23:

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

  A. Greater RECOVER utility concurrency.
  B. Reduction of the potential for an RBA rollover.
  C. More precise PIT recovery of the DB2 system catalog and directory.
  D. Potentially faster UPDATE performance due to greater LRSN granularity.
  E. Reduced p-Lock contention in the coupling facility due to greater LRSN granularity.
  C. More precise PIT recovery of the DB2 system catalog and directory.

• Question 24:

  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)
  B. -CANCEL DDF THREAD(56) FORCE

• Question 25:

  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
  A. prefix.SDSNLINK

• Question 26:

  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
  A. DBADM

• Question 27:

  You received the following error message:

  DSNI012I -DB2A PAGE LOGICALLY BROKEN TYPE 00000302 NAME DBXX.TSYYY.X'00045065' DBID01B5 OBID0020 PAGE RBA OR LRSN CCA7C9FF11C4 LOG RECORD RBA OR LRSN CCA7C9FF1B78 MODNAME DSNIOLIN ERQUAL 0000 Which utility be used to obtain more information about what may be triggering this message?

  A. DSN1CHKR
  B. CHECK DATA
  C. DSN1COPY, PARM='CHECK'
  D. DIAGNOSE DISPLAY ODB DBXXTSYYY ALL
  D. DIAGNOSE DISPLAY ODB DBXXTSYYY ALL

• Question 28:

  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.
  A. DB2 concurrent copies to DB2 VSAM data sets.

• Question 29:

  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?

  A. XSR_REGISTER
  B. XSR_REGISTER, XSR_COMPLETE
  C. No stored procedures need to be created.
  D. XSR REGISTER. XSR COMPLETE. XSR ADDSCHEMADOC
  B. XSR_REGISTER, XSR_COMPLETE

• Question 30:

  The use of the work file database for RID list processing is controlled by the value of which subsystem parameter?

  A. MAXRBLK
  B. WFDBSEP
  C. MAXTEMPS
  D. MAXTEMPS RID
  A. MAXRBLK