Move from Single-Schema Mode to Multischema Mode

About this task

When installing Sterling Selling and Fulfillment Foundation, the GUI and text-based installation processes prompt for whether you are installing a multischema deployment and, depending on your responses, set up multischema mode for you. When installing by a silent installation file, you must specify the multischema properties necessary if you want a multischema deployment, as described in the Sterling Selling and Fulfillment Foundation: Installation Guide.

If you are upgrading to Release 9.2, both single-schema and multischema upgrade modes are supported. You must be running a multischema deployment before you can upgrade in multischema mode. For more information about upgrading in single-schema and multischema modes, refer to the Sterling Selling and Fulfillment Foundation: Upgrade Guide.

To move from a single-schema deployment to a multischema deployment:

Procedure

  1. In the sandbox.cfg file, set the following properties:
    multischema.enabled=true
    multischema.version=9.2
  2. After editing sandbox.cfg, run the setupfiles script so that the runtime property files are re-created with the updated values:

    (For UNIX or Linux) <INSTALL_DIR>/bin/setupfiles.sh

    (For Windows) <INSTALL_DIR>/bin/setupfiles.cmd

    The Metadata, Configuration, Transaction, and Statistics schemas are automatically set up for you.

  3. Run the Colony Map Synchronizer agent, as described in the “Time-Triggered Transaction Reference” chapter in the Sterling Selling and Fulfillment Foundation: Distributed Order Management Configuration Guide. This agent inserts or updates colony mappings of organizations and users in the PLT_COLONY_MAP table.
    Note: When you run the agent for the first time, it populates the PLT_COLONY_MAP table. Initially, you must run the agent on the DEFAULT colony that is part of the Sterling Selling and Fulfillment Foundation installation. After completing these steps with the DEFAULT colony, you can complete them on other colonies.
  4. Rebuild and deploy the EAR, as described in the Sterling Selling and Fulfillment Foundation: Installation Guide.
  5. Once you have completed the previous steps, you can add colonies using the ManageColony tool, as described in Introduction to Managing Colonies.