Thread: crash recovery
View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 05:56 PM
xixi
 
Posts: n/a
Default crash recovery

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 InstanceB2 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 InstanceB2 Node:000
PID:1692(db2syscs.exe) TID:2860 Appid:AC10040A.GD5F.00FC56D8BEC5
recovery manager sqlpresr Probe:410 Database:NJIPD

Crash recovery started. LowtranLSN 00000006107760AD MinbuffLSN
000000060EAC1CA4

2004-05-05-15.28.31.980001 InstanceB2 Node:000
PID:1692(db2syscs.exe) TID:2860 Appid:AC10040A.GD5F.00FC56D8BEC5
recovery manager sqlprecm Probe:125 Database:NJIPD

Using parallel recovery with 3 agents 5 QSets 35 queues and 4 chunks


2004-05-05-15.29.12.640000 InstanceB2 Node:000
PID:1692(db2syscs.exe) TID:2860 Appid:AC10040A.GD5F.00FC56D8BEC5
recovery manager sqlprecm Probe:400 Database:NJIPD

DIA2051W Forward phase of crash recovery has completed. Next LSN is
"000000061077B300".

2004-05-05-15.29.29.860000 InstanceB2 Node:000
PID:1692(db2syscs.exe) TID:2860 Appid:AC10040A.GD5F.00FC56D8BEC5
recovery manager sqlpresr Probe:1450 Database:NJIPD

There remains configuration changes to apply.

2004-05-05-15.29.30.240001 InstanceB2 Node:000
PID:1692(db2syscs.exe) TID:2860 Appid:AC10040A.GD5F.00FC56D8BEC5
recovery manager sqlpresr Probe:3170 Database:NJIPD

Crash recovery completed. Next LSN is 000000061111C00C

2004-05-05-15.38.43.420000 InstanceB2 Node:000
PID:4004(db2dasstm.exe) TID:4092 Appid:none
Client Config cfgReadDbcDirectory Probe:5

DB_CONFIG:

0x000006FBFCFC5230 : 456E 7469 7265 2044 4243 4647 00 Entire
DBCFG.

PID:4004 TID:4092 Node:000 Title: Sqlcode
SQL -1024


2004-05-05-16.03.14.010000 InstanceB2 Node:000
PID:3356(db2dasstm.exe) TID:3440 Appid:none
Client Config cfgReadDbcDirectory Probe:5

DB_CONFIG:

0x000006FBFCFC5230 : 456E 7469 7265 2044 4243 4647 00 Entire
DBCFG.

PID:3356 TID:3440 Node:000 Title: Sqlcode
SQL -1024

why there is a crash recovery? what is LSN?
Reply With Quote