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

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.)

Good to know Nick,

But there are no Load entries in db2diag.log.

DBFinder

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?