GSE Messages

This section contains the messages for IBM® Spatial Support for Db2 for z/OS®. The messages are listed in numeric sequence.

GSE0001C An internal error occurred.

Explanation

IBM Spatial Support for Db2 for z/OS encountered an unexpected internal error.

User response

Repeat the command. If the problem persists, contact IBM Software Support.

msgcode: -1

sqlstate: 38S01

GSE0002C IBM Spatial Support for Db2 for z/OS could not access its memory pool. Reason code = reason-code.

Explanation

IBM Spatial Support for Db2 for z/OS tried unsuccessfully to access its memory pool.

User response

Note the reason code reason-code and contact IBM Software Support.

msgcode: -2

sqlstate: 38S02

GSE0003N IBM Spatial Support for DB2 for z/OS could not allocate number bytes of memory.

Explanation

Not enough memory was available. Possible reasons are that the supply of memory was too low, or that memory was being used by other applications.

User response

Resolve the memory shortage and repeat the command.

msgcode: -3

sqlstate: 38S03

GSE0004C An internal parameter error occurred.

Explanation

IBM Spatial Support for Db2 for z/OS encountered an unexpected error in a parameter passed to an internal function. The operation cannot be completed successfully.

User response

Repeat the command. If the problem persists, contact IBM Software Support.

msgcode: -4

sqlstate: 38S04

GSE0006N An internal string error occurred.

Explanation

IBM Spatial Support for Db2 for z/OS encountered an unexpected error in an internal string operation. The operation cannot be completed successfully.

User response

Repeat the command. If the problem persists, contact IBM Software Support.

msgcode: -6

sqlstate: 38S06

GSE0007N The string string is missing either a closing quotation mark or a closing pair of quotation marks.

Explanation

This string lacks a closing delimiter and therefore is not terminated correctly.

User response

Terminate the string correctly. If it starts with a quotation mark, close it with a quotation mark. If it starts with a pair of quotation marks, close it with a pair of quotation marks.

msgcode: -7

sqlstate: 38S07

GSE0008N An invalid error code error-code was used to raise an error.

Explanation

There was an attempt to raise an error identified by an invalid error-code.

User response

Contact IBM Software Support.

msgcode: -8

sqlstate: 38S08

GSE0100N IBM Spatial Support for DB2 for z/OS could not open a file named file-name. Reason code = reason-code.

Explanation

Reasons why a file cannot be opened, preceded by their reason codes, are as follows:
111
Permission is denied.
112
The resource is temporarily unavailable.
117
The file exists.
119
The file is too large.
122
An I/O error occurred.
123
The file specified is a directory.
126
The file name specified is too long.
129
No such file or directory exists.
132
Not enough space is available.
141
The specified file system is read-only.
162
HFS encountered a system error.

All other reason codes indicate an internal error.

User response

Verify the authorization for the file and the directories, then repeat the command.

If a reason code that indicates an internal error was encountered, contact IBM Software Support.

msgcode: -100

sqlstate: 38S10

GSE0101N An I/O error occurred while a file named file-name was being processed. Reason code = reason-code.

Explanation

Reasons why an I/O error can occur during file processing, preceded by their reason codes, are as follows:
111
Permission is denied.
112
The resource is temporarily unavailable.
119
The file is too large.
162
HFS encountered a system error.

All other reason codes indicate an internal error.

User response

Verify that the file exists, that you have the appropriate access to the file, and that the file is not in use by another process.

If a reason code that indicates an internal error was encountered, contact IBM Software Support.

msgcode: -101

sqlstate: 38S11

GSE0102N IBM Spatial Support for DB2 for z/OS could not close a file named file-name. Reason code = reason-code.

Explanation

Reasons why an error can occur during an attempt to close a file, preceded by their reason codes, are as follows:
122
An I/O error occurred.
162
HFS encountered a system error.

All other reason codes indicate an internal error.

User response

Verify that the file system is in fully working condition and that enough disk space is available.

If a reason code that indicates an internal error was encountered, contact IBM Software Support.

msgcode: -102

sqlstate: 38S12

GSE0103N IBM Spatial Support for DB2 for z/OS could not delete a file named file-name. Reason code = reason-code.

Explanation

Reasons why an error can occur during an attempt to delete a file, preceded by their reason codes, are as follows:
111
Permission is denied.
112
The resource is temporarily unavailable.
122
An I/O error occurred.
126
The file name specified is too long.
129
No such file or directory exists.
141
The specified file system is read-only.
162
HFS encountered a system error.

All other reason codes indicate an internal error.

User response

Verify the authorization for the file and the directories, then repeat the command.

If a reason code that indicates an internal error was encountered, contact IBM Software Support.

msgcode: -103

sqlstate: 38S13

GSE0200N An attempt to connect to the database failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS was not able to connect to the database. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -200

sqlstate: 38S20

GSE0201W An attempt to disconnect from the database failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS was not able to disconnect from the database. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: +201

sqlstate: 38S21

GSE0202N No connection to a database exists.

Explanation

IBM Spatial Support for Db2 for z/OS cannot connect to a database. The command cannot be executed successfully.

User response

Verify the IBM Spatial Support for Db2 for z/OS and database setup. Make sure that a connection to the database can be established.

msgcode: -202

sqlstate: 38S22

GSE0203W IBM Spatial Support for DB2 for z/OS was already connected to database database-name.

Explanation

IBM Spatial Support for Db2 for z/OS tried to connect to the database database-name but was already connected to it.

User response

Contact IBM Software Support.

msgcode: +203

sqlstate: 38S23

GSE0204N An attempt to commit a transaction failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not commit the current transaction successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -204

sqlstate: 38S24

GSE0205W An attempt to roll back a transaction failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not roll back the current transaction. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: +205

sqlstate: 38S25

GSE0206N A SELECT statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute a SELECT statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -206

sqlstate: 38S26

GSE0207N A VALUES statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute a VALUES statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -207

sqlstate: 38S27

GSE0208N A PREPARE statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not prepare an SQL statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -208

sqlstate: 38S28

GSE0209N An attempt to open an SQL cursor failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not open a cursor over a result set successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -209

sqlstate: 38S29

GSE0210W An attempt to close an SQL cursor failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not close a cursor over a result set successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: +210

sqlstate: 38S2A

GSE0211N A fetch from an SQL cursor failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not fetch a result from a cursor successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -211

sqlstate: 38S2B

GSE0212N An attempt to drop an object failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not drop the specified database object. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -212

sqlstate: 38S2C

GSE0214N An INSERT statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute an INSERT statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -214

sqlstate: 38S2E

GSE0215N An UPDATE statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute an UPDATE statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -215

sqlstate: 38S2F

GSE0216N A DELETE statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute a DELETE statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -216

sqlstate: 38S2G

GSE0217N A LOCK TABLE statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute a LOCK TABLE statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -217

sqlstate: 38S2H

GSE0218N A DECLARE GLOBAL TEMPORARY TABLE statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute a DECLARE GLOBAL TEMPORARY TABLE statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -218

sqlstate: 38S2I

GSE0219N An EXECUTE IMMEDIATE statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute an EXECUTE IMMEDIATE statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -219

sqlstate: 38S2J

GSE0220N The setting of a savepoint failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not set a savepoint successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -220

sqlstate: 38S2K

GSE0221N No database name was specified.

Explanation

IBM Spatial Support for Db2 for z/OS could not connect to a database because the name of the database was not specified.

User response

Specify a database name.

msgcode: -221

sqlstate: 38S2L

GSE0222N An attempt to retrieve the authorization list from DB2 failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not retrieve the authorization list for the current user. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -222

sqlstate: 38S2M

GSE0223N An attempt to quiesce a table space failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not quiesce a table space successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -223

sqlstate: 38S2N

GSE0224N An attempt to import data into a table failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not import data into a table successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -224

sqlstate: 38S2O

GSE0226N An attempt to create a trigger failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not create a trigger successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -226

sqlstate: 38S2Q

GSE0227N An ALTER TABLE statement failed. SQLERROR = sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS could not execute an ALTER TABLE statement successfully. Db2 returned sql-error.

User response

Refer to the description of sql-error.

msgcode: -227

sqlstate: 38S2R

GSE0228N An attempt to retrieve the message for error gse-error and SQLCODE = sqlcode from the IBM Spatial Support for Db2 for z/OS message catalog failed.

Explanation

IBM Spatial Support for Db2 for z/OS could not retrieve the message for error gse-error and SQLCODE = sqlcode successfully.

User response

Verify the installation of IBM Spatial Support for Db2 for z/OS. Verify also that the message catalog in the language that you want to use is installed.

msgcode: -228

sqlstate: 38S2S

GSE0230N The system catalog could not be updated.

Explanation

IBM Spatial Support for Db2 for z/OS encountered an error while attempting to use the Db2 service to update the system catalog.

User response

Contact IBM Software Support.

msgcode: -230

sqlstate: 38S2U

GSE0231N A PREPARE statement encountered a warning condition. SQLWARNING = sql-warning.

Explanation

IBM Spatial Support for Db2 for z/OS encountered a warning condition when preparing an SQL statement. Db2 returned sql-warning. The PREPARE statement was completed successfully.

User response

Refer to the description of sql-warning.

msgcode: -231

sqlstate: 38S2V

GSE0300N The specified password is too long.

Explanation

The password used in your attempt to connect to the database is too long.

User response

Verify that the password you specified is correct. If it is the correct password, then shorten it and try the operation again.

msgcode: -300

sqlstate: 38S40

GSE0301N The specified schema name, schema-name, is too long.

Explanation

The requested operation cannot be completed successfully because the length of the schema name exceeds the limit for schema names in Db2.

User response

Specify a valid, shorter schema name. For more information on the schema name length limit, refer to IBM Spatial Support for Db2 for z/OS User's Guide and Reference and try the operation again.

