PK34116: GOC WSL GETS DATA CONVERSION ERRORS BUT ONLY GETS RC04 IN WSL RUN AND DATA IS NOT LOADED INTO THE NEW OBJECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer changes char(2) to timestamp and GOC runs to rc=00 and
  creates WSL . The WSL runs to completion with rc=4 and the job
  shows that the object was unloaded and there were data
  conversion errors and the old object was dropped and new object
  created and load was attempted but it failed with rc=04 because
  of data conversion errors and records were discarded.
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2 Object Comparison Tool, who   *
  *                 change  column  data  types of tables that   *
  *                 generate  data   conversion  errors  while   *
  *                 running ADB27AC on unloaded data in a WSL,   *
  *                 may be affected.                             *
  *                 Note: PK34116 requires PK34839 APARfix       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When changing CHAR(2) data to Timestamp *
  *                      and running Object Compare, no messages *
  *                      were generated to  warn that errors had *
  *                      occurred  in the  data  conversion. The *
  *                      execution  of  the WSL then generated a *
  *                      Return Code of 4. Old table got dropped *
  *                      and recreated. Load put data records to *
  *                      discard file.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    GOCGCMP  GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMS
  GOC5     GOC5H
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK20898

     UP06/12/30 P F612

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.