Identifying Db2 stored procedures running Java threads with high CPU usage

Use the following procedure to identify Db2 stored procedures that are running Java threads with high CPU usage. Once identified, you can display detailed information about the threads in  views.

1. On THDSTPR, hyperlink on the Stored Procedure Name field for jobs that run in the WLM address space (suffixed with WLMJ).

   Important

   To verify that the Db2 stored procedure is running a Java thread, ensure that the value in the Client/Product field is JCC.

   The THRDDTLZ view is displayed in . The view lists all of the active threads associated with the selected Db2 stored procedure.

2. On THRDDTLZ, identify any threads with high CPU usage. Hyperlink on the Thread State column to see detailed thread information on the THRDDTL view. 
   
   
   For more information, see the .