PI86599: INZX133 SSSSSSSS NO VALID INPUT DDNAME DDDD FOUND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload fails with completion code of 8 after having issued
  message -- INZX133 tsname NO VALID INPUT DDNAME ddname FOUND,
                                       PARTITION p NOT UNLOADED
  This occurs if the following two conditions apply:
  - the table space involved in the unload is partitioned
  - the data to be unloaded is from image copies that must be
  allocated dynamically
     + either because COPYDDN LAST_IC or COPYDDN -integer is
                                                        requested
     + or the COPYDDN ddname option is used with a ddname
       described by a TEMPLATE statement
  the UNLOAD TABLESPACE statement specifies more than 10 SELECT
  statements
  
  PB50263
  

Local fix

• split the unload into several unload statements having no
  more than 10 SELECT statements.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The unload fails with completion code   *
  *                      of 8 after having issued messages       *
  *                      INZX133 tsname NO VALID INPUT DDNAME    *
  *                       ddname FOUND, PARTITION p NOT          *
  *                       UNLOADED This occurs if the following  *
  *                       two conditions apply:                  *
  *                      - the table space involved in the       *
  *                       unload is partitioned                  *
  *                      - the data to be unloaded is from       *
  *                       image copies that must be allocated    *
  *                       dynamically                            *
  *                         + either because COPYDDN LAST_IC or  *
  *                           COPYDDN -integer is requested      *
  *                         + or the COPYDDN ddname option is    *
  *                           used with a ddname described by a  *
  *                           TEMPLATE statement                 *
  *                      - the UNLOAD TABLESPACE statement       *
  *                       specifies more than 10 SELECT          *
  *                       statements                             *
  *                      PB 50263                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzpabf  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:

  UI52010

Modules/Macros

•    INZUTILK INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI52010

     UP17/11/25 P F711

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.