Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Is package is necessary for a single DBRM

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

New User


Joined: 07 Aug 2006
Posts: 6

PostPosted: Tue Jan 02, 2007 9:22 am    Post subject: Is package is necessary for a single DBRM
Reply with quote

Hi


I need your help........... I have only one program which contain some SQL statements.... Is there any need for package in this condition??? Where do we store packages???? My question is I have only one DBRM then is there any need for package??? I hope you got a clear concept of my question??
Back to top
View user's profile Send private message

ansafmmm

New User


Joined: 21 Nov 2006
Posts: 2
Location: India

PostPosted: Tue Jan 02, 2007 11:35 am    Post subject: Re: Question on Packages...... Help me..........
Reply with quote

Dear Finny,

It is necessary to build a package in the latest versions. A package is a bind of one or more DBRMs. Even if there is only one program/DBRM, it is necessary to bind and form a Package.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2238
Location: @my desk

PostPosted: Tue Jan 02, 2007 1:06 pm    Post subject:
Reply with quote

Hi

You have to create a package for each DBRM.If you have one DBRM then you should bind it to a package.


As per DB2 UDB for zOS V8-Appln Pgming & SQL Guide
Quote:
Input to binding a package is a single DBRM only.


Thanks
Arun
Back to top
View user's profile Send private message
ansafmmm

New User


Joined: 21 Nov 2006
Posts: 2
Location: India

PostPosted: Wed Jan 03, 2007 10:05 am    Post subject:
Reply with quote

Yes Arun,
You are right about package defenition.
Sorry for it, a package is only for a single DBRM.

Thankyou
ANSAF
Back to top
View user's profile Send private message
kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Wed Jan 03, 2007 10:29 am    Post subject: Re: Is package is necessary for a single DBRM
Reply with quote

Hi,

Package is a concept, if we have 3 calling programs, if we change one program there is no need to compile all the 3 programs.

In your case, There is only one DB2-program so there is no need for the package. Plan will serve the purpose.

But to see in future prospects it is better to bind using package.
Back to top
View user's profile Send private message
humpty
Warnings : 1

New User


Joined: 01 May 2005
Posts: 23

PostPosted: Wed Jan 03, 2007 2:43 pm    Post subject: Re: Is package is necessary for a single DBRM
Reply with quote

Dear,

let us talk about the basics first.
DBRM - it contains all the embedded SQL statements and the consistency token which is nothing but a timestamp.
BIND - it is simply a compiler for SQL statements.
PACKAGE - it contains access path and consists only of single DBRM.
PLAN - plan consists of more than one DBRM or more than one PACKAGE or a combination of DBRM and a package. It also contains access path, however, it is executable. This is the only difference between plan and package.

every DBRM needs to be bind either into a package or a plan. but since plan is the only executable format, therefore, if you bind DBRM into package. it has to be ultimately transformed into plan.

it is always advisable to bind DBRM into packages and in turn to plan.

lets take an example:
suppose you have 100 programs. if you bind these 100 pgms into single PLAN, and if there is change in any pgm, then you need to BIND the 100 pgms again into PLAN.

but if you make 100 packages for the 100 pgms and if there is any change in 1 pgm. then only 1 package needs to be bind again instead of 100 binds as in the upper case.

since in your case it is only 1 pgm, you may opt for plan. but it is advisable to opt for package and in turn for plan.

i hope this clears the scenario.

icon_smile.gif
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 Splitting of single report to seperat... abdulrafi TSO/ISPF 2 Mon Mar 27, 2017 3:59 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us