DB2 - Problembeschreibung
Problem IC82706 | Status: Geschlossen |
ALTER COLUMN SET DATA TYPE NOT BLOCKED FOR ROW CHANGE TIMESTAMP COLUMN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
A row change timestamp column must have data type TIMESTAMP(6). This is correctly enforced by CREATE TABLE and ALTER TABLE ADD COLUMN. However, the data type can be changed via: ALTER TABLE <table> ALTER COLUMN <row change column> SET DATA TYPE <data type> This should be blocked with SQLCODE SQL0190 if <data type> is not TIMESTAMP(6) but the alteration succeeds. The result is possible abnormal termination of the DB2 server and general unpredictable behaviour with respect to the row change timestamp column. Use the following query to identify any tables that have a row change timestamp column with an invalid type: SELECT TABSCHEMA, TABNAME, COLNAME FROM SYSCAT.COLUMNS WHERE ROWCHANGETIMESTAMP = 'Y' AND ( TYPENAME != 'TIMESTAMP' OR SCALE != 6 ) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 Fix Pack 6 * **************************************************************** | |
Local-Fix: | |
To fix such a table, alter the column back to TIMESTAMP(6) ALTER TABLE <table> ALTER COLUMN <row change timestamp column> SET DATA TYPE TIMESTAMP(6) | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 6 | |
Workaround | |
See Local Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84599 IC84609 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.04.2012 05.06.2012 05.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |