ChannelDB2

Use DB2 Enterprise in the IBM Developer Cloud

DB2 Express-C and DB2 Enterprise are now available in the IBM Developer Cloud

You can sign up and instantiate as many image as you need today.

Transcript:
Hi, my name is Leons Petrazickis. I am on the DB2 team at the IBM Toronto lab.

This video will go through how you can create a DB2 instance in the IBM Developer Cloud, and then it will go through the ways you can connect to your DB2 cloud instance.

***

Let's go ahead and create an instance.

Go to your IBM Developer Cloud Control Panel, and click on the Add Instance button in the top right corner.

Scroll down to one of the DB2 instances, such as DB2 Express-C or DB2 Enterprise. Let's create a DB2 Enterprise instance.

Enter an instance name, such as My Instance Name, and an administrative password for the three Linux and DB2 users on your instance.

Click next and, once everything is ready, you can double-check what you entered. We then accept a license agreement for the IBM Developer Cloud.

Over the next few minutes, the instance will be created, provisioned, and then boot. This is a three step process.

You now have a copy of DB2 running in the cloud.

***

Let's take a look at your instance.

One way is to connect to the command line on your virtual cloud instance using ssh. On Windows you can use an ssh client such as PuTTY, and on Linux you can use the ssh command directly.

Let's copy the hostname of your newly created instance. Since I am working on Windows, I will bring up PuTTY.

I want to connect as the db2inst1 user at that hostname. Let's paste the hostname in.

Now we can log in using the password we entered while creating the instance.

Let's open up DB2.

There's a copy of the standard SAMPLE database already on the instance.

Let's select from one of the usual tables, Act.

Since the query worked, your copy of DB2 in the cloud is ready for use.

***

We can also connect to your cloud DB2 instance using a local copy of DB2. On Windows, let's open up the DB2 Command Window. On Linux, you should log in as the DB2 instance owner, usually db2inst1.

I am on Windows, so I'm going to bring up the DB2 Command Window.

Let's run the local copy of DB2 prompt.

The exact syntax for the next few commands in the getting started docs for your instances.

We'll catalog the remote DB2 instance using the TCPIP, meaning the internet, to connect to the hostname. The port we want is 50001.

We'll then catalog the SAMPLE database on the remote instance as MYDB. You'll then be able to access it just like a local database.

We can now connect to it as the DB2INST1 user. The password is what you entered while creating the cloud instance.

Let's select from one of the tables in it, such as Act.

Your remote DB2 instance is ready for use.

***

Now that you have added the cloud instance of DB2 to your local DB2 catalog, you can use any DB2 tool with it.

Let's open the DB2 Control Center. The newly cataloged node and database should be there. If it's already open, you may need to right-click and Refresh.

Let's right-click on MYDB and open up the Query tool. As before, the user is db2inst1 and the password is what you entered during instance creation.

We can query one of the tables in MYDB, such as Act.

Your cloud DB2 instance is ready for use.

***

You can check out the IBM Developer Cloud at the URL given.

You can also contact us at db2cloud AT ca.ibm.com

As always, any questions and comments are welcome in the associated forum.

Views: 480

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service