Troubleshooting WebSphere Commerce Analyzer: WebSphere Commerce Analyzer DB2 transaction log fills up

If the WebSphere Commerce Analyzer DB2 transaction log fills up, use the DB2 Control Center to extend the size of the DB2 transaction log.

Note: For better performance, the Database Administrator should clean-up the old log files.

Check the size of the LOGFILSIZ, LOGPRIMARY, and LOGSECOND parameters by completing one of these steps:

DB2 Command line:

  1. On a DB2 command line, type DB2 GET DB CFG FOR database_name

Graphical user interface:

  1. Open the DB2 Control Center.
  2. Select the data mart name.
  3. From the data mart name's pop-up menu, select Configure Database Logging. The Configure Database Logging window displays
  4. Select the Logging tab from the left panel. Increase the values according to your disk space limitations.