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