Converting QMF control table indexes to type 2:

If you are running DB2 for MVS/ESA Version 4 or above, the QMF control table indexes will be migrated or created as TYPE 2 indexes. Run the following query to determine the TYPE of your QMF indexes.

SELECT  NAME,CREATOR,TBNAME,TBCREATOR,INDEXTYPE FROM  SYSIBM.SYSINDEXES 
     WHERE CREATOR = 'Q'

If INDEXTYPE is equal to ' ' (blank), the migration jobs will alter the indexes to change them to TYPE 2. After migration, the indexes are left in recover pending state. The index changes do not take place until the indexes are recovered, loaded, or reorganized. Run the DB2 utility REBUILD INDEX (or RECOVER INDEX if you are using DB2 Version 5 or earlier) to complete conversion of the QMF indexes.

If you want to fall back to DB2 R310, you must to convert the indexes back to TYPE 1 prior to falling back. Use the 'ALTER INDEX' SQL statement. Refer to DB2 UDB for OS390 SQL Reference for the syntax.