home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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
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 FixList