I am restoring my DB2 8.2 database into DB2 9.7
The restore was successfully completed and the database was migrated too.
However according to the diag.log all the indexes were made INVALID due to the V8.2 indexes are TYPE 1.
I am happy to convert all the INDEXES to TYPE2 in the DB2 9.7 system.
As the INDEXREC is set to RESTART, the indexes are automatically start rebuiding. But I prefer to do all together by myself at later stage.
The question is how can I disable the DBM CFG - INDEXREC variable?