Dear All,

Currently we are facing problem with our Update Sessions/Programs because it took more than 3 hours to finish its process.

The program reads records from table tdsls045 then update it to a new table tdsls967.

Table tdsls045 has only 1,224,659 records.

We tested the same number of records to our development server and the program only runs for 1 minute and 10 seconds. Our development server uses bisam tables while our production server uses Informix database with the following environment variable set in the db_resource file:

dbsinit:21
lock_retry:5*100,5*500,5*5000
infenv_lock_timeout:60
inf_init:01000
inf_flush_rows:500
optmsg:1
inf_fetarrsize:1
inf_hold_cursor:1


Was the above set-up especially LOCK_RETRY environment variable has a major effect of the mentioned problem?

We will appreciate your immediate feedback on this matter.

thank you very much,

juls