|
Problem IT05640
|
Status: Closed |
DURING THE UPGRADE OF THE DATABASE THE FOLLOWING ERROR MAYBE SEEN SQL0206N |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
This could be caused by the database having inconsistencies in
the statistics between the tables and its indexes. This
inconsistency then causes the upgrade of the database to fail,
and stops the upgrade process. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DURING THE UPGRADE OF THE DATABASE THE FOLLOWING ERROR MAYBE *
* SEEN SQL0206N *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* First fixed in fix pack 5 of v10.1 *
**************************************************************** |
| Local Fix: |
It is recommended to restore the database on the original DB2
Level, then run a fresh runstats on both the tables and indexes
(using the AND INDEXES ALL clause). It is recommended to do this
on all tables within the database. |
| Solution |
First fixed in fix pack 5 of v10.1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.11.2014
15.07.2015
15.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
