IBM IBM Certifications C2090-317 Questions & Answers

• Question 21:

  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

  Correct Answer: A

• Question 22:

  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.

  Correct Answer: B

• Question 23:

  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

  Correct Answer: C

• Question 24:

  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.

  Correct Answer: C

• Question 25:

  You wish to enforce a system-wide limit on the maximum number of parallel subtasks for utilities REORG TABLESPACE, REBUILD INDEX. CHECK INDEX. UNLOAD, and LOAD, to 16 parallel subtasks per utility execution.

  Which action, if any will enforce this limit?

  A. Set subsystem parameter PARAMDEG to 16.

  B. Set subsystem parameter PARAMDEGJJTIL to 16.

  C. Set subsystem parameter INDEX_IO_PARALLELISM to 16.

  D. DB2 does not allow for a system level limit for parallel subtasks in these utilities. The limit can only be specified with the utility keyword PARALLEL n.

  Correct Answer: A

• Question 26:

  Your production DB2 subsystem is up and running, the following message is received:

  DSNJ126I - BSDS ERROR FORCED SINGLE BSDS MODE because one of the BSDS volumes is offline.

  After the volume is back online, in order to ensure a securely running system, what is the least disruptive scenario to correct this error?

  A. Run the recover BSDS utility.

  B. Issue the -RECOVER BSDS command.

  C. IDCAMS REPRO the correct BSDS VSAM replacing the corrupt BSDS VSAM.

  D. Wait until the next stop and then start the DB2 subsystem to correct the problem.

  Correct Answer: C

• Question 27:

  Which statement is true regarding DB2 definitions for SMF collection?

  A. SMF collection is not required for DB2.

  B. At the minimum, DB2 statistics class 1 trace is required.

  C. At the minimum. DB2 accounting classes 1.2.3 are required.

  D. The SMF subsystem does not have to be active for DB2 to write SMF trace records.

  Correct Answer: B

• Question 28:

  DB2 can use RUNSTATS profiles for autonomic statistics maintenance. Which catalog table holds the options specified for the profiles?

  A. SYSIBM.SYSAUTOALERTS

  B. SYSIBM.SYSSTATFEEDBACK

  C. SYSIBM.SYSTABLES_PROFILES

  D. SYSIBM.SYSTABLESPACESTATS

  Correct Answer: D

• Question 29:

  Program Authorization does NOT work in which environment?

  A. IMS

  B. CICS

  C. DSN command processor

  D. Programs that run in stored procedure address spaces

  Correct Answer: C

• Question 30:

  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.

  Correct Answer: A