473,396 Members | 1,871 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Crash recovery

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

Crash Recovery is needed.

2007-01-13-18.55.09.139720 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlpresr Probe:410 Database:MUMAR

Crash recovery started. LowtranLSN 00000005D26EBE0C MinbuffLSN
00000005D26B120C

2007-01-13-18.55.09.270600 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlprecm Probe:125 Database:MUMAR

Using parallel recovery with 3 agents 5 QSets 35 queues and 16 chunks
2007-01-13-18.55.10.121525 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlprecm Probe:400 Database:MUMAR

DIA2051W Forward phase of crash recovery has completed. Next LSN is
"00000005D279C7A2".

2007-01-13-18.55.10.415121 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlpresr Probe:3170 Database:MUMAR

Crash recovery completed. Next LSN is 00000005D279C7A2
================================================== =============
Can anyone help me out with this and suggest ways to avoid it in future.

Jan 15 '07 #1
2 3616
"Racerx" <p.**********@gmail.comwrote in message
news:11**********************@51g2000cwl.googlegro ups.com...
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

Crash Recovery is needed.

2007-01-13-18.55.09.139720 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlpresr Probe:410 Database:MUMAR

Crash recovery started. LowtranLSN 00000005D26EBE0C MinbuffLSN
00000005D26B120C

2007-01-13-18.55.09.270600 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlprecm Probe:125 Database:MUMAR

Using parallel recovery with 3 agents 5 QSets 35 queues and 16 chunks
2007-01-13-18.55.10.121525 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlprecm Probe:400 Database:MUMAR

DIA2051W Forward phase of crash recovery has completed. Next LSN is
"00000005D279C7A2".

2007-01-13-18.55.10.415121 Instance:db2inst1 Node:000
PID:467078(db2agent (mumar) 0) TID:1
Appid:GA010302.O03F.01101B9A3444
recovery manager sqlpresr Probe:3170 Database:MUMAR

Crash recovery completed. Next LSN is 00000005D279C7A2
================================================== =============
Can anyone help me out with this and suggest ways to avoid it in future.
That means the instance crashed or was manually stopped while transactions
were in progress. Upon restart, DB2 backs out the uncommitted changes to the
databases.
Jan 15 '07 #2
Crash recovery completed. Next LSN is 00000005D279C7A2
================================================== =============
Can anyone help me out with this and suggest ways to avoid it in future.
Your system crashed. Did you have any power outage ?

If not, you will have to check the log before these lines and check why
it happened. It is always a good idea to contact IBM support upon
instance crashes.

-M

Jan 15 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Burkhard Schultheis | last post by:
As I wrote last week, we have a problem with a DB2 V8 on Linux. Here is what is in db2diag.log during online backup: Starting a full database backup. 2004-04-01-02.33.54.760164 ...
10
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...
0
by: richardshen | last post by:
Any suggestion about this? DB2 V8.1.5 WorkGroup Edition on Windows Professional 2000. Thanks. Message in DB2Diag.log 2004-07-18-16.54.29.479000 Instance:DB2 Node:000...
5
by: NG | last post by:
Hi, We are having DB2-V7.2 DB on AIX 5.2 machine. Recently we upgraded our system to fixpack 13 and activated activate AIX asynchronous IO function. Our DB is going to crash recovery with...
14
by: Jurgen Haan | last post by:
Hey all, at the company where I work we had a strange situation yesterday. Our DB2 database locked up, or as it later seemed, the DBM, or some connection manager. We couldn't open new...
1
by: Michel Esber | last post by:
Hello, Linux V8 FP12 with a 64 bit instance. My DBA called me and said our instance crashed and recovery would never end. $ db2 list utilities show detail ID ...
110
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...
3
by: subhbhav | last post by:
Hi, Is there any way to get a db2 9.1 Windows UDB database which is in inconsistent state to start without recovery? We were loading data from a source and the database crashed. The Server...
3
by: John Wright | last post by:
I want to create an autosave and crash recovery module for my program. I imagine I would have to use a timer control on the form to call the autosave functionality but I need a starting point. I...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
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,...
0
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...
0
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,...
0
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 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.