RE: Improving System/21 Performance

I would also be interested.

Bill 

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Juan Doe
Sent: Tuesday, August 30, 2005 4:31 AM
To: System 21 Users
Subject: Re: [SYSTEM21] 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 
 
_______________________________________________
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.