|
Problem IC72856
|
Status: Closed |
Engine TRAP WHEN calling AN SQL PROCEDURE THAT WILL in turn CALL WLM_SET_CLIENT_INFO WITH EMPTY STRING AS THE APPLICATION NAME |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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() |
| available fix packs: |
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
|
| Solution |
First fixed in version 9.7 fixpack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.11.2010
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