msgcode: -301

sqlstate: 38S41

GSE0302N The specified table name, table-name, is too long.

Explanation

The requested operation cannot be completed successfully because the length of the table name exceedslimit for table names in Db2.

User response

Specify a valid, shorter table name.

For more information on the table name length limit, refer to IBM Spatial Support for Db2 for z/OS User's Guide and Reference, and then try the operation again.

msgcode: -302

sqlstate: 38S42

GSE0303N The specified column name, column-name, is too long.

Explanation

The requested operation cannot be completed successfully because the length of the column name exceeds the limit for column names in Db2.

User response

Specify a valid, shorter column name.

For more information on the column name length limit, refer to IBM Spatial Support for Db2 for z/OS User's Guide and Reference, and then try the operation again.

msgcode: -303

sqlstate: 38S43

GSE0304N The specified index name, index-name, is too long.

Explanation

The requested operation cannot be completed successfully because the length of the index name exceeds limit for index names in Db2.

User response

Specify a valid, shorter index name. For more information on the index name length limit, refer to IBM Spatial Support for Db2 for z/OS User's Guide and Reference, and then try the operation again.

msgcode: -304

sqlstate: 38S44

GSE0305N The specified data type name, type-name, is too long.

Explanation

The requested operation cannot be completed successfully because the length of the data type name exceeds limit for data type names in Db2.

User response

Specify a valid, shorter type name. For more information on the data type name length limit, refer to IBM Spatial Support for Db2 for z/OS User's Guide and Reference, and then try the operation again.

msgcode: -305

sqlstate: 38S45

GSE0306N A complete path that starts with path would exceed the acceptable limit of limit bytes.

Explanation

The file in a path that starts with path cannot be accessed because the length of the complete path would exceed the limit of limit bytes. As a result, the statement that you submitted cannot be executed successfully.

User response

Change the location of the file to be accessed so that it can be found using a shorter path and re-submit the statement that you specified. On UNIX systems, symbolic links can be used to establish a shorter path name.

msgcode: -306

sqlstate: 38S46

GSE0307N The length of a dynamic SQL statement statement-length would exceed the acceptable limit of limit bytes.

Explanation

The statement cannot be constructed because it would be too long.

User response

If the statement is constructed in the context of a stored procedure, verify that the WHERE clause is not too long. If necessary, shorten the WHERE clause and retry the operation. If the problem persists, contact IBM Software Support.

msgcode: -307

sqlstate: 38S47

GSE0308N The string, string, exceeds the limit of limit bytes.

Explanation

The requested operation cannot be completed successfully because the string, string, is too long.

User response

Specify a shorter string. If necessary, contact IBM Software Support.

msgcode: -308

sqlstate: 38S48

GSE1000N IBM Spatial Support for DB2 for z/OS could not perform an operation operation-name that was requested under user id user-id.

Explanation

You requested this operation under a user id that does not hold the privilege or authority to perform the operation.

User response

Consult the IBM Spatial Support for Db2 for z/OS User's Guide and Reference to find out what the required authorization for the operation is.

msgcode: -1000

sqlstate: 38S50

GSE1001N The specified value, value, is not valid for the argument-name argument.

Explanation

The value value that you entered for argument argument-name was incorrect or misspelled.

User response

Consult the IBM Spatial Support for Db2 for z/OS User's Guide and Reference to find out what value or range of values you need to specify.

msgcode: -1001

sqlstate: 38S51

GSE1002N A required argument, argument-name, was not specified.

Explanation

The requested operation cannot be completed successfully because an argument that it requires was not specified.

User response

Specify argument argument-name with the value that you want; then request the operation again.

msgcode: -1002

sqlstate: 38S52

GSE1003N The spatial column, schema-name.table-name.column-name, could not be registered with the spatial reference system srs-name because it is already registered with another spatial reference system.

Explanation

A spatial reference system is already registered with the spatial column. It cannot be registered again unless it is unregistered first.

User response

Either unregister the spatial column and then register it with the spatial reference system you want or do not attempt to register it again.

msgcode: -1003

sqlstate: 38S53

GSE1006N The spatial column schema-name.table-name.column-name is not registered.

Explanation

This spatial column was not registered with a spatial reference system. Therefore, it cannot be unregistered.

User response

Specify a spatial column that is already registered, or do not attempt to unregister the column.

msgcode: -1006

sqlstate: 38S56

GSE1009N A table named schema-name.table-name does not exist.

Explanation

The requested operation cannot be completed successfully because the table schema-name.table-name does not exist.

User response

Specify a valid table name and retry the operation.

msgcode: -1009

sqlstate: 38S59

GSE1010N A spatial column named schema-name.table-name.column-name does not exist.

Explanation

The requested operation cannot be completed successfully because schema-name.table-name.column-name does not identify an existing column.

User response

Specify a valid spatial column name and retry the operation.

msgcode: -1010

sqlstate: 38S5A

GSE1011N A data type named schema-name.type-name does not exist.

Explanation

The requested operation cannot be completed successfully because a data type schema-name.type-name does not exist.

User response

Specify a valid data type name and retry the operation.

msgcode: -1011

sqlstate: 38S5B

GSE1012N The database has not been enabled for spatial operations.

Explanation

The requested operation cannot be completed successfully because the database has not been enabled for spatial operations and, therefore, a IBM Spatial Support for Db2 for z/OS catalog has not been created.

User response

Enable the database for spatial operations.

msgcode: -1012

sqlstate: 38S5C

GSE1013N The database is already enabled for spatial operations.

Explanation

The database is already enabled for spatial operations. It cannot be enabled again.

User response

Verify that the database has been enabled as you expected. If necessary, disable the database.

msgcode: -1013

sqlstate: 38S5D

GSE1014N IBM Spatial Support for DB2 for z/OS was unable to register a column named schema-name.table-name.column-name because it is not a spatial column.

Explanation

Either this column does not have a spatial data type, or it does not belong to a local table.

User response

Define a spatial data type for column schema-name.table-name.column-name, or specify a column with a spatial data type as declared type.

msgcode: -1014

sqlstate: 38S5E

GSE1015N A spatial reference system named srs-name does not exist.

Explanation

The requested operation cannot be completed successfully because a spatial reference system with the name srs-name does not exist.

User response

Specify an existing spatial reference system and retry the operation.

msgcode: -1015

sqlstate: 38S5F

GSE1016N A spatial reference system whose numeric identifier is srs-id does not exist.

Explanation

The requested operation could not be completed successfully because a spatial reference system with the specified numeric identifier srs-id does not exist.

User response

Specify an existing spatial reference system identifier and retry the operation.

msgcode: -1016

sqlstate: 38S5G

GSE1017N A coordinate system named coordsys-name already exists.

Explanation

A coordinate system named coordsys-name already exists. Another coordinate system with the same name cannot be created.

User response

Specify a unique name for the new coordinate system.

msgcode: -1017

sqlstate: 38S5H

GSE1018N A coordinate system named coordsys-name does not exist.

Explanation

The requested operation cannot be completed successfully because a coordinate system with the name coordsys-name does not exist.

User response

Specify the name of an existing coordinate system.

msgcode: -1018

sqlstate: 38S5I

GSE1019N No values of the spatial coordinate system coordsys-name are specified.

Explanation

You attempted to alter the coordinate system coordsys-name, but did not specify any new values.

User response

Specify at least one new value for the coordinate system.

msgcode: -1019

sqlstate: 38S5J

GSE1020N A spatial reference system named srs-name already exists.

Explanation

A spatial reference system named srs-name already exists. Another spatial reference system with the same name cannot be created.

User response

Specify a unique name for the spatial reference system to be created and retry the operation.

msgcode: -1020

sqlstate: 38S5K

GSE1021N A spatial reference system named srs-name does not exist.

Explanation

The requested operation cannot be completed successfully because a spatial reference system with the name srs-name does not exist.

User response

Specify a name of an existing spatial reference system and retry the operation.

msgcode: -1021

sqlstate: 38S5L

GSE1022N A spatial reference system whose numeric identifier is srs-id does not exist.

Explanation

The requested operation cannot be completed successfully because a spatial reference system with the numeric identifier srs-id does not exist.

User response

Specify an existing numeric identifier for the spatial reference system.

msgcode: -1022

sqlstate: 38S5M

GSE1023N A coordinate system whose numeric identifier is coordsys-id does not exist.

Explanation

The requested operation cannot be completed successfully because a coordinate system with the numeric identifier coordsys-id does not exist.

User response

Specify an existing numeric identifier for the coordinate system and retry the operation.

msgcode: -1023

sqlstate: 38S5N

GSE1024N No values of the spatial reference system srs-name are specified.

Explanation

You attempted to alter the spatial reference system srs-name, but did not specify any new values.

User response

Specify at least one new value for the spatial reference system and then try the operation again.

msgcode: -1024

sqlstate: 38S5O

GSE1025N A geocoder whose function name is schema-name.function-name could not be found in the database.

Explanation

The requested operation cannot be completed successfully because IBM Spatial Support for Db2 for z/OS could not locate a function named schema-name.function-name for the geocoder.

User response

Specify a geocoder with an existing function name or create the function, then try the operation again.

msgcode: -1025

sqlstate: 38S5P

GSE1034N The parameters passed to the stored procedure do not include a parameter parameter-name.

Explanation

The SQLDA that was passed to the stored procedure is too small. It does not contain an entry for parameter parameter-name.

User response

Correct the parameters that are being passed to the stored procedure.

msgcode: -1034

sqlstate: 38S5Y

GSE1035N The parameter-name parameter, which is being passed to the stored procedure, has an incorrect data type.

Explanation

The data type for parameter parameter-name that is passed to the stored procedure is not correct.

User response

Correct the parameters that are being passed to the stored procedure.

msgcode: -1035

