|
Problem IC74930
|
Status: Closed |
UPGRADING DATABASES TO V9.7 VIA RESTORE FROM 64-BIT TO 32-BIT PL ATFORMS MAY FAIL DUE TO DATABASE CONFIGURATION PARAMETERS OUT OF |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Restore database from lower version of database from 64bit to
32bit, the parameter are not automatically tuned.
Following error is being hit while migrating database.
SQL5131N The value specified for the configuration parameter
"pckcachesz" is
not in the valid range. The valid range is "-1", or from "32"
to "128000". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Prior v9.7 FP4 *
****************************************************************
* PROBLEM DESCRIPTION: *
* 64 bit database migration to 32 bit architect machine *
****************************************************************
* RECOMMENDATION: *
* upgrade v9.7 fp5 *
**************************************************************** |
| Local Fix: |
The workaround is simple of course - either:
a) Change db config parameters to valid ranges for 32-bit
platforms prior to taking the backup for the upgrade.
b) Upgrade to a 64-bit instance in v9.7 first, then backup and
restore the database into a 32-bit instance.
(b) will work because we have the fix in place for restoring
databases on the same release which will reset the config parms
that are out of range. |
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
v9.7 FP5 |
| Workaround |
not known / see Local fix |
| Comment |
This is one time occurrence kind of situation |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.03.2011
20.12.2011
20.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
