Installing the Stored Procedure for DB2
Procedure
- Copy the stored procedure file ec_delete_audit_stats_data_db2.sql to a temporary location on the server. For example, copy the file to /home/amx-bpm/temp/ec_delete_audit_stats_data_db2.sql
-
Open the DB2 Command Window and login with the BPM user credentials.
db2 CONNECT TO database_name USER user_name USING password, where
database_name is the database you wish to connect to (for example: amxbpm),
user_name is the user under which the ActiveMatrix BPM schema is installed (for example: bpmuser),
password is the password for the user.
For example, login using:
db2 CONNECT TO amxbpm USER bpmuser USING mypassword
-
Execute the command:
db2 -td/ -f /home/amx-bpm/temp/ec_delete_audit_stats_data_db2.sql
Copyright © 2022. TIBCO Software Inc. All Rights Reserved.
