Bottom line: We can't get Enterprise on a Multi-cpu system to perform
better than Workgroup on a single CPU...

Here is the Hardware configuration:
Brand new IBM AIX eServer p5 550 with 4 CPUs, 8GB ram and a RAID 10
disk system. (To test with single CPU, we dealocate 3 CPUs and remove
them from configuration. Works perfectly to simulate single CPU.)

The benchmark:
When we submit the tests programs on the database (shared-memory, not
remote clients), the system basically stays IDLE... The disk won't go
over 35% busy, while TOTAL CPU usage will stay around 25-30 % busy
(looks like only 1 cpu running at any given time?). Only when APW&BIW
do something will the system be like 60% busy... But most of the time,
it's idling at 60-70%!!!

BTW, each test program updates DIFFERENT tables on the database; so
record locking is not the problem.

We can undestand that Workgroup should use only one processor, but what
about Enterprise? We played with all parameters found in documentation
(-B -spin -semsets, you name it! etc.). Actually, -spin will make
things worst if we set a too low value. But NEVER have we seen any
benefits of Entreprise with 4cpu over Workgroup with 1cpu.

Nothing will make full use of available hardware ressources. WHY?

Any help?? PLEASE!

Thanks.