Online Access Free C2090-317 Exam Questions

What happens in DB2 11 CM once you hit RBA x'FFF800000000' in a non-data sharing environment?

• A.No updates are allowed.
• B.DB2 terminates and can only be restarted in maintenance mode.
• C.No updates are allowed unless you migrated the BSDS to 10-byte RBA/LRSN format.
• D.DB2 does not allow any activity except REORG SHRLEVEL CHANGE or REFERENCE.

Which subsystem parameter setting allows connection queuing?

• A.IDTHTOIN>0
• B.CONDBAT>0
• C.POOLINAC>0
• D.MAXCONGN > 0

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

• A.MAXTEMPSRID
• B.WFDBSEP
• C.MAXTEMPS
• D.MAXRBLK

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.Issue the -RECOVER BSDS command.
• B.Run the recover BSDS utility.
• C.Wait until the next stop and then start the DB2 subsystem to correct the problem.
• D.IDCAMS REPRO the correct BSDS VSAM replacing the corrupt BSDS VSAM.

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 MAXSORTJNJV1EMORY to 5000.
• B.DB2 does not allow for user control of this maximum allocation.
• C.Set subsystem parameter MAXRBLK to 5000.
• D.Issue command-ALTER BUFFERPOOL(BP7) VPSIZE(5000).