PI47724: CONFUSING MSGINZU063I UNSUPPORTED SELECT UNLOADING TABLE WITH SYSIBM.SYSTABLES COLUMN TYPE NOT T, C, M OR V

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running a logical unload (SELECT ... OUTDDN ...) involving
  a table which type (column TYPE from in the SYSIB.SYSTABLES
  table from the DB2 catalog) is not in the supported list of
  types, i.e. T, C, M and V, msgINZU063I UNSUPPORTED SELECT.
  
  Ideally, a specific message reporting the unsupported table type
  should be issued.
  
  Other keywords:
  PB12822 msgINZU063I msgINZU063 INZU063I INZU063 SYSIBM SYSTABLES
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enhancement: When running a logical     *
  *                      unload (SELECT ... OUTDDN ...)          *
  *                      involving a table which type (column    *
  *                      TYPE from in the SYSIB.SYSTABLES table  *
  *                      from the DB2 catalog) is not in the     *
  *                      supported list of type, i.e. T, C, M    *
  *                      and V, either msgINZU063I UNSUPPORTED   *
  *                      SELECT or msgINZU057E EMPTY TABLE       *
  *                      SPACE is issued. Ideally, a specific    *
  *                      message reporting the unsupported       *
  *                      table type should be issued.            *
  *                      PB12822                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  N/A (Enhancement)
  

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:

  UI31879

Modules/Macros

•    INZTDSC  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI31879

     UP15/10/15 P F510

• R430 PSY UI31880

     UP15/10/16 P F510

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.