Re: Query/400

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

At 09:39 PM 4/15/97 -0700, James wrote:
>Alex Chow wrote:
>> 
>> Hello all, perhaps somebody out here would care to share abt how they
>> would manage their Query/400 definitions if they're one like ours,
>> whereby many Query/400 reports are scheduled for various departments
>> everydays, weekly, monthly etc.
>> 
>> As we do not have any HLL compilers on AS/400, 
>
>The system comes with a CL compiler and that IS a HLL.


We use Query/400 as a user tool; yep, they all write their own.  Granted,
the problem is that they sometimes forget to include a join link (causing
intermediate files of about a trillion records), but by and large they do a
good job.

However, since they create so MANY of the darned things, we have had to make
a few changes in how they run.

We have 2 AS/400s, and use Mimix to backup our production data base to the
2nd machine.

We offload all query executions to the 2nd machine to keep the production
system free for interactive users.  We currently offload about 300-400
queries a day.

As a cleanup routine, we routinely:

        - clear any Query outfiles after 30 days

        - Delete any query outfiles after 90 days (they get re-created
automatically if the query gets re-run)

        - Delete Query definitions unused after 13 months (to allow those
end-of-year queries to survive)

--Paul E Musselman
PaulMmn@ix.netcom.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 MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *