RE: ECM Performance UNIX/Informix

["George Sagen" <gsagen@xxxxxxxxxxxxxxxxxxx>]

Mark,

The XWindows version of DBCockpit offered the same data as the onstat
commands but with better drill down capability. There are 3rd party tools
that intercept and monitor your SQL calls, analyze them, then make
recommendations, though I can't recall their names. Perhaps your Informix
dealer can help.

Geo.

George Sagen
BPCS Application Consultant
gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
http://www.primesourcetech.com
PrimeSource Technologies
7373 East Doubletree Ranch Road
Suite 150
Scottsdale, AZ 85258
(801)360-6360 Direct & VM
 


.  -----Original Message-----
.  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of Mark
.  Curtis
.  Sent: Thursday, July 08, 1999 5:38 AM
.  To: BPCS-L@midrange.com
.  Subject: RE: ECM Performance
.
.
.  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 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
+---