Re: Improving System/21 Performance

I would also be interested,

Thanks

--- CMassoglia@xxxxxxxxxxxxx wrote:

> 
> 
> 
> 
> If you have not analyzed access path creation in
> System/21 using STRDBMON,
> your system probably runs far slower that it should.
>  We substantially
> reduced our month end processing time without
> changing a single program.
> Some on demand and daily reports that used to take
> minutes to run now take
> seconds.  Using STRDBMON, we were able to identify
> temporary access paths
> created by SQL, OPNQRYF, and Query/400 that either
> took forever to create
> or were created frequently.  All we had to do was
> create logical paths
> using the suggested key structure.
> 
> If anyone is interested, I have a short 9 page
> PowerPoint presentation that
> describes the technique in more detail.
> 
> Thanks.
> 
> Charlie Massoglia
> Chief Information Officer
> cmassoglia@xxxxxxxxxxxxx
> 517-780-4336
> Fax:  517-789-4503
> 
> 
> 
> _______________________________________________
> This is the System 21 Users (SYSTEM21) mailing list
> To post a message email: SYSTEM21@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/system21
> or email: SYSTEM21-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/system21.
> 
> 



                
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs