2632926 - How to Monitor the Create/Rebuild of Bad Indexes - DB6 IBM | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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