SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

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

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

Keywords

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.