sqlstate: 38S5Z

GSE1037N The definition of the specified coordinate system named coordsys-name is invalid.

Explanation

A coordinate system named coordsys-name cannot be created because the definition given for it is invalid.

User response

Specify a correct definition for the coordinate system.

The function ST_EqualCoordsys can be used to verify the definition by comparing the coordinate system with itself.

msgcode: -1037

sqlstate: 38S61

GSE1038N The WHERE clause specified for the geocoder named geocoder-name is invalid. When IBM Spatial Support for Db2 for z/OS attempted to verify the clause, it encountered SQL error sql-error.

Explanation

The geocoding that you requested cannot be completed successfully because the where clause that determines which rows are to be geocoded is invalid.

User response

Specify a syntactically correct WHERE clause.

msgcode: -1038

sqlstate: 38S62

GSE1039N A coordinate system identified by the specified identifier organization-coordsys-id in combination with the specified organization organization already exists.

Explanation

Your request to create a coordinate system could not be met because the combination of identifiers that you specified for the coordinate system (the name of the organization that defined the system and a number that this organization assigned to it) was not unique. Either these two values must be unique in combination, or they must be null.

User response

Specify a unique set of values for organization and organization-coordsys-id, or choose null values for both.

msgcode: -1039

sqlstate: 38S63

GSE1040N A spatial reference system with the numeric identifier srs-id already exists.

Explanation

Your request to create a spatial reference system could not be met because the numeric identifier srs-id that you assigned to it already identifies another spatial reference system. A spatial reference system's identifier must be unique.

User response

Specify a unique numeric identifier for the spatial reference system.

msgcode: -1040

sqlstate: 38S64

GSE1041N A coordinate system with the numeric identifier coordsys-id already exists.

Explanation

Your request to create a coordinate system could not be met because the numeric identifier coordsys-id that you assigned to it already identifies another spatial coordinate system. A spatial coordinate system's identifier must be unique.

User response

Specify a unique value coordsys-id for the coordinate system.

msgcode: -1041

sqlstate: 38S65

GSE1043N The specified grid index schema-name.index-name already exists.

Explanation

This index already exists. It must be dropped before an index with the same name can be created.

User response

Specify a name for the index that does not yet exist, or drop the existing index and retry the operation.

msgcode: -1043

sqlstate: 38S67

GSE1044N The specified coordinate system coordsys-name cannot be dropped because an existing spatial reference system is based on this coordinate system.

Explanation

At least one spatial reference system exists that is based on the specified coordinate system coordsys-name. The coordinate system cannot be dropped.

User response

Drop all spatial reference systems that are based on the specified coordinate system. Then try to drop the coordinate system again.

msgcode: -1044

sqlstate: 38S68

GSE1045N The specified spatial reference system srs-name cannot be dropped because a spatial column is registered with this spatial reference system.

Explanation

At least one spatial column exists that is associated with the specified spatial reference system srs-name. The spatial reference system cannot be dropped.

User response

Unregister all spatial columns that are associated with the specified spatial reference system. Then try to drop the spatial reference system again.

msgcode: -1045

sqlstate: 38S69

GSE1048N The spatial reference system with numeric identifier srs-id is a predefined geodetic spatial reference system and cannot be altered.

Explanation

The spatial reference system was not altered. Spatial reference systems with numeric identifiers in the range 2000000000 to 2000000317 are predefined geodetic spatial reference systems and cannot be altered.

User response

Do not attempt to alter this spatial reference system. If a geodetic spatial reference system with a different definition is needed, you can create a new geodetic spatial reference system with the numeric identifier in the range 2000000318 to 2000001000.

msgcode: -1048

sqlstate: 38SP3

GSE1049N The spatial reference system with numeric identifier srs-id is a predefined geodetic spatial reference system and cannot be dropped.

Explanation

The spatial reference system was not altered. Spatial reference systems with numeric identifiers in the range 2000000000 to 2000000317 are predefined geodetic spatial reference systems and cannot be dropped.

User response

Do not attempt to drop this spatial reference system. If a geodetic spatial reference system with a different definition is needed, you can create a new geodetic spatial reference system with the numeric identifier in the range 2000000318 to 2000001000.

msgcode: -1049

sqlstate: 38SP4

GSE2100N The number of attribute columns being imported (input-columns columns) does not match the number of attribute columns in the target table (table-columns columns).

Explanation

If you are importing columns that contain attribute data, you have the choice of either specifying or not specifying which attribute columns are being imported and which columns are in the target table. If you specify these values, this error occurs when the specified number of attribute columns being imported differs from the specified number of columns in the target table. If you do not specify these values, this error occurs when the actual number of columns being imported differs from the actual number of attribute columns in the target table.

User response

Make sure that the number of specified or actual attribute columns being imported matches the number of specified or actual columns in the target table.

msgcode: -2100

sqlstate: 38S70

GSE2101N The data type schema-name.type-name to be used during import is unknown to DB2.

Explanation

The spatial data type schema-name.type-name cannot be used during the import of spatial data because it does not exist in the database.

User response

Create the data type in the database or use a data type that exists.

msgcode: -2101

sqlstate: 38S71

GSE2102N The table specified for import, schema-name.table-name, does not exist.

Explanation

A table named schema-name.table-name does not exist in the database. Also, IBM Spatial Support for Db2 for z/OS was not asked to create a table to hold the data that is to be imported. The data was not imported.

User response

If the table is to be created by IBM Spatial Support for Db2 for z/OS, specify the appropriate flag. Otherwise, create the table and retry the operation.

msgcode: -2102

sqlstate: 38S72

GSE2103N The table specified for import schema-name.table-name already exists.

Explanation

IBM Spatial Support for Db2 for z/OS was asked to create a table named schema-name.table-name for the imported data, but a table with that name already exists in the database. No data was imported.

User response

If the table is not to be created by IBM Spatial Support for Db2 for z/OS, do not indicate that the table is to be created. Otherwise, specify the name for a table which does not yet exist in the database.

msgcode: -2103

sqlstate: 38S73

GSE2104N The column schema-name.table-name.column-name to import data into does not exist.

Explanation

The column into which you want to import data column-name does not exist in the table schema-name.table-name. No data can be imported into it.

User response

Correct the column name or create the column in the table that is to be imported, or correct the table name.

msgcode: -2104

sqlstate: 38S74

GSE2105W The import operation completed successfully but not all records from the file were imported.

Explanation

The import operation completed successfully but not all records from the file were imported. The exception file contains the records that could not be imported, and the messages file the contains information why those records were not imported.

User response

Consult the messages file for the reason why not all records were imported, correct the problem and repeat the operation with the original file or the exception file.

msgcode: +2105

sqlstate: 38S75

GSE2106N The data type of the column schema-name.table-name.column-name is column-type, which does not match the expected type expected-type for the data to be imported from file.

Explanation

The column column-name in the table schema-name.table-name to import data into has a declared type column-type. column-type does not match the type name expected-type for the data to be imported from the file. No data can be imported.

User response

Verify the definition of the table with the structure of the file to be imported.

msgcode: -2106

sqlstate: 38S76

GSE2107N The table to import data into could not be created due to error sql-error.

Explanation

IBM Spatial Support for Db2 for z/OS was asked to create a table to import data into, but the table could not be created successfully. Db2 returned sql-error.

User response

Refer to the description of this sql-error.

msgcode: -2107

sqlstate: 38S77

GSE2108N The method specification method to identify the attribute columns to be imported from the file is not correct.

Explanation

Either no method specification was given or method is not a valid method specification. Only 'N' and 'P' are supported method specifications for importing spatial data from a file.

User response

Correct the method specification and try the method again.

msgcode: -2108

sqlstate: 38S78

GSE2109N A character found-char was found when a character expected-char was expected.

Explanation

An unexpected character found-char was found in the string that identifies the attribute columns to be imported from the file but expected-char was expected. The statement cannot be processed successfully.

User response

Correct the string that identifies the attribute columns to be imported from the file.

msgcode: -2109

sqlstate: 38S79

GSE2110N The column position identifier position in the string string is invalid.

Explanation

The column position identifier position specified in the string starting with string is not in the valid range. Only values greater than 0 (zero) and less than or equal to the number of columns in the file to be imported can be specified. The statement cannot be processed successfully.

User response

Correct the column position identifier.

msgcode: -2110

sqlstate: 38S7A

GSE2111N A column named dbf-column-name in the dBASE file is too long.

Explanation

The name of column dbf-column-name in the dBASE file (.dbf) exceeds the limit for column names in Db2.

User response

Specify a dbf-column-name that does not exceed the Db2 length limit.

msgcode: -2111

sqlstate: 38S7B

GSE2112N The column dbf-column-name cannot be found in the dBASE file.

Explanation

The name dbf-column-name does not identify an existing attribute column in the dBASE file (.dbf). The operation cannot be completed successfully.

User response

Specify a column name that exists in the dBASE file.

msgcode: -2112

sqlstate: 38S7C

GSE2113N The dBASE file data type dbf-data-type for the column dbf-column-name in the dBASE file is not supported.

Explanation

The dBASE file data type dbf-data-type for the attribute column dbf-column-name in the dBASE file (.dbf) cannot be mapped to a data type in the Db2 database. The shape file cannot be imported.

User response

Exclude the column from the column list.

msgcode: -2113

sqlstate: 38S7D

GSE2114N The column position position is out of range. The dBASE file contains dbf-column-number columns.

Explanation

The specified column position position must be a value within the valid range. A valid value must greater than 0 (zero) and less than or equal to the dbf-column-number.

User response

Specify a valid position.

msgcode: -2114

sqlstate: 38S7E

GSE2115N A spatial reference system whose numeric identifier is srs-id does not exist.

Explanation

A spatial reference system whose numeric identifier is srs-id does not exist. The data cannot be imported.

User response

