View previous topic :: View next topic
|
Author |
Message |
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Hi,
How to determine whether the package or plan is unused? i have a list of plan and packages, now i have to determine which all packages are unused.
Thanks
Srinath D. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
talking about batch or online/ or both?
what tools do you have?
scheduling? db2 analysis? what version of db2?
what progress have you made in solving the task that you get money for?
how do you plan to share your income for this project with us? |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
It consists of both online and Batch.
Db2 version is 9.
Its one part of activities which we have to perform. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
How to determine whether the package or plan is unused? |
What does this mean to your effort?
Are you looking for those that have never been used by some process(es) or those that have not been executed in some amount of time or . . . ? |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
dick scherrer wrote: |
Are you looking for those that have never been used by some process(es) |
Yes, we are looking for the plans that have never been used. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
realize of course that proving the negative is somewhat difficult.
or very eazy.
just develop a list of all plans that have ever been used.
then remove the 'have been used' list
from the list of all plans. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
The below is from Craig S. Mullin's Presentation - "DB2 10 for z/OS: For Developers Only"
Quote: |
When was that Package Used Last?
• At times, you may want to identify programs that are no longer being run
• But it can be difficult to determine when the last time a package was actually used (pre-V10)
• New DB2 Catalog column: LASTUSED
- SYSPKAGE
- SYSPLAN
• DATE column that is set when DB2 loads the package header from the EDM |
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
If you have Omegamon at your shop , you can look at the status of your PLAN/PACKAGE execuetion. On the other hand, if you want to know all the programs using the plan then following query should work for you:
Code: |
SELECT PLNAME
FROM SYSIBM.SYSDBRM
WHERE NAME= 'YOUR PROGRAM NAME'
; |
Hope this helps. |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
Anuj,
Quote: |
SELECT PLNAME
FROM SYSIBM.SYSDBRM
WHERE NAME= 'YOUR PROGRAM NAME'
; |
I think it depends on the Plan/Package arrangement in a particular shop.
The information on the SYSIBM.SYSDBRM table provides no useful information in our shop.
In fact, by looking at SYSIBM tables, or the DB2 catalog, we have no way of knowing which Packages are part of a Plan. |
|
Back to top |
|
|
|