Oninit cdi / Archive
Talk to an expert →

CPUs utilization

Posted in 2004

Topics: General Discussion

Wayne — — source: Usenet: comp.databases.informix

Hi, I have the Sun Fire V480 system with 4 CPUs and only 2 CPUs are assigned to Informix DB (because of limitation of using IDS Workgroup ED). I observe that doing off business hour and nobody logon the system. I run a big sql report then run UNIX command "mpstat 2 100" it show that only one CPU assigns to Informix is running full blow. But another second CPU assigns to Informix is sit 99% idle. I wonder why is Informix not able to utilize a 2nd CPU to run one job on both CPUs. I would appreciate any of your input so I can understand better. Thank you --Wayne

↪ replying to Wayne
My Name Is Bruce and I'm A Sock Puppet — — source: Usenet: comp.databases.informix

Wayne wrote: > Hi, > > I have the Sun Fire V480 system with 4 CPUs and only 2 CPUs are > assigned to Informix DB (because of limitation of using IDS Workgroup > ED). I observe that doing off business hour and nobody logon the > system. I run a big sql report then run UNIX command "mpstat 2 100" it > show that only one CPU assigns to Informix is running full blow. But > another second CPU assigns to Informix is sit 99% idle. I wonder why > is Informix not able to utilize a 2nd CPU to run one job on both CPUs. > I would appreciate any of your input so I can understand better. Thank > you Did you enable PDQPRIORITY and / or PSORT? -- Strewth! Stick a sock in it, Sheila!

↪ replying to My Name Is Bruce and I'm A Sock Puppet
rkusenet — — source: Usenet: comp.databases.informix

"My Name Is Bruce and I'm A Sock Puppet" <godzone@downundah.com> wrote in message news:2m2hacFhrgh4U1@uni-berlin.de... > Wayne wrote: > > > Hi, > > > > I have the Sun Fire V480 system with 4 CPUs and only 2 CPUs are > > assigned to Informix DB (because of limitation of using IDS Workgroup > > ED). I observe that doing off business hour and nobody logon the > > system. I run a big sql report then run UNIX command "mpstat 2 100" it > > show that only one CPU assigns to Informix is running full blow. But > > another second CPU assigns to Informix is sit 99% idle. I wonder why > > is Informix not able to utilize a 2nd CPU to run one job on both CPUs. > > I would appreciate any of your input so I can understand better. Thank > > you > > Did you enable PDQPRIORITY and / or PSORT? He mentioned Work Group Edition. PDQ is disallowed in WGE.

Glossary