PH71645: INCORROUT DATA WHEN REFORMAT OR INTO TRIGGERS CONVERSION FROM (VAR)GRAPHIC TO (VAR)CHAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 HPU is likely to unload incorrect data when the following
  conditions are met:
  - a logical unload selects GRAPHIC or VARGRAPHIC data
  - a REFORMAT or INTO clause triggers a conversion from this data
    into CHAR or VARCHAR which implies a CCSID conversion from
    DBCS to SBCS or MBCS
  - the CCSIDs involved in the conversion are not both EBCDIC
    CCSIDs
  - additionally, if the unload is performed in native mode (DB2
    NO or DB2 YES with a SELECT statement that qualifies for
    native processing), one or both of the following conditions
    needs to be met:
      - TRIM YES is specified as an option
      - The GRAPHIC or VARGRAPHIC data concerned by the conversion
        is the result of an expression with at least one operand
        or scalar function
  
  When performing the CCSID conversion mentioned above, Db2 HPU
  unduly encloses the source data (the GRAPHIC/VARGRAPHIC data)
  between shift-out and shift-in characters. While these extra
  characters do not always result in visible errors, it frequently
  corrupts the converted output in unpredictable ways.
  

Local fix

• Modify the unload to replace implicit conversions (from REFORMAT
  or INTO clauses) affected by the issue with explicit conversions
  using the SQL CAST scalar function. Additionally, if the
  affected unload is performed in native mode, run it in SQL mode
  by specifying the DB2 FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU is likely to unload incorrect   *
  *                      data when the following conditions are  *
  *                      met:                                    *
  *                      - a logical unload selects GRAPHIC or   *
  *                        VARGRAPHIC data                       *
  *                      - a REFORMAT or INTO clause triggers a  *
  *                        conversion from this data into CHAR   *
  *                        or VARCHAR which implies a CCSID      *
  *                        conversion from DBCS to SBCS or MBCS  *
  *                      - the CCSIDs involved in the conversion *
  *                        are not both EBCDIC CCSIDs            *
  *                      - additionally, if the unload is        *
  *                        performed in native mode (DB2 NO or   *
  *                        DB2 YES with a SELECT statement that  *
  *                        qualifies for native processing), one *
  *                        or both of the following conditions   *
  *                        needs to be met:                      *
  *                          - TRIM YES is specified as an       *
  *                            option                            *
  *                          - The GRAPHIC or VARGRAPHIC data    *
  *                            concerned by the conversion is    *
  *                            the result of an expression with  *
  *                            at least one operand or scalar    *
  *                            function                          *
  *                                                              *
  *                      When performing the CCSID conversion    *
  *                      mentioned above, Db2 HPU unduly         *
  *                      encloses the source data (the           *
  *                      GRAPHIC/VARGRAPHIC data) between        *
  *                      shift-out and shift-in characters.      *
  *                      While these extra characters do not     *
  *                      always result in visible errors, it     *
  *                      frequently corrupts the converted       *
  *                      output in unpredictable ways.           *
  *                                                              *
  *                      Local fix: Modify the unload to replace *
  *                      implicit conversions (from REFORMAT or  *
  *                      INTO clauses) affected by the issue     *
  *                      with explicit conversions using the SQL *
  *                      CAST scalar function. Additionally, if  *
  *                      the affected unload is performed in     *
  *                      native mode, run it in SQL mode by      *
  *                      specifying the DB2 FORCE option.        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Likely INCORROUT data when REFORMAT or INTO triggers conversion
  from (VAR)GRAPHIC to (VAR)CHAR
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UO08456 UO08457

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO08456

     UP26/07/02 I 1000

• R610 PSY UO08457

     UP26/07/02 I 1000

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.