首页 > Linux操作系统 > Linux操作系统 > DB2负载管理(WLM)(三)
目的:删除前面两个测试所创建对象:
1,恢复系统缺省设置
-- Map workload SYSDEFAULTUSERWORKLOAD back to service class
-- SYSDEFAULTUSERCLASS
ALTER WORKLOAD SYSDEFAULTUSERWORKLOAD SERVICE CLASS SYSDEFAULTUSERCLASS@
2,禁用服务类
-- Disable service classes WLM_SHORT, WLM_MEDIUM, WLM_LONG and WLM_TIERS
ALTER SERVICE CLASS WLM_SHORT UNDER WLM_TIERS DISABLE@
ALTER SERVICE CLASS WLM_MEDIUM UNDER WLM_TIERS DISABLE@
ALTER SERVICE CLASS WLM_LONG UNDER WLM_TIERS DISABLE@
ALTER SERVICE CLASS WLM_TIERS DISABLE@
3,设置缺省服务代理\预取优先级
-- Reset agent priority and prefetch priority for default service
-- superclasses.
ALTER SERVICE CLASS SYSDEFAULTSYSTEMCLASS AGENT PRIORITY DEFAULT
PREFETCH PRIORITY DEFAULT@
ALTER SERVICE CLASS SYSDEFAULTMAINTENANCECLASS AGENT PRIORITY DEFAULT
PREFETCH PRIORITY DEFAULT@
ALTER SERVICE CLASS SYSDEFAULTMAINTENANCECLASS AGENT PRIORITY DEFAULT
PREFETCH PRIORITY DEFAULT@
4,删除工作动作集
-- Drop work action set WLM_TIERS_WAS
DROP WORK ACTION SET WLM_TIERS_WAS@
5,删除工作类集
-- Drop work class set WLM_TIERS_WCS
DROP WORK CLASS SET WLM_TIERS_WCS@
6,删除服务类重新影射阈值
-- Drop remapping thresholds WLM_TIERS_REMAP_SHORT_TO_MEDIUM and
-- WLM_TIERS_REMAP_MEDIUM_TO_LONG.
DROP THRESHOLD WLM_TIERS_REMAP_SHORT_TO_MEDIUM@
DROP THRESHOLD WLM_TIERS_REMAP_MEDIUM_TO_LONG@
7,删除服务类
-- Drop service classes WLM_SHORT, WLM_MEDIUM, WLM_LONG and
-- WLM_TIERS.
DROP SERVICE CLASS WLM_SHORT UNDER WLM_TIERS@
DROP SERVICE CLASS WLM_MEDIUM UNDER WLM_TIERS@
DROP SERVICE CLASS WLM_LONG UNDER WLM_TIERS@
DROP SERVICE CLASS WLM_TIERS@
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/18922393/viewspace-702327/ ,如需转载,请注明出处,否则将追究法律责任。