IBM DB2 stored procedures
The following procedures install eight Stored Procedures and one User Defined Function (UDF) into your database. These procedures should be performed by your DB2 DBA.
Note: DB2 Stored Procedures are supported on DB2 LUW
(Linux, Unix and Windows) on versions 9.1 or greater.
Note: If multiple databases are used (for example, test and production
databases), repeat these steps for each database.
If the stored procedures were previously installed with DB2 Data Studio, you may have stored procedures already defined, but named with a lowercase letter. If so, delete these stored procedures manually using the DB2 Control Center before continuing with this procedure. Delete the user defined function: TMGR_TS_FMT, as well as the following stored procedures:
eDF_INCREMENTMSG
eDF_INCREMENTUNB
gETSTAMP
iNCREMENTST
iNCREMENTISA
iNCREMENTGS_BY_TP
iNCREMENTGS_BY_FID
iNCREMENTGS_BY_AP
Preparation
Before you begin, make certain
that you have the following software: DB2 Command Editor, DB2 Control
Center (if required), and DB2 database, version 9.1 or greater. Make
sure of the following conditions before installing stored procedures:
- Make certain that no Trading Manager activity is taking place during the installation process. It is suggested that you back up your database.
- Obtain the user id and password for the user that connects to the database in the Trading Manager maps. See update.mdq. That user should be used to create these objects. If that user does not have create permission, it will require that GRANT EXECUTE statements be issued on all objects created here. Contact your DBA for assistance.
- If the stored procedures and the User Defined Function already exist from a prior version or were created using Developer Workbench, delete them from the Control Center, or with the DROP statements defined later in this procedure.