home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList