upgradeProcessData command-line utility

The upgradeProcessData command upgrades previous versions of the Process Server and Performance Data Warehouse database schemas and data to the current version of IBM® BPM.

Synopsis

upgradeProcessData [parameters]

Description

The upgradeProcessData command updates the following items in the database to IBM BPM V8.0.1:
  • System Data toolkit
  • Process Portal process application
  • Hiring Sample tutorial process application
The Messaging Engine database tables are deleted.

If you are migrating from Teamworks 7.0.0 or 7.0.1, the upgradeProcessData command converts encrypted passwords to work with the encryption algorithm used by IBM BPM V8.0.1. Encrypted passwords may be stored in the database for users defined through the internal security provider, for secure web service integrations, or for Microsoft® SharePoint integrations.

The upgradeProcessData command is located in the install_root/BPM/Lombardi/tools/upgrade/UpgradeProcessData directory. It derives the database information from the datasource configured for the Process Server, the Performance Server, and the corresponding messaging engine data store to connect and update the database. Before running the command, make sure that the servers and cluster members are stopped.

In a network deployment environment, use one of the node names and the cluster member name for the parameter values. You need to run the upgradeProcessData command only once, even if you have multiple nodes and cluster members. Run the command from the deployment manager machine after upgrading the profiles and clusters. The status of the deployment manager does not affect the command.

The logs are saved under the install_root/profiles/PROFILE_NAME/logs directory. PROFILE_NAME is the value that you specified for the -profileName parameter. If you did not specify this parameter, PROFILE_NAME is the default profile of the IBM BPM installation. The log file name contains the name of the tool as the prefix and the timestamp of the current time. If you set the -nodeName and -serverName parameters, these are part of the log file name.

Parameters

-profileName
This parameter is optional, and should be used if you want to run the upgrade against a profile that is different from the default profile for your environment. Specify the name of the profile that you want to use.
-nodeName
This parameter is required for network deployment environments. The upgrade command fails if you do not specify this parameter and the -serverName parameter in network deployment environments. Specify the node name in your network deployment environment.
-serverName
This parameter is required for network deployment environments. The upgrade command fails if you do not specify this parameter and the -nodeName parameter in network deployment environments. Specify the server name in your network deployment environment.
-perfNodeName pdw_node_name
The name of any Performance Data Warehouse cluster node. This parameter is required if Performance Data Warehouse is configured on a different cluster.
-perfServerName pdw_server-name
The name of any member of the Performance Data Warehouse cluster on the node specified by pdw_node_name. This parameter is required if Performance Data Warehouse is configured on a different cluster.
-noPrompt
Set the optional -noPrompt parameter to make the tool run without prompting you with a confirmation message.
-help
Provides the command usage.
This topic applies only to the Distributed platforms

Examples

Upgrade a stand-alone profile database:
  • For Linux operating systemFor UNIX operating system upgradeProcessData.sh -profileName procServ1
  • For Windows operating system upgradeProcessData.bat -profileName procServ1
Upgrade the database in a network deployment environment where Process Server and Performance Data Warehouse are configured on the same server or cluster member:
  • For Linux operating systemFor UNIX operating system upgradeProcessData.sh -profileName procServ1 -nodeName Appnode1 -serverName AppClustermember
  • For Windows operating system upgradeProcessData.bat -profileName procServ1 -nodeName Appnode1 -serverName AppClustermember
Upgrade the database in a network deployment environment where Process Server and Performance Data Warehouse are configured on different servers:
  • For Linux operating systemFor UNIX operating system upgradeProcessData.sh -profileName procServ1 -nodeName Appnode1 -serverName AppClustermember -perfNodeName suppNode -perfServerName suppClusterMember
  • For Windows operating system upgradeProcessData.bat -profileName procServ1 -nodeName Appnode1 -serverName AppClustermember -perfNodeName suppNode -perfServerName suppClusterMember