|
View previous topic :: View next topic
|
| Author |
Message |
vicky10001
Warnings : 1
Active User
.jpg)
Joined: 13 Jul 2005
Posts: 136
|
|
|
|
| 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 |
|
 |
Steve Davies
New User
Joined: 15 Oct 2009
Posts: 32
Location: UK
|
|
|
|
What is the criteria so you know if they are not needed or outdated ?  |
|
| Back to top |
|
|
vicky10001
Warnings : 1
Active User
Joined: 13 Jul 2005
Posts: 136
|
|
|
|
| Plan is not accessd for long time and index alos.. |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
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 |
|
|
|
|
