|
Problem IC71684
|
Status: Geschlossen |
CRASH OCCURS ON UPGRADED DATABASE WHEN VIEWS QUERY COLUMNS CASTED TO LOB TYPES. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
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-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC71797
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.10.2010
02.05.2011
02.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
