Table Of Contents

Running CEPM Scripts in DB2 Client

Running CEPM Scripts in DB2 Client

---

To run the pap.sql and pdp.sql scripts in the DB2 client, follow these steps:

---

Step 1 Open the DB2 Command Editor (for example, in the Windows environment, choose Start > Programs > IBM DB2 > Command line tools > Command Editor).

Step 2 In the Command Editor console, click Add to browse for the database target. The Specify Target window is displayed, which carries all the available database targets.

Step 3 Select the appropriate database.

Step 4 Uncheck the Use implicit credentials option. This prompts you to provide the database user credentials.

Step 5 Enter the database user ID and password and click OK. You are returned to the command editor console in which you can see a confirmation message regarding successful selection of the database target.

Step 6 Modify the Statement Termination Character to @ (default is ;).

Step 7 Choose Selected > Open in the menu to open the necessary script files. First open the pap.sql file in ...\CEPM-V3.3.0.0\scripts\db2 folder. Click OK. You can view the script in the console.

Step 8 Click the Execute button to execute the script.

You will get a confirmation message regarding the successful execution of the selected script.

You can execute the pdp.sql file in the same manner.