I am not sure how to deal with the following scenario.
Let's suppose:
A database SAMPLE is in archive log mode. All log files from
S0000000.LOG to S0000010.LOG are stored in one path, S0000008.LOG to
S0000010.LOG are active log files currently, the others are archive
log files. We have a complete backup image.
The database is offline due to suddenly power cut, after that, the
database can not start again and we find some error info, such as "Log
File cannot be used due to disk error". The file system is ok and just
some of active log files become unavailable.
My question is:
In this case, I usually recover and rollforward database. How to find
which log file is unavailable and identify the rollforward timestamp?
Thanks in advance!
James
5  1780 
i don't know exactly where to look for the timestamp, but the logfile
name can get retrieved using db2 "get db cfg for <database>". The
relevant entry may look like:
First active log file = S0004310.LOG
Maybe the db2diag.log may have some useful clues.
regards,
dotyet
On Jun 13, 5:03 am, James <huyu...@gmail. comwrote:
I am not sure how to deal with the following scenario.
Let's suppose:
A database SAMPLE is in archive log mode. All log files from
S0000000.LOG to S0000010.LOG are stored in one path, S0000008.LOG to
S0000010.LOG are active log files currently, the others are archive
log files. We have a complete backup image.
The database is offline due to suddenly power cut, after that, the
database can not start again and we find some error info, such as "Log
File cannot be used due to disk error". The file system is ok and just
some of active log files become unavailable.
My question is:
In this case, I usually recover and rollforward database. How to find
which log file is unavailable and identify the rollforward timestamp?
Thanks in advance!
James
On Jun 14, 1:26 am, dotyet <dot...@yahoo.c omwrote:
i don't know exactly where to look for the timestamp, but the logfile
name can get retrieved using db2 "get db cfg for <database>". The
relevant entry may look like:
First active log file = S0004310.LOG
Maybe the db2diag.log may have some useful clues.
regards,
dotyet
On Jun 13, 5:03 am, James <huyu...@gmail. comwrote:
I am not sure how to deal with the following scenario.
Let's suppose:
A database SAMPLE is in archive log mode. All log files from
S0000000.LOG to S0000010.LOG are stored in one path, S0000008.LOG to
S0000010.LOG are active log files currently, the others are archive
log files. We have a complete backup image.
The database is offline due to suddenly power cut, after that, the
database can not start again and we find some error info, such as "Log
File cannot be used due to disk error". The file system is ok and just
some of active log files become unavailable.
My question is:
In this case, I usually recover and rollforward database. How to find
which log file is unavailable and identify the rollforward timestamp?
Thanks in advance!
James
I mean if the active logs are deleted or unavailable and there is no
backup image, how to recovery database except using RESTORE utility?
Is there any tool that can do this function? How will you do if you
meet this case?
thanks so much
James
well, in such a case you have 2 options:
Go to IBM support and ask them to reset your SQL Log information in
the core engine.... I have heard that they send you a utility of some
sort which does that.
Execute DB2DART and extract all the data from the database's pages.
You can extract the data in formats like tab-delimited or hex etc.
look at the manual for the same. DB2DART is the tool which is used to
check the physical and logical structure of the database.
(Unfortunately, I have never had an opportunity to use it in a
fire ;P )
regards,
dotyet
On Jun 14, 8:51 pm, James <huyu...@gmail. comwrote:
On Jun 14, 1:26 am, dotyet <dot...@yahoo.c omwrote:
i don't know exactly where to look for the timestamp, but the logfile
name can get retrieved using db2 "get db cfg for <database>". The
relevant entry may look like:
First active log file = S0004310.LOG
Maybe the db2diag.log may have some useful clues.
regards,
dotyet
On Jun 13, 5:03 am, James <huyu...@gmail. comwrote:
I am not sure how to deal with the following scenario.
Let's suppose:
A database SAMPLE is in archive log mode. All log files from
S0000000.LOG to S0000010.LOG are stored in one path, S0000008.LOG to
S0000010.LOG are active log files currently, the others are archive
log files. We have a complete backup image.
The database is offline due to suddenly power cut, after that, the
database can not start again and we find some error info, such as "Log
File cannot be used due to disk error". The file system is ok and just
some of active log files become unavailable.
My question is:
In this case, I usually recover and rollforward database. How to find
which log file is unavailable and identify the rollforward timestamp?
Thanks in advance!
James
I mean if the active logs are deleted or unavailable and there is no
backup image, how to recovery database except using RESTORE utility?
Is there any tool that can do this function? How will you do if you
meet this case?
thanks so much
James
On Jun 15, 10:06 pm, dotyet <dot...@yahoo.c omwrote:
well, in such a case you have 2 options:
Go to IBM support and ask them to reset your SQL Log information in
the core engine.... I have heard that they send you a utility of some
sort which does that.
Execute DB2DART and extract all the data from the database's pages.
You can extract the data in formats like tab-delimited or hex etc.
look at the manual for the same. DB2DART is the tool which is used to
check the physical and logical structure of the database.
(Unfortunately, I have never had an opportunity to use it in a
fire ;P )
regards,
dotyet
On Jun 14, 8:51 pm, James <huyu...@gmail. comwrote:
On Jun 14, 1:26 am, dotyet <dot...@yahoo.c omwrote:
i don't know exactly where to look for the timestamp, but the logfile
name can get retrieved using db2 "get db cfg for <database>". The
relevant entry may look like:
First active log file = S0004310.LOG
Maybe the db2diag.log may have some useful clues.
regards,
dotyet
On Jun 13, 5:03 am, James <huyu...@gmail. comwrote:
I am not sure how to deal with the following scenario.
Let's suppose:
A database SAMPLE is in archive log mode. All log files from
S0000000.LOG to S0000010.LOG are stored in one path, S0000008.LOG to
S0000010.LOG are active log files currently, the others are archive
log files. We have a complete backup image.
The database is offline due to suddenly power cut, after that, the
database can not start again and we find some error info, such as "Log
File cannot be used due to disk error". The file system is ok and just
some of active log files become unavailable.
My question is:
In this case, I usually recover and rollforward database. How to find
which log file is unavailable and identify the rollforward timestamp?
Thanks in advance!
James
I mean if the active logs are deleted or unavailable and there is no
backup image, how to recovery database except using RESTORE utility?
Is there any tool that can do this function? How will you do if you
meet this case?
thanks so much
James
Do you know the name of utility which can reset SQL Log information?
Thanks.
James
On Jun 16, 6:02 am, James <huyu...@gmail. comwrote:
On Jun 15, 10:06 pm, dotyet <dot...@yahoo.c omwrote:
well, in such a case you have 2 options:
Go to IBM support and ask them to reset your SQL Log information in
the core engine.... I have heard that they send you a utility of some
sort which does that.
Execute DB2DART and extract all the data from the database's pages.
You can extract the data in formats like tab-delimited or hex etc.
look at the manual for the same. DB2DART is the tool which is used to
check the physical and logical structure of the database.
(Unfortunately, I have never had an opportunity to use it in a
fire ;P )
regards,
dotyet
On Jun 14, 8:51 pm, James <huyu...@gmail. comwrote:
On Jun 14, 1:26 am, dotyet <dot...@yahoo.c omwrote:
i don't know exactly where to look for the timestamp, but the logfile
name can get retrieved using db2 "get db cfg for <database>". The
relevant entry may look like:
First active log file = S0004310.LOG
Maybe the db2diag.log may have some useful clues.
regards,
dotyet
On Jun 13, 5:03 am, James <huyu...@gmail. comwrote:
I am not sure how to deal with the following scenario.
Let's suppose:
A database SAMPLE is in archive log mode. All log files from
S0000000.LOG to S0000010.LOG are stored in one path, S0000008.LOG to
S0000010.LOG are active log files currently, the others are archive
log files. We have a complete backup image.
The database is offline due to suddenly power cut, after that, the
database can not start again and we find some error info, such as "Log
File cannot be used due to disk error". The file system is ok and just
some of active log files become unavailable.
My question is:
In this case, I usually recover and rollforward database. How to find
which log file is unavailable and identify the rollforward timestamp?
Thanks in advance!
James
I mean if the active logs are deleted or unavailable and there is no
backup image, how to recovery database except using RESTORE utility?
Is there any tool that can do this function? How will you do if you
meet this case?
thanks so much
James
Do you know the name of utility which can reset SQL Log information?
Thanks.
James- Hide quoted text -
- Show quoted text -
db2 rollforward db <dbnamequery status gives you the last committed
transaction...
with this u can know till which point u need to rollforward.. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Rajesh Garg |
last post by:
I have a scenario like this.......
update esan set tes_address_city = 'TEST1' --at some time
update esan set tes_address_city = 'TEST12' --at some time
update esan set tes_address_city = 'TEST123' --at some time
backup database TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS.db'
backup log TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS01.log'
I take these backups at the end of day....
|
by: Rajesh Garg |
last post by:
I have actually extended my request
I have a scenario like this.......
update esan set tes_address_city = 'TEST1' --at some time
update esan set tes_address_city = 'TEST12' --at some time
update esan set tes_address_city = 'TEST123' --at some time
backup database TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS.db'
backup log TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS01.log'
|
by: gotdough |
last post by:
Cluster services gives the high availability needed - that is great.
But I have never seen any discussion about what happens when a node
fails - what do you do to get everything back to the active-passive
tandem.
I imagine there is not much difference in terms of recovery procedure
for either active or passive node. So I'm just going to make up a
scenario that we have encountered. The system hard drive (not the
shared disk) on primary...
|
by: xixi |
last post by:
i have db2 udb v8.1 on windows 64 bit 2003 server, after db2 server
start , i found this in the db2diag.log, is this error?
2004-05-05-15.28.30.780000 Instance:DB2 Node:000
PID:1692(db2syscs.exe) TID:2860 Appid:AC10040A.GD5F.00FC56D8BEC5
base sys utilities sqledint Probe:30
Crash Recovery is needed.
2004-05-05-15.28.31.890000 Instance:DB2 Node:000
|
by: jignesh shah |
last post by:
Hi all,
Is there a way to recover a single container if its been corrupted or
mark bad without restoring whole tablespace?
environment: db28.1/aix5.1/tsm/rs-6000.
Regards
Jignesh
| | |
by: Strahimir Antoljak |
last post by:
I am creating a new windows service and I would like to control its Recovery
property. On a system administrator level the Recovery property is found in
Control Panel -> Administrative Tools -> Services -> Service Properties
(right click on a service) -> Recovery tab -> First failure, Second failure properties.
Would anyone know if I can (and how) control First, Second Failure property
programmatically instead of going to the...
|
by: Racerx |
last post by:
Hi All :
I use db2 8.1 fixpack 3 on AIX.
I recieved the following message in the diaglog
======================================================
ADM7513W Database manager has started.
2007-01-13-18.55.08.262174 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
base sys utilities sqledint Probe:30
|
by: Tin |
last post by:
I bought a laptop and burned 4 recovery CDs for recovery purpose.
Instead of burning as disc images, I just copied and pasted these 4
CDs to my USB HDD as 4 folders called "RecoveryCD 1", "RecoveryCD 2",
"RecoveryCD 3" and "RecoveryCD 4". Now my laptop got problem and I
lost my 4 recovery CDs. All I have now is 4 recovery folders in my USB
HDD. I burned another 4 CDs as data discs from my USB HDD, but it
didn't work out (it didn't boot...
|
by: Winder |
last post by:
Computer Data Recovery Help 24/7
Data recovering tools and services is our focus. We will recover your
data in a cost effective and efficient manner. We recover all
operating systems and media. Call for a free consultation.
http://a.uuload.com/Computer-Data-Recovery.htm
LiveVault's Online Recovery Service
Protect vital data with LiveVault's offsite backup and data storage.
http://a.uuload.com/Computer-Data-Recovery.htm
|
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: 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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
