1.
In a data-sharing environment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time?
2.
Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?
3.
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?
4.
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 about what may be triggering this message?
5.
Which utility can be used to reset the copy-pending status?
6.
What will occur if the parameter PAGE PROTECT is set to YES?
7.
The ALTER BUFFERPOOL command specifying the AUTOSIZE(YES) option enables DB2 to use WLM services to fine tune the buffer pools. What is the result of issuing this ALTER?
8.
Which method can be used to set the DB2 client information (workstation name, application name..) from a JDBC application using a type 4 connection?
9.
Which statement regarding migration from DB2 10 for z/OS to DB2 11 for z/OS is true?
10.
Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?