Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103

    Unanswered: System Error - Rebuilding tablespace (DB2 v9)

    Env: DB2 v9.1 Server / Win XP. DB is enabled for Archival Logging.

    Was playing around with rebuild tablespace feature. My database 'CARD'
    has tablespace named t1,t2,t3.

    Taken couple of individual tablespace backup as below

    C:\dir1>db2 "backup db card tablespace(syscatspace,userspace1,t1)"
    Backup successful. The timestamp for this backup image is :
    20070402114435

    C:\dir1>db2 "backup db card tablespace(syscatspace,t2)"
    Backup successful. The timestamp for this backup image is :
    20070402114448

    Then intentionally I dropped the tablespace t1,t2 to restore it from
    backup.

    Then I tried to restore but it fails
    C:\dir1>db2 "restore db card rebuild with
    tablespace(syscatspace,userspace1,t1) taken at 20070
    402114435"
    SQL2561W Warning! Rebuilding a database from a table space image or
    using a
    subset of table spaces. The target database will be overwritten. The
    restore
    utility also reports the following sqlcode "2539".
    Do you want to continue ? (y/n) y
    DB20000I The RESTORE DATABASE command completed successfully.

    C:\dir1>db2 rollforward db card to end of logs
    SQL1042C An unexpected system error occurred. SQLSTATE=58004

    Please advice.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    check db2diag.log
    or retry the operation, but first db2 update dbm cfg diaglevel 4
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Sep 2003
    Posts
    237
    according to Data Recovery and High Availability Guide and Reference, you should use the latest tablespace backup
    mota

Posting Permissions

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