Updating Database Statistics for DB2 UDB

Upon initial database load, the JD Edwards EnterpriseOne Platform Pack Installer automatically updates the DB2 UDB database statistics. However, is highly recommended to update database statistics after loading a significant amount of data to your database. Depending on the size of your tables, updating statistics can be time consuming.

To update the database statistics for your DB2 UDB database:

1. Sign on to the database machine as the DB2 administrator.
2. Start the DB2 UDB Command Window.
3. Connect to the database to which you want to update statistics for DB2 UDB by running the following DB2 UDB command:

   DB2 CONNECT TO database_name

   where database_name is a variable for the name of the database to which you wish to connect

4. Run the follow command to update the statistics:

   DB2 REORGCHK UPDATE STATISTICS ON TABLE ALL