|
Problem IC74930
|
Status: Geschlossen |
UPGRADING DATABASES TO V9.7 VIA RESTORE FROM 64-BIT TO 32-BIT PL ATFORMS MAY FAIL DUE TO DATABASE CONFIGURATION PARAMETERS OUT OF |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
v9.7 FP5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Kommentar |
This is one time occurrence kind of situation |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.03.2011
20.12.2011
20.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
