Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Backup Pending State

    Hi Experts,

    In our staging environment I am havig trouble (as a DBA) with one database.
    The tablespce is put to Backup Pending State again and again.

    I am supposed to fix as soon as possible. I advise them avoid LOAD an IMPORT statement or ask me how to use these.

    But they don't seem to be using LOAD or IMPORT.


    Can there be anything else creating problem. If so how can I determine.



    Thanks for your time,
    DBFinder

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    LOAD operations are logged to db2diag.log, so I would check it to see if indeed there were no loads. (IMPORT would not change the tablespace state, obviously.)
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Good to know Nick,

    But there are no Load entries in db2diag.log.

    DBFinder

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    As far as I know, there are only two ways to put a tablespace into the backup pending mode: doing a LOAD with COPY NO, or doing a ROLLFORWARD. Both operations are recorded in db2diag.log, at least with DIAGLEVEL 3 in effect. This may be a stupid question, but how do you determine if your tablespace is in that state?
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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