Informix - Problem description
Problem IC81342 | Status: Closed |
FUNCTION SE_DISSOLVE MIGHT RETURN (USE06) - UNKNOWN ESRI SHAPE LIBRARY ERROR (-2000) | |
product: | |
IFMX SPATIAL DB / 5724C6100 / 821 - Informix 8.21 | |
Problem description: | |
The function SE_Dissolve returns (USE06) - Unknown ESRI shape library error (-2000) in SE_Dissolve_Iter. when specific geometry objects are processed as part of the aggregate. Example: select grid,se_dissolve(geom) from geotab group by 1 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of the spatial datatype getting a -2000 from * * se_disolve or st_union * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10 with spatial data type * * with version 8.21.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of the spatial datatype getting a -2000 from * * se_disolve or st_union * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10 with spatial data type * * with version 8.21.xC7 * **************************************************************** | |
Comment | |
Problem Fixed In IBM Informix spatial data type with version 8.21.xC7 The customer must set: SGMAXRESOVERLAY=1 in the server OS environment and restart the server to enable spatial to use the maximum resolution during overlay operations in se_disolve() and st_union(). Note that using the environment variable will impact performance. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.02.2012 30.12.2015 30.12.2015 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.0 | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5.W1 | |
12.10.xC6 |