Performance considerations | Conclusions
16.4.3 DBClean
Most of the database performance defects or PMRs opened with WebSphere Commerce are a result of poor database maintenance. Over time the database is filled with expired orders information, expired guest user information, user traffic logs, stale coupons, and promotion information. If we do nothing to the database, the result is frequent occurrences of deadlocks, transaction time outs, throughput degradation, and time-consuming response times.
The DBClean, combined together with other well known DB2 maintenance utilities, consist of an entire WebSphere Commerce DB2 database maintenance solution. Refer to Chapter 25, Database maintenance, for more about DB2 maintenance.