3 Replies Latest reply: Dec 11, 2006 9:57 AM by thomas wang RSS

DB-Connect with Informix

Dmitry Stesev
Currently Being Moderated

We need to set up DB-Connect between 2 servers:

1) BW server on DBMS Informix (DBMS Informix and BW are installed on the same host)

2) Transactional data server on DBMS Informix


Databases were created with different locales:

dbs_collate (from table sysdbslocale) is en_US.819 for Informix on BW and ru_RU.915 for transactional data server.


After DB-Connect creation we get an error “Source system <NAME> cannot be accessed.”. In system log we see:


Time       Ty.   Nr Cl.   User            Tcod  MNo Text                                          


12:14:41 DIA  0   100 DSTESEV   RSA1 BY2 Database error -23101 at CON                  

12:14:41 DIA  0   100 DSTESEV   RSA1 BY0 > INF-23101: Unable to load locale categories.


This error doesn’t depend on values of environment variables CLIENT_LOCALE, DB_LOCALE, DBNLS, LC_CTYPE, LANG, LC_COLLATE for user <SID>adm. We restart appl. server after changing variables (stopsap r3; startsap r3).


Does anybody meet such problem? How to solve it?