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 1761
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.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
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.comwrote:
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 =...
|
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...
|
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...
|
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...
|
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 ->...
|
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.
...
|
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",...
|
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....
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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,...
|
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...
|
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...
|
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...
| |