TASM Filters and Exceptions

General
Fan

TASM Filters and Exceptions

Hi,

We are trying to implement a filter that would restrict users from returning more than 10,000,000,000 rows however there seems to be a restriction to 10 characters restricting us to 1,000,000,000, any ideas?

Rgds Paul

3 REPLIES
Enthusiast

Re: TASM Filters and Exceptions

TASM :

IN QUERY RESOUCE RULE

MAX ROW COUNT :   THOUSAND ROWS,

                                  MILION ROWS,

                                  BILION ROWS..

by using   bilion rows we can do.

Enthusiast

Re: TASM Filters and Exceptions

Hello all,

Is there any way in TASM to set up an exception to abort queries based on the time in which they are in "acive state"?

For example, if a query is in delayed state for half an hour and then it goes into active state (the total time on system is half hour but I would consider this the start time and if the start time crosses 1 hour, the query should abort)

If I put the exception on "Duration" that time would include (time in active state + time in delayed state) and this is not working for me.

Can you please let me know if exception can be done on "active state" time?

Thanks

Enthusiast

Re: TASM Filters and Exceptions

Usmans,

Have you tried the "Elapsed TIme" in the exception criteria? I believe that should give you the time since the query came into the active state. 

--SK