Symptom
- Transaction log dump files grow larger and larger but never decrease in size.
- Database may run out of space and report errors:
Error: 1105, Severity: 17, State: <n> Can't allocate space for object 'syslogs' in database '<DBSID>' because 'logsegment' segment is full/has no free extents.
If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment
- Command sp_spaceused syslogs shows the transaction log table continues to grow.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) - All versions
Product
SAP Adaptive Server Enterprise all versions
Keywords
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.