SAP Knowledge Base Article - Preview

3126129 - Indexes of sysusages were corrupted after shrink database failure - SAP ASE

Symptom

  • Shrink database hanging 
    • Tried killing the process (did not work)
    • Killed the process with force option - (did not work)
    • Rebooted ASE
    • Then alter database again showed 'sysusages' index corruption.
  • dbcc checktable(sysusages)’ returned two errors for unique clustered index after shrink database failure:
    Msg 2510,  “Key mismatch between index page 225, …at offline 44; and data page 209 (row ID 34), …”
    Msg 7928, “Index csysusages is not consistent; found 24 leaf rows but 35 data rows. Drop and recreate the index.”

  • select * from master.dbo.sysusages where dbid=db_id("dbname")
         --  returns duplicate rows
    dbid   segmap         lstart              size     vstart     location    unreservedpgs                               crdate    vdevno
    ------   ----------- ----------      ---------- -----------      --------        ------------- -------------------------------   -----------     
         4           3  265420800   16384000           0                0          16320000     Nov 13 2021 12:22AM          30
         4           3  265420800   16384000           0                0          16320000     Nov 13 2021 12:22AM          30
  • sp_helpdb "dbname" - shows the same duplicates.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sp_fixindex, CR#825824, CR825824, CR 825824, 825824 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.