|
Problem IT29915
|
Status: Closed |
ADMIN_MOVE_TABLE DOES NOT COPY ALL DIGITS OF TIMESTAMP(P) FOR P > 9
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
When moving a table using ADMIN_MOVE_TABLE and source table
contains a TIMESTAMP(p) with p > 9 the last digits of the
timestamps get lost.
Sample:
CREATE TABLE TEST(TS12 TIMESTAMP(12))
INSERT INTO TEST VALUES(TIMESTAMP_FORMAT('2000-12-31
23:59:59.123456789012','YYYY-MM-DD HH24:MI:SS.FF12',12))
call SYSPROC.ADMIN_MOVE_TABLE('SCHEMA','TEST','','','MOVE')
The table will contain
2000-12-31 23:59:59.123456789000
instead of
2000-12-31 23:59:59.123456789012
after the move. The last 3 digits are lost. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ADMIN_MOVE_TABLE users having tables with TIMESTAMP(p) and p *
* > 9 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade Db2 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.08.2019
09.08.2019
09.08.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
