Table of Contents

Search

  1. Preface
  2. Introduction to Informatica RulePoint Installation
  3. Before You Install RulePoint
  4. RulePoint Installation
  5. After You Install RulePoint
  6. Start RulePoint
  7. Upgrade RulePoint
  8. Switch from SQL Database Server Authentication Mode to Windows Authentication Mode Overview

Installation and Upgrade Guide

Installation and Upgrade Guide

Step 1. Decommission the Topology and Schemas

Step 1. Decommission the Topology and Schemas

Before you upgrade from RulePoint version 6.1.1 to version 6.1.2, you need to decommission the topology instance and the schemas to prepare for the installation.
  1. Decommission the topology instance.
    • On Windows command prompt, run the following command from the
      <RulePoint installation directory>/bin
      directory:
      topology.bat decommission <Topology_Name>
      For example,
      c:\RulePoint_6.1.1\bin>topology.bat decommission Default
    • On Linux, run the following command:
      topology.sh decommission <Topology_Name>
      For example,
      /userhome/RulePoint_6.1.1/bin>topology.sh decommission Default
  2. Stop the RulePoint host-agent instance.
    • On Windows command prompt, run the following command from the
      <RulePoint installation directory>/bin
      directory:
      stopHostAgent.bat -h <host_ip_address> -p <port_number>
      For example,
      c:\RulePoint_6.1.1\bin>stopHostAgent.bat -h 10.10.10.10 -p 19000
    • On Linux, run the following command:
      stopHostAgent.sh -h <host_ip_address> -p <port_number>
      For example,
      /userhome/RulePoint_6.1.1/bin>stopHostAgent.sh -h 10.10.10.10 -p 19000
  3. Stop the RulePoint design-time instance.
    • On Windows command prompt, run the following command from the
      <RulePoint installation directory>/bin
      directory:
      design.bat stop
      For example,
      c:\RulePoint_6.1.1\bin>design.bat stop
    • On Linux, run the following command:
      design.sh stop
      For example,
      /userhome/RulePoint_6.1.1/bin>design.sh stop
  4. Run the following SQL commands to decommission the RulePoint schemas:
    delete from RULEPOINT_ACTIVITY.T_AM_ARTIFACT; delete from RULEPOINT_ACTIVITY.T_AM_ARTIFACT_HISTORY; delete from RULEPOINT_ACTIVITY.T_AM_EVENT; delete from RULEPOINT_ACTIVITY.T_AM_RESPONSE_EXECUTION_STATS; delete from RULEPOINT_ACTIVITY.T_AM_RULE_EXECUTION_STATS; delete from RULEPOINT_ACTIVITY.T_AM_RULE_TRACE; delete from RULEPOINT_ACTIVITY.T_AM_SOURCE_EXECUTION_STATS; delete from RULEPOINT_ACTIVITY.T_AM_TOPIC_STATS; delete from RulePoint_Design.DEPLOYPLAN_GROUPNAMES; delete from RulePoint_Design.DeploymentPlan; update RulePoint_Design.Artifact SET deployState = 0; delete from RulePoint_TopologyState.HA_SOURCE_STATE; delete from RulePoint_TopologyState.MARKER_SOURCE_STATE; delete from RulePoint_TopologyState.T_RPSERVER_DEPLOYMENT_PACKAGE; delete from RulePoint_TopologyState.T_RPSERVER_DEPLOY_SEQUENCE; delete from RulePoint_TopologyState.T_RPSERVER_FAILOVER; delete from RulePoint_TopologyState.T_RPSERVER_ARTIFACT_DEPLOY_LOC; delete from RulePoint_TopologyState.T_RPSERVER_ARTIFACT_REFERENCES; delete from RulePoint_TopologyState.T_RPSERVER_ARTIFACT; delete from RulePoint_TopologyState.T_RPSERVER_ARTIFACT_SHADOW; delete from RulePoint_TopologyState.T_RPSERVER_CONTROLLERS; delete from RulePoint_TopologyState.T_RPSERVER_GROUP_DETAILS; delete from RulePoint_TopologyState.T_RPSERVER_LEADER; delete from RulePoint_TopologyState.T_RPSERVER_CEPEU; delete from RulePoint_TopologyState.T_RPSERVER_UM_LBMRD; delete from RulePoint_TopologyState.T_RPSERVER_UM_STORES; delete from RulePoint_TopologyState.T_RPSERVER_SERVERS; delete from RulePoint_TopologyState.T_RPSERVER_NODE; delete from RulePoint_TopologyState.T_RPSERVER_TOPOLOGY; delete from RulePoint_TopologyState.HA_ENGINE_STATE;
  5. Delete the following folders from the RulePoint 6.1.1 installation directory:
    • stored.Default_UM-Store
    • lbmrd.Default_UM-Lbmrd
    • nodeagent_*
    • logs
    • felixcache_*

0 COMMENTS

We’d like to hear from you!