Solved

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

Posted on 2015-01-24
3
217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 45

Accepted Solution

by:
Kent Olsen 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
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.

623 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