Posts

Showing posts from May, 2018

DB2 Federation between two DB2 databases

Two Databases ----------------------- Step 1: Go to db2 prompt db2=> Step 2 (Optional) Create database if necessary create database Tom create database Jerry Step 3: Connect to DB1 and create table (Example Tom) (Optional) connect to tom create table db2inst1.tab1 (cod1 int) insert into db2inst1.tab1 values (1) Step 4: Connect to DB2 and create table (Example Jerry) connect to jerry create table db2inst1.tab2 (name1 char) insert into db2inst1.tab2 values ('a') Step 5: Create server and mappings in 1st DB (Tom) to access 2nd DB (Jerry) connect to tom create server fedserver TYPE DB2/UDB VERSION 10.5 WRAPPER drda  AUTHORIZATION "db2inst1" password "******" OPTIONS(DBNAME 'jerry') create user mapping for db2inst1 SERVER fedserver OPTIONS(REMOTE_AUTHID 'db2inst1',REMOTE_PASSWORD '******') create nickname mytable for fedserver.db2inst1.tab1 Step 6: Executing Select statement from 1st Db (Tom) to query resu...

Config Mule Managment Console backend as MSSQL Database

Image
Mule Management Console which is also known as  MMC  in short,  is a centralizes management and monitoring functions for all our on-premise  Mule ESB Enterprise  deployments, that includes running as a standalone instances, as a cluster, or embedded in application servers. MMC   as an enterprise management and monitoring tool is designed specifically for Mule on-premises instances. It provides all the functionality for managing and monitoring running Mule on premises servers, Mule clusters, deployed applications within Mule servers, and the flows within those applications. Another important feature is it also provides ways of looking at specific transactions through pre-defined business events, as well as transactions in flight. MMC   by default supports internal   derby   database to persist environment and transaction data. If we start our   MMC   application under   Apache Tomcat   server, we can see under the   bin   folder there is a folder named as   mmc-data   is created whe...

How to Mount S3 bucket on EC2 Linux Instance

Step-1:-   If you are using a new centos or ubuntu instance. Update the system. -> For CentOS or Red Hat 1 yum update all -> For Ubuntu 1 apt - get update   Step-2:-   Install the dependencies. -> In CentOS or Red Hat 1 sudo yum install automake fuse fuse - devel gcc - c ++ git libcurl - devel libxml2 - devel make openssl - devel   In Ubuntu or Debian 1 sudo apt - get install automake autotools - dev fuse g ++ git libcurl4 - gnutls - dev libfuse - dev libssl - dev libxml2 - dev make pkg - config   Step-3:-   Clone s3fs source code from git. 1 git clone https : // github.com/s3fs-fuse/s3fs-fuse.git   Step-4:-   Now change to source code  directory, and compile and install the code with the following commands: 1 2 3 4 5 cd s3fs - fuse . / autogen . sh . / configure -- prefix = / usr -- with - openssl make sudo make install   Step-5:-   Use below command to check where s3fs command is placed in O.S. It will also tell you the installation is ok. 1 which s3fs   Step-6:-  ...