MVSFORUMS.com

[wdnealis]

I've been looking through the threads to resolve the issus of removing a backup pending state from a tablespace. When I try, I get a message that the DB is in use or Table space access is not allowed. Any ideas?

[bauer]

wdnealis,

well i' didn't exactly know what you did already and why is the tablespace in backup pending mode (you did any reorg activitys ????).

Try the DB2 command

-START DATABASE(<dbname>) SPACENAM(<spacename>) ACCESS=FORCE

This normaly (re-)starts the database / tablespace resolving the backup pending state.

regards,
bauer

[wdnealis]

I think the problem occured when I tried a LOAD command from a file. The START DATABASE(SAMPLE) SPACENAM(USERSPACE1) ACCESS=FORCE command returns the following error:

SQL0104N An unexpected token "(" was found following "DATABASE". Expected
tokens may include: "MANAGER". SQLSTATE=42601
_______________

I aslo tried the RESTART DATABASE SAMPLE DROP PENDING TABLESPACES (USERSPACE1) command which said the command was successful, but did not resolve the issue because the list tablespaces shows:

Tablespace ID = 2
Name = USERSPACE1
Type = System managed space
Contents = Any data
State = 0x0020
Detailed explanation: Backup pending

[kolusu]

wdnealis,

Looking at your error messages I am guessing this is NOT mainframe DB2.

Check this link which might help you

http://www-128.ibm.com/developerworks/db2/library/techarticle/0202kline/0202kline.html

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[wdnealis]

I was trying to use Control Center to do a BACKUP, but I kept getting DB in USE. But the BACKUP from the CLP resolved the issue:

db2 backup database sample

Backup successful. The timestamp for this backup image is : 20061026115802


Thanks