Hi,

We just finished to upgrade our system:
Windows NT 4.0 Enterprise Edition with 2 CPU - > Windows 2000 Advanced Server with 4 CPU.
Total RAM 4 Gb

Informix 7.31 TC6 - > Informix 7.31 TD4

The tests performances are bad comparing to the tests before the upgrading.

Is anyone having any suggestions to make the system run as should be? (ONCONFIG/db_resource).

dbsinit:01
inf_fetarrsize:1
bdb_max_session_schedule:10
inf_init:0421
lock_retry:0
infenv_lock_timeout:15
inf_max_cursors:255

kereni,

In order to determine the cause of performance problems, a system needs to be monitored, the database needs to be monitored, baan needs to be monitored.

You need basic information, like
- consecutive users
- table sizes
- most used sessions
- etc.

As for the database settings, simply start with the recommendations that Baan gives in the documentation that came on your installation cd.

Then finaly, check articles and discussions here that match your situation and hopefully some will apply to you.
Unless you have a very specific problem, I am afraid that nobody will be able to help you because of the many unknown variables.

Good luck on your quest though.

If i'm not mistaken, Informix also has statistics to pump up performance (aka Oracle), have this been run lately for the new configuration?
As mentioned, getting good performance means a lot of monitoring and changes of configurations...

I know this was the case on UNIX, but I am not sure on NT going to the TD4 release of Informix.

Due to a change at 7.31 UC5, we had to recreate some indexes due to an introduced "inconsistency" between versions. I do not know if this applies to NT. The symptom was a gradual slowdown that was fixed by restarting Informix and then after a little while the system would begin slowing down again.

Also, as Victor mentioned you will need to generate statistics after the upgrade.

-- Jim

Kereni,
One change I would make to your onconfig is from
NETTYPE soctcp,1,100,CPU
to
NETTYPE soctcp,3,100,CPU

You have set up your Informix instance to be multi-processor and multi VP's, but you have only one thread handler.
This will defintely cause an issue with performance.

Regards
Nick

Can anyone enlighten me as to the pedigree of the above ?

It has been suggested we use this with Win2000

Frank,
As far as I am aware, the workgroup edition is exactly the same software as Informix 7.31, but is limited to 2 CPU's, this is certainly the case with Solaris. Informix just rely on the fact that even though you may have physically more CPU's in your server, you only have 2 configured to be used with Informix. This is simply achieved by making the necessary changes in your onconfig file.

Nick

Thanks Nick

Are you using the "workgroup edition" ?

See link for current offerings , if of interest

http://www6.boulder.ibm.com/devcon/devcon/docs/ids93wso.htm

Was interested as there is also an IBM DB2 Workgroup Edition
and wondered which was developed first and whether it was a "mix" of Informix and DB2 or DB2 with an Informix label ?

Also interested if anyone using it in anger with Baan ?

Regards

Frank

After monitoring and changing the onconfig, the times are almost the same as the "good" tests (but not good comparing to Win NT).
Can anyone give me suggestions for db_resource parameters?

I do not think your answer will be with db_resource.

It is probably going to be in the version/patch level of Informix, regenerating indices (or some other large-scale database tuning) or an OS SP/patch level.

What does IBM say about the Informix version you are on?

The system was installed on WinNT and Informix 7.23.TC14
The Informix was upgrade to 7.31.TC6 (at this point a performances test was good)
Next the WinNT was upgrade to Win2k. The Informix version works OK but some tools were not working (onstat, ontape etc).
After consulting with Informix they told us to upgrade to 7.31.TD4 that support Win2k. Now the Informix version is working as should be on this environment but the performances are very bad compare to the tests in WinNT.

Thanks,
kereni

I did a check and some other sites have had performance issues with TD4 on W2K. The TC6 version is obviously a different build from TD4.

What Win2000 SP are you on?

I would also suggest posting at dbforums.com or the comp.databases.informix group. A lot of Informix people hang out there that may have hit your problem. I would also push Informix support more for a solution -- what is the latest patch set, Client SDK and SP level for Win 2000. My gut reaction is that you will find the solution here.

-- Jim