Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: Restore without system tables

    We are running DB2 7.2 fxpak 12 on W2K. We have a corruption issue with the sysibm.syscoldist table. Our Server re-booted in the middle of a runstats and now we can't do another runstats. Would we be able to restore all our user defined tablespaces and just leave the syscatspace out of the restore. Would DB2 just regenerate the tablespace after the restore or would we see other problems?

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by treyou
    We are running DB2 7.2 fxpak 12 on W2K. We have a corruption issue with the sysibm.syscoldist table. Our Server re-booted in the middle of a runstats and now we can't do another runstats. Would we be able to restore all our user defined tablespaces and just leave the syscatspace out of the restore. Would DB2 just regenerate the tablespace after the restore or would we see other problems?
    Unfortunately no.

    When you say "corruption", do you mean the data is invalid or that there is a page-level corruption, ie. bad CRC?

    jono
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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