Fixes are available
DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
Crash Recovery Fails Following "Interrupt. User Cancel." Message DB2 Linux/Unix/Windows crash recovery fails with the following symptoms: db2diag.log contains messages similar to the following: 2008-03-02-07.16.19.430863-300 I26985E453 LEVEL: Error PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3 INSTANCE: xxxxt040 NODE : 003 DB : MARCH APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509 FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2350 RETCODE : ZRC=0x800F0003=-2146500605=SQLO_INTRP "Interrupt. User Cancel." DIA8003C The interrupt has been received. 2008-03-02-07.16.19.431588-300 I27439E493 LEVEL: Error PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509 FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640 DATA #1 : String, 140 bytes Crash recovery failed with rc -2146500605 LowtranLSN 000002F33A07D026 MinbuffLSN 000002F34407D00C Recovery started on log file S0019160.LOG. 2008-03-02-07.16.19.456611-300 E27933E392 LEVEL: Error PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509 FUNCTION: DB2 UDB, base sys utilities, recover, probe:60 MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1044". 2008-03-02-07.16.19.456987-300 I28326E407 LEVEL: Error PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509 FUNCTION: DB2 UDB, base sys utilities, sqleInitEngineComponents, probe:111 MESSAGE : Restart failed due to interrupt with type: -2080374783 2008-03-02-07.16.19.457228-300 I28734E478 LEVEL: Severe PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509 FUNCTION: DB2 UDB, base sys utilities, sqleInitEngineComponents, probe:202 MESSAGE : If 'DATALINK: file server not registered' appears above and DATALINKS=NO, set DATALINKS=YES and try RESTART again 2008-03-02-07.16.19.457383-300 I29213E358 LEVEL: Severe PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509 FUNCTION: DB2 UDB, base sys utilities, sqlesrsu, probe:140 RETCODE : ZRC=0xFFFFFBEC=-1044 Subsequent crash recovery operation may fail with the following messages 2008-03-02-14.20.05.487184-300 I6309E426 LEVEL: Warning PID : 23732 TID : 182968993600PROC : db2agent (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 3-210 APPID: *N3.xxxxx040.080302192004 FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410 MESSAGE : Crash recovery started. LowtranLSN 000002F33A07D026 MinbuffLSN 000002F34407D00C 2008-03-02-14.20.05.490137-300 I6736E407 LEVEL: Warning PID : 23732 TID : 182968993600PROC : db2agent (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 3-210 APPID: *N3.xxxxx040.080302192004 FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000 MESSAGE : Using parallel recovery with 9 agents 9 QSets 72 queues and 128 chunks 2008-03-02-14.20.05.723779-300 I7144E436 LEVEL: Warning PID : 23732 TID : 182968993600PROC : db2agent (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 3-210 APPID: *N3.xxxxx040.080302192004 FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000 MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is "000002F33A07D026". 2008-03-02-14.20.05.724271-300 I7581E379 LEVEL: Severe PID : 23732 TID : 182968993600PROC : db2agent (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 3-210 APPID: *N3.xxxxx040.080302192004 FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4110 MESSAGE : Recovery did not reach the end of the logs! 2008-03-02-14.20.05.724412-300 I7961E183 LEVEL: Severe PID:23732 TID:182968993600 NODE:003 Title: SQLP_DBCB Dump File:/var/ibmdb2/xxxxx040/sqllib/db2dump/237322580367168.003 2008-03-02-14.20.05.724745-300 I8145E492 LEVEL: Error PID : 23732 TID : 182968993600PROC : db2agent (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 3-210 APPID: *N3.xxxxx040.080302192004 FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640 DATA #1 : String, 140 bytes Crash recovery failed with rc -2045771763 LowtranLSN 000002F33A07D026 MinbuffLSN 000002F34407D00C Recovery started on log file S0019160.LOG. 2008-03-02-14.20.05.724916-300 I8638E380 LEVEL: Warning PID : 23732 TID : 182968993600PROC : db2agent (MARCH) 3 INSTANCE: xxxxx040 NODE : 003 DB : MARCH APPHDL : 3-210 APPID: *N3.xxxxx040.080302192004 FUNCTION: DB2 UDB, base sys utilities, sqlePdbRemap, probe:100 MESSAGE : ZRC 8610000d remapped to SQLCODE -1042
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * All DB2 LUW 9.5 users who have their database fail * crash recovery. **************************************************************** * PROBLEM DESCRIPTION: * symptom may be caused by rebooting the server without * shutting down the database and not using the CTRL-C * interrupt. **************************************************************** * RECOMMENDATION: * Upgrade to DB2 Version 9.5 fix pack 2 or higher * to avoid this issue. ****************************************************************
Problem conclusion
First fixed in DB2 UDB Version 9.5, FixPak 2
Temporary fix
Comments
APAR Information
APAR number
IZ17801
Reported component name
DB2 DPF
Reported component ID
5724N7400
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-03-14
Closed date
2008-08-26
Last modified date
2010-02-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB ESE SOL
Fixed component ID
5765F4102
Applicable component levels
R950 PSY
UP
Document Information
Modified date:
03 October 2021