Showing posts with label node. Show all posts
Showing posts with label node. Show all posts

Thursday, September 21, 2017

Adding Certificates to trustore

1)Open ikeyman utility : C:\Program Files\IBM\IIB\10.0.0.9\common\jdk\jre\bin

2)Clink Open, then Browse:

3)Navigate to Truststore, then Open: (trustore.jks)

4)click OK

5) Enter pwd then click Ok

6)Select signer certificate from dropdown.

7) Lcisk Add then browse

8) Select Cert to add then click open.

9) Click Ok.

10) Enter a label then OK

11) done, new cert has been added.

Reference: https://www.ibm.com/support/knowledgecenter/en/SSKM8N_8.0.0/com.ibm.etools.mft.doc/ap34020_.htm

Monday, June 12, 2017

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

Tuesday, November 8, 2016

How to increase JVM IBM integration bus

mqsireportproperties TESTNODE -e Java_POC -o ComIbmJVMManager -r


mqsichangeproperties TESTNODE -e Java_POC -o ComIbmJVMManager -n jvmMaxHeapSize -v 1073741824


mqsireportproperties TESTNODE -b agent -o ComIbmJVMManager -r


mqsichangeproperties TESTNODE -b agent -n jvmMaxHeapSize -o ComIbmJVMManager -v 1073741824

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...