Either specify an existing spatial reference system, or create the spatial reference system before attempting the import operation.

msgcode: -2115

sqlstate: 38S7F

GSE2116N The coordinate system definition coordsys-def is too long.

Explanation

The coordinate system definition coordsys-def used for the spatial data to be imported is too long. It could not be verified with the coordinate system that underlies the spatial reference system that is to be used for the imported data.

User response

Verify that the coordinate system defined in the projection file (.prj) is correct. To skip the verification step, do not supply the projection file.

msgcode: -2116

sqlstate: 38S7G

GSE2117N The coordinate system definition coordsys-def does not match the coordinate system definition on which the spatial reference system srs-id is based.

Explanation

The coordinate system coordsys-def does not match the coordinate system on which the spatial reference system srs-id is based. Both coordinate systems must be semantically identical.

User response

Verify that the coordinate system defined in the projection file (.prj) matches the coordinate system of the spatial reference system. To skip the verification step, do not supply the projection file.

msgcode: -2117

sqlstate: 38S7H

GSE2118N The spatial data does not fit into the spatial reference system with the numeric identifier srs-id.

Explanation

The spatial data covers an area that exceeds the minimum and maximum coordinates of the spatial reference system with the numeric identifier srs-id.

User response

Specify a spatial reference system which may fully contain the spatial data to be imported. Refer to the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view for the minimum and maximum coordinate values applicable for the spatial reference system.

msgcode: -2118

sqlstate: 38S7I

GSE2119N The imported data's spatial reference system, whose numerical identifier is srs-id1, does not match the target column's spatial reference system, whose numeric identifier is srs-id2. The target column's name is schema-name.table-name.column-name.

Explanation

The spatial column schema-name.table-name.column-name was registered with a spatial reference system srs-id2 assigned to it. This spatial reference system does not match the spatial reference system srs-id1, which is used for the spatial data to be imported into that column. The data cannot be imported.

User response

Either unregister the spatial column, or specify the same spatial reference system for the data to be imported that the column uses.

msgcode: -2119

sqlstate: 38S7J

GSE2120N No data was imported.

Explanation

None of the shape data could be imported. All rows were rejected and written to the exception file.

User response

Consult the message file for the reasons why all the spatial data was rejected.

msgcode: -2120

sqlstate: 38S7K

GSE2121N The value restart-count specifying the record to restart the operation is out of range. The shape file contains record-count records.

Explanation

The specified restartCount restart-count must be a greater than or equal to 0 (zero), and less than or equal to record-count.

User response

Specify a valid number for restartCount, or specify a null value for the restartCount.

msgcode: -2121

sqlstate: 38S7L

GSE2122N The SQL statement used to import the shape data does not fit into the internal buffer.

Explanation

The SQL statement used to import the shape data into the table does not fit into the internal buffer. A possible reason for this might be too many columns are in the file.

User response

Import a smaller set of the attribute columns in the shape file.

msgcode: -2122

sqlstate: 38S7M

GSE2123N A buffer to hold the data for row-count rows cannot be allocated.

Explanation

IBM Spatial Support for Db2 for z/OS tried to use a single INSERT statement to import at least row-count rows, but a buffer to hold the data for these rows could not be allocated. Too much memory was required.

User response

Specify a commit count for the import that is less than row-count. Or, specify a smaller set of columns to be imported. This will reduce the amount of memory required.

msgcode: -2123

sqlstate: 38S7N

GSE2124N An invalid type identifier type-id was found in the header of the shape file to be imported.

Explanation

The data in the shape file does not appear to have a valid spatial data type. The shape file is possibly corrupted. The data was not imported.

User response

Verify that the shape file is valid.

msgcode: -2124

sqlstate: 38S7O

GSE2125N A column in the shape file has an unsupported data type type.

Explanation

The shape file contains a column whose data type is not supported by IBM Spatial Support for Db2 for z/OS. The shape file could not be imported.

User response

Import only a smaller set of the columns of the shape file and omit the column with the unsupported data type.

msgcode: -2125

sqlstate: 38S7P

GSE2126N The header of the shape file shape-file is invalid.

Explanation

The header of the shape file shape-file is invalid. The shape file cannot be imported.

The extension of the file name shape-file indicates in which part of the shape file the error was encountered. The file extensions include:
.shp
main file
.shx
index file
.dbf
dBASE file
.pri
projection file

User response

Verify and correct the header of the shape file.

msgcode: -2126

sqlstate: 38S7Q

GSE2127N The offset offset for the record record-number in the shape index file shx-file is invalid.

Explanation

The offset offset for the record record-number in the index file (.shx) shx-file is invalid. The offset must be greater than or equal to 50 and less than the total length of the main file (.shp) of the shape file. The offset is measured in 16 bit words.

User response

Verify and correct the shape file.

msgcode: -2127

sqlstate: 38S7R

GSE2128N The length of the shape in record record-number of the shape index file shx-file is too short.

Explanation

The length of the shape in record record-number found in the shape index file shx-file is too short. Each shape must consist of at least 4 bytes (two 16 bit words).

User response

Verify and correct the shape file.

msgcode: -2128

sqlstate: 38S7S

GSE2129N IBM Spatial Support for DB2 for z/OS found an incorrect record number record-number in the shape file shp-file when expecting record number expected-number.

Explanation

IBM Spatial Support for Db2 for z/OS found an incorrect record number record-number in the shape file shp-file when expecting record number expected-number.

User response

Verify and correct the shape file.

msgcode: -2129

sqlstate: 38S7T

GSE2130N The size of the shape data record-size indicated in the shape file shp-file does not match the size indicated in the shape index file index-size.

Explanation

The size of the shape data record-size indicated in the shape file shp-file does not match the size indicated in the shape index file index-size.

The main file of the shape file (.shp) is not consistent with the index file (.shx) and cannot be processed further.

User response

Verify and correct the shape file.

msgcode: -2130

sqlstate: 38S7U

GSE2131N The data for record record-number in the dBASE file dbf-file is invalid.

Explanation

The data for record record-number in the dBASE file dbf-file that contains the attribute information associated with the geometries in the shape file is invalid.

Possible explanations are:
  • The first byte of the record is neither an asterisk ('*') nor a space (' ').
  • The sum of all lengths of the columns in the dBASE file (.dbf) must be equal to the record size indicated in the header of the file.

User response

Verify and correct the dBASE file.

msgcode: -2131

sqlstate: 38S7V

GSE2132N The data in shape file shape-file is invalid.

Explanation

The data in shape file shape-file is corrupted. This shape file cannot be imported.

The file name shape-file indicates in which part of the shape file the error was encountered.

User response

Verify and correct the shape file.

msgcode: -2132

sqlstate: 38S7W

GSE2133N The import operation failed because the column schema-name.table-name.column-name is not nullable.

Explanation

The definition of the column column-name in the existing table schema-name.table-name indicates that the column may not contain nulls. The column is not included in the list of columns to be imported and Db2 would not produce the values for that column by any other means like default values, a generated column definition or any triggers.

The import operation cannot be completed successfully.

User response

Include the column in the list of columns to be imported, identify the column as id-column, or define an alternate way for Db2 to generate the values for that column during the import operation.

msgcode: -2133

sqlstate: 38S7X

GSE2134N The spatial reference system associated with the data to be imported is not identical with the spatial reference system with the numeric identifier srs-id.

Explanation

The spatial data in the file to be imported uses a spatial reference system with different offsets and scale factors than the spatial reference system with the numeric identifier srs-id. The data cannot be imported successfully.

User response

Specify a spatial reference system which has the same definition as the spatial reference system required by the data in the file to be imported. Refer to the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view for the minimum and maximum coordinate values and the offsets and scale factors applicable for the spatial reference system.

msgcode: -2134

sqlstate: 38S7Y

GSE2299N The shape file file-name has an invalid file size.

Explanation

Shape file file-name has an invalid file size. Shape files have a file size that is a multiple of 16-bit words. Therefore, their size is always even. The shape file might be corrupt. It cannot be used.

User response

Verify and correct the shape file.

msgcode: -2299

sqlstate: 38S9H

GSE3000N Null SRS identifier.

Explanation

A null value was passed to the function or method instead of a numeric spatial reference system identifier.

User response

Specify a numeric spatial reference system identifier for an existing spatial reference system. Refer to the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS for the defined spatial reference systems.

msgcode: -3000

sqlstate: 38SU0

GSE3001N Invalid SRS identifier srs-id.

Explanation

The spatial reference system identifier srs-id that was provided to the spatial function or method does not identify an existing spatial reference system.

User response

Specify an existing numeric spatial reference system identifier that is defined in the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS, or create a spatial reference system that is identified by srs-id.

msgcode: -3001

sqlstate: 38SU1

GSE3002N Null unit name.

Explanation

A null was specified as a unit of measure. The specification for a unit of measure must be the unit itself (for example, “meter”). It cannot be a null.

User response

Either omit the unit of measure when calling the spatial function or method, or specify an existing unit of measure. Consult the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_UNITS_OF_MEASURE for supported units.

msgcode: -3002

sqlstate: 38SU2

GSE3003N Unknown unit unit-name.

Explanation

The unit unit-name that was provided to the spatial function or method does not identify an existing unit of measure.

User response

Either omit the unit of measure when calling the spatial function or method, or specify an existing unit of measure. Consult the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_UNITS_OF_MEASURE for supported units.

msgcode: -3003

sqlstate: 38SU3

GSE3004N Unsupported conversion to unit unit-name.

Explanation

The conversion to the unit unit-name is not supported.

The functions ST_Area, ST_Buffer, ST_Length, and ST_Perimeter cannot accept a linear unit of measure if the given geometry is not in a projected coordinate system.

User response

Use one of the following methods:
  • Omit the unit of measure when calling the spatial function or method.
  • Specify an angular unit of measure.
  • Project the geometry into a projected coordinate system using the ST_Transform function. Consult the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS for applicable spatial reference system.

