PH52495: UNLOAD OF LOB DATA IN NATIVE MODE ABENDS WITH ABENDU1136 REASON=0000005F INSTEAD OF RC 8 WHEN PARM VUU084/ULLOBBHV SET TO STOP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 HPU unduly stops with ABENDU1136 REASON=0000005F although
  the VUU084/ULLOBBHV parmlib parameter is set to STOP.
  This can occur if the following conditions are fulfilled:
  - 1) LOB data must be unloaded
  - 2) the unload is run in native mode
  - 3) the LOB data to unload is subject to concurrent updates
  during the unload which leads to inconsistency between the base
  tablespace and the associated LOB index which triggers the code
  driven by the value of VUU084/ULLOBBHV
  - 4) the enhancement brought by the APAR PH45159 is enabled
  

Local fix

• none but you may want to avoid the ABENDU1136 from occuring by
  either of the following means, if applicable:
  1) run the unload in SQL mode by specifying the DB2 FORCE option
  to remove the condition 2. This completely suppresses the risk
  of ABENDU1136 but has an impact on performance
  2) specify the LOCK YES option to remove the condition 3. This
  completely suppresses the risk of ABENDU1136 but prevents
  concurrent updates against the LOB data involved in the unload
  3) disable the enhancement brought by APAR PH45159 to remove the
  condition 4 by specifying LGARBCOL(0) in the value for the
  VUU063/ULOPTLX parmlib parameter. With this setting, the risk of
  ABENDU1136 is significantly lower but nonetheless present and
  the 64 bit memory consumption is not limited.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU unduly stops with ABENDU1136    *
  *                      REASON=0000005F although the            *
  *                      VUU084/ULLOBBHV parmlib parameter is    *
  *                      set to STOP. This can occur if the      *
  *                      following conditions are fulfilled:     *
  *                      1) LOB data must be unloaded            *
  *                      2) the unload is run in native mode     *
  *                      3) the LOB data to unload is subject    *
  *                         to concurrent updates during the     *
  *                         unload which leads to inconsistency  *
  *                         between the base tablespace and the  *
  *                         associated LOB index which triggers  *
  *                         the code driven by the value of      *
  *                         VUU084/ULLOBBHV                      *
  *                      4) the enhancement brought by the APAR  *
  *                         PH45159 is enabled                   *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Unload of LOB data in native mode unduly stops with ABENDU1136
  REASON=0000005F instead of RC 8 as requested by the setting of
  VUU084/ULLOBBHV to STOP
  

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:

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI91518

     UP23/04/26 P F304

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.