Adding tables to the runtime database

Before you begin

Verify the following:

Why and when to perform this task

If you need to add tables to the Business Process Choreographer runtime database, for example, the table for an entity bean in your application, you can use the runDllFile.jacl script that runs a DDL file on the database.

Steps for this task

  1. Change to the Business Process Choreographer utilities directory where the scripts are located.
    On Windows systems, enter:
    cd install_root\ProcessChoreographer\util
    On UNIX and Linux systems enter:
    cd install_root/ProcessChoreographer/util
  2. Add the tables to the database.

    On Windows systems, enter one of the following commands:

    install_root\bin\wsadmin -f runDdlFile.jacl 
                             -server serverName 
                             -filename ddlFile
    install_root\bin\wsadmin -f runDdlFile.jacl 
                             -node nodeName 
                             -server serverName 
                             -filename ddlFile
    install_root\bin\wsadmin -f runDdlFile.jacl 
                             -cluster clusterName 
                             -filename ddlFile

    On UNIX and Linux systems, enter one of the following commands:

    install_root/bin/wsadmin -f runDdlFile.jacl 
                             -server serverName 
                             -filename ddlFile
    install_root/bin/wsadmin -f runDdlFile.jacl 
                             -node nodeName 
                             -server serverName 
                             -filename ddlFile
    install_root/bin/wsadmin -f runDdlFile.jacl 
                             -cluster clusterName 
                             -filename ddlFile

    Where:

    clusterName
    The name of the cluster. Required if the business process container is configured for a WebSphere cluster.
    nodeName
    Optional when specifying the server name. This name identifies the node. The default is the local node.
    serverName
    The name of the server. Required if the cluster name is not specified.
    ddlFile
    The name of a DDL file that is local to the application server.

Result

The staff assignments that belong to this process template are refreshed.