Symptom
- A database was defined with mixed log and data segments.
- Mixing data and log segment on same database device has the following limitations and is not recommended for production database usage:
- Can't backup transaction only.
- Can't calculate free space clearly.
- Can't fully recover database from a data segment failure.
- Segment will fill up more quickly when large transactions occur.
- How to separate data and log segments?
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise all versions
Keywords
CR730371, CR#730371, 730371, dbrepair, remap, findstranded, stranded, allocdump, sp_dropsegment, sysusages, segmap, GA1105, "Guided Answers" , 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.