Re: Limiting (but not stopping) interactive query by user

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxx>]

Hello, all:

It might be done even simpler than that... if you have an initial program
(specified in the *USRPRF) when those users sign on, perhaps you
could issue the CHGQRYA there?

To quote Albert Einstein: "Make it as simple as possible, but not simpler."

Regards,

Mark S. Waterbury


----- Original Message -----
From: <Adam.Driver@xxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, December 04, 2003 6:36 PM
Subject: Re: Limiting (but not stopping) interactive query by user


> Hi Simon,
>
> You might be onto something! I assume the only reason CHGQRYA doesn't
> affect batch is because batch submitted queries would have a different job
> name etc,? This could be good for us, because we don't want to use the
> system value if it limits batch.
>
> I'm also downloading the trial version of CHGQRYOPT, so I'll let you know
> what I think.
>
>
> Thanks
>
> Adam Driver
> Technical Consultant
> Kaz Technology Services
> Level 7
> 66 Wentworth Ave
> Sydney NSW 2010
> Australia
> Phone: +61 2 9844 0386
> Fax: +61 2 9844 0333
>
> A division of Kaz Group Limited - visit our website at www.kaz.com.au
> date: Thu, 4 Dec 2003 19:04:07 +1100
> from: Simon Coulter <shc@xxxxxxxxxxxxxxxxx>
> subject: Re: Limiting (but not stopping) interactive query by user
>
>
>
> On Thursday, December 4, 2003, at 03:47  PM, Adam.Driver@xxxxxxxxxxxxx
> wrote:
>
> > I might be clutching at straws here, but we have a customer that's
> > requested us to limit interactive query by user; ie, they don't want to
> > stop anyone from using interactive query, just limit their impact on
> > the
> > system based on CPU utilisation. We don't really want to use QQRYTIMLMT
> > because we don't want to limit batch run queries at all.
> >
> > Does anyone know if this is possible? All suggestions most welcome.
>
> You could use the CHGQRYA command in the initial program for each user
> to set the QRYTIMLMT for each job. This would not affect batch queries.
> The CHGQRYA command requires the user to have *JOBCTL so the program
> must adopt suitable authority.
>
> If you want more control over the query attributes you could use the
> CHGQRYOPT command in the base component of ONcmd. This is a free
> feature. See
>              http://www.flybynight.com.au/oncmd.html
> for more information.
>
> Regards,
> Simon Coulter.
> --------------------------------------------------------------------
>     FlyByNight Software         AS/400 Technical Specialists
>
>     http://www.flybynight.com.au/
>     Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
>     Fax:   +61 3 9419 0175                                   \ /
>                                                               X
>                   ASCII Ribbon campaign against HTML E-Mail  / \
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>