SAP Knowledge Base Article - Preview

1886081 - sp_helpdb reports "mixed data and log" while the devices are allocated for data and log separately - SAP ASE


  • Database (still) shows it is mixed log and data
  • sp_helpdb reports value of 'mixed log and data' while the device listing only shows entries with 'data only' and 'log only' (so no actual mixed devices)
  • The status2 bit in master.dbo.sysdatabases table shows -32767 or -32768 indicating the database contains mixed segment allocation



SAP Adaptive Server Enterprise (ASE)


SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions


status, bit, status2, log device, fragment, mixed allocation, segment, data and log , mixed log , mixed database , mixed devices , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.