GSE4000-4999
| GSE Message ID | Message | Explanation | User Response |
|---|---|---|---|
|
GSE4000N |
Required parameter parameter-name is missing. |
The required parameter was not found. |
Specify the required parameter and try to execute the command again. msgcode: -4000 sqlstate: 38SB0 |
|
GSE4001N |
An error occurred while the spatial operation was allocating an environment handle. |
An environment handle could not be allocated using the Call Level Interface (CLI). The operation cannot be completed successfully. |
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 the spatial operation was allocating a connection handle. CLI error cli-error and native error code = native-error-code. |
An unexpected error cli-error with native error code = native-error-code occurred while the spatial operation was allocating a connection handle. |
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 the spatial operation was connecting to the database. CLI error cli-error and native error code = native-error-code. |
An unexpected error cli-error with native error code = native-error-code occurred while the spatial operation was connecting to the database. |
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 the spatial operation was allocating a statement handle. CLI error cli-error and native error code = native-error-code. |
An unexpected error cli-error with native error code = native-error-code occurred while the spatial operation was allocating a statement handle. |
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. |
An unexpected error cli-error with native error code = native-error-code occurred while the spatial operation was preparing an SQL statement. |
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 the spatial operation was binding parameters to an SQL statement. CLI error cli-error and native error code = native-error-code. |
An unexpected error cli-error with native error code = native-error-code occurred while the spatial operation was binding parameters to an SQL statement. |
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 the spatial operation was executing an SQL statement. CLI error cli-error and native error code = native-error-code. |
An unexpected error cli-error with native error code = native-error-code occurred while the spatial operation was executing an SQL statement. |
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 the spatial operation was ending a transaction. CLI error cli-error and native error code = native-error-code. |
An unexpected error cli-error with native error code = native-error-code occurred while the spatial operation was ending a transaction. |
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. |
The specified option, option, is invalid. |
Specify a valid option and repeat the command. msgcode: -4009 sqlstate: 38SB9 |
|
GSE4100N |
Column schema-name.table-name.column-name does not exist. |
The specified column schema-name.table-name.column-name does not exist. |
Specify an existing column in an existing table and execute the command again. msgcode: -4100 sqlstate: 38SC0 |
|
GSE4101N |
Column schema-name.table-name.column-name does not have a spatial data type. |
The specified column schema-name.table-name.column-name does not have a spatial type. A spatial type is ST_Geometry or one of its proper subtypes. |
Specify a column with a spatial data type and execute the command again. msgcode: -4101 sqlstate: 38SC1 |
|
GSE4102N |
Spatial grid index schema-name.index-name does not exist. |
The specified spatial grid index schema-name.index-name does not exist. |
Specify a spatial grid index which does exist and execute the command again. msgcode: -4102 sqlstate: 38SC2 |
|
GSE4103N |
An internal error occurred while the spatial operation was retrieving index information for column schema-name.table-name.column-name. |
The spatial operation encountered an unexpected internal error while retrieving information about the spatial index on the column schema-name.table-name.table-name. |
Contact IBM Software Support. msgcode: -4103 sqlstate: 38SC3 |
|
GSE4104N |
The spatial operation could not retrieve grid sizes for spatial grid index schema-name.index-name. |
The spatial operation encountered an unexpected internal error while retrieving the grid size definition for the grid index schema-name.index-name. |
Contact IBM Software Support. msgcode: -4104 sqlstate: 38SC4 |
|
GSE4105W |
No rows to analyze in column schema-name.table-name.column-name. |
The column schema-name.table-name.table-name does not contain any values that the spatial operation could analyze. If sampling was used, the sample rate might have been too low. |
Execute the command on a column that contains geometries. If sampling is used, use a higher sampling rate. msgcode: +4105 sqlstate: 38SC5 |
|
GSE4106W |
The spatial operation could not get enough memory to retrieve MBR histogram for number entries. |
The histogram size of the minimum boundary rectangles for all the geometries in the spatial column is too big. Not enough memory to store it could be allocated. The command cannot be executed successfully. |
Do not specify the SHOW DETAIL option for the command or reduce the number of geometries to be analyzed by sampling them with a lower sample rate. msgcode: +4106 sqlstate: 38SC6 |
|
GSE4107N |
Grid size value grid-size is not valid where it is used. |
The specified grid size grid-size is not valid. One of the following invalid specifications was made when the grid index was created with the CREATE INDEX statement:
|
Specify a valid value for the grid size. msgcode: -4107 sqlstate: 38SC7 |
|
GSE4108W |
Geometries in column schema-name.table-name.column-name do not cover extent. |
All geometries in the column schema-name.table-name.column-name do not span an extent greater than 0 (zero). That means that only identical points exist in the column. The index information cannot be gathered. |
Insert additional rows into the spatial column. msgcode: +4108 sqlstate: 38SC8 |
|
GSE4109N |
An invalid query box of size query-box-size was specified. |
The specified query box size query-box-size is not valid. A query box must be greater than 0 (zero) and less than or equal to 1 (one). The query box size indicates the percentage of the extent for the data in the column that is usually retrieved. |
Correct the query box size by choosing a value greater than 0 (zero) and less than or equal to 1 (one). msgcode: -4109 sqlstate: 38SC9 |
|
GSE4110N |
An invalid number of rows num-rows to analyze was specified. |
The specified number of rows to be analyzed (num-rows) is invalid. The number must be greater than 0 (zero). |
Specify a valid number of rows greater than 0 (zero) and execute the command again. msgcode: -4110 sqlstate: 38SCA |
|
GSE4111N |
An invalid percentage percentage was specified. |
The specified percentage percentage of rows to be analyzed is not valid. The percentage must be an integer that is greater than 0 (zero) and less than or equal to 100. |
Specify a valid percentage greater than 0 (zero) and less than or equal to 100 and retry the command. msgcode: -4111 sqlstate: 38SCB |
|
GSE4112W |
No samples for the table schema-name.table-name.column-name at percent percent could be produced. |
The spatial operation tried to sample percent percent of table schema-name.table-name.column-name, but could not produce any sample rows that could be analyzed any further. |
If the table is not empty, choose a higher sampling rate and retry the command. msgcode: +4112 sqlstate: 38SCC |
|
GSE4113N |
No tablespace for a declared global temporary table for the sampled data exists. |
A USER TEMPORARY tablespace with a page size of at least 4096 bytes must exist to declare a global temporary table that is needed to sample the data that is to be analyzed by the spatial operation. A global temporary table is needed so that the spatial operation can sample the data that it is going to analyze. A USER TEMPORARY tablespace with a page size of at least 4096 bytes is required for declaring this table. |
Either create an appropriate USER TEMPORARY tablespace and retry the command, or do not use the ANALYZE clause to avoid sampling the spatial data. msgcode: -4113 sqlstate: 38SCD |
|
GSE4200N |
Parameter value of data type type is not expected in that context. |
The parameter value value of type type is not expected in the context of the command. |
Correct the command to be executed and then try the operation again. msgcode: -4200 sqlstate: 38SD0 |
|
GSE4201N |
No command was specified. |
No command to be executed was specified. |
Specify a command. msgcode: -4201 sqlstate: 38SD1 |
|
GSE4202N |
Parsing of command failed. |
The given command syntax could not be parsed successfully. |
Correct the syntax and execute the command again. msgcode: -4202 sqlstate: 38SD2 |
|
GSE4203N |
Unexpected end-of-statement found following token token. |
An unexpected end of the statement was found after parsing token token. |
Correct the syntax and execute the command again. msgcode: -4203 sqlstate: 38SD3 |
|
GSE4204N |
Parsing failed near token token. |
An unexpected parse error occurred near token token. |
Correct the syntax and execute the command again. msgcode: -4204 sqlstate: 38SD4 |
|
GSE4205N |
The spatial operation found more than one type clause. |
While the spatial operation parsed the command, it found more than one clause of data type type. |
Specify only one clause of type and execute the command again. msgcode: -4205 sqlstate: 38SD5 |