Configure a JDBC provider configurable service so that the deployed application can connect to the database.
Ensure that the integration node named IB9NODE is created and started.
At run time, the Mapping node uses a JDBC provider configurable service 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 IB9NODE -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.
Set up security for the configurable service. For more information, see Securing the JDBC provider configurable service.