PH21064: DB2 ADMIN TOOL GEN NO STATISTICS FOR ARCHIVE TABLE WHEN NO DDL REQUESTED OR ARCHIVE TABLE ALPHABETICALLY PRECEDES BASE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool GEN processing will not produce statistics
  statements for archive tables under the following conditions:
  
  1) When 'Generate catalog stats' is set to 'only' on
  panel ADB2GEN, or, for MIGrate processing, when 'Catalog
  statistics' is set to 'yes' on panel ADB28M, but 'DDL'
  is set to 'no'.
  
  2) In a GEN request, where the name of the archive table (or
  parent database or tablespace) appears earlier in the alphabet
  than the base table (or its parent database or tablespace).
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering function (GEN)      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When both archive and archive-enabled   *
  *                      table are in the scope of GEN and user  *
  *                      elects to generate only catalog         *
  *                      statistics (no DDL), the archive table  *
  *                      statistics may be missing.              *
  ****************************************************************
  When both archive and archive-enabled table are in the scope of
  GEN and user elects to generate only catalog statistics
  (no DDL), the archive table statistics may be missing.
  
  This occurs when the archive table is listed before the
  archive-enabled table in the GEN request. This also applies if
  the scope of the GEN request is database or table space, and the
  database or table space containing the archive table is listed
  first.
  

Problem conclusion

• The issue 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:

  UI67939

Modules/Macros

• ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67939

     UP20/03/02 P F002

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.