|
Problem IC91367
|
Status: Closed |
INSTANCE MAY TRAP IN DB2 V10.1 WHEN STATEMENT MONITOR IS TURNED ON |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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: *
* Upgrade to DB2 Version 10.1 Fix Pack 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.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95334
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.04.2013
27.09.2013
27.09.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
