Introduction

IBM Bluemix offering provides IBM DB2 database on IBM’s SoftLayer global cloud infrastructure. It offers customers the rich features of an on-premise DB2 deployment without the cost, complexity, and risk of managing their own infrastructure.

The setup is very easy!!! This tutorial will walk you through creating and accessing your DB2 on Cloud.

Step One — Log In to Bluemix

To create your DB2 On cloud, you need to have Bluemix Account.
Go to http://console.ng.bluemix.net and login with your email and password.

 

 

 

 

 

 

 

 

 

 

Step Two — Select Service

You can create your Service by Choosing IBM DB2 on Cloud Service. Based on your requirement, every service has plan to choose from.

 

 

Step Three — Select Plan Size

Depending on your needs and budget, you can select the database size option that works best for you.

 

 

There is a wide spectrum for prices, IOPS, Network and storage capacity. The smallest and least expensive option starts at private 2 x 2.0 GHz Cores, 8GB RAM , 1x100GB (SAN), 1x500GB (SAN) , 1 Gbps Network , 100GB at 500 IOPS. The size options grow larger from there, all the way up to Bare metal server 32 x 2.0 GHz Xeon Cores, 1TB RAM, 16 x 1.2TB SSD ( 10 DWPD ) – Configured with RAID 10 (9.5TB), 2 x 800GB SSD ( 10 DWPD ) – Configured with RAID 1 (800GB) 10 Gbps Redundant Network.

Should your needs change at a future point, you can upgrade your plan using the options.
You can refer Pricing plans on
https://console.ng.bluemix.net/catalog/services/ibm-db2-on-cloud

Step Four — Database provisioning

After choosing the Plan, and completing create process for the service, database server instance will get created for you.

While creation, Based on your location, you may choose the most effective region (US/Sydney/Germany/UK) while creation.

 

 

Although equally powerful, the best region to choose is the one nearest to you and your customers or other possible users. Selecting a more distant server location may increase your server latency without serving any practical purpose.

Step Five — Verify your DB2 instance

DB2 on Cloud is a hosted DB2 database service. Provisioned on-demand when you purchase the service, DB2 database is installed on a host machine in the cloud. After the server is set up, you take over management of the server. You will see steps you need to follow.

1) After you purchase a DB2 on Cloud service, you receive a “Welcome” email that contains the IP address of your server and login credentials for a default administrative user.
2) The password given for the default administrative user in the “Welcome” email is temporary:
3) The first time you log in to your DB2 on Cloud server, you are prompted to change the temporary password.

You can login through Putty to change the password.

SSH – You must use Secure Shell (SSH) to log in to your DB2 on Cloud server. Linux and UNIX come with the ssh client. On Windows, you can install an ssh client, such as one with Cygwin or Putty to connect to DB2 on Cloud.
There is a default administrative user, “adminuser”. Your IBM DB2 on Cloud for Bluemix server is set up with a default administrative user with the username adminuser.
The default administrative user cannot run restricted commands directly, but has sudo privileges to be able to run those commands.

 

Let’s see Default instance information: db2inst1
Default instance is created for you and ready to use right away. Default instance owner for this is “db2inst1”

You will have a default instance, “db2inst1” is created.
Your DB2 on Cloud server is set up using a default root installation, with a default database manager instance named db2inst1.
You can create more/your own instances too.

Step Six — Login

You cannot log in to your DB2 on Cloud server directly as the user db2inst1.
Instead, log in to your DB2 on Cloud server as the default administrative user(adminuser), and then use the su command to switch the ownership of your login session to db2inst1: Follow below steps

[adminuser@XXX.XX.XXX.XX ~]$ db2start
-bash: db2start: command not found
[adminuser@XXX.XX.XXX.XX ~]$ sudo su – db2inst1
Last login: Tue Apr 18 18:19:47 CDT 2017 from 49.248.167.102 on pts/0
[db2inst1@ XXX.XX.XXX.XX ~]$ db2start
10/02/2016 13:32:04 0 0 SQL1026N The database manager is already active.
SQL1026N The database manager is already active.
[db2inst1@ XXX.XX.XXX.XX ~]$ logout
[adminuser@ XXX.XX.XXX.XX ~]$

Step Seven — Create Users (Optional)

As explained earlier, You will have default instance owner, “db2inst1” with a default database manager instance named db2inst1.

You can create your own users and instance. For, Creating group and user IDs for a DB2 database installation
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0006742.html
With that, your server is ready!

Step Seven — Access using your instance (IBM Data Studio Client)

Next, you can choose tools for working with your DB2 on Cloud Server.
IBM Data Studio is an integrated, modular environment for database development and administration with collaborative database development tools:
Saves time and reduces errors with advanced data management, configuration, and administration tools and features. You can install same from
https://www.ibm.com/developerworks/downloads/im/data/https://www.ibm.com/developerworks/downloads/im/data/https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0006742.html>

 

Once you start this thick client, you will have to create a workspace for saving your work. Click Ok, for creating a workspace. Now you are ready to start your development

Step Eight— Work with your Database

Next, you can connect to your instance by providing connection information as shown below.
Click on New connection to a Database

 

You will be prompted to enter details shown below.

 

Click on “Test Connection”. On successful connection, you will see below message

 

Now you are ready to work with your database. Go ahead with creating tables, add seed data for master tables, and so on.

Complete!

Once you have configured DB2 on Cloud Service, you are ready to use for your applications.
Please refer https://console.ng.bluemix.net/catalog/services/ibm-db2-on-cloud for more details.

Join The Discussion

Your email address will not be published. Required fields are marked *