Installing DB2/EMS

Use this procedure to install a DB2 database and EMS.

Important: When creating the database, set the page size to 16 KB (16,384 bytes) or higher.

Procedure

  1. Install the TIBCO Enterprise Messaging Server and start the server.
  2. Install the DB2 Database.
    1. Download and install the DB2 Database.
    2. Perform the server configuration by following the prompts in the DB2 installer.
    3. Accept the default port value 50000, or enter your own port number.
    4. Download the following JDBC driver connector JAR files (db2jcc4.jar) to the TIBCO_HOME/afx/version/system/lib/db folder.
    Note: The TIBCO_HOME/afx/version/config/dbscripts/db2/folder contains two SQL scripts named db2_create and db2_drop. These scripts help you to administer the database in an efficient manner. The db2_create script indicates what you can expect in the database and the db2_drop script allows you to drop a table if you have a problem with the database. You should back up the data before using the db2_drop script.