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

Please advise.
Thanks , Valan.

You cannot disable it, but you can set it to ACCESS - each index will be rebuilt upon the first attempt to access it.

Thanks you so much, I have now updated the INDEXREC to ACCESS
and I can not see that db2 is not rebuilding automaticaly.

I have now identified all TYPE 1 indexes using db2IdentifyType1 command and its created a script automatically.

So, I have executed the script to CONVERT and it is now running.
hope this will run smoothly.

Thanks for you BIG help.
Valan