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.
- Change your working directory to the following:
Option |
Description |
AIX®, HPUX, HPUXi, Solaris |
/fnsw/local/sd |
Windows |
\fnsw_loc\sd |
- Each connection has a file associated with the following naming scheme
.alias.bin
Note
the names for all aliases.
- Collect the connection information for each alias by running vwtool with the
listdbconfig option as follow:
- Start vwtool at a command prompt as follows:
vwtool -Y pe_service_username+pe_service_username_password
- Enter the following command at the prompt:
listdbconfig alias
- For each database type, the information returned is as follows:
- Oracle
- global database name
- SQL Server
- SQL Server name
- database name
- DB2®
- database alias
- 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