Recover indexes converted to type 2

If your indexes were altered to TYPE 2 as a result of running DSQ1TBJ0, they must be recovered, loaded or reorganized.

If you are uncertain whether indexes need to be rebuilt, follow these steps:

1. Review the output of job DSQ1TBJ0. If the final return code was 4, search the job output for the string ALTER INDEX. If you find any occurrences of ALTER INDEX, perform the next step.
2. Run the following DB2 command:

   -DISPLAY DATABASE (DSQDBCTL) SPACENAM (*)

   If any indexes (TYPE=IX) show a STATUS of RECP or RW,RECP, rebuild the indexes.

Depending on your DB2 for OS/390 release, the following DB2 utility job streams must be run:

Version 5 and lower

RECOVER INDEX(ALL) TABLESPACE DSQDBCTL.DSQTSCT1
RECOVER INDEX(ALL) TABLESPACE DSQDBCTL.DSQTSCT2
RECOVER INDEX(ALL) TABLESPACE DSQDBCTL.DSQTSCT3
RECOVER INDEX(ALL) TABLESPACE DSQDBCTL.DSQTSPRO
RECOVER INDEX(ALL) TABLESPACE DSQDBCTL.DSQTSSYN

Version 6 and above

REBUILD INDEX (Q.OBJECT_DIRECTORYX)
REBUILD INDEX (Q.OBJECT_REMARKSX)
REBUILD INDEX (Q.OBJECT_OBJDATAX)
REBUILD INDEX (Q.PROFILEX)
REBUILD INDEX (Q.COMMAND_SYNONYMSX)