Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Pre-Upgrade Tasks
  4. Database Tasks
  5. Application Server Tasks
  6. Hub Store Upgrade
  7. Hub Server Upgrade (In-place Upgrade)
  8. Process Server Upgrade (In-place Upgrade)
  9. Resource Kit Upgrade (In-place Upgrade)
  10. Post-Upgrade Tasks
  11. Search Configuration Upgrade
  12. ActiveVOS Post-Installation Tasks for the Application Server
  13. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  14. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  15. Troubleshooting the Upgrade Process
  16. Frequently Asked Questions
  17. Processing Existing ActiveVOS Tasks
  18. Configuring Metadata Caching

Upgrading from Version 9.7.1

Upgrading from Version 9.7.1

Enabling Match Population

Enabling Match Population

You must enable the match population to use for the match rules.
  1. Copy the
    <
    population
    >.ysp
    files to the following location:
    On UNIX.
    <
    MDM Hub installation directory
    >/hub/cleanse/resources/match
    On Windows.
    <
    MDM Hub installation directory
    >\hub\cleanse\resources\match
  2. In the C_REPOS_SSA_POPULATION metadata table, verify that the population is registered.
    The seed database for the MDM Hub installation has some populations registered in the C_REPOS_SSA_POPULATION table, but not enabled.
  3. If the C_REPOS_SSA_POPULATION table does not contain the population, add it to the table and enable it.
    The population name is the same as the ysp file name. For example, if the ysp file name is
    US.ysp
    , the population name is US.
    To add the population to an Operational Reference Store, use the following steps:
    On IBM DB2 or Oracle.
    1. Connect to the Operational Reference Store schema that you want to add the population to.
    2. In SQL*Plus, run the
      add_std_ssa_population.sql
      script in the following directory:
      On UNIX.
      <
      MDM Hub installation directory
      >/server/resources/database/custom_scripts/oracle
      On Windows.
      <
      MDM Hub installation directory
      >\server\resources\database\custom_scripts\oracle
    3. Answer the prompts described in the following table:
      Prompt
      Description
      Enter the population to add
      Name of the population.
      Enter a value for ROWID_SSA_POP (example: INFA.0001) DEFAULT [INFA.0001]
      Unique value for the ROWID_SSA_POP column of the C_REPOS_SSA_POPULATION metadata table. Default is
      INFA.0001
      The population is registered in the C_REPOS_SSA_POPULATION table.
    4. Run the following command to enable the population:
      UPDATE c_repos_ssa_population SET enabled_ind = 1 WHERE population_name = '<
      Your Population
      > '; COMMIT;
    On Microsoft SQL Server
    1. Run the
      add_std_ssa_population.bat
      script in the following directory:
      <
      MDM Hub installation directory
      >\server\resources\database\custom_scripts\MSSQL
    2. Answer the prompts described in the following table:
      Prompt
      Description
      Hostname with MSSQL instance for CMX_ORS DB ("localhost")
      Host name of the Microsoft SQL Server instance.
      cmx_ors user name ("cmx_ors")
      User name of the Operational Reference Store.
      cmx_ors user password
      Password of the Operational Reference Store.
      Enter the population name (Note: If you use Person_Name_Kanji for the Japan population or Japan_i population, add the suffix '_Kanji' to the end of the name) DEFAULT (" ")
      Name of the population.
      Enter a value for ROWID_SSA_POP (example: INFA.0001) DEFAULT (INFA.0001)
      Unique value for the ROWID_SSA_POP column of the C_REPOS_SSA_POPULATION metadata table.
      The population is registered in the C_REPOS_SSA_POPULATION table.
    3. Run the following command to enable the population:
      USE <
      Operational Reference Store user
      > GO UPDATE [dbo].[C_REPOS_SSA_POPULATION] SET ENABLED_IND = 1 WHERE POPULATION_NAME = '<
      population
      >'
  4. Restart the
    Process Server
    .
  5. Log in to the Hub Console to verify that the population is enabled.
    The population appears in the
    Match/Merge Setup
    user interface for base objects.

0 COMMENTS

We’d like to hear from you!