ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DB2负载管理(WLM)(三)

DB2负载管理(WLM)(三)

原创 Linux操作系统 作者:redhouser 时间:2011-07-15 16:59:56 0 删除 编辑

目的:删除前面两个测试所创建对象:

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博客 ” ,链接:http://blog.itpub.net/18922393/viewspace-702327/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-05-26

  • 博文量
    211
  • 访问量
    826017