DB2 - Problembeschreibung
Problem IC80579 | Status: Geschlossen |
TABLE COLUMN DEFINITION CHANGES AFTER MOVING TABLE TO DIFFRENT FIXPACK BY ADMIN_MOVE_TABLE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
After creating the table using command below .... DESCRIBE shows Column Length 13 and Scale 12: db2 "create table test ("CHGTSP" TIMESTAMP(12)) in userspace1" db2 "describe table test" Data type Column Column name schema Data type name Length Scale Nulls ----------------- ---------- --------------- ------- ----- ----- CHGTSP SYSIBM TIMESTAMP 13 12 Yes 1 record(s) selected. db2 "insert into test values('2011-09-30 00:00:00.001293952')" DB20000I The SQL command completed successfully. db2 "select * from test" CHGTSP -------------------------------- 2011-09-30-00.00.00.001293952000 1 record(s) selected. DB2 "CALL SYSPROC.ADMIN_MOVE_TABLE ('DBINST97', 'TEST','DMS1','DMS1','DMS1','','','','','','MOVE')" After the table MOVE the TIMESTAMP column has a Columnn Length of 10 and Scale of 6: db2 "describe table test" Data type Column Column name schema Data type name Length Scale Nulls ----------------- ---------- --------------- ------- ----- ----- CHGTSP SYSIBM TIMESTAMP 10 6 Yes db2 "select * from test" CHGTSP -------------------------- 2011-09-30-00.00.00.001293 1 record(s) selected. Here OTM is ignoring the length and scale values while constructing souce table column definition string. Hence we are seeing default length and scale values after table move. Its a product defect | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 users * **************************************************************** * PROBLEM DESCRIPTION: * * After creating the table using command below .... DESCRIBE * * shows * * Column Length 13 and Scale 12: * * * * * * * * db2 "create table test ("CHGTSP" TIMESTAMP(12)) in * * userspace1" * * * * * * * * db2 "describe table test" * * * * * * * * Data type Column * * * * Column name schema Data type name Length Scale * * Nulls * * * * * * * * ----------------- ---------- --------------- ------- ----- * * ----- * * * * * * * * CHGTSP SYSIBM TIMESTAMP 13 12 * * Yes * * * * * * * * 1 record(s) selected. * * * * * * * * * * * * db2 "insert into test values('2011-09-30 * * 00:00:00.001293952')" * * * * DB20000I The SQL command completed successfully. * * * * * * * * db2 "select * from test" * * * * * * * * CHGTSP * * * * -------------------------------- * * * * 2011-09-30-00.00.00.001293952000 * * * * * * * * 1 record(s) selected. * * * * * * * * * * * * DB2 "CALL SYSPROC.ADMIN_MOVE_TABLE ('DBINST97', * * * * 'TEST','DMS1','DMS1','DMS1','','','','','','MOVE')" * * * * * * * * After the table MOVE the TIMESTAMP column has a Columnn * * Length * * of 10 and * * Scale of 6: * * * * * * * * * * * * db2 "describe table test" * * * * * * * * Data type Column * * * * Column name schema Data type name Length Scale * * Nulls * * * * * * * * ----------------- ---------- --------------- ------- ----- * * ----- * * * * * * * * CHGTSP SYSIBM TIMESTAMP 10 6 Yes * * * * * * * * * * * * db2 "select * from test" * * * * * * * * CHGTSP * * * * -------------------------- * * * * 2011-09-30-00.00.00.001293 * * * * * * * * 1 record(s) selected. * * * * Here OTM is ignoring the length and scale values while * * constructing souce table column definition string. * * Hence we are seeing default length and scale values after * * table * * move. * **************************************************************** * RECOMMENDATION: * * Will be fixed in future fixpacks. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
NA | |
Kommentar | |
NA | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84395 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.12.2011 12.06.2012 12.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |