PM39861: LISTDEF IS NOT DEFINED FOR RUNSTATS WHEN USING ALC ON A TABLE TO ADD A PARTITION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Listdef is not defined for Runstats when using ALC on a table to
  add a partition.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the ALC or ALT line command is     *
  *                      issued for a table with LOB or XML      *
  *                      columns, and a partition is added       *
  *                      through the use of a work statement     *
  *                      list ( WSL ), the RUNSTATS statement    *
  *                      is missing the name of the LISTDEF.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The skeleton ADBTRUN relies on variables being set to indicate
  whether a table includes LOB or XML columns.  If the variables
  are not set correctly, the skeleton builds the wrong
  statements.
  

Problem conclusion

• The callers of the skeleton are modified to correctly set
  variables ADBLOBC and ADBXMLC.
  

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:

  UK71423 UK71424

Modules/Macros

•    ADBGAJOB ADBTRUN  ADB2U    ADB2USR  ADB2USRO
  ADB25LD  ADB27CA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK71423

     UP11/09/02 P F109

• R720 PSY UK71424

     UP11/09/02 P F109

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.