|Lab: Leveraging the Newest Tools to Prevent and Minimize the Impact of Outages.|
|Check out the latest DB2 posts in the CSE-Commerce blogging community.|
|Possible Lock Escalations with DBClean. See JR51847 and this post: DBClean and Lock Escalation.|
|New APAR: DBClean fails to clean the CACHEIVL table. See JR53245.|
|Learn about the DB2 versions bundled with Commerce: License to Thrill - DB2 Versions Bundled with Commerce|
|Advanced post: DB Must-Do's: Review DB2 Settings to Avoid Latching and Performance Problems.|
|Learn about locking in the inventory tables: That's My Product! Dealing with Inventory Contention.|
The WebSphere Commerce DB2 Report tool relies on the db2collect.sh script to gather DB2 configuration and performance data using DB2 Monitor routines and views. The collection is lightweight and provides a high level overview of the database performance. Upload the zip created by the db2collect.sh script to this to tool to obtain a report of your WebSphere Commerce database configuration and performance.
The db2collect.sh requires DB2 9.7 Fix Pack 1 or newer. Currently the script is only available for Linux/Unix platforms. The script has not been tested in a pure scale environment.