How to delete all the DB2 packages in collection COLL1?

A DB2 collection is a physical quantity which is used to group the packages. A collection can be simply termed as a group of DB2 packages. By using collections we can bind the same DBRM into different packages. In order to delete all the DB2 packers under a collection, we can issue below command.


The FREE PACKAGE reserved word is followed by the name of collection i.e. COLL1. The * after the collection name indicates that we need to perform delete action for all the packages under the said collection.