Informix - Problem description
Problem IT45676 | Status: Closed |
A DBSCHEMA OR DBEXPORT WILL HANG IF THE THE DATABASE IS CREATED WITH 8859-2 CODE SET AND CLIENT_LOCALE IS SET TO UTF8. | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
A dbschema or dbexport will hang if the database is created with 8859-2 code set (e.g. hr_HR.8859-2) and CLIENT_LOCALE is set to utf (e.g. hr_HR.utf8). The dbschema/dbexport session will be stuck in "cond wait netnorm" with the last parsed SQL as: Last parsed SQL statement : select extentsize, flags, sbspace from informix.syscolattribs where tabid = ? and colno = ? The dbschema/dbexport command does not hang if CLIENT_LOCALE is set to 8859-2 too. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC11. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.03.2024 12.06.2024 12.06.2024 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |