PI93187: ABENDU1132 WHEN UNLOADING BIG LOB DATA IN NATIVE MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 version 10 and later versions, an ABENDU1132 with reason
  8 occurs when attempting to unload a very big LOB in native
  mode.
  
  A very big LOB is a LOB that requires more than 1 LOB MAP page
  in the LOB table space, i.e. which is greater than
  - 26 MB when the page size on LOB TS is 4K.
  - 52 MB when the page size on LOB TS is 4K.
  - 104 MB when the page size on LOB TS is 4K.
  - 208 MB when the page size on LOB TS is 4K.
  
  PB51005 Z631
  

Local fix

• Run the unload in SQL mode.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 version 10 and later versions,   *
  *                      an ABENDU1132 with reason 8 occurs      *
  *                      when attempting to unload a very big    *
  *                      LOB in native mode.                     *
  *                      A very big LOB is a LOB that requires   *
  *                      more than 1 LOB MAP page in the LOB     *
  *                      table space, i.e. which is greater      *
  *                      than                                    *
  *                                                              *
  *                      - 26 MB when the page size on LOB TS    *
  *                        is 4K.                                *
  *                      - 52 MB when the page size on LOB TS    *
  *                        is 4K.                                *
  *                      - 104 MB when the page size on LOB TS   *
  *                        is 4K.                                *
  *                      - 208 MB when the page size on LOB TS   *
  *                        is 4K.                                *
  *                      pb51005                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzmsgs and inzctrlh modules were changed.The inzlobr
  module was changed.
  

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:

Modules/Macros

•    INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI53962

     UP18/02/23 P F802

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.