PM45902: RUNSTATS ISSUE WHEN USING TABLE IS MIGRATED AND SEVERAL TABLES EXIST IN TABLESPACE. RUNSTATS PICKS UP LAST TABLE IN TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS, when migrating a table,
  and the tablespace contains multiple tables, RUNSTATS utility
  picks up the last table in the tablespace instead of the
  table being migrated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the MIG (Migrate) function to   *
  *                 migrate a table and select the 'Run          *
  *                 RUNSTATS' = 'YES' option on panel ADB28M     *
  *                 'Migrate Parameters'.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Administration Tool for      *
  *                      z/OS, when migrating one of the tables  *
  *                      under a table space using the MIG       *
  *                      function, the LISTDEF statement for     *
  *                      the RUNSTATS and COPY utility picks     *
  *                      up the wrong table name. The last       *
  *                      table listed under the table space is   *
  *                      used instead of the table being         *
  *                      migrated.                               *
  *                                                              *
  *                      The following method could be used      *
  *                      to determine which table is the         *
  *                      last table:                             *
  *                                                              *
  *                      when line command 'T' is issued         *
  *                      against a table space on panel          *
  *                      ADB21S 'Table Spaces' panel, the        *
  *                      following statement will be             *
  *                      executed to list all the tables         *
  *                      under the table space:                  *
  *                                                              *
  *                      SELECT * FROM                           *
  *                      SYSIBM.SYSTABLES                        *
  *                      WHERE DBNAME = 'XXX' AND                *
  *                      TSNAME = 'XXX' AND                      *
  *                      DBID= XXX FOR FETCH ONLY                *
  *                                                              *
  *                      EXPLAIN this statement to               *
  *                      determine which index is used           *
  *                      and how DB2 determines the last         *
  *                      table.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In the DB2 Administration Tool for z/OS, when migrating one of
  the tables under a table space using the MIG function, the
  LISTDEF statement for the RUNSTATS and COPY utility picks up
  the wrong table name. The last table listed under the table
  space is used instead of the table being migrated.
  
  The following method could be used to determine which
  table is the last table: when line command 'T' is issued
  against a table space on panel ADB21S 'Table Spaces'
  panel, the following statement will be executed to list
  all the tables under the table space:
  
  SELECT * FROM SYSIBM.SYSTABLES WHERE
  DBNAME = 'XXX' AND TSNAME = 'XXX' AND
  DBID= XXX FOR FETCH ONLY
  
  EXPLAIN this statement to determine which index is used and
  how DB2 determines the last table.
  

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:

  UK72126

Modules/Macros

•    ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK72126

     UP11/09/23 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.