Wednesday, May 2, 2012

Getting started with DB2 Express-C 10.1 on RightScale

DB2 Express-C is the free edition of the IBM DB2 database. Version 10.1 has just become available for download as well as for deployment in your cloud environment.

New features in DB2 Express-C 10.1:
- Time Travel Query for easy historical queries
- Built-in NoSQL support with SPARQL and RDF triplestores
- 98% compatibility for the PL/SQL syntax of Oracle Database

RightScale is an automation layer for deploying software on Amazon Elastic EC2, Rackspace, and other environments. The guide below comes courtesy of Bradley Steinfeld.

Next steps

Getting started with DB2 Express-C 10.1 on Rightscale

Browse to, Search for the IBM DB2 Express-C 10.1 Setup Macro.

Then click open in dashboard

Click subscribe to copy the Macro to your account

Then read and accept the license agreement

You will now be presented with the macro page.

Click the Run button to run the macro

On the next page do not select anything from the drop downs, just click the Run button.

Then simply answer the prompts.
After answering all prompts, the macro will run. When the macro is completed it will show the following alert:

When you click OK you will be automatically redirected to the newly created deployments page.

Launching the Server

Everything should be already configured so all you need to do is launch the server. Do this by first clicking the > button to the right of the server.

You will then be set the the pre-launch page for the server. From here you can view all the inputs associated with your DB2 server. When you are ready to boot the server click the Launch button.

Your server should now be booting. You from know the boot process is complete when this:

Changed to this:

Using the Server

You can access the servers console (SSH) by clicking the monitor button on the right. Alternatively, if you installed RDP (Remote Desktop Protocol) on the server you can simple browse to the servers Public IP or Public DNS Name.


By default you can login as user db2inst1 with password password.
Default Macro responses

Congratulations, you now have DB2 running in the cloud. For a good resource to learn more about DB2, check out Big Data University!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.