• Subject: RE: ECM Performance
  • From: "Mark Curtis" <mark.curtis@xxxxxxxxxxxx>
  • Date: Thu, 8 Jul 1999 13:38:19 +0100
  • Importance: Normal

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
+---


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].