473,856 Members | 1,694 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Not all archive (offline active) logs are getting backed up

1 New Member
Hi,
Im new to db2.

Im using db2 ese 9.1 (fix pack 1) on SLES 9.0 32 bit. I have single instance on three logical nodes 0,1,2. i have cofigured userexit - on, logretain - on, trackmod - on.

when i take full offline backup i observe that more number of archive logs are backed up on logical node 0. But the less logs are getting backed up on logical nodes 1,2. So when i drop the database those logs are lost.
when i restore the database and say rollforward to the end of logs and complete i get the error msg:
SQL4970N Roll-forward recovery on database "SAMPLE" cannot reach the specified stop point (end-of-log or point-in-time) because of missing or
corrupted log file(s) on database partition(s) "1,2". Roll-forward recovery
processing has halted on log file "S000002.LO G".

i need ur help regarding:
1. Is my observation is in line with the cause of the problem.
2. when we see current FIRST ACTIVE LOG FILE in the get db cfg, is that all the files previous to the one indicated are inactive offline active logs and should to backed up by userexit program.
3. how can i fix my problem.

I seek your help at the earliest.

Thanks
Prashanth
Jun 14 '07 #1
0 1648

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

Similar topics

1
3457
by: DB2 Convert | last post by:
Hi, A few points to confirm as I am still new with DB2. 1. What will happen if archive logging is used, however there is no userexit or manual process to move those online archived logs to another directory. At this moment my LOGPRIMARY is set to 3. Will the logging hang? 2. Does LOGSECOND apply to circular logging only? If if use archive
7
6566
by: William | last post by:
I am using DB2 8.2 on RH Linux 8.0. I just compiled db2uext2.c but failed to archive the log files, did anybody fix this problem before? TIA db2diag.log 2005-06-12-12.39.52.305630-240 I3534G369 LEVEL: Error PID : 3300 TID : 8192 PROC : db2logmgr (SAMPLE) INSTANCE: db2prd NODE : 000
4
9485
by: manwiththeaxe.70 | last post by:
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases up to DB2 UDB v8.2. One question I can't seem to understand is why would I want to run an offline backup for a database now that the online backup includes the necessary log files. Is there a reason why I would need or want to go through the hassle of getting exclusive control of a db for an offline backup?
1
1653
by: saramathi | last post by:
I am a little confused about the archive parameters work together. We currently have LOGRETAIN=RECOVERY and LOGARCHMETH1=USEREXIT. It appears that the logarchmeth1 can be set to DISK:<path>. Does this mean that we can use DISK (rather than USEREXIT) and replace the <path> to our existing archive log path, set USEREXIT OFF and db2 will automatically copy files to this directory? Thanks for any help.
2
6470
by: =?Utf-8?B?ZGF2ZS5oYXJkeQ==?= | last post by:
Hi, there have been loads of posts about this problem on loads of forums and I have tried everything suggested (except the stuff I’m not comfortable with like deleting drivers and reg. edits). I have an HP Pavilion dv2130ea laptop computer with XP media edition and sp2. I have had lots of automatic updates recently. When I boot my computer, everything is fine.
10
6867
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:
1
1706
by: shiva359 | last post by:
Dear All , will changes done on a table data After a load with nonrecoverable option on a archive loging enabled Database be recorded in logs if we don't do a complete backup after load ? also curious to know on what would bedoing the effect if we do a backup online after the load and do changes to table ( wihtout
3
3759
by: Kofa | last post by:
Hi, we have an application which uses online backups, so archive logging is a requirement. We have a small/moderate size database (a few hundred megabytes isn't much by today's standards) with relatively low insert/update activity (a few thousand per day). How should I set up archive logging (number of primary and secondary logs files, size of each log file)?
5
13591
by: alex250374 | last post by:
I have a db is in archive mod (LOGRETAIN = RECOVERY) and logprimary is set to 3. Pat the log file is / arch_log. If I go in that path i have: S0000000.LOG S0000001.LOG S0000002.LOG S0000003.LOG S0000004.LOG S0000005.LOG S0000006.LOG But the active logs are only S0000004.LOG S0000005.LOG S0000006.LOG (db cfg >>> First active log file S0000004.LOG) ?
0
9916
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
9762
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
11056
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10696
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9531
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
7932
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
7093
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();...
1
4575
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
2
4174
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.