Informix - Problem description
Problem IT12665 | Status: Closed |
"CAN NOT SWITCH TO " IN MESSAGE LOG | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Since version 12.10.xC5 a "LOCK TABLE IN SHARED|EXCLUSIVE MODE;" would be propagated by an HDR primary to its secondary servers and raise the same table lock there (to avoid a potentially large number of row or page locks). The message "Can not switch to " in the secondary servers' message logs means this lock couldn't be raised there because opening the table's database has failed. One possible reason for this is the database is using a DB_LOCALE with a non-default code set. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Informix user trying lock table on secondary server * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.12.2015 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |