Installing Universal Addressing Module Databases

This procedure describes how to install databases used by Get Candidate Addresses, Get City State Province, Get Postal Codes, Validate Address, and Validate Address AUS. For instructions on installing databases used by Validate Address Global, see Installing Validate Address Global Databases. For instructions on installing databases used by Validate Address Loqate, see Installing Validate Address Loqate Databases.

Note: If you have Oracle environment variables set in your profile, these environment variables may interfere with DVD database loading processes. If you experience database loading problems and are using Oracle, check that the Oracle environment variables are not active when you perform the DVD database loads.
  1. Download the database from the Pitney Bowes Software eStore using the link provided in the release announcement or welcome email. You can also download the database from the Pitney Bowes technical support web site.
  2. The database is downloaded as a zip file. Unzip the database before proceeding with the installation.
  3. Change the working directory to the bin directory of where Spectrum™ Technology Platform is installed.
  4. Source the "setup" bourne shell script to set up the environment by typing the following command:
    . ./setup
  5. Execute the script for installing the database by typing the following command:

    ./installdb_unc

  6. Follow the prompts as the script verifies your environment and database location.
    Note: You may install databases on a network share, but performance will be affected since you will be accessing them on a network rather than accessing them locally.
  7. If you choose to install Residential Delivery Indicator, an optional database that you license directly from the U.S. Postal Service, you are prompted for the nine-digit RDI table and the eleven-digit RDI table. These are the .R9 and .R11 files provided from the U.S. Postal Service.