SAP Knowledge Base Article - Preview

2400917 - dbcc reindex on deferred table - SAP ASE

Symptom

  • Enhance dbcc reindex to reset RID comparison mode for index of deffered table
  • 1> dbcc reindex ('t1',2,"ridbinarycmp")
    2> go

    Make sure t1 is deferred by checking  sysstat3 &128 = 128
    Make sure before reindex, sysindexes has
    status & 256 = 256
    true.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

dbcc reindex, RID, deferred table, cmp, CR746238, CR#746238, 746238 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.