JR29061: DATA REPORTED IN JOB LOG FOR DB2 STAGE DATE FIELD IS CORRUPTED

APAR status

• Closed as program error.

Error description

• When an insert to a table is done via DB2 API stage and there is
  a primary key violation, the data to be inserted is reported in
  the job log. The data is ok except for the DATE field, it shows
  the following for START_DT:
  
  Message::
  djsLODExchgRate010_GENERADUPLICADOS..db2LODExchgRateUpd:
  START_DT =
  8-01-02e2008-01-02(2008-01-02_2008-01-02008-01-02_2008-01-024200
  8-01-02 CRNCY_FROM_CDE = 80 CRNCY_TO_CDE = 5 CONV_RATE = 2.8194
  DFLT_IND = N
  
  The sample job and job log are in the ecase directory.
  
  This is for PMR 67768,999,000.
  
  Files under: http://g01ciapp019.ahe.pok.ibm.com:5559/ecase/testc
  ases/dstage/133193/
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Issue reporte on 801
  ****************************************************************
  PROBLEM DESCRIPTION:
  When a row is rejected the date field is incorrectly printed in
  the log
  ****************************************************************
  RECOMMENDATION:
  Install the patch mentioned in the PMR details
  ****************************************************************
  

Problem conclusion

• Issue is fixed.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• DB2 API
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP