Cascaded drop of WLM service classes
Dropping a disabled service class with the DROP statement now drops all dependent service subclases, thresholds, and work action sets.
For example, to drop a service superclass A with three subclasses B, C, and D, and a work action
set WAS1, you can simply run the following
statements:
ALTER SERVICE CLASS A DISABLE
DROP SERVICE CLASS A
In previous
releases of Db2®, you would have
to run the following statement to get the same result:
ALTER SERVICE CLASS B UNDER A DISABLE
DROP SERVICE CLASS B UNDER A
ALTER SERVICE CLASS C UNDER A DISABLE
DROP SERVICE CLASS C UNDER A
ALTER SERVICE CLASS D UNDER A DISABLE
DROP SERVICE CLASS D UNDER A
ALTER WORK ACTION SET WAS1 DISABLE
DROP WORK ACTION SET WAS1
ALTER SERVICE CLASS A DISABLE
DROP SERVICE CLASS A