SAP Knowledge Base Article - Preview

3567100 - The manual DUMP TRAN is blocked by CHECKPOINT for hours - SAP ASE 16.0

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.