PM19767: MESSAGE ADBC033W CONVERSION OF CHARACTER TO DATE MAY FAIL FOR COL ADB27AD ADBC203E DATA CONVERSION ERRORS FOUND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ADB27AC component used by
  the DB2 Object Comparison Tool for z/OS issues the message:
  ADBC033W Conversion of Character to Date may fail for col
  <colname>
  and:
  ADBC203E Data conversion errors found
  ADBC204E Check LOAD Conversion statistics report
  ADB27AC - Ended with errors
  when panel GOC5 "Generate Compare Jobs" option "Stop on
  conversion error" is set to YES even though the conversion is
  listed as valid in Table 29. DB2 Admin data type conversions,
  part 1, in Chapter 27. DB2 Admin data type conversions of the
  DB2 Administration Tool for z/OS' User's Guide and Reference.
  

Local fix

• Specify "Stop on conversion error" NO on panel GOC5 "Generate
  Compare Jobs".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool or      *
  *                 DB2 Object Comparison Tool for z/OS who      *
  *                 convert column data type from CHAR,          *
  *                 VARCHAR, LONG VARCHAR to DATE, or TIME       *
  *                 and TIMESTAMP.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the 'Stop on conversion error'     *
  *                      option on the GOC5 'Generate Compare    *
  *                      Jobs' panel is set to 'YES', program    *
  *                      ADB27AC ends with error:                *
  *                                                              *
  *                      'ADBC203E Data conversion errors        *
  *                      found' even though the Character        *
  *                      to Date conversion is listed as valid   *
  *                      in the DB2 Administration Tool for      *
  *                      z/OS's User's Guide and Reference.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ADB27AC reported a conversion error for valid character to DATE,
  TIME or TIMESTAMP conversions.
  

Problem conclusion

• ADB27AC has been modified to fix the problem. The supported
  DATE, TIME and TIMESTAMP formats can be found in the DB2
  Administration Tool for z/OS User's Guide and Reference, 'DB2
  Admin data type conversions' chapter.
  

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:

  UK66166

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66165

     UP11/03/31 P F103

• R720 PSY UK66166

     UP11/03/31 P F103

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.