Installation Guide › Installing an AIX Implementation › Install and Configure Workpoint Components on AIX/WebSphere › Configure WebSphere Application Server for Workpoint

Configure WebSphere Application Server for Workpoint

In this procedure you prepare WebSphere for the Workpoint application.

• You install the Workpoint Designer application on a 32-bit Windows computer.
• You make configuration changes on that computer
• You copy configuration files to WebSphere
• You complete configuration settings on the WebSphere Application Server

You can install Workpoint Designer on the same computer as the CA RCM client tools, or create a temporary installation just for WebSphere configuration.

To configure a WebSphere Application Server for Workpoint

1. Download the IBM Application Client for WebSphere Application Server, and install it on the Windows computer.
2. The CA RCM installer places a copy of the Workpoint Designer installation package under the directory

   RCM_install\Server\eurekify-jboss\Workpoint\
   

   Note: RCM_install is the CA RCM installation directory.

3. Copy the installation package to a 32-bit Windows computer.
4. Run the installation.
5. Define an ODBC Data Source that points to the CA RCM Workpoint database:
   1. From the Windows Control Panel, click Administrative Tools, Data Sources.
   2. On the User DSN tab, click Add.
   3. The Create New Data Source wizard begins.
   4. Select the SQL Server driver and click Finish.
   5. Enter a label. Specify the SQL Server that hosts CA RCM databases. Click Next.
   6. Select the With SQL Server authentication option. Provide login information for the SQL Server. Click Next.
   7. Select the Change the default database to option and specify WPDS. Click Next.
   8. Accept language and logging defaults, and click Finish.
   9. Click Test Connection to verify that the Data Source attaches to the database. Click OK to conclude.
6. Edit the file c:\workpoint\conf\workpoint-client.properties and make the following changes:

   Under the J2EE Client Configuration header, change all lines in the JBoss SETTINGS section into remarks by adding the # character. Remove the # character from all lines of the IBM WEBSPHERE SETTINGS section to make these lines active.

   Edit the property java.naming.provider.url to define the DNS and port information for the Workpoint cluster load balancer in your configuration. Typically this is the Bootstrap Address of the application server.

7. Edit the file c:\workpoint\bin\init.bat and make the following changes:

   Add the rem keyword to all lines in the USE WITH JBoss section, and remove the rem keyword from all lines in the USE WITH IBM WEBSPHERE section.

   Set the JAVA_HOME and WAS_HOME properties to the WebSphere Application Server client application. Typically the values are:

   SET JAVA_HOME=C:\PROGRA~1\IBM\WebSphere\AppClient\java\jre
   

   SET WAS_HOME=C:\PROGRA~1\IBM\WebSphere\AppClient
   

8. Start Workpoint Designer with the command c:\workpoint\bin\Designer.bat. Do not use Designer.exe when working with WebSphere environments.
9. Find the following files in the c:\Workpoint directory of the Windows server:

   workpoint-server.properties

   workpoint-client.properties

   GeneralMonitor.properties

   Copy them to the WebSphere application server under the folder WAS_install_root/essentials/Workpoint

   where WAS_install_root is the WebSphere Application Server installation directory.

10. Copy a valid Workpoint license file to this directory - typically this file is named License.xml.
11. (Optional) If you are working with Workpoint v.3.4, copy the file j2ee.jar from the Windows server (c:\Workpoint\lib) to this directory.
12. On the Windows server, copy the file js.jar in the c:\Workpoint\lib directory. On the WebSphere application server, place a copy in WAS_install_root/AppServer/lib. If this folder already contains a file named js.jar, rename the existing file before copying.
13. On the WebSphere application server, open the file workpoint-server.properties and edit the following parameters:

    log4j.appender.WSFile1.File = logs/Workpoint.log

    auto.db.create.or.upgrade = true

    workpoint.db.provider = sqlserver

    workpoint.db.id = WPDS

    workpoint.db.name = WPDS

14. Open the file workpoint-client.properties and edit the following parameter:

    log4j.appender.WCFile1.File = logs/Designer.log

15. Open the file GeneralMonitor.properties and edit the following parameter:

    log4j.appender.GMLog1.File = logs/GeneralMonitor.log