DB2 - Problembeschreibung
Problem IC77682 | Status: Geschlossen |
DB2 SERVER ABENDS AFTER FAILED OBJECT REGENERATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Following a failed object regeneration such as a view, trigger or routine, the DB2 server may terminate abnormally with messages in db2diag.log such as: 2011-06-10-05.09.05.860746-240 I21335206E655 LEVEL: Error PID : 5656 TID : 47451780147520PROC : db2sysc 1 INSTANCE: instname NODE : 001 DB : DBNAME APPHDL : 1-23841 APPID: 10.191.95.10.4790.110610090858 AUTHID : MRDUDB EDUID : 12267 EDUNAME: db2agent (DBNAME) 1 FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, probe:80 MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view DATA #1 : Hexdump, 26 bytes ... 2011-06-10-05.09.05.861086-240 E21335862E816 LEVEL: Info (Origin) PID : 5656 TID : 47451780147520PROC : db2sysc 1 INSTANCE: instname NODE : 001 DB : DBNAME APPHDL : 1-23841 APPID: 10.191.95.10.4790.110610090858 AUTHID : MRDUDB EDUID : 12267 EDUNAME: db2agent (DBNAME) 1 FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 MESSAGE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED" DIA8003C The interrupt has been received. DATA #1 : String, 241 bytes Compiler error stack for rc = -2147221501: sqlnn_cmpl[300] sqlnp_main[250] sqlnp_parser[330] sqlnp_smactn[100] sqlnq_sem[170] sqlnq_handle_from_table_re[22] sqlnq_check_referenced_qtb[200] sqlnq_check_referenced_qtb[80] sqlnn_regen_view[20] The messages in db2diag.log may vary depending on the object type that failed to regenerate. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * Following a failed object regeneration such as a view, * * trigger * * or routine, the DB2 server may terminate abnormally with * * messages in db2diag.log such as: * * * * * * 2011-06-10-05.09.05.860746-240 I21335206E655 LEVEL: * * Error * * PID : 5656 TID : 47451780147520PROC : * * db2sysc 1 * * INSTANCE: instname NODE : 001 DB : * * DBNAME * * APPHDL : 1-23841 APPID: * * 10.191.95.10.4790.110610090858 * * AUTHID : MRDUDB * * EDUID : 12267 EDUNAME: db2agent (DBNAME) 1 * * FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, * * probe:80 * * MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view * * DATA #1 : Hexdump, 26 bytes * * ... * * * * 2011-06-10-05.09.05.861086-240 E21335862E816 LEVEL: * * Info * * (Origin) * * PID : 5656 TID : 47451780147520PROC : * * db2sysc 1 * * INSTANCE: instname NODE : 001 DB : * * DBNAME * * APPHDL : 1-23841 APPID: * * 10.191.95.10.4790.110610090858 * * AUTHID : MRDUDB * * EDUID : 12267 EDUNAME: db2agent (DBNAME) 1 * * FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, * * probe:650 * * MESSAGE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER * * INTERRUPT * * DETECTED" * * DIA8003C The interrupt has been received. * * DATA #1 : String, 241 bytes * * Compiler error stack for rc = -2147221501: * * sqlnn_cmpl[300] * * sqlnp_main[250] * * sqlnp_parser[330] * * sqlnp_smactn[100] * * sqlnq_sem[170] * * sqlnq_handle_from_table_re[22] * * sqlnq_check_referenced_qtb[200] * * sqlnq_check_referenced_qtb[80] * * sqlnn_regen_view[20] * * * * * * The messages in db2diag.log may vary depending on the object * * type that failed to regenerate. * **************************************************************** * RECOMMENDATION: * * Uprade DB2 Version 9.7 FixPack 5 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in DB2 Version 9.7 FixPack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.07.2011 09.12.2011 09.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |