Solved

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

Posted on 2015-01-24
3
205 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 45

Accepted Solution

by:
Kdo earned 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

A while back when OPSMGR 2012 was released we were very excited about getting it into our environment and upgrading our 2007 implementation,  we started our planning and we then proceeded with our implementation. All went as planned & our system …
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

776 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