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

Engine TRAP WHEN calling AN SQL PROCEDURE THAT WILL in turn CALL
WLM_SET_CLIENT_INFO WITH EMPTY STRING AS THE APPLICATION NAME

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Engine may trap in sqlpgild when calling an SQL procedure that 
will call WLM_SET_CLIENT_INFO with empty string as the 
application name. 
 
The trap in DB2DUMP/FODC_Trap_xxxx will show a "Signal #7 
(SIGBUS)" with a stack similar to the following : 
 
<POFDisassembly> 
 _Z8sqlpgildP9SQLP_DBCBm + 0x032e 
(/db2/db2d6c/sqllib/lib64/libdb2e.so.1) 
 
    0x00007F49AB1421E6 : 4A8BB4CD08390000 
</POFDisassembly> 
 
Stack: 
 ====================== 
 
 0x00007F49A988F98F ossDumpStackTraceEx + 0x01ef 
  0x00007F49A988A756 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00cc 
  0x00007F49AC5BC910 sqlo_trce + 0x040a 
  0x00007F49AC601025 sqloEDUCodeTrapHandler + 0x023d 
  0x00007F49AF133A90 __pthread_mutex_cond_lock + 0x0490 
  0x00007F49AB1421E6 _Z8sqlpgildP9SQLP_DBCBm + 0x032e 
  0x00007F49AD2FFCB8 
_Z14sqlpWriteToLogP8sqeAgentmmmP14SQLP_LREC_PARTPmP9SQLP_LSN8 + 
0x09d6 
  0x00007F49AD2FDB38 
_Z11sqlpWriteLRP8sqeAgentmmmmmP14SQLP_LREC_PARTmPmP9SQLP_LSN8 + 
0x0270 
  0x00007F49AB1319B5 _Z8sqlptlogP8sqeAgentmm + 0x00f1 
  0x00007F49AB12F39C _Z8sqlpxcm1P8sqeAgentP15SQLXA_CALL_INFOi + 
0x0278
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All using WLM_SET_CLIENT_INFO()  with an empty string for    * 
* application name                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see error description above                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to version 9.7 fixpack 4                             * 
****************************************************************
Local-Fix:
Specify an application name instead of an empty string when 
calling WLM_SET_CLIENT_INFO()
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 version 9.7 fixpack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.11.2010
02.05.2011
02.05.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList