Installing the Stored Procedure for DB2

Procedure

  1. 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
  2. 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
  3. Execute the command:
    db2 -td/ -f /home/amx-bpm/temp/ec_delete_audit_stats_data_db2.sql