DB2 FOR LUW / DB2FORLUW / A50 - DB2

Currently, the "Effective degree" field reflects the compilation 
degree of parallelism, not runtime degree. The title of 
Effective degree easily leads to the expectation that it 
reflects the degree of parallelism actually in use for the 
running of the statement.  This APAR is to fix the db2pd -apinfo 
output that will update the description of 
Number of Agents to something more indicative of what is 
actually being reported, add a field that reports the actual 
runtime degree alongside of Effective degree, and add a field 
that will report the Active Agents from existing monitors.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to 10.5 fp7                                          * 
****************************************************************

Use the mon_get_activity() table function to monitor the in 
effect query parallelism, specifically the QUERY_ACTUAL_DEGREE 
field. 
For example: 
 
    $ db2 "select 
num_agents,agents_top,effective_query_degree,query_actual_degree 
from table(mon_get_activity(616,-1)) t" 
 
    NUM_AGENTS           AGENTS_TOP 
EFFECTIVE_QUERY_DEGREE QUERY_ACTUAL_DEGREE 
    -------------------- -------------------- 
---------------------- ------------------- 
                       3                    3 
12                   2 
 
      1 record(s) selected. 
 
This shows the actual parallelism applied to the query.

first fixed in 10.5 fp7

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.04.2015
22.01.2016
22.01.2016