2473905 - Long runtime of job SAP_COLLECTOR_PERFMON_SWNCREORG (with eventual transaction log depletion)

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

• SAP Neweaver (All releases)
• Workload Analysis
• SAP performance

ccms, performance, workload, dialog step, statistics, monitoring, kernel , KBA , BC-CCM-MON-TUN , Workload Monitoring Tool , Problem