SAP Knowledge Base Article - Preview

2099706 - Msg 12947, Level 16, State 1: DBCC TABLEALLOC - SAP ASE

Symptom

  • DBCC TABLEALLOC reports:

    ***************************************************************
    TABLE: syslogs OBJID = 8 PARTITION ID=8 FIRST=474045 ROOT=1144533 SORT=0
    Msg 12947, Level 16, State 1:
    Server 'ASE', Line 1:
    Syslogs free space is currently 1563890 pages but DBCC counted 1053883 pages.
    This descrepancy may be spurious if this count was done in multi-user mode.
    Please run DBCC TABLEALLOC(syslogs, full, fix) to correct it.
    Data level: indid 0, partition 8. 17110 Data pages allocated and 2139 Extents allocated.
    TOTAL # of extents = 2139
    ***************************************************************
  • Errors that can also be seen in combination:
     
    Msg 12947, Level 16, State 1:
    Msg 7949, Level 18, State 1:
    Msg 2502, Level 16, State 1:
    Msg 7940, Level 18, State 1:


Read more...

Environment

  • SAP  Adaptive Server Enterprise (ASE) - All Versions

Product

SAP Adaptive Server Enterprise 15.7

Keywords

negative value, used_pages, logsegment , 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 ONE Support launchpad (Login required).

Search for additional results

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