SAP Knowledge Base Article - Preview

1886081 - How to fix status2 bit in master.dbo.sysdatabases after separating respective data and log device fragments - SAP ASE


  • sp_helpdb output returns the value of 'mixed log and data' in status field, 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 respective database contains mixed segment allocation.
  • According to Sybase documentation for this status2 values(-32767 or -32768) is "Database has some portion of the log which is not on a log-only device



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 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.