msgcode: -3004

sqlstate: 38SU4

GSE3005N No unit in SRS.

Explanation

The spatial reference system for the geometry does not have an associated linear or angular unit. The operation cannot be performed in the requested unit of measure.

User response

Either represent the geometry in a correct spatial reference system, which does have an associated linear or angular unit of measure, or omit the unit parameter when you request the operation.

msgcode: -3005

sqlstate: 38SU5

GSE3006N Invalid internal type id.

Explanation

The internal data type identifier for this geometry is a null value and therefore invalid.

This error can occur if the internal representation of the geometry is corrupted, or if the geometry was not constructed by one of the supported constructor functions or methods.

User response

Construct the geometry again by using one of the supported constructor functions or methods.

msgcode: -3006

sqlstate: 38SU6

GSE3007N Unknown internal type id type-id.

Explanation

The value of the internal type identifier type-id for the geometry is not valid.

This error can occur if the internal representation of the geometry is corrupted, or if the geometry was not constructed by one of the supported constructor functions or methods.

User response

Construct the geometry again by using one of the supported constructor functions or methods.

msgcode: -3007

sqlstate: 38SU7

GSE3008N Internal type id mismatch (type-id1, type-id2).

Explanation

A mismatch of internal data type identifiers was found. IBM Spatial Support for Db2 for z/OS expected to retrieve a geometry whose internal data type identifier is type-id2, but instead retrieved a geometry whose internal data type identifier is type-id1.

This error can occur if the internal representation of the geometry is corrupted, or if the geometry was not constructed by one of the supported constructor functions or methods.

User response

Construct the geometry again by using one of the supported constructor functions or methods.

msgcode: -3008

sqlstate: 38SU8

GSE3009W Invalid part number part-number.

Explanation

The specified part number part-number is not valid. A null value was returned.

User response

If the geometry is not empty, then specify a valid part number, which should be greater than 0 (zero) and less then or equal to the maximum number of parts in the geometry type.

You can use the ST_NumGeometries function to determine the number of parts of the geometry type.

If the geometry is empty, the method should not be applied.

msgcode: +3009

sqlstate: 01HS0

GSE3010W Invalid ring number ring-number.

Explanation

The specified number ring-number for an internal ring is not valid. A null value was returned.

User response

If the polygon value is not empty, then specify a valid ring number, which should be greater than or equal to 1 (one) and less than or equal to the maximum number of interior rings in the polygon.

If the polygon is empty, the function or method should not be applied. You can use the function ST_NumInteriorRings to determine the number of interior rings of the polygon.

msgcode: +3010

sqlstate: 01HS1

GSE3011W Invalid point number point-number.

Explanation

The specified point number point-number is not valid. A null value was returned.

User response

If the curve value is not empty, then specify a valid point number, which should be greater than 0 (zero) and less than or equal to the maximum number of points in the curve. If the curve is empty, the function or method should not be applied.

You can use the ST_NumPoints function to determine the number of points used to define the curve.

msgcode: +3011

sqlstate: 01HS2

GSE3012N Invalid DE9-IM matrix.

Explanation

The intersection matrix matrix specified for the ST_Relate function is not valid. The matrix must be exactly 9 characters long, and each character in the matrix must be one of the following: 'T', 'F', '0', '1', '2', or '*'.

User response

Specify a valid intersection matrix.

msgcode: -3012

sqlstate: 38SU9

GSE3013N Exterior ring is no ring.

Explanation

The linestring that is to to serve as the new exterior ring for the polygon is not a ring. To be a ring, the linestring must be both simple and closed. One or both of these two conditions is not met.

User response

Specify a simple and closed linestring for the new exterior ring of the polygon.

msgcode: -3013

sqlstate: 38SUA

GSE3014N Interior ring is no ring.

Explanation

The linestring that is to serve as a new interior ring for the polygon is not a ring. To be a ring, the linestring must be both simple and closed. At least one of these two conditions is not met.

User response

Specify a simple and closed linestring for the new interior ring of the polygon.

msgcode: -3014

sqlstate: 38SUB

GSE3015N Reason code = reason-code. Transformation to SRS srs-id failed.

Explanation

The geometry could not be transformed from the spatial reference system it is represented into the spatial reference system with the numeric identifier srs-id. The transform failed with reason code reason-code.

The reason codes have the following meanings:
-2008
The geometry is invalid.
-2018
Not enough memory is available to successfully complete the transformation.
-2020
The spatial reference systems are not compatible. Both spatial reference systems must be based directly or indirectly on the same geographic coordinate system.
-2021
One or more points of the resulting geometry would be outside the maximum possible extent for the new spatial reference system. The resulting geometry cannot be represented in the new spatial reference system.
-2025
The definition of the new spatial reference system is not valid.
-2026
An internal error occurred during the projection of the geometry.

User response

Represent the geometry in a spatial reference system that can be transformed into the spatial reference system identified by srs-id, or specify a different spatial reference system identifier to transform the geometry into.

msgcode: -3015

sqlstate: 38SUC

GSE3016N Unsupported cast type-id1, type-id2.

Explanation

The attempted cast operation from the data type with the internal type identifier type-id1 to the data type with the internal type identifier type-id2 is not supported. The geometry cannot be processed further.

User response

Specify a supported cast operation. For more information, refer to the IBM Db2 SQL Reference for the supported cast functions.

msgcode: -3016

sqlstate: 38SUD

GSE3020N Invalid Z coordinate and measure combination.

Explanation

The geometries that are to be processed by the function or method are not represented using the same dimensions with respect to their Z coordinates and measures.

All the geometries must either contain Z coordinates or contain no Z coordinates. All the geometries must either contain measures or contain no measures.

User response

Provide geometries to the function or method that are represented using the same dimensions with respect to their Z coordinates and measures.

msgcode: -3020

sqlstate: 38SUH

GSE3021N Reason code =reason-code. Locator failure.

Explanation

An internal error occurred when a spatial function or method operated on a LOB locator. The reason code reason-code was returned by a locator function.

User response

Refer to the Db2 Application Development Guide to determine the meaning of reason-code returned from the LOB locator operation and correct the problem. If the problem persists, contact IBM Software Support.

msgcode: -3021

sqlstate: 38SUI

GSE3022N Representation too long (append-length vs. written-length bytes).

Explanation

The representation of the geometry in Geographic Markup Language (GML), well-known text (WKT), well-known binary (WKB), or the shape representation would be too long. From append-length bytes, only written-length bytes could be appended to the encoding. A representation of the geometry cannot be created.

User response

Simplify the geometry by omitting points that are not essential for the geometry. You can use the ST_Generalize function for this procedure. Alternatively, break down the geometry into several smaller geometries.

msgcode: -3022

sqlstate: 38SUJ

GSE3023N Representation too short (length bytes).

Explanation

The representation of the geometry in well-known binary (WKB) representation or the shape representation is only length bytes long. It needs to have at least 4 bytes for the shape representation, exactly 5 bytes for the well-known binary representation for empty geometries, and at least 9 bytes for the well-known binary representation for non-empty geometries. The binary representation must also be long enough to contain all of the geometry points.

User response

Provide a valid well-known binary representation or shape representation to the function or method.

msgcode: -3023

sqlstate: 38SUK

GSE3024N Internal geometry too short.

Explanation

The internal representation of the geometry is too short. It could not be processed further.

This error can occur if the internal representation of the geometry is corrupted, or if the geometry was not constructed by one of the supported constructor functions or methods.

User response

Construct the geometry again using one of the supported constructor functions or methods.

msgcode: -3024

sqlstate: 38SUL

GSE3025N Geometry inconsistent.

Explanation

The geometry value is inconsistent and cannot be processed any further.

User response

Recreate the geometry from a valid binary or text representation.

msgcode: -3025

sqlstate: 38SUM

GSE3026N Inconsistent no. of points (indicated-number vs. data-number).

Explanation

An internal parameter of the geometry indicates that the geometry data contains indicated-number points. But the actual geometry data contains data-number points. Because of this inconsistency, the geometry will not be used further in the processing.

This error can occur if the internal representation of the geometry is corrupted, or if the geometry was not constructed by one of the supported constructor functions or methods.

User response

Recreate the geometry using the functions or methods supported by IBM Spatial Support for Db2 for z/OS.

msgcode: -3026

sqlstate: 38SUN

GSE3027N Point is empty.

Explanation

It is invalid to specify an X coordinate, Y coordinate, Z coordinate, or measure for an empty point.

If the point is constructed by the constructor function ST_Point, the point's X and Y coordinates must both be null. Furthermore, no Z coordinate or measure should be specified unless it is a null value.

If the mutators ST_X, ST_Y, ST_Z, or ST_M are used to modify an empty point, the point's X and Y coordinates must both be null. No Z coordinate or measure should be specified unless it is null.

User response

Use mutators ST_X, ST_Y, ST_Z, or ST_M to modify points that are not empty, or construct the point by specifying both X and Y coordinates with values that are not null.

msgcode: -3027

sqlstate: 38SUO

GSE3028N Inconsistent coordinates.

Explanation

If a new point is constructed, both the X and Y coordinates must be specified. Both coordinates must be either null or not null.

If both coordinate values are null, the resulting point will be empty. In that case, no Z coordinate or measure should be specified unless it is null.

User response

Specify null values for both the X and Y coordinates, or specify values that are not null for both coordinates.

msgcode: -3028

sqlstate: 38SUP

GSE3029N Invalid byte order byte-order.

Explanation

The byte order in the binary representation of the geometry must be either 0 (zero) or 1 (one), but it is byte-order.

In the well-known binary representation, a byte order of 0 (zero) indicates big endian format, and a byte order of 1 (one) indicates little endian format.

User response

Correct the byte order in the binary representation so that it is either 0 (zero) or 1 (one).

msgcode: -3029

