Hello All!

We use have Baan IV and Informix 9.21 on AIX 4.3.3 .
We have ~50 concurent user and ~450 informix session.
It`s normally?
One bshell session -> 10 informix sessions?

Best Regards.

Hello Alex,

It's quite normal to have multiple db drivers per bshell. However if this means that you have 10 db drivers per bshell that's quite many.

Normal is up to three but it depends on how many tables/sessions the user have open.

Han

Ensure that you have sqlmux defined in onconfig. This will give performance boost with baan and also decreases amount of unix-files (kernel tuning...)

NETTYPE sqlmux # Configure poll thread(s) for nettype

This will enable multiplexing, but not decrease amount of sessions.
Add also m=1 to sqlhosts:

db_1 onsoctcp servername db_1 m=1

Informix Max-Connect might be a solution to decrease amount of sessions!

I agree with the assessment on the sqlmux settings. Also look at your db_resource file for the bdb_max_sessions parameter. This will effect the number of connections held open by the driver.

I have tested the max connect server and its real value is in three-tier environments where the DB server is CPU bound and there are >500 users on the system. For fifty users this would be an unnecessary cost and complication.

-- Jim