|
Problem IC77682
|
Status: Closed |
DB2 SERVER ABENDS AFTER FAILED OBJECT REGENERATION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 Version 9.7 FixPack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.07.2011
09.12.2011
09.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
