PM71037: ABENDU1021 WITH R15=0 IN HPU

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABENDU1021 with R15=0 is unduly issued if all of the
  following conditions are true:
  - the image copy to be unloaded contains a multi-table table
    space
  - the table to be unloaded has no versions
  - some of the other tables have versions
  PB11663
  

Local fix

• Add the OPTIM_LEVEL 0 parm to the GLOBAL block of the failing
  HPU job.
  
  For example.  If no GLOBAL block is coded in the HPU SYSIN, add
  the following prior to the UNLOAD TABLESPACE line in the HPU
  SYSIN.
  
  GLOBAL OPTIM_LEVEL 0 ;
  UNLOAD TABLESPACE ....
  
  Regarding suggested setting of OTIM_LEVEL 0.
  HPU has several optimization mechanisms to speed up the
  processing.
  Specifying OPTIM_LEVEL 0, all these mechanisms are disabled.
  Of course, as this option is added to the SYSIN, only the job
  where it is used is impacted.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABENDU1021 with R15=0 is unduly      *
  *                      issued if all following conditions are  *
  *                      true:                                   *
  *                      - the image copy to be unloaded         *
  *                      contains a multi-table table space      *
  *                      - the table to be unloaded has no       *
  *                      versions                                *
  *                      - some of the other tables have         *
  *                      versions                                *
  *                      PB 11663                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzrunh, udbcrrts and inzmsgs modules were fixed to control the
  version only for the tables to be unloaded.
  

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
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK82661

     UP12/10/23 P F210

• R420 PSY UK82662

     UP12/10/23 P F210

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.