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 myself doing Package Bind always for DB2 programs?

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

Active User


Joined: 17 Nov 2009
Posts: 125
Location: India

PostPosted: Thu Mar 02, 2017 10:47 pm    Post subject: Why myself doing Package Bind always for DB2 programs?
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: 687
Location: Pennsylvania

PostPosted: Thu Mar 02, 2017 11:10 pm    Post subject:
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: 125
Location: India

PostPosted: Fri Mar 03, 2017 11:04 am    Post subject: Reply to: Why myself doing Package Bind always for DB2 programs?
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: 687
Location: Pennsylvania

PostPosted: Fri Mar 03, 2017 6:28 pm    Post subject:
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: 125
Location: India

PostPosted: Sat Mar 04, 2017 8:59 am    Post subject:
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: 658
Location: Whitby, ON, Canada

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

For an excellent explanation of the PLAN/Package relationship see this article by Bonnie Baker: https://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    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 pointers on using USS and C programs. Pedro All Other Mainframe Topics 0 Wed Oct 04, 2017 4:38 am
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
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 Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am

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