UOW_TOTAL_TIME_TOP value does not get reset.
Example:
$ db2 "select substr(service_superclass_name,1,25),
substr(service_subclass_name,1,25), uow_total_time_top,
last_reset from table(wlm_get_service_subclass_stats_v97('', '',
-2)) t"
1 2
UOW_TOTAL_TIME_TOP LAST_RESET
------------------------- -------------------------
-------------------- --------------------------
SYSDEFAULTSYSTEMCLASS SYSDEFAULTSUBCLASS
- 2011-05-24-13.28.31.478023
SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
- 2011-05-24-13.28.31.478075
SYSDEFAULTUSERCLASS SYSDEFAULTSUBCLASS
- 2011-05-24-13.28.31.478126
$ db2 "alter service class sysdefaultsubclass under
sysdefaultuserclass collect aggregate activity data base"
DB20000I The SQL command completed successfully.
$ db2 "select substr(service_superclass_name,1,25),
substr(service_subclass_name,1,25), uow_total_time_top,
last_reset from ta>
1 2
UOW_TOTAL_TIME_TOP LAST_RESET
------------------------- -------------------------
-------------------- --------------------------
SYSDEFAULTSYSTEMCLASS SYSDEFAULTSUBCLASS
- 2011-05-24-13.28.31.478023
SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
- 2011-05-24-13.28.31.478075
SYSDEFAULTUSERCLASS SYSDEFAULTSUBCLASS
5 2011-05-24-13.28.59.766290
$ db2 "select * from syscat.columns order by colname" >
/dev/null
$ db2 "select substr(service_superclass_name,1,25),
substr(service_subclass_name,1,25), uow_total_time_top,
last_reset from ta>
1 2
UOW_TOTAL_TIME_TOP LAST_RESET
------------------------- -------------------------
-------------------- --------------------------
SYSDEFAULTSYSTEMCLASS SYSDEFAULTSUBCLASS
- 2011-05-24-13.28.31.478023
SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
- 2011-05-24-13.28.31.478075
SYSDEFAULTUSERCLASS SYSDEFAULTSUBCLASS
922 2011-05-24-13.28.59.766290
$ db2 "call wlm_collect_stats"
Return Status = 0
$ db2 "select substr(service_superclass_name,1,25),
substr(service_subclass_name,1,25), uow_total_time_top,
last_reset from ta>
1 2
UOW_TOTAL_TIME_TOP LAST_RESET
------------------------- -------------------------
-------------------- --------------------------
SYSDEFAULTSYSTEMCLASS SYSDEFAULTSUBCLASS
- 2011-05-24-13.31.13.598868
SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
- 2011-05-24-13.31.13.598868
SYSDEFAULTUSERCLASS SYSDEFAULTSUBCLASS
922 2011-05-24-13.31.13.598868
Expected result: value should have changed to a smaller value.
Actual result: value stays the same as before. |
