Configuring the Archive Database
To use non-partitioned archiving, you must define the Archive database.
The following instructions provide a high level overview of the steps for creating the Archive database. For complete instructions, see “Creating and Dropping Database Components” in Installing Software AG Products.
To configure data archiving
1. Using the Database Component Configurator, create the Archive database for the Process Audit schema.
a. In the Action section, select the following values:
Field | Properties |
Action Type | Create |
Action Component | Archive |
Version | Latest |
b. In the Connection section, define the connection to your Archive database.
Field | Properties |
RDBMS | Select the database provider. The Process Audit and Archive databases must be of the same type. |
URL | Database URL. |
User ID | The name of the database user account. This must be a new user and have sufficient privileges to access both the source and target Process Audit database. |
Password | The password for the database user account. |
c. In the Create Database and Database User section, define the database Administrator.
Field | Properties |
Admin ID | Add the Archive database administrator. |
Admin Password | Password for the Archive database administrator. |
Database | Name of the Archive database, for example, wmProcessAuditArchive. |
d. Click Execute.
2. In the Database Administration console, assign to the database user the appropriate permissions for the tables in the Archive and Process Audit database.
3. Connect the Archive database to an Integration Server. For complete instructions on connecting Integration Server to a database, see the section on configuring databases in webMethods Integration Server Administrator’s Guide.
4. Define a new JDBC connection pool alias settings.
a. In Integration Server Administrator, click Settings > JDBC Pools.
b. In Pool Alias Definitions, click Edit.
c. Add the URL, user ID and password to match the Connection settings defined in the Database Component Configurator and click Save Settings.
5. Define the JDBC pools for the Archive database.
a. In Integration Server Administrator, click Settings > JDBC Pools.
b. In Functional Alias Definitions, click Edit for Archiving.
c. In Associated Pool Alias, select the alias and click Save Settings.
d. Click Restart.
6. Configure the default archiving parameter in the OPERATION_PARAMETER table.
a. In Designer, run the pub.monitor.archive:setOperationParameters service. pub.monitor.archive:setOperationParameters sets the values you specify in the OPERATION_PARAMETER table of the Archive database.
b. Specify the input parameters listed in the following table.
Parameter | Entry |
PROCESS_SCHEMA | To archive data from the Process Audit Log tables, specify the following information for your database provider:  Oracle: Process Audit Log database user SQL Server: Process Audit Log database name DB2: Process Audit Log schema name |
ISCORE_SCHEMA | To archive data from the IS Core Audit Log database, specify the following: Oracle: IS Core Audit Log database user SQL Server: IS Core Audit Log database name DB2: IS Core Audit Log schema name |
DBO_PROCESSES | Boolean Optional. Determines whether Dynamic Business Orchestrator processes are archived. Valid values are: TRUE. Dynamic Business Orchestrator processes are archived. FALSE. Default. Process Engine processes are archived. |
DBO_PROCESS _STATUS | String Optional. When the value of the DBO_PROCESSES parameter is set to TRUE, the value of this parameter determines the statuses of the process data that services use to archive the Dynamic Process Orchestrator process data. Dynamic Process Orchestrator process data in other statuses is retained in the IS Core Audit Log and Process Audit Log database components. Valid values are: 102. Default. Completed Dynamic Process Orchestrator processes. 103.Default. Cancelled Dynamic Process Orchestrator processes. 104. Default. Terminated Dynamic Process Orchestrator processes. Note: The criteria values of this parameter are separated by commas. |
7. Set database permissions to give the Archive database user permissions to select and delete data from the IS Core Audit Log tables, the Process Audit Log tables, or both, depending on the data you want to archive. To do so, execute the following SQL statement:
GRANT SELECT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE, INSERT ANY TABLE
Verify that the database user has the required permissions for the Archive tables.