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
 

 

Obsolete plan and index

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

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Mon Oct 19, 2009 5:51 pm    Post subject: Obsolete plan and index
Reply with quote

We are planing to remove obsolete(not need or outdated ) plans and index... Please let me know which querywe can use and create some plan/index initial report.
Back to top
View user's profile Send private message

Steve Davies

New User


Joined: 15 Oct 2009
Posts: 32
Location: UK

PostPosted: Mon Oct 19, 2009 6:01 pm    Post subject:
Reply with quote

What is the criteria so you know if they are not needed or outdated ? icon_confused.gif
Back to top
View user's profile Send private message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Mon Oct 19, 2009 6:14 pm    Post subject:
Reply with quote

Plan is not accessd for long time and index alos..
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Oct 20, 2009 12:39 pm    Post subject:
Reply with quote

In DB2 V8 there is no way of knowing when an index or plan (or better package) has last been "accessed".

For Indexes :
If you only have static SQL and all your programs have been explained you could check the plan_table. But even then Indexes that are needed for R.I. could be not in the plan_table but still be very needed for the performance of your application.

In DB2 9 there is a column LASTUSED in SYSIBM.SYSINDEXSPACESTATS.


For plans and packages :
You should know which programs are running on your system based on info outside of DB2. Based on that you would know which packages are still needed.
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 SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm


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