MultiCloud Marketplace

IBM

IBM DB2 Rails All-in-one

Open in Dashboard

Published by IBM on Nov 25, 2009Revision: 4

Description

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.

Contents

  • 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

Revisions

Revision 4 | Nov 25, 2009

Updated Install DB2 rightscript. Now uses DB2 9.7.1.

Discussion

Info

No Ratings

Supported Clouds

Pricing

All Users

Sign-up for RightScale

Support Information

Community support via forum: http://ibm.co/3Sc4U5.

IBM support and subscription available for purchase: http://bit.ly/dMQKdN