MultiCloud Marketplace


IBM DB2 Rails All-in-one

Open in Dashboard

Published by IBM on Nov 25, 2009Revision: 4


IBM DB2 Express-C is a freeware database server with advanced features for managing relational and XML data. It is easy-to-use, includes self-managing capabilities, and offers enterprise-proven performance and scalability. DB2 supports key development platforms including , Ruby on Rails, PHP, Python, C/C++, Java, .Net, etc., and is well suited for a variety of Web, Web 2.0, transactional, analytical, ERP, and other business applications.

This Server Template is built on Ubuntu 8.04. It installs and configures DB2 Express-C 9.7 during boot-up. This script also includes the following scripts and tools:

  • Operation Scripts for use with DB2
  • Add Users to Group
  • Backup DB2 Database
  • Create database
  • Create Group
  • Create sample database
  • Create User
  • Delete Group
  • Delete User
  • Drop a database
  • Install DB2 Express-C
  • Remove Users from a Group
  • Restore Database
  • Run command within db2
  • Set DB2 parameter
  • Start DB2
  • Start DB2 Administration Server
  • Stop DB2
  • Stop DB2 Administration Server
  • Other tools
  • Ruby and Rails

NOTE: In order to use this template you MUST create TWO EBS volumes prior to starting this Server Template OR set the USE_LOCAL_STORAGE Input to "YES".

  • Configuration Volume
  • This EBS volume will hold the configuration of DB2 as well as the user home directories.
  • It is recommended to create this volume at LEAST 2GB in size.
  • By default this device is attached to /dev/sdj, however this is modifiable via the DB2_CONFIG_EBS_DEVICE input.
  • Data Volume
  • This EBS volume will hold all of your databases (user data, system catalog tables, indexes, etc.).
  • It is recommended to create this volume at LEAST 10GB in size.
  • By default this device is attached to /dev/sdk, however this is modifiable via the DB2_DATA_EBS_DEVICE input.


  • MultiCloudImage: RightImage Ubuntu8.04_V4_3_4_Alpha

  • RightScript: Remove users from group [rev 4]

  • RightScript: Stop DB2 [rev 1]

  • RightScript: Start DB2 [rev 1]

  • RightScript: Restore Database [rev 1]

  • RightScript: Set DB2 parameter [rev 1]

  • RightScript: Run command within db2 [rev 1]

  • RightScript: Create database [rev 3]

  • RightScript: Backup DB2 Database [rev 12]

  • RightScript: Create User [rev 4]

  • RightScript: Delete User [rev 4]

  • RightScript: Add users to group [rev 4]

  • RightScript: Drop database [rev 1]

  • RightScript: Create Group [rev 4]

  • RightScript: Delete Group [rev 4]

  • RightScript: Start DB2 Administration Server [rev 4]

  • RightScript: Stop DB2 Administration Server [rev 4]

  • RightScript: Boot (possibly format) and mount the EBS volume script [rev 9]

  • RightScript: Setup All-in-one [rev 1]

  • RightScript: SYS Syslog Remote Logging Client v7 [rev 3]

  • RightScript: SYS lvm on /mnt v9 [rev 3]

  • RightScript: SYS Monitoring install v8 [rev 5]

  • RightScript: Install DB2 Express-C [rev 16]

  • RightScript: Create sample database [rev 1]

  • See More


Revision 4 | Nov 25, 2009

Updated Install DB2 rightscript. Now uses DB2 9.7.1.



No Ratings

Supported Clouds


All Users

Sign-up for RightScale

Support Information

Community support via forum:

IBM support and subscription available for purchase: