|
Problem IC95334
|
Status: Closed |
INSTANCE MAY TRAP IN DB2 V10.1 WHEN STATEMENT MONITOR IS TURNED ON |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
This is follow up to APAR IC79625 which was fixed in DB2 v9.7
Fixpack 6 and then code merged to DB2 v10.1 Fixpack 1 release.
After code inspection it was found that one of the necessary
code changes is missing in DB2 v10.1 release.
This APAR is opened to address this missing code change.
The potential problem is related to statement snapshot
monitoring involving stored procedures/udf calls. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
Set statement monitor switch to OFF (DFT_MON_STMT) and make sure
that the statement monitor switch is not turned on for the
sessions (db2 get monitor switches). |
| 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 Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
28.02.2014
28.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
|
|
