SAP Knowledge Base Article - Preview

3641204 - DB6: EWA report flags uneven tablespace distribution.

Symptom

EWA report alert 
An uneven tablespace distribution can cause long running backup and restore runtimes, and contention of prefetching since there is only one prefetcher per container. The current tablespace distribution is considered suboptimal, since the largest tablespaces hold a significant amount of data.
Therefore SAP recommends a deeper database analysis e.g. via Technical Performance Optimization Service (TPO) to analyse the impact on the system and to give specific recommendations.


Read more...

Environment

DB2 LUW IBM

Product

SAP ERP 6.0

Keywords

fragmentation, huge, object, influence, contribute, performance, HWM, hang, slow, backup, online, read, reduce, reduction, how to, check, cause , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.