DB2 FOR LUW / DB2FORLUW / 910 - DB2

RENAME TABLE does not update the SYSCAT.TABLES 
STATISTICS_PROFILE column with the new renamed table name.  The 
STATISTICS_PROFILE registers the Runstats statement when the SET 
PROFILE option is specified during Runstats. 
 
Here is an example: 
 
db2 create table chrisjg.test (c1 int) 
DB20000I  The SQL command completed successfully. 
 
db2 runstats on table TABSCHEMA.test with distribution set 
profile only 
DB20000I  The RUNSTATS command completed successfully. 
 
db2 select 'before',char(tabschema,20) as sch, char(tabname,20) 
as tab, substr(statistics_profile,1,40) as stat_profile from 
syscat.tables where tabschema='TABSCHEMA' 
 
1      SCH                  TAB                  STAT_PROFILE 
 
------ -------------------- -------------------- 
---------------------------------------- 
before TABSCHEMA              TEST                 RUNSTATS ON 
TABLE "TABSCHEMA"."TEST" ON AL 
 
  1 record(s) selected. 
 
 
db2 rename table TABSCHEMA.test to zzz 
DB20000I  The SQL command completed successfully. 
 
db2 select 'after rename',char(tabschema,20) as sch, 
char(tabname,20) as tab, substr(statistics_profile,1,40) as 
stat_profile from syscat.tables where tabschema='TABSCHEMA' 
 
1            SCH                  TAB 
STAT_PROFILE 
 
------------ -------------------- -------------------- 
---------------------------------------- 
after rename TABSCHEMA              ZZZ 
RUNSTATS ON TABLE "TABSCHEMA"."TEST" ON AL 
 
  1 record(s) selected. 
:

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Version 9.1 GA through Fix Pack 8 servers on Linux,  * 
* Unix and Windows platforms issuing RENAME TABLE statements.  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* There was missing functionality in updating the              * 
* STATISTICS_PROFILE column of the catalog table               * 
* SYSIBM.SYSTABLES during a RENAME TABLE statement, hence      * 
* leaving the old table name in the profile.                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 Version 9.1 Fix Pack 9, or re-run RUNSTATS command * 
* as noted in the local fix.                                   * 
****************************************************************

Re-issue a Runstats command after RENAME TABLE with the SET 
PROFILE option to re-initialize this field and gather the most 
up-to-date statistics.

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

Problem first fixed in DB2 Version 9.1 Fix Pack 9 and all 
subsequent Fix Packs.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC64143 IC64144 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.10.2009
11.05.2010
11.05.2010

9.1.FP9,
9.1.FP9