|
Problem IC97004
|
Status: Closed |
DB2 INSTANCE MIGHT TRAP IF A USER REBINDS A PACKAGE WITHOUT HAVING EXECUTE PRIVILEGE ON IT. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Instance trap might occur with following stack when user did
rebind package without having EXECUTE privilege on the package.
-------Frame------ ------Function + Offset------
0x0900000008E788A8 sqlplrl__FP9sqeBsuEduP14SQLP_LOCK_INFOCUl +
0x9CC
0x090000000A467250
sqlra_get_section__FP8sqlrr_cbPUcsT2T3T2UsUlP16db2UCprepareInfoP
15db2UCCursorInfo + 0xC8
0x0900000008DB4490
sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP
15db2UCCursorInfo + 0x880
0x0900000008DB4E38 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x1FC
0x0900000008D9E16C
.sqljs_ddm_excsqlstt.fdpr.clone.1784__FP14db2UCinterfaceP13sqljD
DMObject + 0xCE8
0x0900000008D9E484
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x94
0x0900000008D9C774
.sqljsParse.fdpr.clone.102__FP13sqljsDrdaAsCbP14db2UCinterfaceP8
sqeAgentb + 0x13A4
0x0900000008D992B0 @73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x280
0x0900000009330564
@73@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x0900000009330F4C
@73@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x4E8
0x0900000009330230 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x21C
0x0900000008AECC80 RunEDU__8sqeAgentFv + 0x584
0x0900000008AE8858 EDUDriver__9sqzEDUObjFv + 0x13C
0x0900000008AE86E0 sqlzRunEDU__FPcUi + 0x10
0x0900000008AFB558 sqloEDUEntry + 0x264 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade DB2 UDB Version 10.5 Fix Pack 3 *
**************************************************************** |
| Local Fix: |
Workaround would be to do REBIND as a user that has EXECUTE
privilege for the package. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 10.5 Fix Pack 3 |
| Workaround |
Workaround would be to do REBIND as a user that has EXECUTE
privilege for the package. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.10.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
