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 |
|---|---|---|---|---|---|
| -1000305L | Error | 21158 | QDC85 | " Allocation failure. %1" | DBCC allocation failure Click here for a list of possible parameters and odbc states. |
| -1000306L | Error | 21164 | QDC86 | " Different DB space, cannot merge partition %2 into %3. %1" | Cannot merge Partition partition name 1 into Partition partition name2 in different dbspaces Click here for a list of possible parameters and odbc states. |
| -1000307L | Error | 21165 | QDC87 | " No data move is allowed, cannot split partition %2. %1" | Cannot split Partition partition name 1 into Partition partition name2 and Partition name3 as the split requires to move data. Click here for a list of possible parameters and odbc states. |
| -1000308L | Error | 21166 | QDC88 | " Boundary value for the partition %2 cannot be changed. %1" | Cannot change boundary value for split Partition partition name 1 into (partition-decl-1, partition-decl-2). Boundary value for partition-decl-2 must be the same as partition name 1. Click here for a list of possible parameters and odbc states. |
| -1000309L | Error | 21167 | QDC89 | " Not all partitions in each column are in same dbspace, cannot unpartition %2. %1" | Cannot alter partitioned table to an unpartitioned table as not all partitions in each column are in the same dbspace. Click here for a list of possible parameters and odbc states. |
| -1000310L | Error | 21168 | QDC90 | " Cannot truncate table partition on a non-partitioned table %2. %1" | Cannot truncate table partition on a non-partitioned table. Click here for a list of possible parameters and odbc states. |
| -1000311L | Error | 21169 | QDC91 | " '%2' is not an IQ DBSPACE. %1" | Specified dbspace does not exist or is a catalog dbspace. Click here for a list of possible parameters and odbc states. |
| -1000312L | Error | 21170 | QDC92 | " ALTER INDEX MOVE can not move FP indexes. Command failed for %2. Use ALTER TABLE MOVE COLUMN instead. %1" | ALTER INDEX MOVE command does not move FP indexes. Use ALTER TABLE MOVE COLUMN instead. Click here for a list of possible parameters and odbc states. |
| -1000313L | Error | 21171 | QDC93 | " ALTER INDEX MOVE not allowed on components of a join index. Command failed for %2. %1" | ALTER INDEX MOVE command does not move link indexes. Click here for a list of possible parameters and odbc states. |
| -1000314L | Error | 21173 | QDC94 | " All rows must be in the first partition. %1" | Cannot alter unpartitioned table to a partitioned table as not all rows in the first partition. Click here for a list of possible parameters and odbc states. |
| -1000315L | Error | 21174 | QDC95 | " Cannot drop the last partition of a partitioned table. %1" | Cannot drop the last partition of a partitioned table. Click here for a list of possible parameters and odbc states. |
| -1000316L | Error | 21175 | QDC96 | "The NoExec option is set. The current operation will be rolled back. %1" | Certain operations will not be allowed whenever the NoExec option is set. They are: Alter table Split Partition & Alter Table Partition Click here for a list of possible parameters and odbc states. |
| -1000317L | Error | 21181 | QDC97 | "The current operation is not allowed on RO partition. %1" | Alter table drop/split/merge on a RO partition is not allowed. Click here for a list of possible parameters and odbc states. |
| -1000318L | Error | 21182 | QDC98 | "Unexpected type encountered for column '%2'. %1" | Parse tree contains an expected column type. Click here for a list of possible parameters and odbc states. |
| -1000319L | Error | 21185 | QDC99 | "Server (%2) is no longer a Multiplex coordinator. %1" | Specified server is no longer a Multiplex coordinator. Click here for a list of possible parameters and odbc states. |
| -1000320L | Error | 21189 | QDD00 | "Table with table id %2 no longer exists. %1" | There is no table with the given table id. It would have been dropped. Click here for a list of possible parameters and odbc states. |
| -1000321L | Error | 22006 | QDB85 | "dropleaks is not allowed in multiplex mode. %1" | Dropleaks require server to be started in simplex configuration Click here for a list of possible parameters and odbc states. |
| -1000322L | Error | 22007 | QDB86 | "Use CREATE DBSPACE USING FILE syntax for creating IQ dbspaces. %1" | In Atomic IQ dbspaces can be created using the FILE Syntax for create dbspace. Old pre-atomic syntax can be used to create catalog store dbspaces only. Click here for a list of possible parameters and odbc states. |
| -1000324L | Error | 21193 | QDD03 | "Maximum secondary node license limit reached. Cannot add new secondary node. %1" | New secondary node cannot be added since the license limit for adding a new secondary node has been reached. Click here for a list of possible parameters and odbc states. |
| -1000325L | Error | 21194 | QDD04 | "%2 node cannot be made a failover node. %1" | An excluded or coordinator node cannot be made a failover node. Click here for a list of possible parameters and odbc states. |