PH71203: ABENDS0C4 DURING AN UNLOAD USING THE DELIMITED OR DB2U-DELIMITEDFORMAT WITH DUPLICATED DELIMITERS AND REFORMATTING TO CHAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 HPU terminates with an ABENDS0C4 when the following
  conditions are fulfilled:
  - the output format is DELIMITED or DB2U-DELIMITED
  - the DUPLICATE_DELIMITER YES option is specified
  - the reformatting of an unloaded column into a
    CHAR(target_length) field is requested (either via a valid
    REFORMAT or INTO clause, e.g. TYPE source_type INTO
    CHAR(target_length)) where target_length is the length of the
    output CHAR field
  - the data from the unloaded column to be reformatted (as
    CHAR(target_length)) contains the character explicitly or
    implicitly defined as the delimiter by the specified output
    format
  - for at least one unloaded row, the duplication of the
    delimiter character (performed to honor the
    DUPLICATE_DELIMITER YES option) leads the unloaded data to
    exceed the number of characters set by target_length
  
  The expected behavior in such a case is the truncation of the
  data from the concerned column and not the undesirable
  ABENDS0C4.
  

Local fix

• If truncation of the data while maintaining the CHAR format is
  intended/requested, there is no local fix.
  
  If you wish to keep the CHAR format, the ABEND can only be
  avoided by increasing the length of the target column. Setting
  target_length to at least twice the length of the original
  column will remove any chance of the ABEND occurring. Changing
  the target format to VARCHAR will keep the truncation, but the
  output format will be different.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU terminates with an ABENDS0C4    *
  *                      when the following conditions are       *
  *                      fulfilled:                              *
  *                      - the output format is DELIMITED or     *
  *                        DB2U-DELIMITED                        *
  *                      - the DUPLICATE_DELIMITER YES option is *
  *                        specified                             *
  *                      - the reformatting of an unloaded       *
  *                        column into a CHAR(target_length)     *
  *                        field is requested (either via a      *
  *                        valid REFORMAT or INTO clause, e.g.   *
  *                        TYPE source_type INTO                 *
  *                        CHAR(target_length)) where            *
  *                        target_length is the length of the    *
  *                        output CHAR field                     *
  *                      - the data from the unloaded column to  *
  *                        be reformatted (as                    *
  *                        CHAR(target_length)) contains the     *
  *                        character explicitly or implicitly    *
  *                        defined as the delimiter by the       *
  *                        specified output format               *
  *                      - for at least one unloaded row, the    *
  *                        duplication of the delimiter          *
  *                        character (performed to honor the     *
  *                        DUPLICATE_DELIMITER YES option) leads *
  *                        the unloaded data to exceed the       *
  *                        number of characters set by           *
  *                        target_length                         *
  *                                                              *
  *                      The expected behavior in such a case is *
  *                      the truncation of the data from the     *
  *                      concerned column and not the            *
  *                      undesirable ABENDS0C4.                  *
  *                                                              *
  *                      Local fix: If truncation of the data    *
  *                      while maintaining the CHAR format is    *
  *                      intended/requested, there is no local   *
  *                      fix.                                    *
  *                                                              *
  *                      If you wish to keep the CHAR format,    *
  *                      the ABEND can only be avoided by        *
  *                      increasing the length of the target     *
  *                      column. Setting target_length to at     *
  *                      least twice the length of the original  *
  *                      column will remove any chance of the    *
  *                      ABEND occurring. Changing the target    *
  *                      format to VARCHAR will keep the         *
  *                      truncation, but the output format will  *
  *                      be different.                           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  ABENDS0C4 during an unload using the DELIMITED or DB2U-DELIMITED
  format with duplicated delimiters and reformatting to 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:

  UO07914

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R610 PSY UO07914

     UP26/05/22 P F605

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.