PH32273: ABEND 0C4-00000038, LOC=DSNXGRDS.DSNX9CAC +027E FOR UDF AFTER SOFT CANCEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend 0C4-00000038, LOC=DSNXGRDS.DSNX9CAC +027E for UDF after
  soft cancel
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 11 and 12 for z/OS users of external                     *
  * User Defined Functions (UDFs).                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND0C4-00000038,                                           *
  * LOC=DSNXGRDS.DSNX9CAC+027E (in V11)                          *
  * occurred after the UDF encountered                           *
  * an error or a cancel was issued                              *
  * during UDF execution.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When an UDF encounters an error during execution or is
  cancelled, normally the UDF will be terminated. However,
  in a rare situation, the variable in the WLM application
  address space may contain some residual information from
  previous stored procedure or UDF execution. This invalid
  information in the variable may cause the UDF to continue
  execution even after an error has occurred or a cancel has
  been issued. This may result in the 0C4 abend later.
  

Problem conclusion

• Db2 code has been added to initialize the variable in WLM
  application address space so that no residual information will
  be incorrectly used in the consecutive execution of a UDF.
  Additional Keywords:
  ABEND0C4 SQLUDF
  

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:

  UI74574 UI74575

Modules/Macros

• DSNX9WLS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI74574

     UP21/03/31 P F103

• RC10 PSY UI74575

     UP21/03/31 P F103

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.