Creating the JDBC data source

At startup, the FTM runtime searches for a configured JDBC data source by name. It searches in the following order:
  1. FTMJDBCProvider_<Application Name>
  2. FTMJDBCProvider_<Integration Server Name>
  3. FTMJDBCProvider

The combined name for the data source must be no greater than 256 characters in length. All spaces are replaced with underscores. For example, if the name of the application is FTM Sample App, the runtime searches for a JDBC data source called FTMJDBCProvider_FTM_Sample_App.

The following sections and topics describe the instructions for creating the default JDBC data source - FTMJDBCProvider. Use the appropriate instructions for your database.

Database on z/OS®

The following integration node PDSE members contain sample JCL to use to run the specified commands.
Table 1. Integration node PDSE members
Member name Command
BIPCRCS mqsicreateconfigurableservice
BIPSDBP mqsisetdbparms
BIPRPPR mqsireportproperties
BIPCHPR mqsichangeproperties