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?
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?
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?