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
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.
SAP Knowledge Base Article - Preview