DDF Thread reuse

Matthew Stitt

DDF Thread reuse
We've been seeing some instances where DDF threads are being reused with no change in the user id coming across. This causes headaches for us as we have created WLM classifications based on the thread user id. If a thread gets created with a user id that places it into the High Velocity service class, that is fine. Later on, another request comes in that is assigned to that thread which generates a long running heavy CPU workload. This is where the problem comes in. Based on the type of request, it should have been in the Low Velocity service class.

Is there any way we can get WLM to reclassify the DB2 DDF threads without shutting down thread reuse?

Thanks.....
**************************************************************************************************
****************************************************************************************************
This e-mail and any files transmitted with it are confidential to abc distributing, llc.
("abc"), and may contain proprietary or copyrighted materials belonging to abc, which
are intended solely for the individual named. If you are not the named addressee, you
are notified that any copying, dissemination, distribution or disclosure of any or all of its
contents, and any action taken in reliance on the transmission, are unauthorized and
prohibited. Please notify abc immediately by e-mail reply if you have received this
transmission in error and take all necessary and appropriate actions to permanently
delete it from your system.
*****************************************************************************************************

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm