PI89113: CLONE/MATERIALIZED/HISTORY TABLE NOT UNLOADED IF DEFINED THROUGHLISTDEF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A table defined through a LISTDEF statement and that
  fulfills one of the following conditions:
          it has a clone table and CLONED YES is specified
          it is an history table
          it is a materialized query tableYES is specified
  is unduly not unloaded by DB2 HPU/InfoUnload without any
  explanation message.
  
  PB50701 Z626 Z627
  

Local fix

• the concerned table can be unloaded by explicitly specifying it
  in the FROM clause of the SELECT statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A table defined through a LISTDEF       *
  *                      statement and that fulfills one of      *
  *                      the following conditions:               *
  *                      - it has a clone table and CLONED YES   *
  *                       is specified                           *
  *                      - it is an history table                *
  *                      - it is a materialized query table      *
  *                      is unduly not unloaded by DB2           *
  *                      HPU/InfoUnload without any              *
  *                      explanation message.                    *
  *                      pb50701                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The olistdef  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:

  UI53208

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI53208

     UP18/01/18 P F801

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.