Creating the DB2 data source

About this task

When you have verified that the JDBC Provider is configured properly, the data source for IBM® BigFix® Remote Control must be created using that JDBC Provider.

To create the data source complete the following steps:

Procedure

  1. Select Resources > JDBC > Data Sources.
  2. Select the scope from the drop down menu that includes the node and the server.
    For example, Node=TEST-2008Node02, Server=server1.
  3. Click New.
  4. Specify the data source information.
    1. Enter basic data source information
      Data source name
      Specify a name for the data source. This can be any required name.
      JNDI Name
      This should be set to jdbc/trcdb
      Note: If this name is changed, you need to change the common.properties file also.
    2. Select JDBC Provider

      The data source will use the Universal JDBC Provider for DB2 that is predefined in WebSphere.

      1. If DB2 Universal JDBC Driver Provider is available, select Select an existing JDBC provider from the list. If it is not available, click Create new JDBC provider.
      2. In the Database type list, select DB2.
      3. Select DB2 universal JDBC Driver provider.
      4. From the Implementation type list, select Connection pool data source.
      5. Click Next.
      6. Accept the default values and click Next.
    3. Enter database specific properties for the data source
      Driver Type
      Select 4 from the list.
      Database name
      This is the name used when the db2 create db command was issued.
      Server name
      This is set to the IP or host name of the server where DB2® is installed. If DB2 is installed locally you can use localhost.
      Port number
      This is set to the port that was configured in DB2 for remote connections.
      Click Next.
    4. Setup security aliases
      1. From the Component-managed authentication alias list, select your node/DB2 where your node is the node you previously created for DB2.
      2. Accept the default of none in the remaining lists.
      3. Click Next.
    5. Review the summary and click Finish.
  5. To save the configuration changes, click Save.

Results

When the data source has been created and the changes to the profile are saved, test that the data source is correctly configured. Select the data source from the list of data sources and click Test connection. If the connection is successful, a conformation message is displayed. A failure in the test should be corrected before continuing with the installation, as IBM BigFix Remote Control will not work without a valid data source.