SAP Knowledge Base Article - Preview

2530524 - DBCC error 2540 / 2521 on system and/or user tables - SAP ASE

Symptom

  • When running DBCC checks

  • Errors 2540 and 2521 are reported on system and/or user tables:
       
    Msg 2540, Level 16, State 1:
    Server 'xxxxxx', Line 1:
    Table Corrupt: Page is allocated but not linked. Run DBCC TABLEALLOC to correct the problem. (allocation page#=260096, extent id=260192, logical page#=260197,
    object id in extent=24, object name=sysstatistics, index id in extent=0)
         
    Msg 2521, Level 16, State 1:
    Server 'xxxxxx', Line 1:
    Table Corrupt: Page is linked but not allocated. Run DBCC TABLEALLOC to correct the problem. (allocation page#=259328, extent id=259352, logical page#=259359,
    object id in extent=576002052, object name=test_tab, index id in extent=0)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE). All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

Msg 2540, Msg 2521, table corrupt, DBCC TABLEALLOC, Page is allocated but not linked, Page is linked but not allocated, 2540 , 2521 , tablealloc, checkalloc , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.