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.Blogs
Blogs
Matching:
db2dart
X
X
| Display: |
Basic Guideline on how to rebuild a Db2LUW database
Basic Guideline for rebuilding a Db2LUW database : Create a temp directory to store the outputs of db rebuild and go to that directory. Save all the DDLs for the database : db2look...
from Blog: Thoughts from Support
Modified on by Biswarup(Bis)Mukherjee
|
|
In Db2 LUW simple steps which might help getting rid of corrupted pages
Recently following simple guidelines helped customers to get rid of corrupted pages easily. So, just putting it here in case it helps. Customer's db2 inspect output was showing following kind of...
from Blog: Thoughts from Support
Modified on by Biswarup(Bis)Mukherjee
|
|
Debunking the online vs offline db2dart myths
There is a common misconception that db2dart is only an offline tool. To understand the truth we have to understand 2 things: that db2dart only reads data from disk and that there are 3 distinct types of db2dart options. &nb...
from Blog: Thoughts from Support
Modified on by Jeff Andersen
|
|
Marking individual indexes invalid
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...
from Blog: Thoughts from Support
Modified on by Jeff Andersen
|
|
SYSCOLDIST table is marked as invalid. Rebuild index getting error - 901 due to duplicate values
Some older DB2 levels experienced this problem. If the database cannot be restored using an earlier good backup then following way might help, The SYSCOLDIST table contains the distribution statistics. So, first ...
from Blog: Thoughts from Support
Modified on by Biswarup(Bis)Mukherjee
|
|
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
|
