SAP Knowledge Base Article - Preview

2018668 - How to separate data and log in a mixed data and log segments - SAP ASE


  • A database was defined with mixed log and data segments.
  • Mixing data and log segment on the same database device has the following limitations and it is not recommended for production database usage:
    • Cannot backup transaction only.
    • Cannot calculate free space clearly.
    • Cannot fully recover database from a data segment failure.
    • Segment will fill up more quickly when large transactions occur.
  • How to separate a mixed data and log segments?



SAP Adaptive Server Enterprise (ASE)


SAP Adaptive Server Enterprise all versions


CR730371, CR#730371, 730371, dbrepair, remap,  findstranded, stranded, allocdump, sp_dropsegment, sysusages, segmap, GA1105, "Guided Answers", mixed, data, log, segments , 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.