DocumentationAEM 6.4Forms Guide

DB2 database: Running a process weekly db-database-running-a-process-weekly

Last update: Wed May 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User
CAUTION
AEM 6.4 has reached the end of extended support and this documentation is no longer updated. For further details, see our technical support periods. Find the supported versions here.

If your AEM forms DB2 database begins to run slowly, running the following process on a weekly basis can improve its performance:

  1. Start DB2 Control Center:

    (Windows) Select Start > Programs > IBM DB2 > General Administratison Tools > Control Center.

    (Linux and UNIX) From a command prompt, type the db2jcc command.

  2. In the DB2 Control Center object tree, click All Databases.

  3. Click the database you created for AEM forms and click the Tables folder.

  4. Select all the database tables in the contents pane, right-click them and select Run Statistics.

  5. Go to Statistics > Index Statistics.

  6. Select Collect Statistics For All Indexes, select Collect Statistics For Indexes With Extended Detailed Statistics, and then click OK.

A message appears when the process is completed. Close the message.

recommendation-more-help
a6ebf046-2b8b-4543-bd46-42a0d77792da