Query and Interactive users

[Guest.Visitor]

Help!!!!!!Is there a way of stopping users runnning queries interactively? We are having a lot of problems with developers aswell as users doing this, and it is impacting our machine! TIACarl

[David Abramowitz]

On Thursday, February 11, 1999, 07:51 AM, Carl Longley wrote: Help!!!!!! Is there a way of stopping users runnning queries interactively? We are having a lot of problems with developers aswell as users doing this, and it is impacting our machine!

---

One method would be to change the command defaults for the RUNQRY command, so that RUNQRY can not execute interactively. You could also create your own RUNQRY command in a higher library that would intercept the user's RUNQRY and submit that to batch. I don't know how this would effect queries run from within the Start Query environment. David Abramowitz

[Guest.Visitor]

Carl, IBM documents a way to do it in the Appendix of your Query/400 manual. For Query/400 Use V3R1, it is appendix D. Basically, you CHGCMD to not allow RUNQRY to run in the interactive mode. We modified this logic to have a copy of RUNQRY that has the allow interactive attribute set to be copied to a library higher than QSYS for those users that know the impact of interactive queries and will use them intelligently. Bill Carl Longley wrote: Help!!!!!! Is there a way of stopping users runnning queries interactively? We are having a lot of problems with developers aswell as users doing this, and it is impacting our machine! TIA Carl

[Guest.Visitor]

In addition to Apx D of Query/400 User's Gd. see also search results on keyword QRY400 at: href="http://as400service.rochester.ibm.com/as4sde/slkbase.nsf/4086d1dc7efffb0a8 62565d80076c024/$searchForm?SearchView"> href="http://as400service.rochester.ibm.com/as4sde/slkbase.nsf/4086d1dc7efffb0a8 62565d80076c024/$searchForm?SearchView">http://as400service.rochester.ibm.com/a s4sde/slkbase.nsf/4086d1dc7efffb0a862565d80076c024/$searchForm?SearchView There is further revisions via a data area QUSRSYS/QQUCHKIRUN which can be activated. Also there is the CHGQRYA command and its related system value QQRYTIMLMT; I can not recommend prevention by system value. The CHGQRYA could be used in a routing program for your interactive subsystem(s). HTH. Regards, Chuck Comments provided "as is" with no warranties of any kind whatsoever.