Skip Headers
JD Edwards EnterpriseOne Applications Upgrade Guide
Applications Release 9.1 and Tools Release 9.1.x for UNIX with DB2 UDB

E23321-16
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

17 DB2 UDB Installation Utilities

This chapter discusses:

17.1 Cataloging for DB2 UDB

You must catalog the DB2 UDB databases on any machines that need to connect to the DB2 UDB database server. For example, client machines, Deployment Server, or Enterprise Server (if different than database server. This procedure makes the databases known to the connecting machines.

From the machine where you want to catalog:

  1. Map a drive to the location where the DB2 database scripts reside; typically they are located in:

    \\deployment_server_name\910\database

  2. Edit the catalog_db.bat file so that the variable values, such as instance name, as applicable to your installation. The catalog_db.bat file contains comments describing how to set the variables contained therein.

  3. Start the DB2 UDB Command Window.

  4. Change directory to location where the DB2 UDB database scripts reside.

  5. Run the catalog_db.bat batch file.

17.2 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