PI67064: UNLOAD FROM AN ALIAS FAILS WITH CC=8 AND MSGINZU066E NO TABLESPACE FOUND FOR TABLE TABLE_NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload specifying an alias in the FROM clause of the
  SELECT statement ends with completion code 8 after having issued
  msgINZU066E NO TABLESPACE FOUND FOR TABLE table_name, where
  table_name is the name of the alias. This occurs if :
      the unload is processed in native mode
      the alias was defined on a three-part table name
      the location in the three-part table name is the current
      the value of the LOCATION column from the SYSIBM.SYSTABLES
  for the involved alias has trailing blanks
  
  PB46162
  

Local fix

• Instead of the alias name, specify the table name in the FROM
  clause or change the alias definition to remove
  the location name from the table name.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload specifying an alias    *
  *                      in the FROM clause of the SELECT        *
  *                      statement ends with completion code 8   *
  *                      after having issued msgINZU066E NO      *
  *                      TABLESPACE FOUND FOR TABLE table_name,  *
  *                      where table_name is the name of the     *
  *                      alias. This occurs if :                 *
  *                      - the unload is processed in native     *
  *                       mode                                   *
  *                      - the alias was defined on a            *
  *                       three-part table name                  *
  *                      - the location in the three-part table  *
  *                       name is the current server name        *
  *                      - the value of the LOCATION column      *
  *                       from the SYSIBM.SYSTABLES for the      *
  *                       involved alias has trailing blanks     *
  *                      pb46162                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The olistdef, inztyacc and oddlx2 modules were 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:

Modules/Macros

•    INZQRYV8 INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI42179

     UP16/11/05 P F611

• R430 PSY UI42180

     UP16/11/05 P F611

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.