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
 

 

understand about collection ID and packages

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

New User


Joined: 13 Jan 2012
Posts: 20
Location: India

PostPosted: Fri Mar 15, 2013 1:56 pm    Post subject: understand about collection ID and packages
Reply with quote

Can anyone help me understand the below icon_confused.gif

lets say i have a DB2 Cobol Programs PG-A ,a collection ID COLID-1 and a Plan PLN-1.

Section1
As of now i just have a DBRM and a load module.So now i try to bind the member PG-A with the parameters as below.
BIND PACKAGE(COLID-1) MEMBER(PG-A) ,

Question
When i submit the bind job with the collection id in PACKAGE parameter a packages gets created with the name "COLID-1.PG-A" . Is this how a package gets created ?
(After which i include all the packages from COLID-1.* to the Plan PLN-1 using PKLIST)


Section-2
Below are my understandings
1 . Collection ID and Plan have a N-N relationship
2. A DBRM has a single package meaning it has a 1-1 relationship

Question
Now i have a PLN-1, two collection ID ,COLID-1 and COLID-2 and a program PG-A
Can PG-A be present in COLD-1 and COLD-2 ? If it can then can then what does 1-1 relationship between DBRM and package mean.
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Fri Mar 15, 2013 2:14 pm    Post subject:
Reply with quote

DBRM => Package is kind of like SOURCEcode => Loadmodule.
you bind a dbrm into a package
you compilelink sourcecode into a loadmoadule.

you can bind a DBRM into different collections, just like you can compile/link into different loadlibraries.
So there is no 1:1 relationship between DBRM and package.
Back to top
View user's profile Send private message
arjun.h

New User


Joined: 13 Jan 2012
Posts: 20
Location: India

PostPosted: Fri Mar 15, 2013 3:32 pm    Post subject:
Reply with quote

Guyc, Thanks for your reply
One more questions if you could answer .

I have three programs PG-A , PG-B,PG-C
Methods to BIND
1. Include all the above in to a Collection ID and then bind to a Single plan PLAN
2. Bind all the three to the same plan PLAN
3. Bind PG-A to plan name PG_A , PG-B to PG_B and PG-C to PG_C

I know the second method does have a disavantage if the change is for a single program , but is there any difference for method 1 and 3 ? i mean if the change is for PG-B then you need to bind only PG_B.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Fri Mar 15, 2013 4:27 pm    Post subject:
Reply with quote

don't bind a dbrm to a plan.
bind to collection
and bind a plan to collid.*

option 3 is impossible if PG-A calls PG-B
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 15, 2013 5:33 pm    Post subject:
Reply with quote

arjun.h wrote:
3. Bind PG-A to plan name PG_A , PG-B to PG_B and PG-C to PG_C
Did you mean package here?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 15, 2013 6:29 pm    Post subject:
Reply with quote

As a general point, suggest you go through the sticky here, just in case you've not done it already: http://ibmmainframes.com/viewtopic.php?t=23965
Back to top
View user's profile Send private message
arjun.h

New User


Joined: 13 Jan 2012
Posts: 20
Location: India

PostPosted: Fri Mar 15, 2013 7:03 pm    Post subject:
Reply with quote

Thanks Guyc and Anuj .Your help is really appreciated . Let me go back to my drawing board icon_biggrin.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 15, 2013 7:08 pm    Post subject:
Reply with quote

Good Luck! icon_smile.gif
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Sat Mar 16, 2013 1:52 am    Post subject:
Reply with quote

GuyC wrote:
...
and bind a plan to collid.*
...
That technique is forbidden in our shop. Each package has to be individually listed in the PKLIST. Even in the test environment.

As you would expect, we are regularly bitten by -805s caused by packages being omitted from the list.
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 Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts Need documents or links to understand... sherlinpraveenkumar IDMS/ADSO 5 Wed Oct 28, 2015 4:40 pm
No new posts list of executed but not commited pac... ramsri CA Products 4 Sat May 17, 2014 12:33 pm
No new posts Query to list packages bound under a ... gylbharat DB2 7 Wed Jul 03, 2013 2:06 pm
No new posts Multiple Packages - Confusion gylbharat DB2 10 Mon Jun 10, 2013 12:23 am


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