Redbrick List Forum

Restricting Runtime for Queries

Posted By: Joseph Kaminski
Date: Saturday, 17 May 2003, at 11:18 a.m.

In Response To: Restricting Runtime for Queries (betty.chan@sickkids.ca)

Betty -- check the Admin Guide for more information on the following...

Initialization Files
Each time a user starts a session to access a database, that session is
initialized
by database server initialization files (named .rbwrc), which might exist
on
the global, database, or user levels to provide startup information for
that
session. Additional initialization files (named .rbretrc) provide setup
information
for the RISQL Entry Tool and RISQL Reporter.
For more information refer to “Initialization Files� on page 2-22.

------------------------------------------------------------------------------------------------

Joe Kaminski office: 610-250-5943
IBM - Data Management Solutions
Small-Mid Business Group (internal) t/l: 390-9609
230 Browns Drive efax: 530-239-3344
Easton, PA 18042

jkaminsk@us.ibm.com cell: 610-392-1587




betty.chan@sickki
ds.ca To: redbrick-list@iiug.org
Sent by: cc:
forum.subscriber@ Subject: Restricting Runtime for Queries [84]
iiug.org


05/16/2003 10:01
AM






Hello Everybody,
We run RB 6.2 on AIX and sometimes have queries that run forever. Is there
a way to set a limit to the computer resource (time, memory disk space)
that each query can use for individual accounts, so that some accounts have
more resource and run longer queries than the other.
Thanks in advance
Betty Chan
The Hospital for Sick Children

Messages In This Thread

• Restricting Runtime for Queries
  betty.chan@sickkids.ca -- Friday, 16 May 2003, at 10:01 a.m.
  • Restricting Runtime for Queries
    Joseph Kaminski -- Saturday, 17 May 2003, at 11:18 a.m.

Redbrick List Forum is maintained by Administrator with WebBBS 5.12.