Installing and configuring Process Server with an SQL Server database server

Process Server provides a single BPM runtime environment that can support a range of business processes for development, test, staging, or production.

1. Optional: If you are connected to the Internet, the typical installation upgrades your product to the latest fix pack or refresh pack level and recommended interim fixes automatically. If you want these upgrades to be installed from a local directory instead, or if you want to specify the fix level, you can use a properties file to tell the Installation Manager where to find the upgrades and which upgrades to install.
   Create the following file:

   • /user_home_directory/bpm_updates.properties
   Note: Ensure that you have read/write access to the folders specified in the bpm_updates.properties file.
   The file uses three prefixes: ifix, fixpack, and launchpad. Each prefix must be followed by a dot. The part of the name after the prefix and the dot can be anything you want, which enables you to point to multiple locations for ifixes, fix packs, and launchpad upgrades. The locations can be either local directories or URLs. For example:

   ifix.1=/bpmUpdates
   fixpack.2=http://test/rep
   launchpad.1=/launchpad_updates
   fixpack.WAS_REP=/WAS_updates
   fixpack.BPM_REP=/BPM_updates

2. Access the media in one of the following ways, depending on whether you are installing from the product DVD or from images downloaded from Passport Advantage®. You can run only one launchpad at a time.
   • If you are installing from the product DVD, insert the product disk labeled IBM Business Process Manager Advanced into the disk drive. Mount the disk drive if necessary. Enter the following command to start the launchpad manually:
     • mount_point/launchpad.sh
   • If you are installing from images downloaded from Passport Advantage, perform the following steps:
     1. Go to the directory into which you extracted the images.
     2. Enter the following command to start the launchpad:
        • extract_directory/launchpad.sh
3. Optional: If you see a message that prompts you to update the launchpad, click Update to receive the latest updates. The updates are installed and your launchpad is restarted automatically. If you do not have access to the Internet and want the updates to be installed from a local directory, you can use a properties file with the appropriate launchpad prefix as described in step 1 to tell the Installation Manager where to find the upgrades and which upgrades to install.
4. After starting the launchpad, click Typical installation on the Welcome page.
5. Select Install Process Server and click Next.
6. Specify Process Server information:
   • Hostname: This field shows the name of your machine.
   • Location: Enter the installation location for Process Server or click Browse to select the location.
     Note:

     • The installation location must either be an empty directory or a directory that does not exist and is created during installation.
     • Because you are installing DB2 Express, your installation location cannot contain National Language Strings (NLS).
   • Environment Type: Select how the Process Server is used:
     • Select Development if the server is to be used in a development capacity.
     • Select Production if the server is to be used in a production capacity.
     • Select Stage if the server is to be used as a temporary location to host changes before putting them into production.
     • Select Test if the server is to be used as a testing environment, for example, for load testing.
   • Name: Specify the name for the Process Server environment. This name is used to connect from a Process Center to this Process Server.
     Restriction: Do not mix production and non-production servers in the same cell.
   • Specify the Username and Password for the cell administrative account. The cell administrator is the primary WebSphere® Application Server administrator. A user assigned to this role can assign other administrator roles, and is responsible for the administration of the cell and topology. A user assigned to this role is not responsible for the administration of the IBM Business Process Manager components. This role provides access to all interfaces, enabling users to alter or delete all types of available library items and assets, including process applications and toolkits. This role also enables administration of Process Servers, Performance Data Warehouses, and internal users and groups. You must be a user assigned to this role to deploy Process Applications on the Process Center server.
   • Specify the Username and Password for the deployment environment account. The deployment environment administrator is the primary IBM Business Process Manager administrator. A user assigned to this role has administrative access to Process Center and Process Admin Console. This role provides access to all interfaces, enabling users to alter or delete all types of available library items and assets, including process applications and toolkits. This account also enables administration of Process Servers, Performance Data Warehouses, and internal users and groups.
   Select Use this server offline if this Process Server will not be connected to a Process Center. Offline servers can still be used when deploying snapshots of process applications, but the method for deploying process applications to an offline Process Server differs from the method for deploying process applications to an online Process Server.
   If you did not select Use this server offline, provide the following information for the Process Center that this server is to connect to:

   • Hostname: Enter the host or virtual host that this Process Server will use to communicate with Process Center. Use a fully qualified host name. In an environment with a load balancer or proxy server between the Process Server and the Process Center services, make sure that what you designate here matches the URL for accessing the Process Center.
   • Port: Enter the port number of the Process Center. In an environment with a load balancer or proxy server between the Process Server and the Process Center, make sure that what you designate here matches the URL for accessing the Process Center.
   • User name: Enter the name of a Process Center user. Process Server will connect to Process Center as this user.
   • Password: Enter the password for the Process Center user.
   You can click Test Connection to check the connection to the Process Center.
7. Specify the Username and Password for the cell administrative account. The cell administrator is the primary WebSphere Application Server administrator. A user assigned to this role can assign other administrator roles, and is responsible for the administration of the cell and topology. A user assigned to this role is not responsible for the administration of the IBM Business Process Manager components. This role provides access to all interfaces, enabling users to alter or delete all types of available library items and assets, including process applications and toolkits. This role also enables administration of Process Servers, Performance Data Warehouses, and internal users and groups. You must be a user assigned to this role to deploy Process Applications on the Process Center server.
8. Click Next.
9. Select Yes to use an existing database.
10. Specify the required database information.

    Table 1. Required database configuration fields for SQL Server

    Field	Action needed
    Username	Only required if you are not using Windows authentication. Enter the user name to authenticate with the database. Restriction: User names must not contain National Language Strings (NLS).
    Password	Only required if you are not using Windows authentication. Enter a password to authenticate with the database.
    Select the Apply Windows authentication option to indicate that you will connect to your databases using your Windows authentication information. If you select this option, the previous fields are made inactive.
    Hostname	Accept the default value of localhost or enter the correct database server host name. For example, the IP address.
    Port	Accept the default value of 1433 or enter the correct server port number.
    Common database name	Accept the default value of CMNDB, or enter the name for the Common database.
    Process database name	Accept the default value of BPMDB, or enter the Process database name.
    Performance Data Warehouse database name	Accept the default value of PDWDB, or enter the Performance Data Warehouse database name.
    Cell only configuration database	Accept the default value of CMNDB, or enter the name for the cell-scoped Common database. This database is applicable only in case of an Advanced or Advanced-Only Deployment Environment.

11. Click Next to continue. You are prompted to provide your IBM ID and password to connect to the IBM service repositories.
    Note: If you are using a local properties file, you do not need to provide your IBM ID and password.

    The connection to the service repositories is required to download and install any fix packs and required interim fixes from the Internet, including fixes for WebSphere Application Server and IBM Business Process Manager. An IBM ID and password can be obtained by registering at http://www.ibm.com.

    Click Cancel to continue installing without downloading the required fixes from the Internet or clear the Use your support account to include updates with the installation option on the Installation summary page.

    After successfully installing the product, you can use Installation Manager to install the required fixes.

12. On the Installation summary page, verify the installation options and read the license agreements. If you agree to the terms of the license agreements, click I have read and accepted the license agreement and notices.
13. Click Install Software.