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 |
---|---|---|---|---|---|
-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. |
-1009182L | Error | 20236 | QSB78 | "DBFile name %2 is already in use. %1" | logical filenames must be unique for dbfiles Click here for a list of possible parameters and odbc states. |
-1009183L | Error | 20237 | QSB79 | "A readwrite dbspace may not be placed offline. %1" | A dbspace must be readonly before it can be placed offline Click here for a list of possible parameters and odbc states. |
-1009184L | Error | 21190 | QSB80 | "Operation not permitted on a READONLY DBSpace. %1" | No additional information available.. Click here for a list of possible parameters and odbc states. |
-1009185L | Error | 21191 | QSB81 | "An IO error was encountered while writing a database page in %2 DBSpace. %1. File is readonly." | No additional information available.. Click here for a list of possible parameters and odbc states. |
-1009186L | Error | 21200 | QSB82 | "Global Request for freelist failed. %1" | Global reqest for freelist failed. Click here for a list of possible parameters and odbc states. |
-1009187L | Error | 21205 | QSB83 | "Textindex External Error: Error Code: %2: Error Message: %3. %1" | Error from external prefilter or term breaker library. Click here for a list of possible parameters and odbc states. |
-1009188L | Error | 22019 | QDD1A | "Create shared temporary dbspace not allowed. %1" | Additional dbspaces may not be created in shared temp store. Shared Temp space may only be added to IQ_SHARED_TEMP. Click here for a list of possible parameters and odbc states. |
-1009189L | Error | 21210 | QSB84 | "Text document exceeds maximum number of terms. Support up to 4294967295 terms per document. %1" | Error from external prefilter or term breaker library. Click here for a list of possible parameters and odbc states. |
-1009190L | Error | 21211 | QSB85 | "Incorrect %3 Index Version (%2): Index must be dropped and recreated. %1" | Error from text index. Click here for a list of possible parameters and odbc states. |
-1009191L | Error | 22025 | QSB86 | "The FORCE READWRITE clause is not allowed on this dbspace. It can be specified for the dbspace IQ_SHARED_TEMP only. %1" | The FORCE READWRITE clause can be used with IQ_SHARED_TEMP only. Click here for a list of possible parameters and odbc states. |
-1009192L | Error | 22026 | QSB87 | "File may not be accessible from one or more multiplex servers. Use sp_iqmpxfilestatus for further diagnosis. %1" | The file must be accessible from all multiplex servers (except those that are excluded) before its mode can be changed to READWRITE. The global file status maintained at the coordinator indicates that file may not be accessible from one or more multiplex servers. Use sp_iqmpxfilestatus for further diagnosis. Click here for a list of possible parameters and odbc states. |
-1009193L | Error | 22027 | QSB88 | "Insufficient space to accommodate Freelist blocks. Please use a file with at least %2 MB space and turn that file READWRITE. %1" | There is no READWRITE file in IQ_SHARED_TEMP dbspace at this point in time. While trying to turn the first file READWRITE, the file needs to have enough space to accommodate freelist blocks for all the existing files. Click here for a list of possible parameters and odbc states. |
-1009194L | Error | 22028 | QSB89 | "Please drop the rest of the files in this dbspace before trying to drop this file. \nThis was the first file to be made READWRITE and can only be dropped if it is the last remaining file. %1" | This was the first file to be made READWRITE in IQ_SHARED_TEMP dbspace This file should be the last file in IQ_SHARED_TEMP to be dropped. Please drop rest of the files before trying to drop this file. Click here for a list of possible parameters and odbc states. |
-1009412L | Error | 21050 | QCB10 | "The INSERT ... LOCATION statement must use a SELECT statement. %1" | The INSERT ... LOCATION statement must use a SELECT statement. No other SQL statement is supported here. Click here for a list of possible parameters and odbc states. |
-1009413L | Error | 21051 | QCB11 | "Secondary server cannot maintain catalog sync. %1" | An error has occurred while applying catalog updates from the coordinator. The secondary server must be restarted or synchronized. Click here for a list of possible parameters and odbc states. |