Installing DB2 stored procedures

Edit online

The following procedure installs stored procedures and one User Defined Function (UDF) into your database. These procedures should be performed by your Database Administrator.

Procedure

  1. Connect to the database using the Command Editor. Use the same user id and password specified in update.mdq.
  2. Set statement terminator to @ in Command Editor (at the bottom of the screen).
  3. Set the Command Editor option to Stop Execution on Error (Tools > Tools Settings > Command Editor).
  4. Open the SQL File, DB2V9TMSP.SQL in an editor and change the connect statement to the user id and password assigned in Trading Manager's update.mdq, as described in the Preparation steps. DB2V9TMSP.SQL is located in the install_dir/tmgr_dir/pmgr/sql directory, where install_dir indicates the installation location of the core WebSphere Transformation Extender product and tmgr_dir indicates the location of Trading Manager.
  5. Copy the changed SQL file and paste into the Command Editor and execute. If any errors are reported, contact your Database Administrator and/or IBM support.
  6. The SQL file contains a suggested test call that can be run at this point.
  7. To use the stored procedures in Trading Manager, set Use Stored Procedures in Partner Manager: Utilities > Message Manager Config > Database tab