sqlstate: 38SUQ

GSE3030N Invalid number of points num-points in geometry.

Explanation

The geometry has an invalid number of points num-points. This number must be greater than or equal to 0 (zero).

If the geometry is not empty, then the following conditions must be met:
point
The geometry must have exactly one point.
linestring
The geometry must have 2 or more points defining it.
polygon
The geometry must have 3 or more points defining it.

User response

Construct the geometry by using the functions or methods supported by IBM Spatial Support for Db2 for z/OS.

msgcode: -3030

sqlstate: 38SUR

GSE3031N Invalid extent (min-coord vs. max-coord) in geometry.

Explanation

The extent of the geometry in one of the dimensions is invalid. The minimum coordinate min-coord must be less than or equal to the maximum coordinate max-coord for all dimensions of the geometry.

User response

Construct the geometry by using the functions or methods supported by IBM Spatial Support for Db2 for z/OS.

msgcode: -3031

sqlstate: 38SUS

GSE3032N Aggregation failure.

Explanation

A mismatch between internal identifiers was encountered for the computation of a spatial aggregate.

Aggregate functions are not supported if used in any of the following situations:
  • In the partitioned environment.
  • A GROUP BY clause is used in the query that contains the spatial aggregate.
  • Any function other than the Db2 aggregate function MAX is used.
  • The aggregate function is not used in the correct context.

User response

Make sure that you use the aggregate function in a way that is supported by IBM Spatial Support for Db2 for z/OS.

msgcode: -3032

sqlstate: 38SUT

GSE3033N Invalid binary data (type ids type-id1, type-id2).

Explanation

A binary representation that is passed as input to this spatial function or method has to represent a geometry whose data type identifier is type-id2. But the representation that was actually passed to the function or method represents a geometry whose data type identifier is type-id1. No geometry could be constructed.

User response

Either call the correct function or method which constructs geometries of type type-id2 or correct the binary representation to represent a geometry of type-id1.

msgcode: -3033

sqlstate: 38SUU

GSE3034N Invalid text data (type ids type-id1, type-id2).

Explanation

A text representation that is passed as input to this spatial function or method has to represent a geometry whose data type identifier is type-id2. But the representation that was actually passed to the function represents a geometry whose data type identifier is type-id1. No geometry could be constructed.

User response

Either call the correct function which constructs geometries of type type-id1 or correct the text representation to represent a geometry of type-id2.

msgcode: -3034

sqlstate: 38SUV

GSE3035W Curve not changed.

Explanation

The curve was not changed because the specified point to be appended to the curve was empty.

User response

Append a point that is not empty to the curve.

msgcode: +3035

sqlstate: 01HS3

GSE3036W Geometry not accurate.

Explanation

The resulting geometry could not be represented accurately in the spatial reference system. One of the scale factors is too small and does not allow for a high enough precision to represent each point that defines the resulting geometry.

For example, consider a linestring with a well-known text representation of 'linestring m ( 10 10 8, 10 11 12 )' represented in a spatial reference system that includes a scale factor of 1 (one) for X coordinates and a scale factor of 1 (one) also for Y coordinates. If the function ST_MeasureBetween is applied to that linestring, and the upper and lower bounds for the measures are 9 and 10, respectively, the resulting linestring, represented in its well-known text representation, would have to be 'linestring m ( 10 10.25 9, 10 10.50 10 )'. However, the scale factor of 1 (one) for the Y coordinates prevents the representation of fractions. The coordinates 10.25 and 10.50 cannot be represented without rounding that would produce an incorrect result. Such coordinates will be removed from the geometry.

User response

Represent the geometry in a spatial reference system that uses larger scale factors. Alternatively, choose different parameters that influence the resulting geometry.

msgcode: +3036

sqlstate: 01HS4

GSE3037N Invalid GML, expecting char instead of string at position position.

Explanation

A character char was expected in the Geography Markup Language of the geometry, but the text string was found instead at position position. The GML representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the GML representation and construct the geometry again.

msgcode: -3037

sqlstate: 38SUW

GSE3038N Invalid GML, expecting expected-tag instead of given-tag at position position.

Explanation

The tag given-tag was found in the Geography Markup Language of the geometry at position position, but a tag expected-tag was expected. The GML representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the GML representation and construct the geometry again.

msgcode: -3038

sqlstate: 38SUX

GSE3039N Invalid GML, expecting number instead of text at position position.

Explanation

Unexpected text text was found in the Geography Markup Language of the geometry at position position. A number representing a coordinate was expected instead. The GML representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the GML representation and construct the geometry again.

msgcode: -3039

sqlstate: 38SUY

GSE3040N Invalid GML type type.

Explanation

An unknown type type was specified in the Geography Markup Language of the geometry. The GML supports points, linestrings, polygons, multipoints, multilinestrings, and multipolygons. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the GML representation and construct the geometry again.

msgcode: -3040

sqlstate: 38SUZ

GSE3041N GML point has been incorrectly specified.

Explanation

The problem occurred due to one of the following reasons:
  • A point, represented using the Geography Markup Language, can only have one set of coordinates. The given point had either no set of coordinates or more than one set.
  • The set of coordinates is not enclosed by corresponding <gml:coord> or <gml:coordinates> tags.

The GML representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the GML representation and construct the geometry again.

msgcode: -3041

sqlstate: 38SV0

GSE3042N Could not read number-bytes bytes from locator at offset offset. Total length of data is length.

Explanation

An attempt was made to read number-bytes bytes from the locator, starting at the offset offset. This exceeds the total length of the data length that is referenced by the locator. The data might be truncated.

For binary representations of a geometry, the binary representation might indicate an invalid binary encoding. The encoded geometry has fewer points than the header indicates.

User response

Verify and correct the representation of the geometry. Make sure that the binary or textual representation does not get truncated before it is passed to the IBM Spatial Support for Db2 for z/OS function.

msgcode: -3042

sqlstate: 38SV1

GSE3043N Invalid number of parts number-parts.

Explanation

The number of parts number-parts indicated in the binary representation of the geometry is invalid. The number of parts must be larger than 0 (zero) and match the actual number of parts supplied in the encoding.

User response

Specify the correct number of parts or supply all parts for the geometry.

msgcode: -3043

sqlstate: 38SV2

GSE3044N Invalid number of rings number-rings.

Explanation

The number of rings number-rings indicated in the binary representation of the polygon or multipolygon is invalid. The number of rings must be larger than 0 (zero) and match the actual number of parts supplied in the encoding.

User response

Specify the correct number of rings or supply all rings for the geometry.

msgcode: -3044

sqlstate: 38SV3

GSE3045N Invalid part offset part-offset in shape.

Explanation

An invalid offset part-offset for a part in the shape representation of the geometry was encountered. A part offset must be larger than or equal to 0 (zero), and each part offset must be larger than the preceding one. The shape representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the shape representation and construct the geometry again.

msgcode: -3045

sqlstate: 38SV4

GSE3046N Invalid type ID type-id in shape.

Explanation

The shape representation of the geometry contains an invalid type identifier type-id. The shape data is possibly corrupted. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Verify and correct the shape representation of the geometry.

msgcode: -3046

sqlstate: 38SV5

GSE3047N Invalid length shape-length of shape encoding for type type, expecting only expected-length bytes.

Explanation

The shape encoding contains shape-length bytes, which is too long. To encode a geometry of the specified type type, only expected-length bytes are required. The shape data is possibly corrupted. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Verify and correct the shape representation of the geometry.

msgcode: -3047

sqlstate: 38SV6

GSE3048N Invalid WKT format, expecting char instead of string.

Explanation

A character char was expected in the well-known text representation of the geometry, but the text string was found instead. The well-known text representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the well-known text representation and construct the geometry again.

msgcode: -3048

sqlstate: 38SV7

GSE3049N Invalid WKT format, expecting a number instead of text.

Explanation

An unexpected text text was found in the well-known text representation of the geometry. A number representing a coordinate was expected instead. The well-known text representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the well-known text representation and construct the geometry again.

msgcode: -3049

sqlstate: 38SV8

GSE3050N Unexpected parenthesis in WKT format at text.

Explanation

An unexpected opening or closing parenthesis was found in the well-known text representation of the geometry at text. The well-known text representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the well-known text representation and construct the geometry again.

msgcode: -3050

sqlstate: 38SV9

GSE3051N Parenthesis mismatch in WKT format, expecting parenthesis.

Explanation

The end of the well-known text representation was reached unexpectedly. A parenthesis parenthesis was expected. The well-known text representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the well-known text representation and construct the geometry again.

msgcode: -3051

sqlstate: 38SVA

GSE3052N Unknown type type in WKT.

Explanation

The well-known text representation of the geometry contains an unknown type name of type. The well-known text representation is not valid. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

User response

Correct the well-known text representation and construct the geometry again.

msgcode: -3052

sqlstate: 38SVB

GSE3053N Invalid type id type-id in WKB.

Explanation

The well-known binary representation of the geometry contains an invalid type identifier type-id. The data is possibly corrupted. IBM Spatial Support for Db2 for z/OS cannot construct the geometry successfully.

The type identifiers of separate parts in a geometry type (multipoint, multilinestring, or multipolygon) must have the same indicators for the Z and M coordinates as the geometry type itself.

User response

Verify and correct the well-known binary representation of the geometry.

msgcode: -3053

sqlstate: 38SVC

GSE3300N Invalid grid size grid-size-number.

Explanation

The grid size identified by its position grid-size-number is invalid. One of the following invalid specifications was made when the grid index was created with the CREATE INDEX statement:
  • A number less than 0 (zero) was specified as the grid size for the first, second, or third grid level.
  • 0 (zero) was specified as the grid size for the first grid level.
  • The grid size specified for the second grid level is less than the grid size of the first grid level but it is not 0 (zero).
  • The grid size specified for the third grid level is less than the grid size of the second grid level but it is not 0 (zero).
  • The grid size specified for the third grid level is greater than 0 (zero) but the grid size specified for the second grid level is 0 (zero).

