Re: System Analysis Suggestions

DSPACTPJ SBS(Qusrwrk) PGM(QZdasoinit)

If CPU utilization is bumping up against 100%, you might actually be better off limiting the number of QZDASOINIT jobs so that Web applications and other database clients don't overwhelm a CPU. It would be better to queue requests rather than run too many servers, which overextend a CPU. Use MAXJOBS parameter on CHGPJE command.

Performance monitors tell you which jobs are using which resources, but how do you know if a resource is a bottleneck?

Monitoring database server jobs often don't shed much light because lots of different applications may be using the same QZDASOINIT jobs.

Performance monitors more or less point a finger back at badly performing applications. On the other hand, application developers are admonished against prematurely optimizing their applications.

It seems that either way you end up spending money to add capacity to a server, rewrite or move to better performing applications. There's only so much you can do via configuration options. Take the suggestion to reduce the priority of QZDASOINIT jobs - it may please green-screen users, but anger database server clients.

It appears that a good chuck of Brian's applications are Windows based Web applications - but he's asking what he can do to tune IBM i performance. Why not tune Windows or IIS performance, instead?

-Nathan