Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 WLM - Hanging threads

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dineshchaudhry

New User


Joined: 26 Mar 2009
Posts: 9
Location: India

PostPosted: Thu Mar 26, 2009 1:43 pm    Post subject: DB2 WLM - Hanging threads
Reply with quote

Hi,

I am pretty new to DB2 WLM and Stored procedures. We have defined new WLM and few DB2 stored procedures (using Cobol) on z/OS. The stored procedures are called using Java client. We are facing some problems in bouncing (bring-down and bring-up) of WLM. Sometimes even after the call to stored procedure is complete, DB2 threads are still active. This hinders new bind to stored procedures and also bring down of WLM. How can this issue be addressed ? Can there any timeout parameter defined at SP level ?

Dinesh.
Back to top
View user's profile Send private message

a027412

New User


Joined: 05 Jul 2007
Posts: 40
Location: Minneapolis, MN

PostPosted: Thu Apr 30, 2009 2:37 am    Post subject:
Reply with quote

The timeout parameter can be defined at the ROUTINE level using "ASUTIME LIMIT <time in mill sec>"

Code:

.
.
COLLID              TGTT8
WLM ENVIRONMENT     DB2TSP2
ASUTIME LIMIT       500000
STAY RESIDENT NO
.
.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Error with opening new threads vasanthz General Talk & Fun Stuff 0 Fri Mar 13, 2015 1:34 am
No new posts How to Display the Active Threads aga... aviswam DB2 3 Wed Oct 03, 2012 1:05 pm
No new posts 3 threads of ProgA simultaneously XCT... Keanehelp CICS 1 Sat Mar 21, 2009 6:46 am
No new posts How can we get the number of running ... William Thompson CICS 4 Fri Apr 27, 2007 10:27 am
No new posts DB2 Threads Gurmeet DB2 4 Tue Jun 06, 2006 9:27 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us