Db2 Spatial Extender CLP messages

The Db2 Spatial Extender CLP messages indicate the success or failure of an operation. Also, they can provide shape information.

The Db2 Spatial Extender CLP returns messages for:

Stored procedures, if invoked implicitly.
Shape information, if you have invoked the shape_info subcommand program from the Db2 Spatial Extender CLP. These are informational messages.
Upgrade operations.
Import and export shape operations to and from the client.

Examples of messages for stored procedures returned by the Db2 Spatial Extender CLP

Most of the messages returned through the Db2 Spatial Extender CLP are for Db2 Spatial Extender stored procedures. When you invoke a stored procedure from the Db2 Spatial Extender CLP, you will receive message text that indicates the success or failure of the stored procedure.

The message text consists of the message identifier, the message number, the message type, and the explanation. For example, if you enable a database using the command db2se enable_db testdb, the message text returned by the Spatial Extender CLP is:


Enabling database. Please wait ...   

GSE1036W   The operation was successful.  But 
           values of certain database manager and 
           database configuration parameters 
           should be increased.

Likewise, if you disable a database using the command db2se disable_db testdb the message text returned by the Spatial Extender CLP is:


GSE0000I  The operation was completed successfully.

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. The steps to retrieve this information, and a detailed explanation of how to interpret the parts of the message text, are discussed in a separate topic.

If you are invoking stored procedures through an application program or from the Db2 command line, there is a separate topic that discusses diagnosing the output parameters.

Example of messages for shape information returned by the Spatial Extender CLP

Suppose you decide to display information for a shape file named office. Through the Spatial Extender CLP (db2se) you would issue this command:


db2se shape_info -fileName /tmp/offices

This is an example of the information that displays:



Shape file information
----------------------
File code                  = 9994
File length (16-bit words) = 484
Shape file version         = 1000
Shape type                 = 1 (ST_POINT)
Number of records          = 31

Minimum X coordinate = -87.053834
Maximum X coordinate = -83.408752
Minimum Y coordinate = 36.939628
Maximum Y coordinate = 39.016477
Shapes do not have Z coordinates.
Shapes do not have M coordinates.

Shape index file (extension .shx) is present.

Attribute file information
--------------------------
dBase file code                = 3
Date of last update            = 1901-08-15
Number of records              = 31
Number of bytes in header      = 129
Number of bytes in each record = 39
Number of columns              = 3

Column Number  Column Name      Data Type       Length  Decimal

           1   NAME             C ( Character)      16        0
           2   EMPLOYEES        N (   Numeric™)      11        0
           3   ID               N (   Numeric)      11        0

Coordinate system definition: "GEOGCS["GCS_North_American_1983",
DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137,298.257222101]],
PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]"

Examples of messages for upgrade operations returned by the Spatial Extender CLP

When you invoke commands that perform upgrade operations, messages are returned that indicate the success or failure of that operation.

Suppose you upgrade the spatially enabled database mydb using the following command:

db2se upgrade mydb -messagesFile /tmp/db2se_upgrade.msg

The message text returned by the Spatial Extender CLP is:


Upgrading database. Please wait ...   
GSE0000I		The operation was completed successfully.