Timestamp field insertion into a Table with field declared as TIMESTAMP(6) with TIME Zone not Null using TPUMP.

Database

Timestamp field insertion into a Table with field declared as TIMESTAMP(6) with TIME Zone not Null using TPUMP.

Hi

I have a project requirement where I have to unload from a db2 table and load into a teradata table using Tpump.

The fields declared in db2 Table are as below.

 (LINK_ITEM_NBR                                      INTEGER        NOT NULL

      ,ITEM_RELATIONSHIP_TYPE_CD         CHARACTER(1)   FOR SBCS DATA      NOT NULL

      ,RELATIONSHIP_ITEM_NBR                  INTEGER        NOT NULL

      ,REPLENISHMENT_RATE_PCT            DECIMAL(3 , 2) WITH DEFAULT NULL

      ,LAST_UPDATE_USERID                       CHARACTER(10)  FOR SBCS DATA WITH DEFAULT NULL

      ,LAST_UPDATE_PGM_ID                    CHARACTER(10)  FOR SBCS DATA WITH DEFAULT NULL

      ,LAST_UPDATE_TS                                TIMESTAMP WITH DEFAULT NULL

And the Teradata Table Structure is as below

    LINK_ITEM_NBR INTEGER NOT NULL,

      ITEM_RELATIONSHIP_TYPE_CD CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      RELATIONSHIP_ITEM_NBR INTEGER COMPRESS ,

      REPLENISHMENT_RATE_PCT DECIMAL(3,2) COMPRESS ,

      LAST_UPDATE_USERID CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      LAST_UPDATE_PGM_ID CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      LAST_UPDATE_TS TIMESTAMP(6) WITH TIME ZONE NOT NULL)

While trying to insert using Tpump I am getting the below error

02:33:47 UTY8800 WARNING: Rate Monitoring turned off - no permission on

macro: TPumpMacro.ImportCreate.

02:33:47 UTY6608 Import 1 begins.

02:33:47 UTY4204 Output overflow, output size = 61, maximum buffer size =

57,file 'INFILE', record number '1'.

02:33:47 UTY1808 Record 1 of Import 1 rejected due to preceding error.

Could anyone please suggest how can I overcome this error and insert succesfully.

Thanks a lot in Advance