Installing the Stored Procedure for DB2

Procedure

  1. Copy the stored procedure file to a temporary location on the server, for example: /home/amx-pm/temp/ec_delete_non_instance_audit_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: db2 CONNECT TO amxbpm USER bpmuser USING mypassword

  3. Execute the command 
    db2 -td/ -f /home/amx-pm/temp/ec_delete_non_instance_audit_data_db2.sql