|
Problem IC71684
|
Status: Closed |
CRASH OCCURS ON UPGRADED DATABASE WHEN VIEWS QUERY COLUMNS CASTED TO LOB TYPES. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Crash may occur when views query columns which have been casted
to LOB types, after upgrading to v9.7. i.e ALL views that have
the LOB type column "derived" by using the cast function on a
varchar column.
Upgrade logic is responsible for not preserving appropriate
internal values, that can lead to under allocated memory,
resulting in memory overwrites. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 V97 *
****************************************************************
* PROBLEM DESCRIPTION: *
* CRASH OCCURS ON UPGRADED DATABASE WHEN VIEWS QUERY COLUMNS *
* CASTED TO LOB TYPES. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V97 FP4 *
**************************************************************** |
| Local Fix: |
1) For databases that have not been upgraded, upgrading these
databases using a fix pack containing this fix will avoid this
issue.
2) Databases that have already been upgraded to v97 Fix Pack 3
or earlier may encounter this issue. Dropping and recreating
the views will fix the issue. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 V97 FP4 |
| Workaround |
1) For databases that have not been upgraded, upgrading these
databases using a fix pack containing this fix will avoid this
issue.
2) Databases that have already been upgraded to v97 Fix Pack 3
or earlier may encounter this issue. Dropping and recreating
the views will fix the issue. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC71797
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.10.2010
02.05.2011
02.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
