Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: delete old plans/packages

    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
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •