Package & Plan in DB2

[Praveen5526]

How we create a package in db2? and How we can delete the plan?

[NicC]

by reading the manual. Use Google to search for 'IBM DB2 Manuals'

[Praveen5526]

Okay..will check ..thank u

[Robert Sample]

Praveen5526, this is a HELP forum, not a READ-THE-MANBUAL-FOR-YOU forum. When the question you ask is simply answered in the manual, expect to be told to go read the manual. If the question you ask has complications or implications beyond the manual, or the question is about a specific issue, you'll get a lot more help.

[jaggz]

Hi Praveen,

For creating a package you might get in touch with DB2 sys progs or DBA for a valid syntax. For deleting the plans the manual has clearly given the method to delete.

[dick scherrer]

Hello,

If you are NOT the dba and there is a need to create/delete packages/plans, you need to work with the dba. Do NOT experiment as this may be cause for discipline - even termination.

fwiw. . .

[Praveen5526]

Thanks all. Actually it was asked in the interview. So just thought of knowing the answer. I googled it . I got 2 comments to delete the package and plan ,
1. Drop package
2. Free package ,
for plan ,
1. Free plan .
Please tell me if these answers are correct.

[NicC]

It was an interview question - then why did you not post in the interview questions part of the forum?