Adding process installation settings

You can add data definition language (DDL) statements that perform preparation tasks during process installation and cleanup statements when the process is removed.

For example, during process installation you might want to increase the buffer pool size of a DB2® data source containing the business data. Conversely, DDL statements performing cleanup tasks can be run when the process is removed, for example, the buffer size might be reset to the default size.

To add process installation cycle settings:

  1. Click the canvas to see the process related properties.
  2. Click the Information Service Support tab in the properties area of the process editor.
  3. Add a new data source.
    1. Enter the display name and the Java™ naming and directory interface (JNDI) name.
    2. Select Preparation or Cleanup statement under the new data source and click New Statement to enter your own SQL statement in the editor.

(C) Copyright IBM Corporation 2006. All Rights Reserved.