PK84364: GETTING AN ABEND0C4 REASON CODE=00000004 IN INZUTILB SPECIFYING FASTUNLOAD.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Getting an ABEND0C4 in INZUTILB specifying FASTUNLOAD.
  INZU105I ESTIMATED-ROWS OPTION IS IGNORED BY THE UTILITY
  LSCX041 **** ERROR ****
          ABEND occurred in line  7227 of @@402718(ICTRL)  ,offset
          000A64
          Extended name: inzcontrolCheckEcsCommonPost
          Program terminated by operating system. ABEND code =
          S0C4
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following is for 220:               *
  *                      1. FastUnload syntax:  IN HPU 220, an   *
  *                      abend S0C4 can occur when converting    *
  *                      an empty string constant with an INTO   *
  *                      clause specifying a non character       *
  *                      data type with the NULL attribute.      *
  *                      PB 9924                                 *
  *                      The following is for 310:               *
  *                      2. An abend S878-10 occurs after        *
  *                      processing a large number or partitions *
  *                      or LDS in the same execution of HPU     *
  *                      when a LOADDDN option is coded. The     *
  *                      getmain error occurs because all        *
  *                      available memory below the 16mb line    *
  *                      is used.                                *
  *                      PB 9912                                 *
  *                      3. FastUnload syntax: In HPU 310, when  *
  *                      converting an empty string constant     *
  *                      with an INTO clause specifying a non    *
  *                      character data type with the NULL       *
  *                      attribute, the following error          *
  *                      messages are issued:                    *
  *                      INZU025E INVALID OPERAND FOR OPERATOR   *
  *                       operator().                            *
  *                      INZU038E UNSUPPORTED TYPE CONVERSION    *
  *                       FOR COLUMN n                           *
  *                      INZU021E UNSUPPORTED CONVERSION CHAR    *
  *                       TO data_type                           *
  *                      PB 9927                                 *
  *                      4. Formating of numeric constants       *
  *                      with an INTO clause may fail in case    *
  *                      of overflow with error mesage INZU025E. *
  *                      The expected processing is to           *
  *                      truncate the result when the complete   *
  *                      value does not fit in the output data   *
  *                      type.                                   *
  *                      PB 9940                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Modules inzctrlf, inzctrl and inznode were changed to allow
  creation of a NULL constant value in any data type.
  2. Modules inzctrlh, inznode were changed to allows conversion
  of empty strings into a NULL value in any data type.
  3. Modules inzfyacc, inzcol, inzctrlh, inznode were changed to
  allows conversion of empty strings into a NULL value in any
  data type.
  

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:

  UK46434 UK46435

Modules/Macros

•    INZUTILB INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK46434

     UP09/05/14 P F905

• R310 PSY UK46435

     UP09/05/14 P F905

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.