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 IC73725 Status: Geschlossen

IN RARE CASE DB2 CAN TRAP IN SQLJPARSEDSC IF PROCESSING FDODSC IS
INTERRUPTED BY A COMMUNICATION ERROR.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In rare case DB2 can trap in sqljParseDsc if processing FDODSC 
is interrupted by a communication error. 
 
Callstack: 
 
0x0000002A969B9FA9 _Z12sqljParseDscP7sqljDsc + 0x0351 
0x0000002A969FB2B9 
_Z16sqljsParseSqldtaP13sqljsDrdaAsCbP14db2UCinterfaceP13sqljDDMO 
bject + 0x0151 
0x0000002A969F01F1 
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 
0x03c1 
0x0000002A969E02C2 
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U 
Cinterface + 0x007e 
0x0000002A969E0971 
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0x030d 
0x0000002A969DE39F address: 0x0000002A969DE39F ; dladdress: 
0x0000002A95782000 ; offset in lib: 0x000000000125C39F ; // 
libdb2e.so.1 
0x0000002A969DE102 address: 0x0000002A969DE102 ; dladdress: 
0x0000002A95782000 ; offset in lib: 0x000000000125C102 ; // 
libdb2e.so.1 
0x0000002A969DBF21 address: 0x0000002A969DBF21 ; dladdress: 
0x0000002A95782000 ; offset in lib: 0x0000000001259F21 ; // 
libdb2e.so.1 
0x0000002A969DBD0C _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 
0x011e 
0x0000002A969426DC _ZN8sqeAgent6RunEDUEv + 0x00c2 
0x0000002A96E4E431 _ZN9sqzEDUObj9EDUDriverEv + 0x006d 
0x0000002A96E4E3C1 _Z10sqlzRunEDUPcj + 0x0009 
0x0000002A96C34AD6 sqloEDUEntry + 0x02ea 
 
 
db2diag.log errors: 
 
2010-11-23-14.04.05.328213-300 E27509136E588       LEVEL: Error 
PID     : 11318                TID  : 186084485472 PROC : 
db2sysc 1 
INSTANCE: abcde020             NODE : 001          DB   : ABC 
APPHDL  : 1-6785               APPID: 
AUTHID  : XYZ 
EDUID   : 50573                EDUNAME: db2agent (ABC) 1 
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, 
probe:10 
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was 
detected.  The 
          diagnostic data returned is (SRVDGN): "SQLERRP:SQLJCMN 
          SQLCODE:-30081". 
 
2010-11-23-14.04.05.359933-300 E27509725E867       LEVEL: Error 
PID     : 11318                TID  : 186084485472 PROC : 
db2sysc 1 
INSTANCE: abcde020             NODE : 001          DB   : ABC 
APPHDL  : 1-6785               APPID: 
AUTHID  : XYZ 
EDUID   : 50573                EDUNAME: db2agent (ABC) 1 
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, 
probe:11 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -30081   sqlerrml: 
27 
 sqlerrmc: * * 0 TCP/IP SOCKETS  recv 
 sqlerrp : SQLJCMN 
 sqlerrd : (1) 0x81360012      (2) 0x00000012      (3) 
0x00000000 
           (4) 0x00000000      (5) 0x00000000      (6) 
0x00000001 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
2010-11-23-14.04.35.081099-300 I27510593E568       LEVEL: Error 
PID     : 11318                TID  : 186298394976 PROC : 
db2sysc 1 
INSTANCE: abcde020             NODE : 001          DB   : ABC 
APPHDL  : 1-7131               APPID: 
AUTHID  : XYZ 
EDUID   : 297774               EDUNAME: db2agent (ABC) 1 
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, 
probe:1 
MESSAGE : Error in agent servicing application with coor_node: 
DATA #1 : Hexdump, 2 bytes 
0x0000002B6000FA32 : 0100
Problem-Zusammenfassung:
Users affected: All 
Problem summary: Trap in sqljParseDsc
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 v9.7fp4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.01.2011
29.04.2011
29.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList