6 - Creating the Data Sources

To save information to the RPM repository, when using the RPM Web Services API, the data source information or DSN (Data Source Name) must be set correctly. The information specified in the DNS allows the RPM Web Service to connect to the RPM repository database.

When you have several hosts or databases you can run batch scripts to work with each of them by specifying correctly the DSN you want to connect to.

The information required for the data source setting is the following:

This information will be used when the client logs into the server.

A datasource must be created: jdbc/RPMDATASOURCE

To create the RPM database Data Source

  1. From the WebSphere Administrative Console window, go to Resources then to JDBC Providers.
  2. Select the newly created: DB2 Universal JDBC Driver Provider.
  3. Click Data sources (not Data sources (version 4) then New to create the jdbc/RPMDATASOURCE data source using the following values.
    Note: When connecting to the server that specifies the data source, it should read: jdbc/RPMDATASOURCE.
    • Name: RPMDATASOURCE
    • JNDI name: jdbc/RPMDATASOURCE
    • Use this Data Source in CMP: checked
    • Select a data store helper class: selected
    • Data store helper classes provided by WebSphere Application Server: Select the DB2 Universal data store helper.
    • Component-managed authentication alias: the alias you have created (servadm)
    • Database name: Name of the DB2 instance that will be used. Case sensitive.
    • Driver type : 4
    • Server name : Name or IP address of the physical machine that is hosting the database.
    • Port number: Usually 50000 but should be what the DB admin has chosen.



  4. Click OK and save changes to the master configuration file.