How to interpret Db2 Spatial Extender messages

Understanding how Db2 Spatial Extender messages are structured and how to obtain additional information for them can help you determine whether the spatial operation that you requested completed successfully or resulted in an error.

You can work with Db2 Spatial Extender by using any of the following interfaces:

Db2 Spatial Extender stored procedures
Db2 Spatial Extender functions

All these interfaces return Db2 Spatial Extender messages.

The following table explains each part of this sample Db2 Spatial Extender message text:


GSE0000I: The operation was completed successfully.

Table 1. The parts of the Db2 Spatial Extender message text
Message text part	Description
GSE	The message identifier. All Db2 Spatial Extender messages begin with the three-letter prefix GSE.
0000	The message number. A four digit number that ranges from 0000 through 9999.
I	The message type. A single letter that indicates the severity of message: C Critical error messages N Non-critical error messages W Warning messages I Informational messages
The operation was completed successfully.	The message explanation.

The explanation that appears in the message text is the brief explanation. You can retrieve additional information about the message that includes the detailed explanation and suggestions to avoid or correct the problem through the SYSPROC.GET_MESSAGE procedure, the Db2 CLP, or the message reference for Spatial Extender.