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