The function ST_GetIndexParms can be used to retrieve the values used for the parameters specified when the index was created.

User response

Drop the grid index and create a new grid index using valid grid sizes only.

msgcode: -3300

sqlstate: 38SI0

GSE3301N Invalid z-order parameter parameter-number.

Explanation

The parameter identified by its position parameter-number for a Z-Order index contains an invalid value. One of the following invalid specifications was made in the CREATE INDEX statement that was used to create the index to which the geometry is to be added:
  • A null value was specified for the parameter.
  • A negative number was specified for a scale factor (this rule applies to parameter numbers 2 and 4 only).

The function ST_GetIndexParms can be used to retrieve the values used for the parameters specified when the index was created.

User response

Drop the spatial z-order index and create a new index using only valid parameters.

msgcode: -3301

sqlstate: 38SI1

GSE3302N No point to be indexed.

Explanation

The geometry to be indexed using a Z-Order index is not a point. The Z-Order index supports only points, and the index entry cannot be generated.

User response

Do not insert a geometry that is not a point into a column that has a Z-Order index defined on it. Either drop the index or do not insert the geometry.

msgcode: -3302

sqlstate: 38SI2

GSE3303N Invalid quad tree parameter parameter-number.

Explanation

An invalid parameter was specified when the quad tree index was created. The parameter is identified by its position grid-size-number.

One of the following invalid specifications was made:
  • A null value was specified for the parameter.
  • A negative number was specified for a scale factor (this rule applies to parameter numbers 3 and 5 only).
  • A value less than 1 (one) was specified for the first parameter.

The function ST_GetIndexParms can be used to retrieve the values used for the parameters specified when the index was created.

User response

Drop the spatial quad tree index and create a new index using only valid parameters.

msgcode: -3303

sqlstate: 38SI3

GSE3400C Unknown error error-code.

Explanation

An internal error with code error-code was encountered when a geometry was processed.

User response

Note the error and contact IBM Software Support.

msgcode: -3400

sqlstate: 38SS0

GSE3402C Insufficient memory.

Explanation

Not enough memory was available for the spatial function or method that you invoked.

User response

Make more memory available to the Db2 process that executes the function or method.

msgcode: -3402

sqlstate: 38SS2

GSE3403N Invalid geometry type.

Explanation

An invalid type of geometry was passed to the function or method that you invoked.

User response

Specify a valid geometry. For more information, refer to the IBM Spatial Support for Db2 for z/OS User's Guide and Reference.

msgcode: -3403

sqlstate: 38SS3

GSE3405N Too many parts specified.

Explanation

The number of parts indicated in the binary or text representation of the geometry is greater than the actual number of parts supplied. Either the number of parts indicated is too high or not all the parts were supplied.

User response

Specify the correct number of parts or supply all parts for the geometry.

msgcode: -3405

sqlstate: 38SS5

GSE3406N Incorrect geometry type.

Explanation

The wrong type of geometry was passed to the function or method that you invoked. For example, a linestring might have been passed to a function or method that takes only polygons as input.

User response

Either pass to the function or method a type of geometry that it can process, or use a function or method that accepts the type of geometry that you want to pass.

msgcode: -3406

sqlstate: 38SS6

GSE3407N Text is too long.

Explanation

The geometry contains too much detail to be converted to its well-known text representation. The well-known text representation exceeds the maximum allowable length (2 gigabytes).

User response

Simplify the geometry - for example, by using the ST_Generalize function - or convert the geometry to its well-known binary representation.

msgcode: -3407

sqlstate: 38SS7

GSE3408N Invalid parameter value.

Explanation

An invalid parameter was encountered.

User response

Refer to the IBM Spatial Support for Db2 for z/OS User's Guide and Reference for the function's correct syntax and retry the operation. If the problem persists, contact IBM Software Support.

msgcode: -3408

sqlstate: 38SS8

GSE3409N Invalid geometry produced.

Explanation

The parameters provided for the function or method have produced an invalid geometry; for example, an invalid shape representation. An invalid geometry is one that violates a geometry property.

User response

Construct the geometry again from a valid representation.

msgcode: -3409

sqlstate: 38SS9

GSE3410N Incompatible geometries.

Explanation

The function or method expected two geometries of a certain type and did not receive them. For example, the ST_AddPoint function expects two geometries, one a representation and the other a point.

User response

Specify geometries that the function or method accepts as valid input. To determine what types of geometries are valid for this function or method, refer to the IBM Spatial Support for Db2 for z/OS User's Guide and Reference.

msgcode: -3410

sqlstate: 38SSA

GSE3411N Invalid geometry.

Explanation

The function or method cannot process the geometry passed to it because one or more properties of the geometry violate the geometry's integrity.

User response

Use the ST_IsValid function to validate the geometry. Construct the geometry again from a correct representation if it is not valid.

msgcode: -3411

sqlstate: 38SSB

GSE3412N Too many points.

Explanation

The construction of a geometry has exceeded the 1-megabyte storage limit; the geometry has too many points.

User response

Construct a geometry that contains fewer points. Or, if possible, remove some points. For performance and storage considerations, include only those points that are needed to render a geometry.

msgcode: -3412

sqlstate: 38SSC

GSE3413N Geometry too small.

Explanation

The geometry returned by the ST_Difference, ST_Intersection, ST_SymDifference, or ST_Union function is too small to be represented accurately in the current spatial reference system.

For example, this can happen if the internal computation constructs a very thin polygon, but the scale factor of the spatial reference system is so low that the geometry would collapse to a linestring if it were to be represented in this spatial reference system. It would lose its property as a polygon.

User response

Use a spatial reference system for the calculation which allows for a higher resolution. The ST_Transform function can be used to convert a geometry from one spatial reference system into another.

msgcode: -3413

sqlstate: 38SSD

GSE3414N Buffer out of bounds.

Explanation

The ST_Buffer function has created a buffer around the provided geometry that is outside the range of the coordinates to which the spatial reference system applies.

Refer to the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS to determine the minimum and maximum absolute values for each of the dimensions. These values must not be exceeded by the calculated buffer.

User response

Either reduce the distance to be used for the buffer calculation, or change the spatial reference system in which the calculation is done. The ST_Transform function can be used to convert geometries from one spatial reference system into another.

msgcode: -3414

sqlstate: 38SSE

GSE3415N Invalid scale factor.

Explanation

A scale factor for any of the four dimensions (X, Y, Z, and M) must be greater than or equal to 1 (one).

User response

Use a correctly defined spatial reference system to represent the geometry.

msgcode: -3415

sqlstate: 38SSF

GSE3416N Coordinate out of bounds.

Explanation

A coordinate cannot be represented in the spatial reference system because, in at least one dimension, it exceeds the possible minimum or maximum absolute value within the system's range of values.

Refer to the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS to determine the minimum and maximum absolute values for each of the dimensions.

User response

Determine whether the coordinate is correct. If it is, determine whether it fits within the extent of the spatial reference system that you are using. For information about this spatial reference system, consult the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view.

msgcode: -3416

sqlstate: 38SSG

GSE3417N Invalid coordsys definition.

Explanation

There are one or more errors in the text representation of the definition of the coordinate system on which the geometry's spatial reference system is based. The representation cannot be converted into a valid projection.

User response

Verify the coordinate system definition of the spatial reference system. Alternatively, construct the geometry in a spatial reference system that is associated with a valid coordinate system. The ST_EqualCoordsys function can be used to verify the coordinate system definition by comparing it with itself.

msgcode: -3417

sqlstate: 38SSH

GSE3418N Projection error.

Explanation

An error occurred during an attempt to project a geometry to another spatial reference system.

User response

Make sure that the geometry is within the legal domain of the projection.

msgcode: -3418

sqlstate: 38SSI

GSE3419N Polygon rings overlap.

Explanation

The rings of a polygon overlap. By definition, the inner and outer rings of a polygon must not overlap. They can intersect only at a tangent, which means the rings can only touch but not cross each other.

User response

Specify the coordinates for the polygon that will not produce overlapping rings. Note that the scale factors of the spatial reference system for the geometry have an influence on the precision.

msgcode: -3419

sqlstate: 38SSJ

GSE3420N Too few points.

Explanation

The error is a result of one of the following:
  • Linestrings must consist of at least two points, and polygons must consist of at least four points.
  • The geometry cannot be constructed from the points that you have specified.

Note that if the geometry to be constructed is empty, these rules do not apply.

User response

Construct the geometry again from a valid set of points.

msgcode: -3420

sqlstate: 38SSK

GSE3421N Polygon is not closed.

Explanation

The inner and outer rings that define the polygon must be closed. A ring is closed if the start and end points are identical in the X and Y dimensions. If the polygon has Z coordinates, then the start and end points must also be identical to the Z coordinates. Note that this rule does not apply to measures, which can be different for the start and end points.

User response

Specify inner and outer rings for the polygon that have the same points for the start and end points in the X and Y dimension. If the polygon has Z coordinates, the start and end points of the Z coordinate points also have to be identical. If the polygon has measures, the start and end points can be different.

msgcode: -3421

sqlstate: 38SSL

GSE3422N Invalid exterior ring.

Explanation

The exterior ring of the polygon is not valid.

The exterior ring of a polygon must enclose all interior rings of the polygon. All interior rings have to be completely inside the area that is defined by the outer ring and must not cross the exterior ring.

User response

Specify a geometry that consists of a valid set of interior and exterior rings, where the interior rings lie fully within the area that is enclosed by the exterior ring to represent it.

If the geometry has multiple polygons, use a multipolygon.

msgcode: -3422

sqlstate: 38SSM

GSE3423N Polygon has no area.

Explanation

