|
Problem IC64617
|
Status: Geschlossen |
V91FP9 - SPATIAL MIGRATION FAILS IF THERE ARE CUSTOMER STORED PROCEDURES USING SPATIAL OBJECTS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The customer was attempting to migrate a database created and
spatially-enabled on DB2 V8 to DB2 V9.1.
The 'db2se migrate' utility failed due to a package dependency
on spatial objects due to current design checks.
We should allow package dependencies and perform rebind at the
end of the spatial migration process |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All Spatial Extender *
****************************************************************
* PROBLEM DESCRIPTION: *
* Attempting to perform spatial migration of a database which *
* has user-created stored procedures referencing Spatial *
* Extender objects will fail with a message like: *
* ***CAN NOT BE MIGRATED *** *
* : Package "DWA"."P6040277" --> Table *
* "DB2GSE"."GSE_SPATIAL_REFERENCE_SYSTEMS" *
****************************************************************
* RECOMMENDATION: *
* Apply V9.7 FP2 *
* *
* A work-around is to manually drop the stored procedures that *
* reference Spatial Extender objects, perform the spatial *
* migration and re-create the stored procedures. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Fixed in V9.7 FP2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.11.2009
08.04.2010
08.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
