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 for Me (Login required).

Search for additional results

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