|
Problem IC62564
|
Status: Closed |
DURING MIGRATION FROM V8.X TO V9.7 DATABASE CONFIGURATIONS ARE INCORRECTLY SET TO 'AUTOMATIC'. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
During migration from V8.X to V9.5 the following Database
Configuration parameters are incorrectly changed to 'AUTOMATIC':
STMTHEAP
NUM_IOCLEANERS
NUM_IOSERVERS
DFT_PREFETCH_SZ
MAXAPPLS
AVG_APPLS
This includes migration through 'db2 migrate database <database
name>' as well as a migration that occurs from a restore from a
v8.X backup into v9.5.
ONLY migrations from V8.X to V9.5 are affected by this APAR. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* User migrating from 8.x to 9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* During migration from V8.X to V9.7 the following *
* DatabaseConfiguration parameters are incorrectly changed *
* to'AUTOMATIC'STMTHEAPNUM_IOCLEANERSNUM_IOSERVERSDFT_PREFETCH_S
* includes migration through 'db2 migrate *
* database<databasename>' as well as a migration that occurs *
* from a restorefrom av8.X backup into v9.7.ONLY migrations *
* from V8.X are affected by this. *
****************************************************************
* RECOMMENDATION: *
* Migrate to 9.7 FP1 or later directly. *
**************************************************************** |
| Local Fix: |
Manually update the affected database configuration parameters
to desired fixed value. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
ONLY migrations from V8.X are affected by this. |
| Workaround |
Manually update the affected database configuration parameters
to desired fixed value. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.08.2009
12.03.2010
12.03.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
