DB-Connect with Informix

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?

  • SAP Employee