JDBC with IBM Integration Bus

#create configurable serivce:
mqsicreateconfigurableservice TESTNODE -c JDBCProviders -o DSNName -n type4DatasourceClassName,type4DriverClassName,databaseType,jdbcProviderXASupport,portNumber,serverName,description,databaseName,securityIdentity,connectionUrlFormat,databaseSchemaNames -v com.ibm.db2.jcc.DB2XADataSource,com.ibm.db2.jcc.DB2Driver,DB2,jdbcProviderXASupport,446,

,"Data Store",DSNName,DB2SecurityIdentity,"jdbc:db2://[serverName]:[portNumber]/[databaseName]:user=[user];password=[password];",useProvidedSchemaNames

#provide broker with user password
mqsisetdbparms TESTNODE -n jdbc::DB2SecurityIdentity -u userid -p pwd


# link that documents the database config for the different environments:
http://sharethewealth/SiteDirectory/bdsg/IbmRdz/rdzblog/Lists/Posts/Post.aspx?ID=41