IBM DB2 Rails All-in-one
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