PI39736: ABENDU1136 U1136

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABENDU1136 with reason code 2B can occur when unloading the
  data from LOB table space that spreads over several Linear Data
  Sets (LDS) if an ORDER clause is specified.
  
  PB12720  ABENDU1136  ABEND1136 U1136  1136
  

Local fix

• None unless the ORDER clause is not mandatory and can be
  removed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of XXXXXXXXXX                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: A HPU unload with the FAST              *
  *                      UNLOAD syntax requesting                *
  *                      an output in                            *
  *                      FORMAT VARIABLE generates               *
  *                      an output data set with an              *
  *                      irrelevant                              *
  *                      LRECL.                                  *
  *                      This occurs if the target               *
  *                      table has at least one                  *
  *                      nullable                                *
  *                      column. DB2 HPU counts each             *
  *                      null indicator twice thus               *
  *                      leading to                              *
  *                      an overestimated record                 *
  *                      length for the output data set.         *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  ...
  

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

•    INZUTILK INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI27358

     UP15/05/08 P F505

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.