Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Postinstallation : Audit, Non-Repudiation and Runtime Database Configuration

Audit, Non-Repudiation and Runtime Database Configuration
When you initially set up TIBCO BusinessConnect, you provide connection information for a database.
Adding a Database Connection
To add and configure a new database connection, expand BusinessConnect > System Settings > Audit, Non-Repudiation and Runtime Database Configuration, and enter information as explained in Table 6.
Click Add to show the New Database Connection dialog.
See Table 7 for how to configure the parameters.
Note: After making any configuration changes to the database used for the configuration stores, redeploy the TIBCO BusinessConnect application.
You can request that TIBCO BusinessConnect not only log information about the transaction state but also include the actual message in the log. To include the message, select the Include Message in Log check box under BusinessConnect > System Settings > Audit, Non-Repudiation and Runtime Database Configuration. The message is included in all entries where that is possible now.
Note: If you change the value of the Include Message in Log check box, you must restart the TIBCO BusinessConnect server to pick up the change.
Select from the list to manage any of the following: bc-db (the initial database connection), None, or any other configured database connection.
First select from the Target Table Type list, and then either export the database table schemas, or drop and recreate them.
Select from the Target Table Type list:
Click Export to perform the following operations:
Export Audit Schema  Select Audit Log in the Target Table Type list, and then click Export to export the Audit Schema, such as audit.sql.
Export NR Schema  Select Non-Repudiation Log in the Target Table Type list, and then click Export to export the non-repudiation schema, such as nr.sql.
Export Runtime Schema  Select Runtime Data Store in the Target Table Type list, and then click Export to export the Runtime schema, such as runtime.sql.
Click Create to perform the following operations:
Create Audit Tables  Select Audit Log in the Target Table Type list, and then click Create to drop all Audit tables and recreate them. During this process all existing Audit data is lost.
Create NR Tables  Select Non-Repudiation Log in the Target Table Type list, and then click Create to drop all Non-repudiation tables and recreate them. During this process all existing Non-repudiation data is lost.
Create Runtime Tables  Select Runtime Data Store in the Target Table Type list, and then click Create to drop all Runtime tables and recreate them. During this process all existing Runtime data is lost.
Editing a Database Connection
To edit the database connection, enter information as explained in Table 7.
Note: To learn about Oracle client library path, see Oracle Client Library Path Usage.
Note: For better performance, database pool size for audit logging should be at least the same as the number of the TIBCO ActiveMatrix BusinessWorks engine threads configured for deployment.
Click Save. The details are saved.
Click Test Connection.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved