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.