Re: Batch Billing Performance.

I agree totally.  That's why I would ask that you call me to discuss your
particular environment and performance issues.  I don't just "hand out" access
path list, but would like the opportunity to discuss BPCS clients performance
issues to see if we can assist and improve using various methods and tools that
we have tested and proven to be very valuable to our current clients.

Regards,
Donna W. Stiehl
336.315.1005




Ata510@AOL.COM on 09/27/99 10:47:43 AM

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:    (bcc: Donna Stiehl/SSASE)

Subject:  Re: Batch Billing Performance.




In a message dated 9/22/99 4:06:54 PM Central Daylight Time,
dstiehl@SSASOUTHEAST.COM writes:

> Good afternoon Geoff,
>  We don't have a list of BMR numbers for billing performance, but we have
> created
>  a list of access paths, that when created and applied permanently, can
> reduce
>  the billing job run significantly (one client went from 45 minutes to 9
>  minutes).
>
>  Please contact me at Falk Integrated Technologies, Inc. for additional
>  information at 336.315.1005
Using generic lists of access paths developed for someone else's system (and
possibly release?) is not necessarily the best way to approach improving
performance. You should look for real BMRs, to see first of all if SSA has
found or changed anything, and then use something like DBMON or Centerfield
Technologies tool to find and build access paths on a regular basis (such as
after applying a cume or new set of BMRs). If it the program still doesn't
work quickly enough, call it in to SSA as a performance problem because there
are SQL constructions that can not be helped via an access path. Also, be
aware that such lists of access paths can become outdated, as BMRs may change
or remove the SQL that made the access path useful in the first place. Be
sure to test the paths one by one and if they do not seem to improve
anything, or if you can not tell which statement they were built for - don't
use them, since they do add some overhead to interactive processing of the
files they are built over. Some people have put on lists of access paths that
were designed for another customer or release, and had their systems run
slower afterwards, so be careful when doing this!


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