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
EnyimbaAsked:
Who is Participating?
 
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
Hi Enyimba,

I've never tried to back up a database to /dev/NULL so it's possible that DB2 doesn't consider that a real backup.

Is this a production database where log recovery would be critical?  If not, you should be able to clear this condition by setting LOGARCHMETH1 and LOGARCHMETH2 to OFF.  Both are database configuration parameters.

Kent
0
 
EnyimbaAuthor Commented:
kdo,

No, this is development database. I'll try to do a real backup and see what happens.
0
 
EnyimbaAuthor Commented:
Thanks kdo for giving me the idea what may be wrong and you were right...it was constraint related
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.