Online Access Free C2090-549 Exam Questions

One of your Units of Recovery (URs) needs to be backed out. The back out fails due to a read I/O error on both copies of the archive log which is needed for the b ck out. DB2 issues a critical log read error indicating that a "must complete" operation could not be completed. Which statement is true?

• A.The error generates a write to operator with reply on the console asking you if you would like to CANCEL this UR with NOBACKOUT option and leave it in REFP restrictive state.
• B.The error generates a write to operator with reply on the console asking you if DB2 should shut down. Other URs are not directly impacted and can continue to run.
• C.The error does not generate any write to operator with reply and DB2 abends automatically.
• D.The error generates a write to operator with reply on the console asking you if DB2 should shut down. All other URs are put on hold until you answer the write to operator reply.

Which three region types MUST be present for a z/OS application to use ODBA? (Choosethree.)

• A.IRLM
• B.DLISAS
• C.CTL
• D.DBRC
• E.MPR
• F.JMP

In a non data sharing system, prefetch is getting disabled due to available buffers. Which buffer pool threshold parameter would you increase to reduce prefetch becoming disabled?

• A.VPXPSEQT
• B.VDWQT
• C.DWQT
• D.VPSEQT

Dynamic Resource Definition can be used to replace which type of sysgen?

• A.MODBLKS
• B.CTLBLKS
• C.ONLINE
• D.NUCLEUS

A customer has just migrated their DB2 system to V9 new function mode. They currently use the BACKUP SYSTEM utility and have optionally dumped the backup to tape. Which action should be performed to only use the system level backup that was taken to disk?

• A.Set the RESTORE_RECOVER_FROMDUMP system parameter to NO.
• B.Use the TAPEDUMP(NORECSYS) keyword on the BACKUP SYSTEM utility when the backup is taken.
• C.Use the BACKUPTYPE(DASD) keyword on the RESTORE SYSTEM utility.
• D.Run the DSNJU003 utility and modify the system point in time backup record to have DUMPSTATE=NONE.