Content Platform Engine, Version 5.2.1            Operating systems:  AIX, HP-UX, Solaris, Windows

Collecting configuration information for Process Engine DbExecute connections (upgrades from 4.5.1)

DbExecute connection information must be provided to the peupgrade tool for Process Engine upgrades from Version 4.5.1. Collect the current configuration information for all of your existing DbExecute aliases before you upgrade.

About this task

Collect DbExecute connection information and record it in your Installation and Upgrade worksheet. The DbExecute connection information must be provided to the peupgrade tool. You run the peupgrade tool during the upgrade of Process Engine to Content Platform Engine Version 5.2.1.

Procedure

To collect DbExecute alias configuration information for Process Engine, log on to the Process Engine v4.5.1 server and locate existing information.

  1. Change your working directory to the following:
    Option Description
    AIX®, HPUX, HPUXi, Solaris /fnsw/local/sd
    Windows \fnsw_loc\sd
  2. Each connection has a file associated with the following naming scheme
    .alias.bin
    Note the names for all aliases.
  3. Collect the connection information for each alias by running vwtool with the listdbconfig option as follow:
    1. Start vwtool at a command prompt as follows:
      vwtool -Y pe_service_username+pe_service_username_password
    2. Enter the following command at the prompt:
      listdbconfig alias
    3. For each database type, the information returned is as follows:
      Oracle
      global database name
      SQL Server
      SQL Server name
      database name
      DB2®
      database alias
  4. Using the information for every existing connection, collect the following information. Record the values in your Installation and Upgrade worksheet.
    • Database type
    • Database name
    • Database host name
    • Database port
    • Database user name
    • Database password

    As an alternative to the database host name and port, use a connection URL string. Your URL can vary, depending on your configuration, but default URLs that can be configured are as follows:

    • jdbc:sqlserver://DBhost:DBport;DatabaseName=DBName
    • jdbc:db2://DBhost:DBport/DBName
    • jdbc:oracle:thin:@DBhost:DBport:DBName


Last updated: October 2015
p8ppu124.htm

© Copyright IBM Corporation 2013, 2015.