PM73273: MSGINZI010E INTERNAL CONVERSION ERROR BETWEEN CCSID 37 AND CCSID CCSID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload fails with completion code 8 and msgINZI010E INTERNAL
  CONVERSION ERROR BETWEEN CCSID 37 AND CCSID ccsid (where CCSID
  is graphic) when unsupported conversion from date, time or
  timestamp data to graphic is requested.
  
  For example,
  such an error occurs is the following REFORMAT clause is
  specified
  
  REFORMAT
  (
             TYPE DATE INTO CHAR(20) CCSID 1200,
             TYPE TIME INTO CHAR(16) CCSID 1200,
             TYPE TIMESTAMP INTO CHAR(52) CCSID 1200
  );
  
  and date, time or timestamp data are to be unloaded.
  
  A clearer message should be issued to inform the user he has
  attempted to run an unsupported unload.
  
  PB11688   INZI010E  msgINZI010E  INZI010  msgINZI010
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The unload fails with completion code   *
  *                      8 and msgINZI010E INTERNAL CONVERSION   *
  *                      ERROR BETWEEN CCSID 37 AND CCSID        *
  *                      ccsid (where CCSID is graphic) when     *
  *                      unsupported conversion from date,       *
  *                      time or timestamp data to graphic is    *
  *                      requested.                              *
  *                                                              *
  *                      For example, such an error occurs is    *
  *                      the following REFORMAT clause is        *
  *                      specified                               *
  *                                                              *
  *                      REFORMAT                                *
  *                                                              *
  *                      (                                       *
  *                       TYPE DATE INTO CHAR(20) CCSID 1200,    *
  *                       TYPE TIME INTO CHAR(16) CCSID 1200,    *
  *                       TYPE TIMESTAMP INTO CHAR(52)           *
  *                        CCSID 1200                            *
  *                      );                                      *
  *                                                              *
  *                      and date, time or timestamp data are    *
  *                      to be unloaded.                         *
  *                      A clearer message should be issued to   *
  *                      inform the user he has attempted to     *
  *                      run an unsupported unload.              *
  *                      pb 11688                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzctrlh and inzmsgs module were fixed to issue a clearer
  error message.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK90737 UK90738

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK90737

     UP13/01/10 P F301

• R420 PSY UK90738

     UP13/01/10 P F301

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.