Symptom
You notice that the background job SAP_COLLECTOR_PERFMON_SWNCREORG runs for an exceptionally long time and, additionally, directly impacts on the database's transaction log. Eventually it has to be cancelled due to the complete depletion of the transaction log.
Important: Before following this guide, ensure that the following corrections are already in place, where applicable for your release:
- 2400238 - SWNCREORG is running for a very long time without "DB commits"
- 2070383 - ST03n: Reorg of workload data does not work
- 2536367 - ST03n: the reorganization of old workload statistic data sometimes does not work
Read more...
Environment
- SAP Neweaver (All releases)
- Workload Analysis
- SAP performance
Product
SAP NetWeaver all versions
Keywords
ccms, performance, workload, dialog step, statistics, monitoring, kernel , KBA , BC-CCM-MON-TUN , Workload Monitoring Tool , 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.