What will occur if the parameter PAGE PROTECT is set to YES? A. MSTR log buffers (OUTBUFF) will be placed in page-protected storage. B. IRLM is to load its common storage modules into page-protected storage. C. DIST buffers related to…

Which utility can be used to reset the copy-pending status? A. REPAIR B. DSNJU003 C. DSN1COPY D. COPYTOCOPY

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…

Which statement regarding DSN1LOGP is FALSE? A. DSN1 LOGP does not require DB2 privileges. B. DSN1 LOGP runs on archive data sets when DB2 is running. C. DSN1 LOGP can read logs that have been compressed by DFSMS. D. DSN1…

In a data-sharing environment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time? A. Stop all DB2 members. B. Stop one DB2 member. C. Do not stop any DB2 members. D. Stop…

You wish to enable automatic clean-up of committed pseudo-deleted index entries for all indexes in the DB2 subsystem. You have verified that system table SYSIBM.SYSINDEXCLEANUP has no rows. Without taking any other action, which action will accomplish this? A. Set…

Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base? A. RESTORE_TAPEUNITS B. SYSTEM_LEVEL_BACKUPS C. UTILS_DUMP_CLASS_NAME D. RESTORE _ RECOVER_ FROMDUMP