home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC88609 Status: Geschlossen

AFTER RUNNING SPATIAL EXTENDER UPGRADE, CREATING A SPATIAL INDEX FAILS WITH
-901.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
After running the Spatial Extender upgrade stored procedure, 
either directly or through the 'db2se upgrade' command, it is 
not possible to create a new spatial index.  This fails with 
-901 and an error that some function can not be found although 
the name is not identified. 
 
Attempting to create a new feature layer with ESRI software will 
also fail. 
 
The spatial upgrade process attempts to drop and re-create most 
of the spatial objects with the most current definition.  This 
is resulting in a corruption of the spatial index extension. 
 
This problem only occurs if there are spatial indexes already 
existing in the database, although this will usually be the case 
if a spatial upgrade is performed. 
 
The upgrade process will be successful if no spatial indexes 
exist at the time the upgrade is run. 
 
A work around is to save the current spatial index definitions 
and drop the spatial indexes, then run the upgrade followed by 
re-creating the spatial indexes.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 Spatial Extender                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* After running the Spatial Extender upgrade stored procedure, * 
* it is not possible to create a new spatial index.  This      * 
* fails with -901 and an error that some function can not be   * 
* found although the name is not identified.                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install V10.1 Fixpack 2                                      * 
****************************************************************
Local-Fix:
db2se save_indexes <dbname> 
db2se upgrade <dbname> 
db2se restore_indexes <dbname>
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Install V10.1 Fixpack 2
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.11.2012
02.01.2013
02.01.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.2 FixList
10.5.0.2 FixList