IC81342: FUNCTION SE_DISSOLVE MIGHT RETURN (USE06) - UNKNOWN ESRI SHAPE LIBRARY ERROR (-2000)

APAR status

• Closed as program error.

Error 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
  

Local fix

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                                        *
  ****************************************************************
  

Problem conclusion

• 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.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  IFMX SPATIAL DB

• Fixed component ID

  5724C6100

Applicable component levels

• R821 PSN

     UP