I am trying in to find the workload name being used by a connection in DB2 10.5? What's the easiest way to do this?

Question:

I am trying in to find the workload name being used by a connection in DB2 10.5? What's the easiest way to do this?
 

Answer:

If what you want is the WORKLOAD_NAME element to see what workload a connection has been mapped to by DB2, the easiest way is to use the MON_GET_UNIT_OF_WORK function using the appropriate predicates to get the connections of interest.

0 Comments
Recent Stories
An old Db2 Easter Egg: Setting the default isolation value for dynamic SQL

Interpreting total_extended_latch_wait_time

How do I refresh the libraries used by Db2 external routines without stopping Db2?