SAP Knowledge Base Article - Preview

2826152 - free space count messages in ASE log - SAP ASE

Symptom

The following messages are seen in the SAP ASE database errorlog:

"The segment free page count on segment <segment id> in database 'SID' (4) was found to be negative (-8) after a change of 8 and has been set to 0."

'The free space count for fragment with lstart <lstartnr> in database 'SID' was found to be negative and has been set to 0. Execute 'DBCC USEDEXTENTS(SID,0,1)' in single user mode to correct this count."

The offending segments are data segments - where the value of sysusages.segmap <> 4 (or 8) for the referenced <segment id> or <lstartnr>.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (latest releases)
  • SAP Adaptive Server Enterprise (ASE) 16.0 (latest releases)

Product

SAP enhancement package 2 for SAP NetWeaver 7.0

Keywords

"free page count", lstart, "unreserved count", fragment, segment, negative, "free space" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.