|
View previous topic :: View next topic
|
| Author |
Message |
rakesh17684
New User
Joined: 08 Oct 2006
Posts: 61
Location: San Diego
|
|
|
|
Hi,
We have a front end triggering a SP. Even after the front end is timed out, SP still keeps on running, which creates long running threads in the database. Need to stop the SP from running for a long time. Can anybody help me out. |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| How long a stored procedure can run will be determined by ASUTIME parameter of CREATE/ALTER PROCEDURE. |
|
| Back to top |
|
|
rakesh17684
New User
Joined: 08 Oct 2006
Posts: 61
Location: San Diego
|
|
|
|
| How to edit that parameter??? |
|
| Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
OPen your SP and view the declaration ....
something like
| Code: |
CREATE PROCEDURE CCTDB2S.CCRFIT02 ()
RESULT SETS 1
LANGUAGE SQL
MODIFIES SQL DATA
COLLID CCT_REP
WLM ENVIRONMENT DB2UWLMP
ASUTIME NO LIMIT
RUN OPTIONS ''
|
here you can change the ASUTIME ... the above SP has no time limit |
|
| Back to top |
|
|
|
|
