SAP Knowledge Base Article - Preview

2632926 - How to Monitor the Create/Rebuild of Bad Indexes - DB6 IBM

Symptom

  • A corrupt index which has been marked by db2dart is currently being rebuilt.
  • If the INDEXREC parameter has status RESTART or ACCESS, this means that either the Index will be rebuilt when the Database is restarted (RESTART) or when the table is accessed (ACCESS).
  • There is a performance issue accessing the table that the index is being rebuilt on.


Read more...

Environment

Db2 LUW

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.