I have asked a similar question before, but am still not very clear on
this......expec ting some insights on this one....
Ok, so these are the two pieces of information regarding archived logs
during a rollforward recovery in a recoverable database:
1. OVERFLOWLOGPATH configuration parameter can specify a location for
DB2 to find log files that are needed for rollforward operations.
2. The database configuration file parameter 'userexit' specifies
whether the database manager invokes a user exit program to retrieve
log
files during rollforward recovery of databases.
So, it seems that the algorithm during a rollforward recovery is:
1. Check the active log path directory for the required logs. If logs
are not found here, go to step 2.
2. Check to see if OVERFLOWLOGPATH db. Config. Parm. is specified (or
OVERFLOW LOG PATH parameter is specified in the ROLLFORWARD DATABASE
command).
a. If OVERFLOWLOGPATH is specified, see if the required log files
exist
there. If log files are not present there then check if 'userexit' is
enabled.
i. If 'userexit' is enabled, invoke the userexit to find the location
of the log files. If log found in the location given by userexit,
continue with the rollforward operation else give the 'log not found'
error.
ii. If 'userexit' is diabled, give the 'log not found' error.
b. If OVERFLOWLOGPATH is not specified, check if 'userexit' is
enabled.
i. If 'userexit' is enabled, invoke the userexit to find the location
of the log files. If log found in the location given by userexit,
continue with the rollforward operation else give the 'log not found'
error.
ii. If 'userexit' is diabled, give the 'log not found' error.
So, basically, the sequence is: active log path directory,
OVERFLOWLOGPATH directory and lastly the 'userexit'.
Is my understanding correct or flawed.
TIA
Raquel. 2 2619
The sequence you use at the end of your note is right.
One more point.
The overflow logpath parm. must b specified if you logpath is defined over
raw devices. The logpath will be checked, if log file is not there, the
overflow is checked; if not found againand the exit is used (which in thic
case should always be) then the FILES stored in the archive can ONLY be
retrieved to the overflow logpath as the exit is not able to deal with raw
devices.
HTH, Pierre.
"Raquel" <ra************ ****@yahoo.com> a écrit dans le message de
news:9a******** *************** ***@posting.goo gle.com... I have asked a similar question before, but am still not very clear on this......expec ting some insights on this one....
Ok, so these are the two pieces of information regarding archived logs during a rollforward recovery in a recoverable database:
1. OVERFLOWLOGPATH configuration parameter can specify a location for DB2 to find log files that are needed for rollforward operations.
2. The database configuration file parameter 'userexit' specifies whether the database manager invokes a user exit program to retrieve log files during rollforward recovery of databases.
So, it seems that the algorithm during a rollforward recovery is:
1. Check the active log path directory for the required logs. If logs are not found here, go to step 2.
2. Check to see if OVERFLOWLOGPATH db. Config. Parm. is specified (or OVERFLOW LOG PATH parameter is specified in the ROLLFORWARD DATABASE command). a. If OVERFLOWLOGPATH is specified, see if the required log files exist there. If log files are not present there then check if 'userexit' is enabled. i. If 'userexit' is enabled, invoke the userexit to find the location of the log files. If log found in the location given by userexit, continue with the rollforward operation else give the 'log not found' error.
ii. If 'userexit' is diabled, give the 'log not found' error.
b. If OVERFLOWLOGPATH is not specified, check if 'userexit' is enabled.
i. If 'userexit' is enabled, invoke the userexit to find the location of the log files. If log found in the location given by userexit, continue with the rollforward operation else give the 'log not found' error. ii. If 'userexit' is diabled, give the 'log not found' error.
So, basically, the sequence is: active log path directory, OVERFLOWLOGPATH directory and lastly the 'userexit'.
Is my understanding correct or flawed.
TIA Raquel.
Thank you so much Pierre for your response. Your responses are always appreciated.
Raquel.
"Pierre Saint-Jacques" <se*****@invali d.net> wrote in message news:<XC******* *************@w agner.videotron .net>... The sequence you use at the end of your note is right. One more point. The overflow logpath parm. must b specified if you logpath is defined over raw devices. The logpath will be checked, if log file is not there, the overflow is checked; if not found againand the exit is used (which in thic case should always be) then the FILES stored in the archive can ONLY be retrieved to the overflow logpath as the exit is not able to deal with raw devices. HTH, Pierre. "Raquel" <ra************ ****@yahoo.com> a écrit dans le message de news:9a******** *************** ***@posting.goo gle.com... I have asked a similar question before, but am still not very clear on this......expec ting some insights on this one....
Ok, so these are the two pieces of information regarding archived logs during a rollforward recovery in a recoverable database:
1. OVERFLOWLOGPATH configuration parameter can specify a location for DB2 to find log files that are needed for rollforward operations.
2. The database configuration file parameter 'userexit' specifies whether the database manager invokes a user exit program to retrieve log files during rollforward recovery of databases.
So, it seems that the algorithm during a rollforward recovery is:
1. Check the active log path directory for the required logs. If logs are not found here, go to step 2.
2. Check to see if OVERFLOWLOGPATH db. Config. Parm. is specified (or OVERFLOW LOG PATH parameter is specified in the ROLLFORWARD DATABASE command). a. If OVERFLOWLOGPATH is specified, see if the required log files exist there. If log files are not present there then check if 'userexit' is enabled. i. If 'userexit' is enabled, invoke the userexit to find the location of the log files. If log found in the location given by userexit, continue with the rollforward operation else give the 'log not found' error.
ii. If 'userexit' is diabled, give the 'log not found' error.
b. If OVERFLOWLOGPATH is not specified, check if 'userexit' is enabled.
i. If 'userexit' is enabled, invoke the userexit to find the location of the log files. If log found in the location given by userexit, continue with the rollforward operation else give the 'log not found' error. ii. If 'userexit' is diabled, give the 'log not found' error.
So, basically, the sequence is: active log path directory, OVERFLOWLOGPATH directory and lastly the 'userexit'.
Is my understanding correct or flawed.
TIA Raquel. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Raquel |
last post by:
During a ROLLFORWARD recovery, are the log datasets copied from the
archive log directory to the active log directory? I know the log datasets
are copied from archive log directory to active log directory during a
ROLLBACK (for example in a crash recovery), but was wondering if it is
the same during a ROLLFORWARD recovery too.
TIA
Raquel.
|
by: Michelle |
last post by:
Hi,
I'm trying to rollforward my database to end of logs and complete, the
first error message i get is - SQL6063N rollforward recovery on
database X has stopped on node "0" due to change in log file size,
when i re-issue the command I get the " unexpected system error
occured"
I also dropped the db and restored it again, but still getting the
same errors.
|
by: shenanwei |
last post by:
DB2 V8.1.5 on Windows.
When I execute ROLLFORWARD after a Restore.
C:\db2 ROLLFORWARD db sample to END OF LOGS overflow log path(C:\LOGS\)
Rollforward Status
Input database alias = sample
Number of nodes have returned status = 1
|
by: t2581 |
last post by:
Hi ,
I run restore with rollforward
In job in output, last commited transaction time less then backup image
time
Is it normal ?
RESTORE DATABASE PRICE_V8 FROM "E:\BACKUP" TAKEN AT 20050610095841 TO
"D:" INTO PR_READ NEWLOGPATH "D:\DB2_FILES\PR_READ\LOG" WITH 2 BUFFERS
BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING
.....
|
by: t2581 |
last post by:
Hi,
we are daily restore db "PRICE" with rollforward from server A
into PRICE on server B
Usually we restore from backup with timestamp of ~ 02:00 AM and
applying logs till 7 AM (30-50 logs),restore process last 1 1/2 hr.
Sometimes we need to restore till 10-11 am (80-90 log files).
Restore at this case could last up to 5 hrs.
| |
by: darnold |
last post by:
I have restored a clients database using a redirected restore. However,
it is in a roll forward pending state. When I try to to a roll forward
to end of the logs, I get
SQL1268N Roll-forward recovery stopped due to error "1" while
retrieving log....
I have all of the logs, including the one mentioned in the SQL1268N
message. And they are in the log directory
I have tried changing userexit to no, and logretain to recovery.
|
by: EC |
last post by:
We have two DB2 servers are supposed to be a replicate of each other
with a database of the same name. I want to do a 'db2 db backup
online... include logs' on the first server, and do a 'db2 restore db
to ... logtarget...' on the second server, and then rollforward ONLY
those logs that were included in the backup image. Both databases may
have the same DB id because of previous restores. However, the second
server might have additional...
|
by: balubkp |
last post by:
can u plz tell me the rollforward recovery & rollforward pending state concepts
|
by: shorti |
last post by:
We are running DB2 UDB 8.1 fp 14 on AIX using archival logging and
online backups. I was running some disaster tests and found my
database restore was not restoring to the latest active log. Online
backup include logs. For this test I created a disaster where we lost
the database about 30 minutes after the last backup. Current archive
and active logs were saved off and I ran a Restore of the latest
backup and rollforward to the end of...
|
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...
|
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,...
| |
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...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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...
|
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...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |