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