#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
Subscribe to:
Post Comments (Atom)
Distributed Computing: A Guide to Comparing Data Between Hive Tables Using Spark
In big data, efficient data comparison is essential for ensuring data integrity and validating data migrations. Apache Spark, with its in-me...
-
1.Mqsisetdbparams Mqsisetdbparms– brokername – -n – DataSourceName -u – DataSourceUserId – -p – DataSourcePassword To dele...
-
BROKER SCHEMA gen --CREATE PROCEDURE getUserDefinedPropertyValue(in prop char) RETURNS CHARACTER --LANGUAGE JAVA --EXTERNAL NAME ...
-
HTTP/HTTPS listener behavior with IIB HTTPInput nodes When a flow containing HTTPInput nodes are deployed on an Integration Server...
No comments:
Post a Comment