Symptom
- 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
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions
Keywords
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.