Unix Technical Forum

Re: Maxconnect

This is a discussion on Re: Maxconnect within the Informix forums, part of the Database Server Software category; --> Hi, I think your problem is the setting of $INFORMIXDIR environment variable. I assume the environment setting you provided ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 12:06 PM
Martin Fuerderer
 
Posts: n/a
Default Re: Maxconnect

Hi,

I think your problem is the setting of
$INFORMIXDIR environment variable.
I assume the environment setting you provided
below is the environment for the client
(and possibly MaxConnect)?

/informix/imc is the proper setting for the
Maxconnect deamon. But in your environment this
is not where the client runtime is installed,
therefore it will not find the GLS things in
there (and hence the error about locales).

So you need two environments, one for the
Maxconnect deamon only, and a different one
for the client application.

And while we are at it, I would keep things completely
separate (as you may have the case where even the
clients and Maxconnect will be on different machine
(i.e. a 3-tier environment). Therefore I would move
the clients' sqlhosts file to the clients $INFORMIXDIR
(/opt/informix) and set the clients' $INFORMIXSQLHOSTS
accordingly. You still need the existing sqlhosts file
in /informix/imc for Maxconnect itself.


Environment Setting for IMC deamon:

INFORMIXDIR where IMC is installed
IMCCONFIG IMC config file
INFORMIXSQLHOSTS IMC sqlhosts file
IMCSERVER IMC listener
INFORMIXSERVER IDS's imc listener
IMCADMIN IMC Admin listener



Example:

----------------------------------------------------
a) Existing config:

IDS onconfig file:
DBSERVERNAME ids
DBSERVERALIASES ids_soc

IDS sqlhosts file:
ids onipcshm ids_host ids_port
ids_soc onsoctcp ids_host ids_soc_port

Remote client's sqlhosts file:
ids_soc onsoctcp ids_host ids_soc_port
----------------------------------------------------
b) New configuration for IMC:

IMC sqlhosts file:
ids_soc onsocimc ids_host ids_soc_port
imc onsoctcp imc_host imc_port
imc_admin onsoctcp imc_host imc_adm_port

=> IMC environment:
IMCSERVER imc
INFORMIXSERVER ids_soc
IMCADMIN imc_adm
----------------------------------------------------
c) New configuration for IDS:

IDS onconfig file:
[ NETTYPE socims,...,...,... ] # change if present

IDS sqlhosts file:
ids onipcshm ids_host ids_port
ids_soc onsocimc ids_host ids_soc_port

Remote Client's sqlhosts file:
ids_soc onsoctcp imc_host imc_port
----------------------------------------------------

I'll send directly to you a picture that better explains
the above example at a simple glance.
(Really a case of "a picture says more than 1000 words" here!)

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

informix-list-bounces@iiug.org wrote on 11.05.2006 11:39:51:
>
> I need some advice on configuring a client to use maxconnect.
>
> H/W Sun
> O/S Linux
>
> CSDK 2.81.UC3
> Maxconnect 1.00.UC1
>
> Maxconnect is in it's own directory:- /informix/imc
> CSDK is installed in:- /opt/informix
> INFORMIXDIR is set to /informix/imc
> LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql
> INFORMIXSQLHOSTS=/informix/imc/etc/sqlhosts
> INFORMIXSERVER=imc_client_db
> IMCSERVER=imc_client_tcp
> IMCADMIN=imc_client_adm
> IMCCONFIG=/informix/imc/etc/IMCconfig
>
> When the application is started, we get the error "-23101 Unable to load


> locale categories."
>
> If I set INFORMIXDIR=/opt/informix it works ok, but is not using

Maxconnect.
>
> Will this config work or should I installed them both in the same

directory
> (which order)? The manual is a bit vague in places
>
> Any help appreciated
>
> Regards
>
> Colin
>
> There are 10 types of people in the world, those that understand binary

and
> those that don't
> __________________________________________________ _______________
> Are you using the latest version of MSN Messenger? Download MSN

Messenger
> 7.5 today! http://join.msn.com/messenger/overview
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:28 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com