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

Program and its corresponding plan


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

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Thu Apr 07, 2016 9:27 pm
Reply with quote

Is there any way i can check the plan associated with the program via Query ?.I tried sysibm.sysplan but could not found.


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

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Thu Apr 07, 2016 9:51 pm
Reply with quote

No, because there is no association between a load module and a plan.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Thu Apr 07, 2016 10:09 pm
Reply with quote

If there are some proper naming conventions used in your shop you should be able to find out yourself or else also by asking your team mates
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Fri Apr 08, 2016 1:42 am
Reply with quote

if you know the dbrm then check into sysibm.sysdbrm.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Fri Apr 08, 2016 7:08 pm
Reply with quote

As stated above, you should speak with your DBA support staff so you get an understanding of the standards and conventions used at your shop.

For example, at our shop:
There are multiple Schema used within a DB2 Subsystem.
Each Schema (referred to as regions) is the qualifier for a set of tables.

A Package (the DBRM/SQL of a program) is Bound to a Collection using the Qualifier of the Schema/Region.
This Package can be found on the sysibm.syspackage table.

A Plan points to a Collection which which contains all the Packages.
This can be found on the sysibm.syspacklist table.

The bold terms are just a few you need to understand.

As stated, a Program is not directly associated to a plan.
A Package may be associated to a plan, but not at our shop.

Your question is just too general to answer without you having and understanding of DB2 basics, and how things are configured at your shop.
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
No new posts Using API Gateway from CICS program CICS 0
No new posts DB2 Event passed to the Application P... DB2 1
No new posts How to pass the PARM value to my targ... COBOL Programming 8
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top