IC88703: SPATIAL QUERY USING BOTH THE ST_NEARESTPOINTS AND ST_DISTANCE FUNCTIONS MAY FAIL WITH THE SQL0430N ERROR.

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• 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
  

Local fix

• There is no workaround.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 10.1 Fix Pack 2.                      *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 Version 10.1 Fix Pack 2.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC87330

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP