- 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)
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 pageThis 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.