Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 30
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: 1738
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: 1529
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: 1610
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: 645
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 I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts A sample of exit program for exit XMN... lind sh CICS 2 Mon Oct 03, 2016 5:07 pm
No new posts Need points to tune IMS Checkpoint Pr... satish.ms10 IMS DB/DC 2 Fri Sep 30, 2016 4:12 pm
No new posts ISPF program to set SCRNAME prino TSO/ISPF 5 Fri Sep 30, 2016 2:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us