PK88633: ABEND0C4 WHEN USING DB2 FORCE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 when using DB2 FORCE on the same SELECT statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An abend S0C4 occurs when converting a  *
  *                      GRAPHIC string into a CHAR MIXED. This  *
  *                      only occurs for SELECT processed by     *
  *                      DB2 (DB2 FORCE or DB2 YES with non      *
  *                      supported select statement).            *
  *                      The calling trace produced with         *
  *                      message LSCX041 contains:               *
  *                      LSCX041 **** ERROR ****                 *
  *                       ABEND occurred in line   597 of        *
  *                         700955(ODICT)  ,offset 0000AE        *
  *                       Extended name: odictLoad               *
  *                       Program terminated by operating        *
  *                       system. ABEND code = S0C4              *
  *                          Function        Line    Offset      *
  *                      Context                                 *
  *                        700955(ODICT)   == "odictLoad"        *
  *                                           597    0000AE      *
  *                        518326(IPABF)   == "inzpabfFillEcs"   *
  *                                         12743    001B48      *
  *                        308685(IPAB)    == "_inzpabBuildDsu"  *
  *                                          1970    000290      *
  *                        308900(IPAB)                          *
  *                           == "_inzpabBuildSelectDb2"         *
  *                                          3544    0003B6      *
  *                        308868(IPAB)    == "inzpabBuild"      *
  *                                          3372    0000B8      *
  *                        218816(IRUN)    == "inzrunRun"        *
  *                                           292    000856      *
  *                          MAIN(IMAIN)      783    00108A      *
  *                                                              *
  *                      This can occur in the following cases:  *
  *                      - Usage of INTO, REFORMAT, FORMAT USER  *
  *                       or LIKE TABLE that defines a           *
  *                       conversion for a graphic/vargraphic    *
  *                       column into a char/varchar mixed       *
  *                       field.                                 *
  *                      - Usage of FORMAT DELIMITED on a        *
  *                       graphic/vargraphic column with         *
  *                       DELIMITEDGRAPHEXT(YES) specified in    *
  *                       parmlib variable VUU030/ULOPTNS        *
  *                      PB 10086                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module inzpabf, function inzpabfFillEcs was changed to fill the
  missing information fields in case of SQL processing that were
  leading to the S0C4 abend.
  

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:

  UK48112

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK48112

     UP09/07/11 P F907

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.