DB2 - Problem description
Problem IC74405 | Status: Closed |
CRASH WHEN CONNECT_PROC IS SET AND AUDIT IS ON | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
When DB CFG parameter CONNECT_PROC is set to not NULL value and AUDIT policy is turned on, customer may see the crash at database connect time with below call stack: 0x00002AEE3328DFB8 _Z10sqlr_auditP8sqlrr_cbP14sqlexAuditDataPii + 0x065c (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE33290CE2 _Z18sqlr_audit_executeP8sqlrr_cbsP19sqlrr_curr_activitymP5sqlcai + 0x134a (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE33236329 _Z8sqlrrcomP8sqlrr_cbii + 0x0dd9 (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE33209252 _Z21sqlrr_callConnectProcP14db2UCinterfaceb + 0x06dc (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE310AB500 _Z32sqljsPostProcessingConnectAttachP13sqljsDrdaAsCbP14db2UCinte rfacei + 0x0362 (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE310A9CE8 _Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x02ca (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE31055307 _Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject + 0x020f (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE3104B379 _Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint erface + 0x011f (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) 0x00002AEE3104C816 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x01c2 (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * customer who set connect_proc as non-NULL and turned on * * audit policy * **************************************************************** * PROBLEM DESCRIPTION: * * When DB CFG parameter CONNECT_PROC is set to not NULL value * * and * * AUDIT policy is turned on, customer may see the crash at * * * * database connect time with below call stack: * * * * 0x00002AEE3328DFB8 * * _Z10sqlr_auditP8sqlrr_cbP14sqlexAuditDataPii * * + 0x065c * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE33290CE2 * * * * _Z18sqlr_audit_executeP8sqlrr_cbsP19sqlrr_curr_activitymP5sqlc * + 0x134a * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE33236329 _Z8sqlrrcomP8sqlrr_cbii + 0x0dd9 * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE33209252 * * _Z21sqlrr_callConnectProcP14db2UCinterfaceb + * * 0x06dc * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE310AB500 * * * * _Z32sqljsPostProcessingConnectAttachP13sqljsDrdaAsCbP14db2UCin * rfacei * * * * + 0x0362 * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE310A9CE8 * * * * _Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + * * 0x02ca * * * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE31055307 * * * * _Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject + * * 0x020f * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE3104B379 * * * * _Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCi * erface * * * * + 0x011f * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * * * * 0x00002AEE3104C816 * * * * _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + * * * * 0x01c2 * * * * (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1) * **************************************************************** * RECOMMENDATION: * * turn audit policy off or set connect_proc to NULL * **************************************************************** | |
Local Fix: | |
turn audit policy off or set connect_proc to NULL | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.02.2011 28.04.2011 28.04.2011 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |