PH22202: IGNORE EXISTENCE OF UNUSABLE INDEX ON UNLOADED TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a Db2 index on the table to be unloaded is in a Db2 state
  that prevents from using it, Db2 HPU terminates in error even
  though the index is not used to unload the table and only used
  for the INDEXSCAN feature that is an optional feature.
  An enhancement should be done :
  - to ignore Db2 status of all indexes
  - to disable the index scan process if the index to be used is
  in an unsupported state
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a Db2 index on the table to be     *
  *                      unloaded is in a Db2 state that         *
  *                      prevents from using it, Db2 HPU         *
  *                      terminates in error even though the     *
  *                      index is not used to unload the table   *
  *                      and only used for the INDEXSCAN feature *
  *                      that is an optional feature.            *
  *                                                              *
  *                      An enhancement should be done :         *
  *                      - to ignore Db2 status of all indexes   *
  *                      - to disable the index scan process if  *
  *                        the index to be used is in an         *
  *                        unsupported state                     *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  ignore existence of unusable index on unloaded 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.