Hi experts database adminstrators

Can someone give me the onconfig configuration for Informix 10.

I currently have migrated baan 4 on informix 10. Please help and appreciate it. Also is there anything i should add in db_resource file?

Thanks and regards,

Hi,

Some variables, specific to Infomrix or Oracle can be specified in a resource file, which will be read by the driver. The file is $BSE/lib/defaults/db_resource and contains the following:
<resource_name>:<value>

Informix: db_resource:

inf_init: 0001
dbsinit: 01
lock_retry: 0
infenv_lock_timeout: 5
bdb_max_session_schedule: 3
inf_fetarrsize: 0
ssts_set_rows: 3
cursor_refresh: 1

Note: using lock_retry:”0” and inf_env_locktimeout:5 in db_resource helped for passing a 190 BM users run. CPU 94% Privtime 40% when running 780 database sessions.

Viplov