Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: DB2 9.7 FP 3a /win 2008 R2 -migration

    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.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You cannot disable it, but you can set it to ACCESS - each index will be rebuilt upon the first attempt to access it.

  3. #3
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Indexrec - access

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •