DROP MODULE
From SQL PL Guide for DB2
DROP MODULE statement
With the DROP MODULE statement the whole module will be dropped including all objects like prodedures and functions in the module. Dropping just an object in the module must be done with the ALTER MODULE Command.
Example:
drop module mymodule
Link to the DB2 Information Center: DB2 9.7