Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Unhappy Unanswered: Stuck in backup pending

    Hello,

    I've tried to configure my DB for rollforward and follow the standart procedure ( enable log retain -> db2stop -> db2start )
    But When i try to make the offline backup i've an error :
    SQL2048N An error occurred while accessing object "3". Reason code: "6".

    And when i look the db2diag.log it say that i've a problem with a tablespace :
    Tablespace TMP (13) is in state x4000.
    Starting it failed. rc=1ec1 ffff

    I really like to correct it but i need to activate to do this. But i can't because i'm in backup pending.....

    I do not find any way to proceed... If someone have an idea......

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Re: Stuck in backup pending

    List tablespaces show detail

    Check the status of all the tablespaces
    Make sure the state of all the tablespaces 0x0000


    Originally posted by guyot
    Hello,

    I've tried to configure my DB for rollforward and follow the standart procedure ( enable log retain -> db2stop -> db2start )
    But When i try to make the offline backup i've an error :
    SQL2048N An error occurred while accessing object "3". Reason code: "6".

    And when i look the db2diag.log it say that i've a problem with a tablespace :
    Tablespace TMP (13) is in state x4000.
    Starting it failed. rc=1ec1 ffff

    I really like to correct it but i need to activate to do this. But i can't because i'm in backup pending.....

    I do not find any way to proceed... If someone have an idea......

    Thanks

  3. #3
    Join Date
    Feb 2003
    Posts
    20
    Make sure that the tablespace container is accessible.

  4. #4
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Re: Stuck in backup pending

    Looks Like Your Tablespace is offline and it is not accessible.
    This means the filesystem which is holding the containers is unmounted.
    Check with your sysadmin to bring back the files system


    Originally posted by guyot
    Hello,

    I've tried to configure my DB for rollforward and follow the standart procedure ( enable log retain -> db2stop -> db2start )
    But When i try to make the offline backup i've an error :
    SQL2048N An error occurred while accessing object "3". Reason code: "6".

    And when i look the db2diag.log it say that i've a problem with a tablespace :
    Tablespace TMP (13) is in state x4000.
    Starting it failed. rc=1ec1 ffff

    I really like to correct it but i need to activate to do this. But i can't because i'm in backup pending.....

    I do not find any way to proceed... If someone have an idea......

    Thanks

Posting Permissions

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