Creating and populating the Collaborate system tables

If the automatic database setup fails during the installation of Collaborate, you must create and populate Collaborate system tables manually.

Before you begin

Update the unencrypted value for udm_data_source.password in the udm_jdbc.properties file that is located in the <Collaborate_Home>/tools/bin directory before you run udmdbsetup.

About this task

When the Collaborate installer is run in manual database setup mode, an SQL file is created in the <Collaborate_Home>/tools directory. The SQL file is provided for manual review before you run on the Collaborate database. If this file is not created because of any installation errors, you can create this SQL by using the udmdbsetup.sh tool. Complete the following tasks if you select manual database setup, or if the automatic database setup failed during installation:

Procedure

  1. Open the <Collaborate_Home>/tools directory.
  2. Set the JAVA_HOME and DBDRIVER_CLASSPATH parameters if they are not already set.
  3. Run the udmdbsetup.bat or udmdbsetup.sh file, in the <Collaborate_Home>/tools directory. Follow the instructions for the installation type: new installation, reinstallation, or upgrade.

Example

For a new installation or a reinstallation:

The name of the file is udm_install_[12.1.x.x].sql.

Run udmdbsetup by using the full installation parameter. Use the correct parameter values for your locale and installation type. The following example creates and populates the Collaborate system tables for a new installation on Windows™ in the en_US locale: udbmdbsetup.bat -L en_US -t full -v.

If you want to configure Collaborate for a locale other than en_US, run the udmdbsetup utility for different locales, such as fr_FR, de_DE, and so on.

If you are upgrading Collaborate:

The name of the file is udm_upgrade_[10.1.x.x]_[11.0.0.0].sql. Before you run udmdbsetup.sh, you must the run database parameters in udm_jdbc.properties, which is in the <Collaborate_Home>/tools directory.

Run udmdbsetup.sh by using the upgrade parameter. Use the correct parameter values for your locale, installation type, and the version you are upgrading from. The following example creates the SQL file for an upgrade from version 10.x on UNIX™ in the fr_FR locale: ./udmdbsetup.sh -m -b 10.1.x.x -L fr_FR -tupgrade -v.

Note: The -m option does not run the script on the database automatically.

To automatically run the script on the database, you can run the following command: ./udmdbsetup.sh -b 10.1.x.x -L fr_FR -tupgrade -v.

If you run this command for the first time, an extra parameter must be added: -E. This parameter encrypts the password of the database user and successfully runs the script.