DB2 FOR LUW / DB2FORLUW / 970 - DB2

A spatial query using both the ST_NearestPoints and ST_Distance 
functions may fail with the error: 
 
SQL0430N User defined function "DB2GSE.GSENATIVEDISTANCE" 
(specific name "GSENDIST") has abnormally terminated. 
SQLSTATE=38503 
 
The ST_NearestPoints function is typically used to find the 
point(s) on a line "nearest" to a specified point location, such 
as querying a table of highway segments to find the highway 
segments and the closest points to a specified point. This would 
normally be qualified by a distance to avoid scanning the entire 
table. 
 
An example query is: 
with test_point(point) as ( 
     values(db2gse.ST_Point (-108.21461,44.77150 , 1)) 
   ) 
select objectid 
      ,db2gse.ST_NearestPoints(route.shape, point) as np 
from  highways, test_point 
where db2gse.st_distance(shape, point) < 0.1

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 8 or higher.             * 
****************************************************************

There is no workaround.

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
 

First fixed in DB2 Version 9.7 Fix Pack 8.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

23.10.2012
08.04.2013
08.04.2013

9.7.FP8