|
Problem IT03535
|
Status: Closed |
"FLUSH PACKAGE CACHE" STATEMENT CLEANS UP STATIC SQL STATEMENTS BY MISTAKE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The "FLUSH PACKAGE CACHE" statement is designed to remove cached
dynamic SQL statements only, which is stored in DB2 package
cache.
However it unexpectedly removes "static" SQL statements as well.
The problem was introduced in V9.7 Fix Pack 3. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of version 9.7 on Linux, Unix and Windows *
* platforms. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 LUW Version 9.7 Fix Pack 10 or higher levels. *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
First fixed in DB2 LUW Version 9.7 Fix Pack 10. |
| Workaround |
N/A |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.08.2014
10.11.2014
10.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
