Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Program and its corresponding plan

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Program and its corresponding plan
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: 1789
Location: Bloomington, IL

PostPosted: Thu Apr 07, 2016 9:51 pm    Post subject:
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

Moderator


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

PostPosted: Thu Apr 07, 2016 10:09 pm    Post subject:
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

Senior Member


Joined: 21 Sep 2010
Posts: 2300
Location: NY,USA

PostPosted: Fri Apr 08, 2016 1:42 am    Post subject:
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: 726
Location: Pennsylvania

PostPosted: Fri Apr 08, 2016 7:08 pm    Post subject:
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    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 Is multiple program names allowed in ... Sakthidevi PL/I & Assembler 1 Tue Nov 19, 2019 11:12 pm
No new posts Running a REXX exec program using ZOSMF Sakthi344 CLIST & REXX 3 Tue Oct 15, 2019 3:13 pm
No new posts How to handle NULL in COBOL program bhaskar_kanteti COBOL Programming 8 Mon Oct 07, 2019 3:54 pm
No new posts REXX - CLIST program to be invoked af... pkmurali CLIST & REXX 5 Wed Sep 04, 2019 4:31 pm
No new posts Verify WITH UR present inside program... priyankakir CLIST & REXX 23 Wed Jun 12, 2019 3:37 pm

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