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.

FREE PACKAGE(COLL1.*)

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.

Mandalika

Published on 12-Sep-2020 14:22:07

• Related Questions & Answers
• How to BIND all the packages in a collection COLLA to a plan PLANA?
• How to delete all the documents from a collection in MongoDB?
• How to delete a DB2 table TAB1?
• How to delete documents from a collection in MongoDB?
• How to get the list of all COBOL-DB2 programs using a DB2 table TAB1?
• How can you revert all the DB2 table changes done in a COBOL-DB2 program?
• How to remove all elements from a Collection in another Collection
• How to delete all the file contents using PowerShell?
• Write a DB2 query to find out all the duplicate INVOICE_ID in ORDERS DB2 table?
• How to delete multiple documents from a collection using Java?
• How to find all the foreign keys of a DB2 table TAB1?
• How to find out all the indexes for a DB2 table TAB1?
• How to delete all the duplicate records in a MySQL table?
• How to compile packages in Java
• How to delete all the tags of the azure resource using PowerShell?