The developerWorks Connections platform will be sunset on January 2, 2020. This blog will no longer be available unless an extension has been requested. More details available on our FAQ.
New to Blogs?
Share your news and views with others. Learn how to:
Matching: db2dart X
There has been a long standing request to allow for marking of individual indexes invalid via the db2dart /MI command. This would be extremely useful in the case where crash recovery is failing on one invalid index page. So even though all of...Modified on by Jeff Andersen
Invalidating range partitioned indexes using db2dart Community Blog
NishantSinha Tags: mark syscat.indexpartitions range_partition invalid partition index table db2 range db2dart syscat.datapartition 11,504 Views
We often come around a case, where the database crashes due to a corrupt index. The index can be invalidated using - db2dart /MI - REORG In this article, we would focus on marking an index invalid using db2dart. Once the index has been invalidated with...
from Blog: DB2 Problem Troubleshooting and Tips