IBM DB2 database: Running commands for regular maintenance

Last update: May 24, 2024

CREATED FOR:

  • User
  • Developer

The following IBM DB2 commands are recommended for regular maintenance of your AEM forms database. For detailed information about maintenance and performance tuning for your DB2 database, see IBM DB2 Administration Guide.

  • runstats: This command updates statistics that describe the physical characteristics of a database table, along with its associated indexes. Dynamic SQL statements generated by AEM forms automatically use these updated statistics, but static SQL statements built inside a database require that the db2rbind command be run as well.

  • db2rbind: This command rebinds all the packages in the database. Use this command after running the runstats utility to revalidate all packages in the database.

  • reorg table or index: This command checks whether a reorganization of some tables and indexes is required.

    As your databases grow and change, recalculating table statistics is critical to improving database performance and should be done regularly. These commands can be run either manually by using scripts or by using a cron job.

NOTE
Before you run the runstats command, the database must contain data, and at least one directory synchronization must have been performed.

For a small database, such as for 10,000 users or 2,500 groups, it is sufficient to invoke the runstats command to reduce the sync timings.

For larger databases, such as for 100,000 users or 10,000 groups, run the reorg command before you run the runstats command.

Use the runstats command on your AEM forms database

Run the runstats command on the following AEM forms database tables and indexes.

NOTE
The runstats command needs to be run only during the first database synchronization. However, it must be run twice during that process: once during the synchronization of Users and Groups and then during the synchronization of Group Members. Ensure that the script executes completely each time you run it.

For correct syntax and usage, see the database manufacturer’s documentation. Below, <schema> is used to denote the schema that is associated with your DB2 user name. If you have a simple default DB2 installation, this is the database schema name.

     TABLE <schema>.EDCPRINCIPALGROUPENTITY

     TABLE <schema>.EDCPRINCIPALGRPCTMNTENTITY

     TABLE <schema>.EDCPRINCIPALENTITY

     TABLE <schema>.EDCPRINCIPALUSERENTITY

     TABLE <schema>.EDCPRINCIPALEMAILALIASENTITY

     TABLE <schema>.EDCPRINCIPALENTITY FOR INDEXES ALL

     TABLE <schema>.EDCPRINCIPALEMAILALIASENTITY FOR INDEXES ALL

     TABLE <schema>.EDCPRINCIPALUSERENTITY FOR INDEXES ALL

     TABLE <schema>.EDCPRINCIPALGROUPENTITY FOR INDEXES ALL

     TABLE <schema>.EDCPRINCIPALGRPCTMNTENTITY FOR INDEXES ALL

Run the reorg command on your AEM forms database

Run the reorg command on the following AEM forms database tables and indexes. For correct syntax and usage, see the database manufacturer’s documentation.

     TABLE <schema>.EDCPRINCIPALGROUPENTITY

     TABLE <schema>.EDCPRINCIPALGRPCTMNTENTITY

     TABLE <schema>.EDCPRINCIPALENTITY

     TABLE <schema>.EDCPRINCIPALUSERENTITY

     TABLE <schema>.EDCPRINCIPALEMAILALIASENTITY

     INDEXES ALL FOR TABLE <schema>.EDCPRINCIPALENTITY

     INDEXES ALL FOR TABLE <schema>.EDCPRINCIPALEMAILALIASENTITY

     INDEXES ALL FOR TABLE <schema>.EDCPRINCIPALUSERENTITY

     INDEXES ALL FOR TABLE <schema>.EDCPRINCIPALGROUPENTITY

     INDEXES ALL FOR TABLE <schema>.EDCPRINCIPALGRPCTMNTENTITY

Experience Manager


Espressos & Experience Manager: AEM Forms

Espressos & Experience Manager

Thursday, Mar 6, 7:00 PM UTC

Join Adobe's AEM product team as they highlight AEM Forms' latest innovations, including: the new Gen AI Assistant, Unified Composition with AEM Sites, and new ways to deploy forms through conversations.

Register

The True Cost of a Failed Implementation

Online | Session | General Audience

A failed implementation isn’t just an inconvenience — it costs real revenue. Poor execution and misaligned tools disrupt pipelines,...

Wed, Mar 19, 2:00 PM PDT (9:00 PM UTC)

Register

Put the Customer at the Center and Build Relationships That Last a Lifetime

Online | Strategy Keynote | General Audience

First impressions last a lifetime. Great first impressions feel personal, connected, and relevant right from the start. From the first...

Wed, Mar 19, 2:30 PM PDT (9:30 PM UTC)

Register

Connect with Experience League at Summit!

Get front-row access to top sessions, hands-on activities, and networking—wherever you are!

Learn more

Register now