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 |
|---|---|---|---|---|---|
| -1013101L | Error | 21021 | QCB01 | "You do not have permission to drop this join index. %1" | You do not have permission to drop this join index. Click here for a list of possible parameters and odbc states. |
| -1013102L | Error | 21022 | QCB02 | "User name '%2' does not exist. %1" | The specified user does not exist. Click here for a list of possible parameters and odbc states. |
| 1013103L | Warning | 21026 | QCB03 | "JI MATCH E=%1;S=%2;TID=%3;NRows=%4;JID=%5;NTab=%6;Miss=%7;Data=%8" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays the scoring given to each table/join index matched. Click here for a list of possible parameters and odbc states. |
| -1013103L | Error | 22001 | QCC00 | "%2 not implemented %1" | This feature has not been implemented Click here for a list of possible parameters and odbc states. |
| 1013104L | Warning | 21027 | QCB04 | "JI NOMATCH - Entry=%1, Table=%2, Join=%3" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join has not been selected. Click here for a list of possible parameters and odbc states. |
| -1013104L | Error | 22012 | QDD13 | "This operation is not allowed on the dbspace IQ_SYSTEM_TEMP. %1" | Illegal op for iq_system_temp Click here for a list of possible parameters and odbc states. |
| 1013105L | Warning | 21028 | QCB05 | "JI MATCH COMPARING - E=%1, MP=%2, JID=%3, Name=%4" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join is being compared to the others. Click here for a list of possible parameters and odbc states. |
| -1013105L | Error | 22013 | QDD14 | "Use ALTER DBSPACE ALTER FILE for this operation. %1" | Must use alter dbspace alter file Click here for a list of possible parameters and odbc states. |
| -1013106L | Error | 22004 | QDC59 | "logical file %2 not part of dbspace %3. %1" | this logical filename is not part of this dbspace Click here for a list of possible parameters and odbc states. |
| 1013106L | Warning | 21029 | QCB06 | "JI MATCH SELECTED - MP=%1, JID=%2, Name=%3" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join has been selected. Click here for a list of possible parameters and odbc states. |
| 1013107L | Warning | 21030 | QCB07 | "JI MATCH EXACT - This join exactly matches the requested tree" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join completely replaces the requested tree. Click here for a list of possible parameters and odbc states. |
| -1013107L | Error | 22008 | QDD09 | "MPX: server %2 is not part of the Multiplex configuration. %1" | This is a multiplex and this server is not part of it. Click here for a list of possible parameters and odbc states. |
| 1013108L | Warning | 21031 | QCB08 | "JI MATCH - Building Match List for Table ID=%1, Name=%2" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this table will be queried for joins that it participates. Click here for a list of possible parameters and odbc states. |
| -1013108L | Error | 22009 | QDD10 | "MPX: startup failure message: server '%2' was started on an incorrect host '%3': this server was created with this connection string '%4'. %1" | This server cannot be started on this host Click here for a list of possible parameters and odbc states. |
| 1013109L | Warning | 21032 | QCB09 | "JI MATCH - Join Index ID=%1, Name=%2, TopTableID=%3" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join will attempt to be matched during the match-up process. Click here for a list of possible parameters and odbc states. |
| -1013109L | Error | 22010 | QDD11 | "MPX: coordinator has been started with an incorrect catalog. %1" | The coordinator has been started with an incorrect catalog Click here for a list of possible parameters and odbc states. |
| 1013110L | Warning | 21033 | QSB35 | "IQ had insufficient memory to create the buffer cache with the size specified with the Main_Cache_Memory_MB or Temp_Cache_Memory_MB options. Instead, the cache will be created using the default size." | If we catch an OUTOFMEMORY exception when creating the MAIN or the TEMP buffer cache, we report this warning of our failure and retry to create the cache with the default settings (and NOT the settings in the hos_paramset). This will allow the DBA to re-open a database even if the Main_Cache_Memory_MB or Temp_Cache_Memory_MB options are set so high as to otherwise prevent the re-opening of the database. (QTS 183253.) Click here for a list of possible parameters and odbc states. |
| -1013110L | Error | 22011 | QDD12 | "MPX: server %2 has been started with an incorrect catalog path (expected path: %3). %1" | The coordinator has been started with the incorrect catalog Click here for a list of possible parameters and odbc states. |
| -1013111L | Error | 22014 | QDD15 | "MPX: This operation is not supported on a MPX secondary node. %1" | Not supported on a mpx secondary node Click here for a list of possible parameters and odbc states. |
| -1013112L | Error | 22015 | QDD116 | "MPX: Striping parameters for IQ_SYSTEM_TEMP are global and may only be altered on the coordinator node. %1" | Change striping for IQ_SYSTEM_TEMP on coordinator only. Click here for a list of possible parameters and odbc states. |