Symptom
- The ASE Database has a transaction log of 6.1Tb, with a current usage of 5.7Tb.
- The database option "sp_dboption <db_name>, 'trunc log on chkpt' , true" was activated to manage the large amount of transaction data.
- Run dump "tran..with truncate_only" manually, but blocked by CHECKPOINT.
- The SAP application was stopped to prevent running out of transaction log space.
Read more...
Environment
Business Suite on Adaptive Server Enterprise 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
ASE Database, transaction log, CHECKPOINT process, blocked process, sp_dboption, trunc log on checkpoint, SAP ASE. , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
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.