Solved

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

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to check for shares on HP-UX 1 54
Skill Development 15 163
Expand a partition in Centos 7 Linux with Virtualmin 1 56
aix unix tar error 3 42
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
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 several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
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.

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now