How to interpret spatial messages

Understanding how spatial 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 spatial by using any of the following interfaces:

Spatial stored procedures
Spatial functions

These interfaces return general SQL messages or specific spatial messages.

The following table explains each part of this sample spatial message text:


GSE0000I: The operation was completed successfully.

Table 1. The parts of the spatial message text
Message text part	Description
GSE	The message identifier. All specific spatial 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 spatial message reference.