DB2 - Problembeschreibung
Problem IC74047 | Status: Geschlossen |
DB2 gets TRAP in FUNCTION CALL "GET_DBSIZE_INFO(?,?,?,0)", or SQL1226N when upgrading DB to V9.73a | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Function call "get_dbsize_info(?,?,?,0)" could result in Trap and log error in db2diag.log The call get_dbsize_info(?,?,?,0) is executing successful but it generates this trap and error in the db2diag log: 2011-01-04-13.47.51.311806+660 I155485E630 LEVEL: Severe PID : 23792 TID : 140736909535568PROC : db2sysc 0 INSTANCE: testinst NODE : 000 DB : DZSPADBA APPHDL : 0-13764 APPID: *LOCAL.dbdasp.110104024717 AUTHID : DBA EDUID : 87 EDUNAME: db2agent (DBA) 0 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:50 MESSAGE : Trap Sustainability Criteria Failure : Nested trap detected during trap sanity check. DATA #1 : Hex integer, 8 bytes 0x600000024200001F DATA #2 : Hex integer, 8 bytes 0x0000000400000000 2011-01-04-13.47.51.312055+660 I156116E661 LEVEL: Warning PID : 23792 TID : 140736909535568PROC : db2sysc 0 INSTANCE: testinst NODE : 000 DB : DBA APPHDL : 0-13764 APPID: *LOCAL.dba.110104024717 AUTHID : AUTHID EDUID : 87 EDUNAME: db2agent (DBA) 0 FUNCTION: DB2 UDB, oper system services, sqloInvokeInterruptible, probe:20 DATA #1 : String, 208 bytes An unfenced User Defined Function (UDF) was abnormally terminated. This may leave the DB2 engine in inconsistent state. It is recommended that DB2 server instance is stopped and restarted as soon as possible. Signal 11 is observed: </Siginfo_t> Signal #11 (SIGSEGV): si_addr is 0x00000000000000B0, si_code is 0x00000001 (SEGV_MAPERR:Address not mapped to object.) --------------------------------------------------------- SQL1226N when trying to upgrade DB to V9.7 Fixpack 3a generates this db2diag.log output: 2011-01-14-17.07.24.416122-300 I2254E301 LEVEL: Warning PID : 17626 TID : 47194958118832PROC : db2bp INSTANCE: testinst NODE : 000 APPID : *LOCALtestinst.110114220500 FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:10 MESSAGE : Begin engn migration 2011-01-14-17.07.24.419661-300 I2556E406 LEVEL: Info PID : 13002 TID : 47602137557312PROC : db2sysc 0 INSTANCE: testinst NODE : 000 EDUID : 15 EDUNAME: db2ipccm 0 FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::CreateAppl, probe:100 DATA #1 : <preformatted> Addr[2B4B3C7FDA50] Nodes=[1]:: Appl[0 156]AppNodes[1],krcbNodes[1],maxNode=[0] 2011-01-14-17.07.24.435074-300 I2963E485 LEVEL: Info PID : 13002 TID : 47601932036416PROC : db2sysc 0 INSTANCE: testinst NODE : 000 DB : USAGE1 APPHDL : 0-156 APPID: *LOCAL.testinst.110114220724 AUTHID : MSDB2 EDUID : 64 EDUNAME: db2agent (USAGE1) 0 FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:1037 RETCODE : ZRC=0xFFFFEC55=-5035 ----> Starting migration to the current release DATA #1 : unsigned integer, 4 bytes 936 2011-01-14-17.08.03.714620-300 I97620E1144 LEVEL: Error PID : 13002 TID : 47601932036416PROC : db2sysc 0 INSTANCE: testinst NODE : 000 DB : USAGE1 APPHDL : 0-156 APPID: *LOCAL.testinst.110114220724 AUTHID : MSDB2 EDUID : 64 EDUNAME: db2agent (USAGE1 ) 0 FUNCTION: DB2 UDB, ABP, ABPIcoordAgent::spawnIcoordAgent, probe:200 MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT "SQLCA has been built and saved in component specific control block." CALLED : DB2 UDB, base sys utilities, sqeIcoordCB::DispatchIndependentDBAgent RETCODE : ZRC=0x80A90442=-2136406974=ABP_NO_AGENT "Maximum number of connections reached." DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -5035 sqlerrml: 0 sqlerrmc: sqlerrp : SQL09073 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW * **************************************************************** * PROBLEM DESCRIPTION: * * CALL "GET_DBSIZE_INFO(?,?,?,0)" results in a trap. * * * * Maximum number of connections reached (SQL1226N) when trying * * to upgrade DB to V9.7 Fixpack 3a. * **************************************************************** * RECOMMENDATION: * * Upgrade to v97fp4. * **************************************************************** | |
Local-Fix: | |
This may leave the DB2 engine in inconsistent state. It is recommended that DB2 server instance is stopped and restarted as soon as possible. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
CALL "GET_DBSIZE_INFO(?,?,?,0)" no longer traps as SNAPSHOT_CNTRFS has been changed to FENCED UDF. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.01.2011 12.05.2011 12.05.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |