Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: 2 Tablespaces in Restore Pending state (0x2001100)

    I've got DB2 9.7 with AIX 6.1. I have restored a database but 2 tablespaces are in Restore Pending state of 0x2001100



    Tablespace ID = 32
    Name = PRODDTATE4K
    Type = Database managed space
    Contents = All permanent data. Large table space.
    State = 0x2001100
    Detailed explanation:
    Restore pending
    Storage must be defined
    Storage may be defined


    Tablespace ID = 34
    Name = PRODDTATG4K
    Type = Database managed space
    Contents = All permanent data. Large table space.
    State = 0x2001100
    Detailed explanation:
    Restore pending
    Storage must be defined
    Storage may be defined


    I cannot a backup of these tablespaces, I'm getting this error:
    SQL2048N An error occurred while accessing object "32". Reason code: "6".

    Also I've tried dropping the tablespaces and am getting errors:

    SQL0282N Table space "PRODDTATE4K" cannot be dropped because at least one of
    the tables in it, "PRODDTA.F4211Z1", has one or more of its parts in another
    table space.

    So then I try to drop the Table and am getting this error:
    SQL0290N Table space access is not allowed.

    Could someone help me or direct me to what I can do here, I would like to get these Tablespaces back into Normal State?
    Thank you so much!

    CC

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Check the errors logged in the db2diag.log during the restore to understand why they were left in restore pending. Could be filesystem full? How was the db restored - using regular restore or redirected restore? Was this a restore into an existing db or a new db?

    SQL0282N - check where the indexes and/or lobs for PRODDTA.F4211Z1 are stored. Related tablespaces must be dropped together (ie. drop tablespaces <data tablespace>, <index tablespace>, <log tablespace>)

Posting Permissions

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