View previous topic :: View next topic
|
Author |
Message |
vickey_dw
New User
Joined: 10 Jun 2015 Posts: 51 Location: India
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
No, because there is no association between a load module and a plan. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
if you know the dbrm then check into sysibm.sysdbrm. |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
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 |
|
|
|