FileNet P8 Process Engine, Version 5.0.+              

Creating the connection to the Process Engine database silently

Create the connection to the Process Engine database after upgrading the Process Engine software and before upgrading the database.

Be sure that you have available the Installation and Upgrade Worksheet that was completed during your planning activities.

Create the connection to the Process Engine database after installation of the Process Engine 5.0 software. Edit a property file and before running the vwupgrade tool. In this task, you create a property file and run the commands to create and configure the virtual server and database. This step creates the vwserver.ini configuration file in the respective virtual server directory and, in a farmed configuration, copies the file to the virtual server directory on all nodes in the farm. This configuration file identifies basic database configuration information, including where the Process Engine database is located and how to log on to it.

To create the connection to the Process Engine database:

  1. Log on to the Process Engine server. Any user can create the input parameter files.
  2. Create the virtual server:
    1. Change the current directory to pe_install_path\data where pe_install_path is the location of the program files that was specified during the Process Engine installation.
    2. Make a copy of the PEInitV.properties.sample file and save it as PEInitV.properties.
    3. Using a text editor, edit the PEInitV.properties file by providing the parameter values for your configuration.
    4. Enter the parameters, one parameter per line in the following format:
      parameter name=value
      Parameter Description
      DBType Define the database type. Valid values are:
      • DB2
      • Oracle
      • MSSQL
      Enter the database type as defined by the DBType property in the worksheet. This parameter is required. You distinguish between DB2® for z/OS® and DB2 for Linux®, UNIX® and Windows® by using the DBVersion parameter.
      DBVersion This parameter is required for DB2 databases, and valid values are:
      • DB2LUW
      • DB2zOS
      DBName Enter the name of the Process Engine database that is defined by the DBName property in the worksheet. This parameter is required. If you are using the PEInitV.properties file, set DBName to the DB2 for z/OS instance name.
      DBHost Enter the server host name where the Process Engine database resides. The host is identified by the DBHost property in the worksheet. If the parameter is not provided, the default value is localhost. This parameter is not required if you provide the DBConnectURL. If the default URL format is not acceptable, enter the DBConnectURL instead of the DBHost and DBPort in the PEInitV.properties file.
      DBPort Enter the value for the database port as identified by the DBPort property in the worksheet. Default values are:
      1433
      The default value for an SQL Server database instance. The port number is used to identify the SQL Server instance, and the instance name is not required in the configuration parameters.
      60000
      The default port number for a DB2 database.
      1521
      The default port number for an Oracle database.
      If no alternative port is identified, the default value for the port is assigned. This parameter is not required if you provide the DBConnectURL. If the default URL format is not acceptable, enter the DBConnectURL instead of the DBHost and DBPort in the PEInitV.properties file.
      DBConnectURL This parameter is the optional database connection URL to be used to configure the database connection. Use this URL or use the DBHost and DBPort. If you specify the DBHost and DBPort, the DBConnectURL is automatically created for SQL Server, DB2, and Oracle databases as follows:
      • jdbc:sqlserver://DBhost:DBport;DatabaseName=DBName
      • jdbc:db2://DBhost:DBport/DBName
      • jdbc:oracle:thin:@DBhost:DBport:DBName
      If the default URL format that is specified is not acceptable, enter the DBConnectURL instead of the DBHost and DBPort. If the default URL is acceptable, enter only the DBHost and DBPort values in the PEInitV.properties file.
      DBUserName This parameter is the database user name that was identified by the pe_db_user parameter in the installation worksheet. This must be the existing database user name, which for pre-5.0 versions defaulted to f_sw. This value is required.
      DBpw This parameter is the password for the database user. If the password is encrypted, enter the value as @encrypted_pe_db_password. To encrypt the password, see the information in Encrypting passwords for Process Engine. If you enter the password as a nonencrypted value in the PEInitV.properties file, delete the PEInitV.properties file after the configuration is complete. This value is required.
      DBVersion This parameter is required for DB2 databases, and valid values are:
      • DB2LUW
      • DB2zOS
    5. Configure the servers in a farmed or nonfarmed environment:
      Environment Command
      Nonfarmed configuration Configure a single virtual server by running the following command, entered as a single line:
      PEinit virtual_server_name -V 
      PEInitV.properties 
      where virtual_server_name is the name of the virtual server you are defining. If you do not specify the virtual server name, this server name is defined as default.
      High availability farmed server environments Farmed configuration Configure all servers in a farm by running the following command, entered as a single line:
      PEinit virtual_server_name -V PEInitV.properties -l 
      serverlist 
      where serverlist is a list of the host names for the other servers in the farm, separated by a + character, for example:
      servername1+servername2+servername3
      where virtual_server_name is the name of the virtual server you are defining. If you do not specify the virtual server name, this server name is defined as default.
  3. Log off and log back on as the pe_install_user.


Feedback

Last updated: November 2010


© Copyright IBM Corporation 2010.
This information center is powered by Eclipse technology. (http://www.eclipse.org)