asked on

BDB2 backup pending state persist even after database backup...what could be happening?

Hi all,

Why would a talespace that has been loaded remain in backup pending state even after a database backup has been taken. I did not take a standard backup to disk or TSM but rather did a backup to /dev/null. Otherwise the backup reported success. When I did a list tablespace show detail, I received the following:

ablespace ID = 6
Name = TS8K_DATA_IDX
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0020
Detailed explanation:
Backup pending

Tablespace ID = 21
Name = TS8K_DATA1 Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0020
Detailed explanation:
Backup pending
Total pages = 10495020

Can somebody please explain what could be the reason for this.

Thanks

Enyimba

ASKER CERTIFIED SOLUTION

Kent Olsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Enyimba

ASKER

kdo,

No, this is development database. I'll try to do a real backup and see what happens.

Enyimba

ASKER

Thanks kdo for giving me the idea what may be wrong and you were right...it was constraint related