PI95207: POTENTIAL ABEND WHILE UNLOADING THE DATA FROM IMMAGES COPIES FORMORE THAN 9 TABLESPACES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When unloading the data from image copies for at least 10
  tablespaces, the unload can terminate in ABEND (ABENDU1010 in
  HPU 4.3, ABENDS0C4 in HPU 5.1) if the following conditions are
  fulfilled:
  - one of the involved table space is a partition-by-growth table
    space
  - the involved input image copies are allocated dynamically by
    DB2 HPU (COPYDD LAST_IC or COPYDDN -integer is specified of
    COPYDDN tempdd with tempdd is a TEMLATE name)
  - the UNLOAD statement specifies more than 10 SELECT statements
    (either explicitly or using a FROM LIST clause)
  
  PB52230
  

Local fix

• if applicable, split the unload into several unloads with less
  than 10 table space or 10 SELECT statements involved.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IBM Db2 High Performance Unload                     *
  * z/OS.                                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When unloading the data from image                           *
  * copies for at least 10 tablespaces,                          *
  * the unload can terminate in ABEND                            *
  * (ABENDU1010 in HPU 4.3, not determined                       *
  * in HPU 5.1) if the following                                 *
  * conditions are fulfilled:                                    *
  * - one of the involved table space is a                       *
  * partition-by-growth table space                              *
  * - the involved input image copies are                        *
  * allocated dynamically by DB2 HPU                             *
  * (COPYDD LAST_IC or COPYDDN -integer                          *
  * is specified of COPYDDN tempdd with                          *
  * tempdd is a TEMLATE name)                                    *
  * - the UNLOAD statement specifies more                        *
  * than 10 SELECT statements (either                            *
  * explicitly or using a FROM LIST                              *
  * clause)                                                      *
  * PB52230                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * APPLY the PTF.                                               *
  ****************************************************************
  The inzpab 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:

  UI55111

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI55111

     UP18/04/12 P F804

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.