PK91279: ABEND878-10 WHEN USING LISTDEF INCLUDE FOR TABLESPACES WITH WILDCARDED TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using a LISTDEF statement similar to 'INCLUDE TABLESPACES
  TABLE C9SRC%.XF%' and one of the tablespaces found has hundreds
  or thousand of tables that match the wild carded table, each
  table is processed even though only one table from each
  tablespace is required. This results in far too many catalog
  accesses and may eventually lead to the 878-10 storage abend.
  The code has been changed to exclude from further processing all
  but one table in a particular DB.TS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using a LISTDEF statement similar  *
  *                      to 'INCLUDE TABLESPACES TABLE           *
  *                      C9SRC%.XF%' and one of the tablespaces  *
  *                      found has hundreds or thousand of       *
  *                      tables that match the wild carded       *
  *                      table, each table is processed even     *
  *                      though only one table from each         *
  *                      tablespace is required. This results    *
  *                      in far too many catalog accesses and    *
  *                      may eventually lead to the 878-10       *
  *                      storage abend. The code has been        *
  *                      changed to exclude from further         *
  *                      processing all but one table in a       *
  *                      particular DB.TS.                       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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

•    CKZTCPS
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R210 PSY UK51118

     UP09/10/20 P F910

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.