Creating Common Event Infrastructure data source for IBM i

The Common Event Infrastructure data source must be manually created on IBM® i after running the configuration wizard to create a Sametime® Gateway cluster. These steps apply to clustered deployments only.

Before you begin

Expected state: the deployment manager is running and nodes are stopped.

Procedure

  1. Log into the Integrated Solutions Console (http://localhost:9060/ibm/console) and select Resources > JDBC > Data sources.
  2. Set the scope to Cluster=SametimeGatewayCluster
  3. Click New.
  4. Type the data source name:
    CommonEventInfrastructure_Bus
  5. Type the JNDI name:
    jdbc/com.ibm.ws.sib/SametimeGatewayCluster-CEI.DM_cell_name.BUS
    Where DM_cell_name is the cell name of the deployment manager which is input in the installation of the deployment manager.
  6. Select the existing Event_DB2iSeries_JDBC_Provider and click Next.
  7. Type the server name. This is the hostname of the IBM i system where your database schema is located.
  8. For the Component-managed auth alias, select:
    DM_cell_name/SametimeGatewayCluster/EventAuthDataAliasDB2iSeries
    
    and then click Next.
  9. Deselect CMP
  10. Click Next.
  11. Click Finish.
  12. Click the data source you just created, CommonEventInfrastructure_Bus, to see its properties.
  13. In the "Additional Properties" section, select Custom Properties.
  14. Select the property named libraries.
  15. Set the Value to the name of the schema you are using for the Sametime Gateway cluster.
  16. Select OK.
  17. Save your changes to the configuration.
  18. Select Resources > JDBC > JDBCProviders .
  19. Select the Event_DB2iSeries_JDBC_Provider.
  20. Change the Class path to:
    /QIBM/ProdData/OS400/jt400/lib/jt400Native.jar
  21. Click OK and then Save to save your changes to the configuration.