Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Why Plan is preferred over package

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Mon Aug 29, 2005 7:27 am    Post subject: Why Plan is preferred over package
Reply with quote

Why Plan is preferred over package?

Regards,
Anu.
Back to top
View user's profile Send private message

AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Mon Aug 29, 2005 7:29 am    Post subject: Max Columns
Reply with quote

How many maximum coloumns are allowed in a table in DB2?
Back to top
View user's profile Send private message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Mon Aug 29, 2005 7:36 am    Post subject: Commit
Reply with quote

According to my knowledge , once commit is issued after making some changes in the table , the changes become permanent and to get back the previos state of the table one needs to use alter or update but, i have come across a question where it says :-

"After some updations are made to the table and commit is issued , how can one get back the original data without alter or update again?"

Regards,
Anu.
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Mon Aug 29, 2005 11:02 am    Post subject:
Reply with quote

Most columns in DB2 table:
for db2 mvs --750
for db2 os/400--8000
for ibm --255

hope this helps.
Back to top
View user's profile Send private message
tanguduk
Warnings : 1

New User


Joined: 29 Aug 2005
Posts: 14

PostPosted: Mon Aug 29, 2005 5:22 pm    Post subject: package and plan
Reply with quote

package is not executable but plan is executable thats why we prefer plan over package .
Back to top
View user's profile Send private message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Tue Aug 30, 2005 12:19 am    Post subject: Re:Paln/Package
Reply with quote

Thank u all for ur response.

Could u pls elaborate more about Plan & a Package ?

Regards,
Anu.
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Tue Aug 30, 2005 9:30 am    Post subject:
Reply with quote

AnuB,

A plan may contain multiple packages and pointers to packages. The one program would then exist in a package that could be referenced in two different plans.

It is compulsary to use plan name for every DB2 program because the Cobol we are using dont know how to access the DB2 resources. That Information will be there in Packages and Plans.

A plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be composed of one or more DBRMs and packages. Before a DB2 for z/OS program (with static SQL) can be run, it must have a plan associated with it.

Plans are created by the BIND command. The plan is stored in the DB2 directory and accessed when its program is run. Information about the plan is stored in the DB2 catalog.

A package is a single, bound DBRM with optimized access paths. By using packages, the table access logic is "packaged" at a lower level of granularity than a plan -- at the package (or program) level.

To execute a package, you first must include it in the package list of a plan. Packages are not directly executed, they are only indirectly executed when the plan in which they are contained executes -- as discussed previously, UDFs and triggers are exceptions to this rule. A plan can consist of one or more DBRMs, one or more packages or, a combination of packages and DBRMs.

For more information,pls refer site manual.
Back to top
View user's profile Send private message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Thu Sep 01, 2005 12:56 am    Post subject: Re: Package & Plan
Reply with quote

Thank u.
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Thu Sep 01, 2005 2:54 am    Post subject: Hi
Reply with quote

u could read this stuff too

http://www.db2mag.com/story/showArticle.jhtml?articleID=15300107


http://www.db2mag.com/story/showArticle.jhtml?articleID=17602333

http://www.db2mag.com/story/showArticle.jhtml?articleID=18901299
Back to top
View user's profile Send private message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Thu Sep 01, 2005 11:22 am    Post subject: Re: Package & Plan
Reply with quote

Thank u.

Even i have found this link thru' some search .

Anyway,thank u very much for ur kind consideration.

Regards,
anu.
Back to top
View user's profile Send private message
Anbudan

New User


Joined: 07 Sep 2005
Posts: 26
Location: Germany

PostPosted: Wed Sep 07, 2005 4:39 pm    Post subject:
Reply with quote

Hi AnuB

Regarding Package & Plan,

1) Through DB2 panel, you can create package and plan. i.e

On DB2 panel,
i)select BIND/REbind/Free
ii)Select Bind package
iii)Give the needed parameters
Package fertig

For plan, do the above and the (ii) point, Bind plan


OR
U can do manually with job.
see below:



Anbudan

2)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us