db2 => DROP TYPE ADDRESS_T
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "DEMO.ADDRESS_T" is an undefined name. SQLSTATE=42704
I had a similar issue earlier with functions and found that I had to drop by SPECIFICNAME but, from what I can tell, TYPES don't have those.