Setting Up a Common Repository Database - spectrum_platform - 23.1

spectrum-inline

Product type
Software
Portfolio
Enrich
Integrate
Locate
Verify
Product family
Spectrum
Product
Spectrum > Quality > Context Graph
Spectrum > Discovery
Spectrum > Web Services
Spectrum > Spatial > Spectrum Spatial
Spectrum > Quality > Addressing
Spectrum > Dataflow Designer
Spectrum > Geocoding > Enterprise Tax
Spectrum > Data Integration
Spectrum > Quality > Spectrum Quality
Spectrum > Spectrum Platform
Spectrum > GeoEnrichment
Version
23.1
Language
English
Product name
Precisely Spectrum
Title
spectrum-inline
First publish date
2007

You must configure Spatial to use a common repository database for the cluster. This ensures that named resources, geographic metadata and configuration settings are managed across the cluster.

The repository is installed with a set of named resources, geographic metadata and configuration files. To migrate these resources to the common database repository the resources need to be exported from the default internal repository database and reimported into the new shared repository database.

For bulk export and import of repository content, use the limrepo import and limrepo export commands in the Administration Utility. These commands give you the option of preserving permissions (see the Administration section of the Guide for instructions.)

These steps describe how to set up your repository on a common database, either PostgreSQL, Oracle, or Microsoft SQL Server:

  1. Export all repository resources to a local folder using the limrepo export command in the Administration Utility.
    For instructions, see the Administration section of the Guide.
    The contents of the installed repository must be exported. This step only needs to be performed once, as the contents of the repository should be the same at this point for all instances of Spectrum Technology Platform.
  2. Stop the Spectrum Technology Platform server on all nodes.
    For instructions, see Stopping a Cluster.
  3. On all nodes of the Spectrum Technology Platform modify the configuration to specify the common database.
    1. Copy the contents of repository.databaseType.xml to repository.xml located under the server/modules/spatial/jackrabbit folder where databaseType is the appropriate type for your database (postgres, oracle, or mssql).
    2. In repository.xml:
      • Modify the DataSource section with the server host name, port, database, user, and password.
      • Modify the Cluster section to assign a distinct cluster ID, like Node1. Ensure unique IDs are assigned to every subsequent node in the cluster (for example, Node2, Node3).
      • Save the changes to repository.xml.
    3. Remove these folders from the /server/modules/spatial/jackrabbit folder: repository, version, workspaces.
  4. If your database has previously contained any repository content, you must remove these tables to create a clean repository:
    • default_binval
    • default_bundle
    • default_names
    • default_refs
    • rep_fsentry
    • rep_global_revision
    • rep_journal
    • rep_local_revisions
    • security_binval
    • security_bundle
    • security_names
    • security_refs
    • version_binval
    • version_bundle
    • version_names
    • version_refs
    If using Oracle, then also delete version_seq_names_id, security_seq_names_id, and default_seq_names_id.
  5. On the seed node only, import the backed up repository content.
    1. Start the Spectrum Technology Platform server.
      For instructions, see Starting a Cluster.
    2. Import the contents using the limrepo import command, pointing to the seed node.
  6. Start the remaining nodes in the cluster.
    For instructions, see Starting a Cluster.