RE: Inquiry : Queries and number of ODPs in programs

Chris,

Sounds like you have two options:

1) Fire them and hire new programmers.
2) Order a model upgrade for the AS/400 (the old "throw more hardware at
the problem" solution).

:-)


OK - maybe a third option:
Send them away for some education so they can learn what they are doing
wrong.


Neil Palmer                                AS/400~~~~~      
NxTrend Technology - Canada   ____________          ___  ~     
Thornhill, Ontario,  Canada   |OOOOOOOOOO| ________  o|__||=   
Phone: (905) 731-9000  x238   |__________|_|______|_|______)   
Cell.: (416) 565-1682  x238    oo      oo   oo  oo   OOOo=o\   
Fax:   (905) 731-9202       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
mailto:NPalmer@NxTrend.com    AS/400  The Ultimate Business Server      
http://www.NxTrend.com

> -----Original Message-----
> From: Spirinckx Chris [SMTP:chris.spirinckx@club.innet.be]
> Sent: Wednesday, April 08, 1998 3:50 PM
> To:   midrange-l@midrange.com
> Subject:      Inquiry : Queries and number of ODPs in programs
> 
> 
> Fellow-midrangers,
> 
> A colleague and I are responsible for 2 AS/400 ( 620/600 ).
> One of our tasks is of course the tuning of those systems.
> 
> Currently we're having 2 "hot" discussions with the programmers :
> 
> 1) Usage of RUNQRY-command. 
> ---------------------------
> We think that this command should mainly be used by the DP-staff
> itself
> (testing purposes ) or for ad-hoc reports.
> The programmers on the otherhand are using this command in practicly
> 50 %
> of the applications 
> (including interactive ones ). 
> Some of the batchjobs are 5 or more RUNQRY-commands that run after
> each
> other in order to produce one single query-report.
> They say : "its easy to use and with minimum on effort".
> The course about SQL has just finished, we're shaking already.
> 
> 2) Number of ODPs in a program.
> -------------------------------
> We try to encourage them to us as less ACCPTHs in a program as
> possible. (
> whatever that means ).
> What we cannot understand is that a simple report needs 40 or more
> ODPs and
> some applications uses more than 100 ODPs (yes, hundred).
> 
> We have about 120 interactive users ( still growing ) and 10
> batch-programs
> running simultaneous. 
> 
> When we say that the users are complaining about the response-times,
> the
> programmers cannot understand that it is due to the usage of
> RUNQRY-cmd and
> the number of ODPs open in the jobs.
> 
> 
> 
> 
> What are your opinions and did you have similar discussions ??
> 
> 
> 
> Many thanks,
> 
> Chris
> 
> 
> ======================================================================
> ===
> Chris Spirinckx            # E-mail live :
> chris.spirinckx@club.innet.be
> F. van Eedenplein 4a/5     # E-mail work :
> chris_spirinckx@pee.pioneer.be
> B2050 Antwerpen            # Tel/Fax : + 32 3 219.09.12
> BELGIUM (Europe)           #
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---