This chapter discusses:
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:
Map a drive to the location where the DB2 database scripts reside; typically they are located in:
\\deployment_server_name\910\database
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.
Start the DB2 UDB Command Window.
Change directory to location where the DB2 UDB database scripts reside.
Run the catalog_db.bat batch file.
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:
Sign on to the database machine as the DB2 administrator.
Start the DB2 UDB Command Window.
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
Run the follow command to update the statistics:
DB2 REORGCHK UPDATE STATISTICS ON TABLE ALL