IBM C2090-317 Online Practice Questions and Exam Preparation

IBM C2090-317 Online Questions & Answers

• Question 51:

  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?

  A. -START DB(DBA) SP(TSA) ACCESS(FORCE)
  B. Restart the failed DB2 member with the LIGHT(YES) option.
  C. 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
  D. Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}
  C. 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

• Question 52:

  How can you create a dynamic location alias?

  A. Use the CREATE ALIAS statement.
  B. Issue the -MODIFY DDF ALIAS ADD command.
  C. INSERT a dynamic alias row into SYSIBM.LOCATIONS.
  D. Execute the DSNJU003 utility with a DDF ALIAS statement.
  D. Execute the DSNJU003 utility with a DDF ALIAS statement.

• Question 53:

  The subsystem parameter PKGREL_COMMIT is set to YES.

  Which statement is true for packages bound with RELEASE(DEALLOCATE)?

  A. A persistent thread will release an active package at every COMMIT or ROLLBACK.
  B. A persistent thread will not release an active package at COMMIT or ROLLBACK.
  C. A persistent thread will release an active package at COMMIT if there is a REBIND PACKAGE request on that package.
  D. A persistent thread will not release an active package at ROLLBACK if there is a REBIND PACKAGE request on that package.
  A. A persistent thread will release an active package at every COMMIT or ROLLBACK.

• Question 54:

  Which utility can be used to reset the copy-pending status?

  A. REPAIR
  B. DSNJU003
  C. DSN1COPY
  D. COPYTOCOPY
  A. REPAIR

• Question 55:

  You wish to set the maximum allocation of sort storage to 5000 kilobytes for a query that contains an ORDER BY clause. Which action will accomplish this?

  A. Set subsystem parameter MAXRBLK to 5000.
  B. Set subsystem parameter MAXSORTJNJV1EMORY to 5000.
  C. Issue command-ALTER BUFFERPOOL(BP7) VPSIZE(5000).
  D. DB2 does not allow for user control of this maximum allocation.
  B. Set subsystem parameter MAXSORTJNJV1EMORY to 5000.

• Question 56:

  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?

  A. DWQT
  B. VDWQT
  C. VPSEQT
  D. VPPSEQT
  D. VPPSEQT

• Question 57:

  Which information uniquely identifies a distributed thread?

  A. The 'ID' field in the -DISPLAY THREAD output.
  B. The 'REG' field in the -DISPLAY THREAD output.
  C. The 'ASID' field in the -DISPLAY THREAD output.
  D. The TOKEN' field in the -DISPLAY THREAD output.
  D. The TOKEN' field in the -DISPLAY THREAD output.

• Question 58:

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

  A. COPY
  B. RUNSTATS
  C. CHECK INDEX
  D. MODIFY STATISTICS
  B. RUNSTATS

• Question 59:

  In complex DB2 recovery scenarios, it is important to understand the scope of which objects require recovery.

  Which DB2 utility provides a list of the names of all table spaces in the table space set that is specified and a list of all the tables in those table spaces?

  A. CHECK
  B. REPORT
  C. QUIESCE
  D. RECOVER
  D. RECOVER

• Question 60:

  You use utility DSN1PRNT to print the header page of table space DB1TS1. Where do you find information about the various header page fields?

  A. DB2 Messages
  B. DB2 Utility guide
  C. DB2 Diagnosis guide
  D. DB2 Administration guide
  A. DB2 Messages