473,791 Members | 3,028 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Backup Pending State

4 New Member
hai can u please send me the backup pending state details and solution
Apr 9 '08 #1
1 10271
docdiesel
297 Recognized Expert Contributor
Hi,

perhaps you could provide a little more detail? Did you load data successfully or did a load process fail? What command(s) did you use ? And most important: What error message or sql error state is DB2 displaying?

If you're on a unix or linux system, a very quick and dirty solution for solving backup pending state is a backup to the null device (means there'll be no real backup):
Expand|Select|Wrap|Line Numbers
  1. db2 backup db mydbname to /dev/null
But make sure to make a proper backup to disk or tsm soon afterwards.

Regards,

Bernd
Apr 9 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1726
by: bkow | last post by:
I am having this problem Server Config System : Sun E250 ( 2 hard disks - One is a mirror) 1 GB ram OS : Solaris 7 Db2 : version 7.2 Running software raid for mirroring. The production and failover servers are identical.
1
9757
by: Steven | last post by:
Ok W2K DB2 v8.1 fix pack 5. On production I took a an online backup of production and copied it over to my staging environment. restored the production database on top of staging database redirect. I copied over all the log files from production box to a temp directory. restore was complete with redirect and staging went into roll forward pending.
14
2049
by: johnm | last post by:
Hello All, I appreciate all of the help with my previous posts. It's nice having such a knowledgeable group to draw upon for help. I have taken all of your previous suggestions to heart and have upgraded our DB/2 system to 8.2. However, I still have a problem with backup times and backup window size.
5
1943
by: Gladiator | last post by:
Hai..... I have a database............ i took an online backup for tht..... After tht mistakenly i dropped the database.......... now i dont have the logs also....... now after i restore the database it will be in rollforward pending state........ when i am rollforwarding it is saying cannot rollforward........ can anyone tell me how to bring the database back again........
3
2518
by: Konstantin Andreev | last post by:
Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with Examples", but still unable to answer this simple question. I need to perform the full database backup for at least these two goals: - to restore data onto developers' database system. - to ensure disaster recovery
4
20503
by: aj | last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1 I have a DB2 online DB backup that was done w/ the INCLUDE LOGS option. I am interested in restoring that backup, and rolling forward ONLY the logs contained in the backup and no more, then bringing the DB online. I do not want to use a userexit to try and retrieve additional logs - I only want to roll forward the logs in the backup. (In case you haven't guessed, I am restoring a test version of my
10
6856
by: Michael Hoffmann | last post by:
Hello, I hope this doesn't come across as totally newbieish, but I've been searching the web and the IBM docs until smoke is coming out of my head. Scenario: We are trying to take primitive "snapshots" of our production database into a test environment by taking (what we thought are) offline backups of production, then doing a redirected restore into test. Here's the steps I do:
0
2730
by: normajeansebastian | last post by:
Hello, db2v9.1 fix pack 1 on sun solaris 2.10 every night we do an online backup on this system. (db2 & netbackup) last night netbackup had a problem and the process died on the netbackup side before the db2 backup completed. DB2 did not get the death notice and now it says I can not do another backup because a backup is already in progress. here is the section of the db2 list tablespaces command showing backup in progress:
0
6073
by: msheikh25 | last post by:
After a failed informatica load session, when I try to select from a table it shows that the table is in Load Pending state: 1 ----------- SQL0668N Operation not allowed for reason code "3" on table "TABLE". SQLSTATE=57016 But then when I try to take it out of load pending state by running a
0
9669
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9515
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9995
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9029
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7537
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6776
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5431
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4110
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2916
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.