IBM Support

IC80579: TABLE COLUMN DEFINITION CHANGES AFTER MOVING TABLE TO DIFFRENT FIXPACK BY ADMIN_MOVE_TABLE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error 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.
    
    Its a product defect
    

Local fix

Problem summary

  • ****************************************************************
    * 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.                           *
    ****************************************************************
    

Problem conclusion

Temporary fix

  • NA
    

Comments

  • NA
    

APAR Information

  • APAR number

    IC80579

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-12-23

  • Closed date

    2012-06-12

  • Last modified date

    2012-06-12

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC84395

Fix information

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80579

Modified date: 12 June 2012