Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1009162L | Error | 20200 | QSB58 | "Insufficient space to relocate structures on %2. %1" | Database structures may need to be relocated in order to drop a segment or make it readonly. This space must be available on other segments. Click here for a list of possible parameters and odbc states. |
| -1009163L | Error | 20201 | QSB59 | "Segment %2 cannot be smaller than %3 blocks. %1" | Database structures may need to be relocated in order to drop a segment or make it readonly. This space must be available on other segments. Click here for a list of possible parameters and odbc states. |
| -1009164L | Error | 20202 | QSB60 | "You cannot drop the last dbspace. %1" | You can drop the last dbspace only if it is a temp dbspace Click here for a list of possible parameters and odbc states. |
| -1009165L | Error | 20203 | QSB61 | "Cannot perform requested command as the SYSIQFILE table is locked by another transaction. %1" | A CREATE DBSPACE, ALTER DPSACE or DROP DBSPACE command was issued when there was another command or stored procedure accessing the system table SYSIQFILE. Click here for a list of possible parameters and odbc states. |
| -1009166L | Error | 20204 | QSB62 | "%3 %4 is in use by dropped dbspace %2 on a secondary server. The drop dbspace command has not yet propagated through the multiplex. %1" | Fields for dropped dbspaces cannot be re-used until the drop dbspace commands have propagated through the multiplex Click here for a list of possible parameters and odbc states. |
| -1009167L | Error | 20207 | QSB63 | "dbspace %2 failed to open since it's definition conflicts with dbspace %3. Secondary server may need to be synchronized. %1" | The server has an invalid dbspace configuration. New dbspaces may fail to open or the server may fail to start until this is corrected. Click here for a list of possible parameters and odbc states. |
| -1009168L | Error | 20208 | QSB64 | "The WORD SKIP limit (%2) has been exceeded. %1" | The number of words encountered that are longer than the limit specified when the word index was create has been exceeded for the load. The load will rollback. Click here for a list of possible parameters and odbc states. |
| -1009169L | Error | 20222 | QSB65 | "Cannot write to RO DBSpace %2. %1" | No additional information available.. Click here for a list of possible parameters and odbc states. |
| -1009170L | Error | 20223 | QSB66 | "You have run out of space in %2 DBSpace. %1" | No additional information available.. Click here for a list of possible parameters and odbc states. |
| -1009171L | Error | 20224 | QSB67 | "An IO error was encountered while writing a database page in %2 DBSpace. %1" | No additional information available.. Click here for a list of possible parameters and odbc states. |
| -1009172L | Error | 20226 | QSB68 | "%2 is in use by another sp_iqemptyfile or ALTER DBSPACE command. %1" | sp_iqemptyfile or ALTER DBSPACE commands disallow status change for the FILE(s) or DBSPACE. No other ALTER DBSPACE or sp_iqemptyfile command can run on those FILE(s) or DBSPACE. Click here for a list of possible parameters and odbc states. |
| -1009173L | Error | 20227 | QSB69 | "Operation not permitted on an OFFLINE DBSpace %2. %1" | No additional information available.. Click here for a list of possible parameters and odbc states. |
| -1009174L | Error | 20228 | QSB70 | "Operation not yet supported. Sort metadata sources have incompatible record descriptors. %1" | No additional information available.. Click here for a list of possible parameters and odbc states. |
| -1009175L | Error | 20229 | QSB71 | "Database segment '%2' is not valid. Reserve Blocks found in the header: %3 Reserve Blocks expected: %4. This segment cannot be used. %1" | The start block of the disk segment that was found in the disk segment header is not the same as what was expected. The disk segment cannot be used. You will need to restore your database from backup. Click here for a list of possible parameters and odbc states. |
| -1009176L | Error | 20230 | QSB72 | "Create temporary dbspace not allowed. %1" | Additional dbspaces may not be created in temp store. Temp space may only be added to IQ_SYSTEM_TEMP. Click here for a list of possible parameters and odbc states. |
| -1009177L | Error | 20231 | QSB73 | "%2 is already %3. %1" | The dbspace being altered already had the requested attributes Click here for a list of possible parameters and odbc states. |
| -1009178L | Error | 20232 | QSB74 | "Operation not allowed on dbspaces that contain multiple files. %1" | The specified operation cannot be applied to a file the contains multiple files Click here for a list of possible parameters and odbc states. |
| -1009179L | Error | 20233 | QSB75 | "The last file in a dbspace may only be removed by DROP DBSPACE. %1" | A dbspace must contain at least one file. The last file can only be removed by dropping the dbspace that contains it. Click here for a list of possible parameters and odbc states. |
| -1009180L | Error | 20234 | QSB76 | "%2 is not allowed on system dbspace %3. %1" | The requested DDL operation is not allowed on system dbspaces Click here for a list of possible parameters and odbc states. |
| -1009181L | Error | 20235 | QSB77 | "Multiple FILE clauses are not allowed for this command. %1" | Some alter dbspace commands do not allow multiple files to be specified Click here for a list of possible parameters and odbc states. |