DB2 v8.2/9.5 on AIX5/6
I was trying to delete aliases and schemas for obsolete userids. So when I dropped all aliases and started dropping schemas db2 found plans with same schema and did not let me to drop the schema for these userids. How do I drop/remove those plans we don't use anymore? Need to use SQL or CLP command only (no CC). Thank you