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 IC61726 Status: Geschlossen

IMPORTING A SHAPEFILE WITH A POLGON THAT INCLUDES A LARGE NUMBER OF
INTERIOR RINGS MAY CAUSE DB2 TO HANG OR CRASH THE AGENT.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Importing a shapefile with a polgon that includes a large number 
of interior rings may cause 
one of the following DB2 failures: 
 
1. Apparent hang of DB2 for an operation that should complete 
quickly.  May consume 
large amounts of CPU resources until process killed by user. 
 
2. Import process takes a very long time but eventually 
completes with a message that some 
records could not be imported.  The import message file contains 
the message: 
GSE0214N  An INSERT statement failed.  SQLERROR = "SQL0430N 
User defined function "DB2GSE.GSEGEOMFROMBIN" 
(specific name "GSEGEOMBIN1") has abnormally terminated. 
SQLSTATE=38503". 
 
3. Crash of DB2 instance with message: 
SQL1224N The database manager is not able to accept new 
requests, has 
terminated all requests in progress, or has terminated your 
particular request 
due to an error or a force interrupt. SQLSTATE=55032
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Spatial Extender                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Importing a shapefile with a polygon that includes a large   * 
* number of interior rings might cause                         * 
* one of the following DB2 failures:                           * 
*                                                              * 
* 1. Apparent hang of DB2 for an operation that should         * 
* complete                                                     * 
*    quickly.  Might consume large amounts of CPU resources    * 
* until process killed by user.                                * 
*                                                              * 
* 2. Import process takes a very long time but eventually      * 
*                                                              * 
*    completes with a message that some                        * 
*    records could not be imported. The import message file    * 
*    contains the message:                                     * 
*        GSE0214N  An INSERT statement failed.  SQLERROR =     * 
*        "SQL0430N     User defined function                   * 
* "DB2GSE.GSEGEOMFROMBIN"                                      * 
*        (specific name "GSEGEOMBIN1") has abnormally          * 
*        terminated.    SQLSTATE=38503".                       * 
*                                                              * 
* 3. Crash of DB2 instance with message:                       * 
*     SQL1224N The database manager is not able to             * 
*     accept new requests, has                                 * 
*     terminated all requests in progress, or has              * 
*     terminated your particular request                       * 
*     due to an error or a force interrupt.                    * 
*     SQLSTATE=55032                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install V9.7 FP1                                             * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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
Install V9.7 FP1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.06.2009
15.10.2009
15.10.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList