Creating and populating the Distributed Marketing system tables

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

About this task

When the Distributed Marketing installer is run in manual database setup mode, an SQL file is created in the <DistributedMarketing_Home>/tools directory. The SQL file is provided for manual review before you run on the Distributed Marketing 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 <DistributedMarketing_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 <DistributedMarketing_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_[10.x.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 Distributed Marketing 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 Distributed Marketing 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 Distributed Marketing:

The name of the file is udm_upgrade_[10.x.x.x]_[10.x.x.x].sql. Before you run udmdbsetup.sh, you must the run database parameters in udm_jdbc.properties, which is in the <DistributedMarketing_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.x.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.x.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.