
with Tags:
wlm
X

Why does event monitor for statistics only work for workload at position 1 and not for all the other workloads ?
Here is an example of the problem description: Create Workload: -- db2 "SET WORKLOAD TO SYSDEFAULTADMWORKLOAD" db2 "CREATE WORKLOAD WL_A SESSION_USER('DB2V10')" db2 "CREATE WORKLOAD WL_B SESSION_USER('JKGERA')" db2 "ALTER WORKLOAD WL_A COLLECT AGGREGATE ACTIVITY DATA BASE" db2 "ALTER WORKLOAD WL_B COLLECT AGGREGATE ACTIVITY DATA BASE" db2 "GRANT USAGE ON WORKLOAD WL_A TO PUBLIC" db2 "GRANT USAGE ON... [More]
Tags:  db2 event mon_statistics_wlstats_pm... db.mon_statistics_wlstats... wlm priority monitor |
50 DB2 Nuggets #42: Tech Tip - how to integrate the db2 and AIX WLM classes ?
Do you want to know how to integrate the db2 and AIX WLM classes ? You can do that while defining the db2 WLM class using the outbound correlator string constant. Refer : http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0050550.html OUTBOUND CORRELATOR NONE or OUTBOUND CORRELATOR string-constant Specifies whether or not to associate threads from this service class to an external workload manager service class. If OUTBOUND CORRELATOR is set to a string-constant for the... [More]
Tags:  db2_techtip create correlator outbound service 50_db2_nuggets wlm class |
50 DB2 Nuggets #41 Tech Tip - Want to know more on SQL4728W & what Agent Priority to be set ?
SQL4728W : A priority setting was assigned to a service class that is higher than the priority setting of the default system service class SYSDEFAULTSYSTEMCLASS and this might negatively impact performance. To ensure that system work can take precedence over user work, the priority settings of the default system service class SYSDEFAULTSYSTEMCLASS should always be higher than the priorities that were set for all other service classes. Failure to assign higher priority settings to the default system service class can result in a negative impact... [More]
Tags:  agent wlm 50_db2_nuggets priority sysdefaultsystemclass sql4728w db2_techtip |