Configure a JDBC provider configurable service so that the deployed application can connect to the database.
Ensure that the integration node where you will run your solution is created and started. In this scenario, the integration node is named IBNODE.
At run time, the Mapping node uses a JDBC provider configurable service that is called CLIENTS to obtain the configuration parameters that it needs to connect to the database CLIENTS.
To configure the JDBC provider configurable service CLIENTS, run the mqsicreateconfigurableservice command.
mqsicreateconfigurableservice IBNODE -c JDBCProviders -o CLIENTS -n connectionUrlFormat,connectionUrlFormatAttr1,connectionUrlFormatAttr2,connectionUrlFormatAttr3,connectionUrlFormatAttr4,connectionUrlFormatAttr5,databaseName,databaseType,databaseVersion,description,environmentParms,jarsURL,jdbcProviderXASupport,maxConnectionPoolSize,portNumber,securityIdentity,serverName,type4DatasourceClassName,type4DriverClassName -v "jdbc:db2://[serverName]:[portNumber]/[databaseName]:user=[user];password=[password];","","","","","","CLIENTS","DB2 Universal Database","10.1","default_Description","default_none","C:\Program Files\IBM\SQLLIB\java","true","0","50000","mySecurityId","localhost","com.ibm.db2.jcc.DB2XADataSource","com.ibm.db2.jcc.DB2Driver"
A JDBC provider configurable service is available at run time.
Follow the steps in Securing the JDBC provider configurable service.