Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: Db2 Repair Tablespace On Windows

    HI,

    I search how to repair a tablespace in a delete pending states on DB2 7.2 for windows.

    Thanks for help.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Did a LOAD put the table in Delete pending ? Then issue the load with Terminate option ...

    For eg

    LOAD FROM a1.ixf of ixf TERMINATE into table1 ;


    db2dart may have an option to reset the delete pending flag, but not sure
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2004
    Posts
    3
    Thanks, but I have an error on the load ... terminate command : SQL3508 Error for access a file "Restart/Terminate Info".

  4. #4
    Join Date
    May 2004
    Posts
    3
    I don't know if it was the great solution but after a "db2dart BEX01 /ATSC" the tablespace state is normal.

Posting Permissions

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