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 on this page the zip created by the db2collect.sh script to obtain a report of your WebSphere Commerce database configuration and performance.
Maximum upload size is 10 MB. See the Help tab for additional instructions.
Use of this tool is subject to the terms and conditions of the IBM terms of use. This tool is not designed for the collection, storage or processing of personal information, and you agree not to upload or submit any personal information using this tool. IBM may compile and use and analyze anonymous, aggregate or statistical data based on data and information submitted or uploaded to this tool, and may prepare, use or disclose reports resulting from this compilation and analysis. By using this tool, you agree to all the above terms and conditions.
Useful News and Articles
News
   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.

Requirements

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.

Installation and Usage

Useful Links

Additional Help

The WebSphere Commerce DB2 Report tool is provided as-is. Questions can be posted to the forum:
For non-technical issues you can reach out to:
Andres Voldman
+1 905-413-4309
voldman@ca.ibm.com

Legal

  • Use of this tool is subject to the terms and conditions of the IBM terms of use. This tool is not designed for the collection, storage or processing of personal information, and you agree not to upload or submit any personal information using this tool. IBM may compile and use and analyze anonymous, aggregate or statistical data based on data and information submitted or uploaded to this tool, and may prepare, use or disclose reports resulting from this compilation and analysis. By using this tool, you agree to all the above terms and conditions.
  • Privacy information