We have BaaN IVc4 with HP-UX 11.11 and Informix 7.31FC6X5.
There are around 1200 users on the system with around 30% working on DSS system and 70% working on OLTP system.

Following is our db_resource file :

dbsinit:01
lock_retry:0
inf_fetarrsize:0
bdb_max_session_schedule:3
inf_init:0621
rds_full:100
ssts_set_rows:100
inf_connection_pool_length:0
infenv_lock_timeout:30
inf_hold_cursor:1
inf_level1:1
inf_max_cursors:512
inf_session_pool_length:0
pdqpriority:100
optmsg:1

Also,
in the nighttime, we submit batch extraction processes and certain updation processes.

Can anyone suggest me how to manage the db_resource variable for different situations ?

Hi kaukul,

the best advise I can give you is: Do not use db_resource!

OK, this sounds a bit provocative, but you can set all these parameters equally well with UNXI shell variables. Just not, that you need to use upper case for the names. So "dbsinit:01" becomes "export DBSINIT=01".

These you can set centrally, by using the "mybshell" construct. Search for ipc_info and mybshell on this forum, if you do not use it yet. mybshell is basically a wrapper script, which first sets variables and others and then calls the actual bshell. This way you can set variables depending on the logged in user and other conditions.

This approach might sound hacky in the first moment, but it is widely used in the Baan community and I first saw it around 6 years in an implementation done by Baan themselves.

Regards

Markus

Thanks for your response. We do use wrapper scripts through which we envoke the bshell6.1.

But, I am interested in the rough value that we can put for these respective variables. We have recently upgraded our OS and we wanted to take a relook at our db_resource variableas so that we can modify these variable and utilise the resources.

Can you suggest us any changes in values of these variables, if any?

Hi,

Look into Baan Solution 106492 for some info.

Regards