|
Problem IC72869
|
Status: Geschlossen |
SQL0301 may be returned if ADMIN_MOVE_TABLE was used to change a table's column from LONG VARCHAR FOR BIT DATA to BLOB. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
If a table contains a column with the datatype "LONG VARCHAR FOR
BIT DATA",
and the ADMIN_MOVE_TABLE procedure is used to convert that
column to a BLOB while other applications are concurrently
accessing this table, then an sql0301 may be returned. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* LONG VARCHAR FOR BIT DATA TO BLOB migrations *
****************************************************************
* PROBLEM DESCRIPTION: *
* If you have "LONG VARCHAR FOR BIT DATA" COLUMNs and trying *
* to *
* move them to BLOB using ADMIN_MOVE_TABLE, while applications *
* are *
* running against these tables, then you could get SQL0301N. *
* *
* Please, apply this APAR. *
* *
* You can work around the issue, by making sure that *
* statements *
* are re-prepared after ADMIN_MOVE_TABLE is done. *
****************************************************************
* RECOMMENDATION: *
* Install this APAR or work around the issue, by making sure *
* that statements *
* are re-prepared after ADMIN_MOVE_TABLE is done. *
**************************************************************** |
| Local-Fix: |
Application can re-prepare statements against the table after
ADMIN_MOVE_TABLE is done. |
| 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 |
If you have "LONG VARCHAR FOR BIT DATA" COLUMNs and trying to
move them to BLOB using ADMIN_MOVE_TABLE, while applications
are
running against these tables, then you could get SQL0301N.
Please, apply this APAR.
You can work around the issue, by making sure that statements
are re-prepared after ADMIN_MOVE_TABLE is done. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.11.2010
29.04.2011
29.04.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
