SAP Knowledge Base Article - Preview

3263382 - DB6: How to use "Costly Transactions" function for diagnostics


Database ever experienced one of following situation:

  • Long lock waiting time
  • Huge amount of locks held
  • Holding log space for a long time
  • Huge amount of log space used

You want to know if there is any way to find out the past information (within 14 days) which may still be available.



  • SAP on IBM Db2 for Linux, UNIX, and Windows

  • SAP basis version equal or higher than the one listed in note 2233061.


SQL0911N, SQL0964C, log full, lock timeout, lock wait, costly transactions , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-DB6-DBA , Database Administration , 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.