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
 

 

Db2 Unused, Plan , Packages

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
srinathds83

New User


Joined: 17 Jul 2007
Posts: 41
Location: pune

PostPosted: Tue Sep 13, 2011 10:30 pm    Post subject: Db2 Unused, Plan , Packages
Reply with quote

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
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Sep 13, 2011 11:15 pm    Post subject:
Reply with quote

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
View user's profile Send private message
srinathds83

New User


Joined: 17 Jul 2007
Posts: 41
Location: pune

PostPosted: Tue Sep 13, 2011 11:43 pm    Post subject: Reply to: Db2 Unused, Plan , Packages
Reply with quote

It consists of both online and Batch.

Db2 version is 9.

Its one part of activities which we have to perform.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Sep 14, 2011 12:45 am    Post subject:
Reply with quote

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
View user's profile Send private message
srinathds83

New User


Joined: 17 Jul 2007
Posts: 41
Location: pune

PostPosted: Wed Sep 14, 2011 6:58 am    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Sep 14, 2011 10:17 am    Post subject:
Reply with quote

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
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Fri Sep 16, 2011 3:13 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Sep 16, 2011 3:15 pm    Post subject:
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Fri Sep 16, 2011 7:03 pm    Post subject:
Reply with quote

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
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 Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am
No new posts Multiple COBOL-DB2 pragrams calling b... deepak_shrivastava DB2 1 Wed Jan 06, 2016 3:45 pm


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