473,883 Members | 2,607 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How To Find The Plan For A Program


I've been searching this newsgroup for an answer to my question, and
the closest I've come asks my question, but in reverse ("How to figure
out the program from plan/package"). I've -- shall we say, inherited?
-- a COBOL program with very little documentation that I've recompiled
for debugging purposes. The compile/link/bind have all been done, but
nothing in the output tells me what plan the program has been bound to,

so I can't execute until I know. I imagine that somewhere in the SYSIBM

tables I can find the information, but so far I haven't found the right

Any help would be appreciated.

P.S. I previously posted this request in 'bit.*listserv. *db2-l'. I
should have cross-posted, so if you get this twice, sorry 'bout that...

Nov 30 '06
10 13685
"Norm" <w_******@hotma il.comwrote in message
news:11******** **************@ n67g2000cwd.goo glegroups.com.. .
There are two different methods of binding on DB2 for z/OS.

The older method is used when you statically link many COBOL
sub-programs into one giant load module. In this case, you would bind
all the associated DBRMs (database request modules) into one big plan.
If this is the case, you can look in SYSIBM.SYSDBRM to see the plan
associated with the program. The DBRM name is the same as your COBOL
program name.

The new method is to bind a package with each COBOL program (main or
sub-program). The package is identified by location, collection id,
name, and version. Unlike DB2 for LUW, a plan is always required for
DB2 for z/OS. A plan is bound with to include package lists. This
allows a sub-program to be run under multiple plans. To find which
plan to use at execution time, you would query SYSIBM.SYSPACKL IST to
find the list(s) that qualify your package. You may end up with
multiple plans. The correct plan to run usually depends on security
requirements that are implemented by different plans.

The newer method is almost always used for new applications. It
reduces catalog contention during rebinds and has a closer matching of
load modules to packages reducing "Package not found" or "Consistenc y
token mis-matches".

Hope this clears things up a bit.

Using plans (without packages) instead of packages is only problem for CICS
programs. It is not a problem for batch programs, and many people still use
plans for batch programs (one program per plan). Some people do use packages
for batch programs, but there is no serious advantage to it.

The reason for the problem of plans with CICS is that you cannot switch
plans when you XCTL to another CICS program, so that when using plans, all
the DBRMs for every program in an application had to be bound in the same
plan. You can switch plans with a CICS Start Transaction, but that is a very
expensive operation. That is why packages were introduced in DB2 for MVS
Dec 9 '06 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Cyril Vi?ville | last post by:
As it's written in the subject, i would like to know how can i find which program modified a file (last access, last changed). By example: Example.txt in a log directory I need to know which apps wrote in Thx
by: Jim Heavey | last post by:
I am tyring to figure out why a class that I am trying to instatiate can not be found. I am NOT WORKING WITH PRE_COMPILED code. I am dragging the source code over and placing the code in a folder. I make the appropriate changes in my @Page directive to ensure that the program would be compiled on the fly ("src="myProgram.aspx"). All works perfectly fine until I get to one of the pages with instatiates a "utility" class that I created...
by: Edward | last post by:
hi, everyone, my Page_Load fill tblProducts with some TextBox. <form runat="server"> <asp:Table id="tblProducts" runat="server"></asp:Table> <hr> <asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="Button"></asp:Button> <hr> <hr>
by: I_AM_DON_AND_YOU? | last post by:
Hi Cor: You have given a very good suggestion that I can directly reference the "Program Files" Folder. Actually my vb.net program reads/write a notepad file record.txt. For example, the name of my program is MYPROGRAM and I am presuming that it would be installed in the "MYPROGRAM" folder of "Program Files". Therefore I can reference record.txt file in my code as path =...
by: fdu.xiaojf | last post by:
Hi, When I want to uninstall my usb disk on windows, the operating systems sometimes tells me the device is being used by other program. But I can't find which program is using it. Can I do this using python ? Thanks. xiaojf
by: greyhoundz102 | last post by:
pls help me to make a program on how to display printer lists in my computer wid the ff info: printer name drivername port name processor name comment location.. tnx so much.
by: nobrow | last post by:
I need a syntactically comprehensive test program to test a C parser on. Does anyone know where I might find a program that uses all syntactical elements of the language and combines them in cunning/ realistic ways so that one might be confident that a pass on this program will mean a pass on any valid C program. Big ask, but I thought someone might know of a suitable file(s).
by: Jason Heyes | last post by:
Why can't I use the find algorithm to find a program argument in the following way? std::find(argv, argv + argc, "-v") Thanks.
by: Richard Hollenbeck | last post by:
I originally wrote my grades program in MS-Access to help community college teachers in the California community colleges keep track of their students' grades and produce reports for the students to know how they are doing in the semester and to submit reports to the school at the end of the semester. I later discovered many flaws my program's design and in my own skills as a programmer. I would like to put this program "out there" so...
by: Soulless | last post by:
Hi, I have created a batch file in C# and want to find and place it in the path of an installed application. Now, this might be done on an XP, 2000, etc system. The application is installed and will likely be in the registry. Does anyone know of anything in C# to check the registry for a particular application path? Say, for instance, i needed to find the Word path and place a file in it... how to check the registry through code...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.