PM76859: GEN 'GENERATE CATALOG STATS' MISSING AVGROWLEN FOR SYSIBM.SYSTABLESPACE IN DB2 10 NFM.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN functions 'Generate
  catalog stats' does not create SQL UPDATE statements for
  the AVGROWLEN column of SYSIBM.SYSTABLESPACE when executed on
  a DB2 10 subsystem.
  The DB2 SQL Reference does not indicate that the column is
  updatable however a query of the column in SYSIBM.SYSCOLUMNS
  shows the UPDATES column has a 'Y' value.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 to generate catalog statistics on panel      *
  *                 ADB2GEN 'Generate SQL from DB2 catalog'      *
  *                 on a DB2 10 system which have a 'Y' value    *
  *                 for the UPDATES column in DB2 catalog        *
  *                 table SYSIBM.SYSCOLUMNS for column           *
  *                 AVGROWLEN of catalog tables                  *
  *                 SYSIBM.SYSTABLEPART and                      *
  *                 SYSIBM.SYSTABLESPACE.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN function does not create SQL        *
  *                      UPDATE statements for the AVGROWLEN     *
  *                      column value in DB2 catalog tables      *
  *                      SYSIBM.SYSTABLESPACE and                *
  *                      SYSIBM.SYSTABLEPART when the            *
  *                      'Generate catalog stats' field is       *
  *                      set to 'Y' on panel ADB2GEN on a DB2    *
  *                      10 subsystem.                           *
  *                                                              *
  *                      The DB2 SQL Reference, Version 10       *
  *                      does not indicate that the column is    *
  *                      updatable, however a query of the       *
  *                      column in SYSIBM.SYSCOLUMNS shows       *
  *                      the UPDATES column has a value of       *
  *                      'Y'.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN does not generate SQL to UPDATE the AVGROWLEN column for
  SYSIBM.SYSTABLEPART and SYSIBM.SYSTABLESPACE when generating
  catalog statistics.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK90395 UK90396

Modules/Macros

•    ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90395

     UP12/12/19 P F212

• RA20 PSY UK90396

     UP12/12/19 P F212

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.