The specified polygon lacks an interior that covers an area that is not the empty set in the X and Y dimensions.

A geometry is a polygon only if its coordinates span two dimensions in the 2-dimensional space defined by the X and Y coordinates.

User response

Specify a polygon that encloses an area that is not empty. If the polygon is empty, construct an empty polygon.

msgcode: -3423

sqlstate: 38SSN

GSE3424N Exterior rings overlap.

Explanation

The exterior rings of distinct polygons in a multipolygon overlap. Distinct polygons in a multipolygon must not overlap, and the boundaries must touch only at a finite number of points. That means the polygons must not share line segments.

The scale factors of the spatial reference system that is used to represent the geometry influences the precision that applies to the coordinates. Rounding operations performed when the geometry is converted to the representation in the spatial reference system might cause a loss in precision and, subsequently, this error.

User response

Specify coordinates for the polygon that will not produce overlapping rings.

Note that the scale factors of the spatial reference system have an influence on precision.

Refer to the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS for the scale factor used for the spatial reference system in which the geometry will be represented.

msgcode: -3424

sqlstate: 38SSO

GSE3425N Polygon intersects itself.

Explanation

A ring of a polygon cannot intersect itself. The start and end points on each ring of the polygon must be reached twice when traversing the ring. All other points must only be reached once. This holds true also for the line segments that define the rings of the polygon.

The scale factors of the spatial reference system that is used to represent the geometry influences the precision that applies to the coordinates. Rounding operations performed when the geometry is converted to the representation in the spatial reference system might cause a loss in precision and, subsequently, this error.

User response

Construct a valid polygon in which the rings do not intersect themselves.

Refer to the IBM Spatial Support for Db2 for z/OS catalog view DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS for the scale factor used for the spatial reference system in which the geometry will be represented.

msgcode: -3425

sqlstate: 38SSP

GSE3426N Invalid number of parts.

Explanation

The number of parts indicated in the binary or text representation of the geometry is not equal to the actual number of parts supplied. Either the number is too low or too many parts were supplied to the function or method.

User response

Specify the correct number of parts or supply all parts for the geometry.

msgcode: -3426

sqlstate: 38SSQ

GSE3427N Incompatible SRSs.

Explanation

The two spatial reference systems are not compatible. They cannot be transformed into or compared with one another. The operation cannot be completed successfully.

User response

Specify two compatible spatial reference systems.

msgcode: -3427

sqlstate: 38SSR

GSE3428N BLOB too small.

Explanation

The number of bytes in the specified binary representation of the geometry is too small.

User response

Specify a valid binary representation of the geometry.

msgcode: -3428

sqlstate: 38SSS

GSE3429N Invalid geometry type.

Explanation

An invalid internal geometry type was encountered. The geometry is not valid and will not be processed any further.

User response

Construct the geometry again from a valid binary or text representation.

msgcode: -3429

sqlstate: 38SST

GSE3430N Invalid byte order.

Explanation

The byte order in the binary representation of the geometry has an invalid value. The byte order must be 0 (zero) or 1 (one).

In the well-known binary representation, a byte order of 0 (zero) indicates big endianess, and a byte order of 1 (one) indicates little endianess.

User response

Specify a valid byte order in the binary representation for the geometry.

msgcode: -3430

sqlstate: 38SSU

GSE3431N Empty geometry.

Explanation

An empty geometry was passed to the ST_AsBinary function, even though it is not allowed as input.

User response

Edit the SQL statement that you submitted so that only non-empty geometries will be passed to the ST_AsBinary function. For example, you can use the ST_IsEmpty function in the WHERE clause to exclude empty geometries.

msgcode: -3431

sqlstate: 38SSV

GSE3432N Invalid end point.

Explanation

The specified point is intended to be appended to the curve, but it is not valid.

User response

Specify a valid point to be appended.

msgcode: -3432

sqlstate: 38SSW

GSE3433N Point not found.

Explanation

The specified point is intended to be changed or removed, but it does not exist in the curve.

User response

Specify a point that does exist in the curve.

msgcode: -3433

sqlstate: 38SSX

GSE3600N No index specified.

Explanation

No valid index was specified. The index schema parameter, the index name parameter, or both, are null. The index parameter values cannot be derived.

User response

Specify a valid spatial index to retrieve the parameter information.

msgcode: -3600

sqlstate: 38SQ0

GSE3601N Invalid spatial index name schema-name.index-name.

Explanation

The specified name of the index for which you want parameter information retrieved does not exist or does not identify a spatial index. This name is schema-name.index-name.

User response

Specify an existing spatial index to retrieve the parameter information.

msgcode: -3601

sqlstate: 38SQ1

GSE3602N Invalid parameter number number specified.

Explanation

The parameter number number is not valid for the specified spatial index.

The following limits apply for the different types of spatial indexes:
grid index
Parameter numbers between 1 (one) and 3.
z-order index
Parameter numbers between 1 (one) and 4.
quad-tree index
Parameter numbers between 1 (one) and 5.

User response

Specify a valid parameter number for the spatial index. Consult the Db2 system catalog for the type of the spatial index.

msgcode: -3602

sqlstate: 38SQ2

GSE3603N Invalid column name.

Explanation

The specified column does not exist in the table. At least one of the following - table schema, table name, or column name - is a null value. The index parameter for an index on a column cannot be derived.

User response

Specify an existing column which has a spatial index defined on it.

msgcode: -3603

sqlstate: 38SQ3

GSE4000N Required parameter parameter-name is missing.

Explanation

The required parameter was not found.

User response

Specify the required parameter and try to execute the command again.

msgcode: -4000

sqlstate: 38SB0

GSE4001N An error occurred while IBM Spatial Support for DB2 for z/OS was allocating an environment handle.

Explanation

An environment handle could not be allocated using the Call Level Interface (CLI). The operation cannot be completed successfully.

User response

Verify the CLI configuration. If the source of the problem cannot be found and corrected, contact IBM Software Support.

msgcode: -4001

sqlstate: 38SB1

GSE4002N An error occurred while IBM Spatial Support for DB2 for z/OS was allocating a connection handle. CLI error cli-error and native error code = native-error-code.

Explanation

An unexpected error cli-error with native error code = native-error-code occurred while IBM Spatial Support for Db2 for z/OS was allocating a connection handle.

User response

Look up the detailed error message cli-error. Correct the error and execute the command again. If the problem persists, contact IBM Software Support.

msgcode: -4002

sqlstate: 38SB2

GSE4003N An error occurred while IBM Spatial Support for DB2 for z/OS was connecting to the database. CLI error cli-error and native error code = native-error-code.

Explanation

An unexpected error cli-error with native error code = native-error-code occurred while IBM Spatial Support for Db2 for z/OS was connecting to the database.

User response

Look up the detailed error message cli-error. Correct the error and execute the command again. If the problem persists, contact IBM Software Support.

msgcode: -4003

sqlstate: 38SB3

GSE4004N An error occurred while IBM Spatial Support for DB2 for z/OS was allocating a statement handle. CLI error cli-error and native error code = native-error-code.

Explanation

An unexpected error cli-error with native error code = native-error-code occurred while IBM Spatial Support for Db2 for z/OS was allocating a statement handle.

User response

Look up the detailed error message cli-error. Correct the error and execute the command again. If the problem persists, contact IBM Software Support.

msgcode: -4004

sqlstate: 38SB4

GSE4005N An error occurred while an SQL statement was being prepared. CLI error cli-error and native error code = native-error-code.

Explanation

An unexpected error cli-error with native error code = native-error-code occurred while IBM Spatial Support for Db2 for z/OS was preparing an SQL statement.

User response

Look up the detailed error message cli-error. Correct the error and execute the command again. If the problem persists, contact IBM Software Support.

msgcode: -4005

sqlstate: 38SB5

GSE4006N An error occurred while IBM Spatial Support for DB2 for z/OS was binding parameters to an SQL statement. CLI error cli-error and native error code = native-error-code.

Explanation

An unexpected error cli-error with native error code = native-error-code occurred while IBM Spatial Support for Db2 for z/OS was binding parameters to an SQL statement.

User response

Look up the detailed error message cli-error. Correct the error and execute the command again. If the problem persists, contact IBM Software Support.

msgcode: -4006

sqlstate: 38SB6

GSE4007N An error occurred while IBM Spatial Support for DB2 for z/OS was executing an SQL statement. CLI error cli-error and native error code = native-error-code.

Explanation

An unexpected error cli-error with native error code = native-error-code occurred while IBM Spatial Support for Db2 for z/OS was executing an SQL statement.

User response

Look up the detailed error message cli-error. Correct the error and execute the command again. If the problem persists, contact IBM Software Support.

msgcode: -4007

sqlstate: 38SB7

GSE4008N An error occurred while IBM Spatial Support for DB2 for z/OS was ending a transaction. CLI error cli-error and native error code = native-error-code.

Explanation

An unexpected error cli-error with native error code = native-error-code occurred while IBM Spatial Support for Db2 for z/OS was ending a transaction.

User response

Look up the detailed error message cli-error. Correct the error and execute the command again. If the problem persists, contact IBM Software Support.

msgcode: -4008

sqlstate: 38SB8

GSE4009N The option, option, is invalid.

Explanation

The specified option, option, is invalid.

User response

Specify a valid option and repeat the command.

msgcode: -4009

sqlstate: 38SB9

GSE9990C An internal error occurred: error-text.

Explanation

IBM Spatial Support for Db2 for z/OS encountered an unexpected internal error with the text error-text.

User response

Read the given error-text. If the problem cannot be resolved, contact IBM Software Support.

msgcode: -9990

sqlstate: 38SZY

GSE9999C Internal message failure.

Explanation

An internal failure occurred while IBM Spatial Support for Db2 for z/OS was retrieving an error message.

User response

Contact IBM Software Support.

msgcode: -9999

sqlstate: 38SZZ