Re: Inquiry : Queries and number of ODPs in programs

Spirinckx Chris wrote:

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

First, IMO, this will start a FLOOD of responses ;-)

In our shops we use RUNQRY to prototype a user request to assist them in
clarifying their request.

If the resource hit isn't that bad we'll but a CL wrapper around it to change 
the
execution priority and let them run it interactively for display output,
otherwise, for those cases that do not require a record selection, it gets
submitted to the job queue.

If the performance hit is negative, we create a "real" solution.  We even 
created
a black box program which puts up a panel which looks like the record selection
panel used by RUNQRY and allows the user to enter criteria within OPNQRYF
restrictions.  They think they are running the query, but what the heck, their
happy, we're happy, management is happy, the rest of the users of the system are
happy, and what they don't know won't hurt them.

IMHO, your debate touches on the "lazy programmer" category where their desire 
to
be heroes creating solutions, because of their lack of big picture viewpoint, 
has
an ongoing cost to all parties concerned that really, really, requires a little
education to show them how "real" heroes create solutions.  Trust me, they want
to be heroes.  They just need to learn who they are being a hero to.  A single
user, or the whole community.  Once they get a taste of "Kudos" from a group 
they
just might stop trying to serve a particular individual.

BTW, once individuals learn they can get the ear of a developer, anarchy can
easily set in.  The developer becomes the pawn in their game.

Good luck. Let us know how it develops.

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