PI86713: INZU066E WHEN LOGICAL UNLOAD WITH SELECT AGAINST UNQUALIFIED OBJECT NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload fails with a completion code of 8 after having issued
  the following message
  
  INZU066E NO TABLESPACE FOUND FOR TABLE creator.objectname
  
  when the following conditions apply:
  
      logical unload specifes an unqualified object (table, view,
  alias) name in the SELECT statement
      the involved object creator is not the one specifed by the
  VUM032/ACTLGUSR parameter.
  
  PB50225  INZU066E  INZU066 msgINZU066E msgINZU066
  

Local fix

• specify the creator name of the object to unload in the SELECT
  statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the High Performance Unload                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The unload fails with a completion code of 8 after having    *
  * issued the following message:                                *
  *                                                              *
  * INZU066E NO TABLESPACE FOUND FOR TABLE creator.objectname    *
  *                                                              *
  * when the following conditions apply:                         *
  * - logical unload specifes an unqualified object (table,      *
  * view, alias) name in the SELECT statement                    *
  * - the involved object creator is not the one specifed by the *
  * VUM032/ACTLGUSR parameter.                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTFCod                                             *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem.
  

Temporary fix

• Specify the creator name of the object to unload in the SELECT
  statement.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI50435

Modules/Macros

• INZ$$PRM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI50435

     UP17/09/27 P F709

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.