PH20012: UNDUE INZU057E ERROR WHEN LISTDEF INCLUDES TABLESPACE WITH NO TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A physical unload (UNLDDN) requested for the objects from a list
  defined through a LISTDEF statement (UNLOAD TABLESPACE
  LIST(listdef-name)) ends with completion code of 8 after having
  issued the INZU057E EMPTY TABLESPACE name message. This occurs
  if the list of tablespaces generated for the LISTDEF statement
  contains a tablespace with no table.
  In such a case, the expected behavior is the same as when a
  logical unload is requested for the same LISTDEF statement, i.e.
  to ignore the empty table space situation with no notification
  to the user.
  

Local fix

• exclude the table space with no table from the LISTDEF selection
  though an EXCLUDE option
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: A physical unload (UNLDDN) requested    *
  *                      for the objects from a list defined     *
  *                      through a LISTDEF statement (UNLOAD     *
  *                      TABLESPACE LIST(listdef-name)) ends     *
  *                      with completion code of 8 after having  *
  *                      issued the INZU057E EMPTY TABLESPACE    *
  *                      name message. This occurs if the list   *
  *                      of tablespaces generated for the        *
  *                      LISTDEF statement contains a tablespace *
  *                      with no table.                          *
  *                      In such a case, the expected behavior   *
  *                      is the same as when a logical unload is *
  *                      equested for the same LISTDEF           *
  *                      statement, i.e. to ignore the empty     *
  *                      table space situation with no           *
  *                      notification to the user.               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  undue INZU057E error when LISTDEF includes tablespace with no
  table
  

Problem conclusion

• Code has been changed to fix this problem.
  

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

• INZ$$PRM INZTDSC  INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI68215

     UP20/03/18 P F003

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.