Package & Plan in DB2



Package & Plan in DB2

Postby Praveen5526 » Sun Apr 22, 2012 11:09 pm

How we create a package in db2? and How we can delete the plan?
Praveen5526
 
Posts: 10
Joined: Sat Apr 21, 2012 6:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Package & Plan in DB2

Postby NicC » Mon Apr 23, 2012 4:04 am

by reading the manual. Use Google to search for 'IBM DB2 Manuals'
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Package & Plan in DB2

Postby Praveen5526 » Tue Apr 24, 2012 12:04 pm

Okay..will check ..thank u :)
Praveen5526
 
Posts: 10
Joined: Sat Apr 21, 2012 6:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Package & Plan in DB2

Postby Robert Sample » Tue Apr 24, 2012 2:40 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Package & Plan in DB2

Postby jaggz » Tue Apr 24, 2012 3:25 pm

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.
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times

Re: Package & Plan in DB2

Postby dick scherrer » Tue Apr 24, 2012 9:26 pm

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. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Package & Plan in DB2

Postby Praveen5526 » Wed Apr 25, 2012 12:33 pm

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.
Praveen5526
 
Posts: 10
Joined: Sat Apr 21, 2012 6:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Package & Plan in DB2

Postby NicC » Wed Apr 25, 2012 10:04 pm

It was an interview question - then why did you not post in the interview questions part of the forum?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to Interview Questions