Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2015-01-24
3
Medium Priority
?
227 Views
Last Modified: 2015-02-17
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
0
Comment
Question by:Enyimba
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Kent Olsen earned 1500 total points
ID: 40569370
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
 

Author Comment

by:Enyimba
ID: 40569871
kdo,

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

Author Closing Comment

by:Enyimba
ID: 40615638
Thanks kdo for giving me the idea what may be wrong and you were right...it was constraint related
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we have discussed the manual scenarios to recover data from Windows 10 through some backup and recovery tools which are offered by it.
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question