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
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.
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.
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
- Download DB2 Express-C 10.1
- Learn DB2 at Big Data University
- Follow the guide below
Getting started with DB2 Express-C 10.1 on Rightscale
Browse to, http://www.rightscale.com/library/macros.
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
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.
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.
SSH
RDP
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