WebSphere Commerce deployment checklist: Database
Is the production database clean of any test or erroneous data?
- Ensure that all test catalog data is removed before going live a smaller database will be faster to access. To clean the database use the Database Cleanup utility.
Are the database statistics up-to-date?
- The database statistics are used by the query optimizer when selecting the best way to execute a query.
- If the database statistics are wrong, then the query optimizer may select a course of action that results in a lot longer to execute than it planned.
- See REORG and REORGCHK in the DB2 documentation, or similar commands in Oracle.
Are the database configuration and tuning parameters signed off by the Database Administrator (DBA)?
- The WebSphere Commerce database is very important as it is the data store for the users, catalog, and orders.
- The database must be configured properly for the amount of memory that is available, the size of the catalog, any new tables/columns that were added, and any new queries that are being performed. For example, do any new indices need to be created to help new SQL in EJBs or Access Beans or Data Beans perform better?
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.