IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Why myself doing Package Bind always for DB2 programs?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Thu Mar 02, 2017 10:47 pm
Reply with quote

Hi
In our mainframe project, we always do a package bind for cobol-db2 program. and run the program using Jcl by IKJEFT01 step.

I got this doubt as we know that only plan is executable.
Then how my jobs running fine with just package BInd. Please help.

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

Active Member


Joined: 01 Dec 2006
Posts: 747
Location: Pennsylvania

PostPosted: Thu Mar 02, 2017 11:10 pm
Reply with quote

Although you execute the Plan, it refers to the package, either explicitly, or to the collection where the package resides.

Someone at your shop should explain to you how the Plans and Packages are organized.
Back to top
View user's profile Send private message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Fri Mar 03, 2017 11:04 am
Reply with quote

The SYSTSIN CARD is

DSN SYSTEM(SSNID)

RUN PROGRAM(XYZPROG) PLAN(CREATORB)

END

'understood ,you said plan CREATORB points to a collection where package of XYZPROG gets added by the package bind command.

Now my query is when exactly we go for a Plan bind.
in my project 'never did a plan bind. icon_sad.gif-
Please let me know, Thanks
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 747
Location: Pennsylvania

PostPosted: Fri Mar 03, 2017 6:28 pm
Reply with quote

Plan CREATORB is probably a shared plan used by all programs/packages in the COLLECTIONB collection.

All the packages in this collection probably refer to SCHEMAB.

It was probably set up by your DBA staff, and should not be touched.

You see I said probably several times. This is because....

Someone at your shop should explain to you how the Plans and Packages are organized.[/b]
Back to top
View user's profile Send private message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Sat Mar 04, 2017 8:59 am
Reply with quote

Thanks for the infos...@dave.
Back to top
View user's profile Send private message
don.leahy

Active Member


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

PostPosted: Tue Mar 07, 2017 7:09 pm
Reply with quote

For an excellent explanation of the PLAN/Package relationship see this article by Bonnie Baker: www.ibm.com/developerworks/data/library/dmmag/DMMag_2011_Issue3/Programmers/
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Invoke REXX thru JCL to expand the co... CLIST & REXX 2
No new posts DB2 - CHAR9 is not accepted by IBM S... DB2 4
No new posts Bind process DB2 4
No new posts How syntax check at Bind time is diff... DB2 5
No new posts VALIDATE option in BIND jcl DB2 2
Search our Forums:

Back to Top