SAP Knowledge Base Article - Preview

2866523 - transaction log of tempdb is not truncated with checkpoint process - SAP ASE

Symptom

The transaction log of tempdb is not truncated automatically after a lot of processing using tempdb. The checkpoint-housekeeper-process does not shrink the log.   To free up the log, this is being done manually by executing "dump tran tempdb with truncate_only"


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - all versions

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

checkpoint process, checkpoint,  housekeeper, transaction log, space, usage , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.