This topic applies only to the IBM Business Automation Workflow Advanced
configuration.

Configuring Business Process Archive Manager

The Business Process Archive Manager is an optional component that lets you reduce the size of the Business Process Choreographer database by moving completed BPEL process instances and human tasks to a separate archive database. To configure a Business Process Archive Manager, you must add entries to the properties file before you create the deployment environment.

About this task

To configure the Business Process Archive Manager, you can either update the properties file to include it before you create the deployment environment, or you can update the deployment environment later using the BPMConfig -upgrade -de -component command.

You can configure the Business Process Archive Manager only on the support cluster of a three-cluster topology of an Advanced or AdvancedOnly deployment environment. When you configure the Business Process Archive Manager, a Business Process Archive Explorer is also configured.

Procedure

If you are updating your deployment environment to add the Business Process Archive Manager, ensure that the configuration properties file correctly reflects the topology of the IBM BPM deployment environment by exporting the configuration properties file using the BPMConfig command.
- On Microsoft Windows operating systems, run the following BPMConfig.bat command:
```
install_root\bin\BPMConfig.bat -export -profile deployment_manager_profile_name [-de deployment_environment_name] -outputDir path_to_configuration_files
```
- On Linux and UNIX-based operating systems, run the following BPMConfig.sh command:
```
install_root/bin/BPMConfig.sh -export -profile deployment_manager_profile_name [-de deployment_environment_name] -outputDir path_to_configuration_files
```
The configuration properties file is named deployment_environment.properties (where deployment_environment is the name of the deployment environment). The file is located in the output directory that you specify when you run the command.
Note: If there is only one deployment environment in the WebSphere cell, you can omit the -de option.
Open your deployment environment properties file in an editor.
Tip: For more information about possible keys and values for the BPCArchive component, see the appropriate properties file.
- install_root/BPM/samples/config/advanced/Advanced-PC-ThreeClusters-DB2.properties
- install_root\BPM\samples\config\advanced\Advanced-PC-ThreeClusters-DB2.properties
Add the archive database to the support cluster.
For example, if cluster 3 is the support cluster, add an entry that is similar to the following example:
```
bpm.de.cluster.3.db=PerformanceDb,ArchiveDb
```
Add the definition of the archive database.
For example, for a DB2 database named BPARCDB, if the next free database index is 5, add entries that are similar to the following example.
```
bpm.de.db.5.name=ArchiveDb
bpm.de.db.5.dbCapabilities=BPCArchive
bpm.de.db.5.type=DB2
bpm.de.db.5.hostname=localhost
bpm.de.db.5.portNumber=50000
bpm.de.db.5.databaseName=BPARCDB
bpm.de.db.5.schema=db2admin
bpm.de.db.5.roleMapping.1.name=DbUser
bpm.de.db.5.roleMapping.1.alias=BPM_DB_ALIAS
bpm.de.db.5.roleMapping.2.name=DbUserXAR
bpm.de.db.5.roleMapping.2.alias=BPM_DB_ALIAS
```
Tip: Because the purpose of the Business Process Archive Manager is to reduce the size of the runtime database, make sure that BPARCDB is a separate database from the database that Business Process Choreographer uses.
Create or update the deployment environment.
- If you are creating your deployment environment for the first time, after you make all your changes and update the properties file, run the BPMConfig -create command. For example:
```
BPMConfig -create -de DE1.properties
```
- If you are updating your deployment environment to add the Business Process Archive Manager, complete the following steps.
  1. Run the BPMConfig -upgrade -component BPCArchive command. You must run the command on the deployment manager node. The following example shows how to run the command:
```
BPMConfig -upgrade -de DE1.properties -component BPCArchive
```
    After you run the command, synchronize the nodes so that the managed nodes obtain the latest configuration file changes.
  2. Run the database script.
    1. The database script is in dmgr_profile_root/dbscripts_upgrade. The script is named createSchema_Advanced.sql.
    2. Copy the script to your database machine and run the script. For example:
```
db2 -tf createSchema_Advanced.sql
```
  3. Restart the deployment environment.

Results

The properties file includes the definitions that are used to configure a Business Process Archive Manager and a Business Process Archive Explorer on the support cluster. The Business Process Archive Manager is automatically configured and is ready to use in the deployment environment.