RE: ECM Performance

["Mark Curtis" <mark.curtis@xxxxxxxxxxxx>]

And if you are on Unix / Informix ?

Has anyone got any better ideas than mine :-

1. Find a slow job (should not be to hard)
2. Sit and monitor via     onstat -g sql ???
3. If one statement hangs around check it via Query Tools in onperf. / set
explain on
4. Add any indexes you feel are missing and try again.

There has to be a better way !!!

Mark Curtis

-----Original Message-----
From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On
Behalf Of Clare.Holtham@ssa.co.uk
Sent: 08 July 1999 11:46
To: BPCS-L@midrange.com
Subject: Re: ECM Performance


Use the Database Monitor to monitor BPCS jobs then use Query to select
records in the resulting file (QAPMDBMON if you do it via Performance
Tools) where QQIDXA = 'Y' and create the indexes advised with the key
fields advised.
Clare


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---