Issues with IDS11 migration
Can someone tell me how does this LANG parameter behaves and what is the
impact?
For example :
LANG=C versus LANG=en_US
After migrating to IDS11.FC6.W2 from 7.31.UD8 on AIX 5.3 and CSDK.3.5 on
the windows desktop in one server the users are receiving the following
error code -23197 and they cannot connect to the database.
-23197
Database locale information mismatch.
The locale information GL_CTYPE or GL_COLLATE in the system catalog of the
specified database does not match the locale information in the specified
environment variable DB_LOCALE. Check the value of DB_LOCALE
Those two are set to en_US.CP1252 but on the database server query of
systables show
"select tabname, site from systables where tabname like ' GL%';
tabname GL_COLLATE
site en_US.819
tabname GL_CTYPE
site en_US.819
Changing the value of CLIENT_LOCALE = EN_US.8859-1 of my laptop works but
not taking a chance that late in the ball game to make this change in all
the desktops without further testing so I revert back to IDS7.
Interestingly, we compared all servers where users are able to connect
versus the one that is not working and we found one discrepancy.
Server where it does not work!
$ locale
LANG=C
LC_COLLATE="C"
LC_CTYPE="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_MESSAGES="C"
LC_ALL=
Sever where it works
$ locale
LANG=en_US
LC_COLLATE="en_US"
LC_CTYPE="en_US"
LC_MONETARY="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_MESSAGES="en_US"
LC_ALL=
By the way both settings work in 7.31.UD8. Is LANG set to C on the OS the
reason why people can't connect to that one server. Informix install was
most likely done with that same setting of LANG on that server, what is the
impact.
By reviewing the installshield wizard of IDS11, it is said that
If using a locale/language other than the default
Set $CLIENT_LOCALE
Set $DB_LOCALE
Set $SERVER_LOCALE
Set $DBLANG
Note: testing connection with ODBC driver via MS Excel Spreadsheet works
fine with both settings.
Any insights would be greatly appreciated!
Thanks in advance!
jp