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@