× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: SQL and File analysis
  • From: Kusman Lim <KUSMAN@xxxxxxxxxxxxx>
  • Date: Wed, 15 Sep 1999 15:48:04 +0700

What Need I do with BPCS Performance if I know the most index use which
not index ?

BPCS 6002plf cum macrh 98

Kusman Lim

-----Original Message-----
From: fkolmann@revlon.com.au [mailto:fkolmann@revlon.com.au]
Sent: Tuesday, September 14, 1999 11:31 AM
To: BPCS-L@midrange.com
Subject: SQL and File analysis


To improve BPCS program performance SSA recommends that we do
a.  Run STRDBMON on jobs to find recommended indexex
b.  Run PRTSQLINF on programs to get a history of SQL statement run by
the program.
There are some utilities that can be purchased to help with the analysis
but again price is an object.
I have cobbled up a small utility to help with PRTSQLINF.
It runs PRTSQLINF over up to 10 libraries and sends the printout to a db
file then it scans the result looking for Arrival seq and created Access
Paths and sends its output to another DB file SQLINFB. I then run a
query over SQLINFB picking up those files with recent dates and long run
times.  There is lot of rubbish in PRTSQLINF, particularly the old stuff
when out PTFs were not up to scratch.  Again no warranties are expressed
and implied , all code is strictly supplied as-is and it is the users
responsibility for any and all consequences of running the programs.
Your downloading of the code is an  acknowledgement that you accept and
abide by these conditions .
+---
| 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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2024 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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.