MultiCloud Marketplace

IBM

IBM DB2 Express-C 10.1

Open in Dashboard

Published by IBM on Apr 30, 2012Revision: 17

Description

IBM DB2 Express-C is the "no-limits" FREE edition of the enterprise-class IBM DB2 database server which is used by the largest enterprises for their mission critical applications . It features advanced technologies such as pureXML, a hybrid relational/XML database engine. It is easy-to-use, includes self-managing capabilities, and offers enterprise-proven performance and scalability.

You can use this server template and DB2 Express-C free of charge. IBM offers optional low cost subscription and support as well as additional features.

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 CentOS 5.6. It installs and configures DB2 Express-C 10.1 during boot-up. This template also includes the following scripts and tools:

Operation Scripts for use with DB2

User/Group Management

  • Create Group
  • Delete Group
  • Create User
  • Delete User
  • Add Users to a Group
  • Remove Users from a Group

Backup/Restore Databases

  • Backup Database
  • Restore Database

Create/Drop Databases

  • Create Database
  • Create SAMPLE Database
  • Drop Database

Start/Stop DBM

  • Start DB2
  • Stop DB2
  • Start DB2 Administration Server
  • Stop DB2 Administration Server

Other commands

  • Run command within DB2
  • Set DB2 parameter

Other tools

  • Ruby and Rails
  • Remote Desktop (via VNC)

**NOTE: In order to use this template you MUST either:

  • 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 3GB 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_CentOS_5.6_x64_v5.7 [rev 27]

  • RightScript: IBM - Setup java VNC viewer [rev 2]

  • RightScript: Backup DB2 Database [rev 12]

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

  • RightScript: Create Group [rev 5]

  • RightScript: Create User [rev 5]

  • RightScript: Create database [rev 4]

  • RightScript: Create sample database [rev 2]

  • RightScript: Delete Group [rev 5]

  • RightScript: Delete User [rev 5]

  • RightScript: Download Attachments [rev 4]

  • RightScript: Drop database [rev 2]

  • RightScript: IBM - SYS Lvm install - 11H1 [rev 1]

  • RightScript: IBM - Setup VNC + GDM + XINETD [rev 2]

  • RightScript: Add users to group [rev 5]

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

  • RightScript: Install IBM Data Movement Tool [rev 1]

  • RightScript: Remove users from group [rev 5]

  • RightScript: Restore Database [rev 1]

  • RightScript: Accept IBM DB2 Express-C License [rev 3]

  • RightScript: Run command within db2 [rev 2]

  • RightScript: SYS Monitoring install - 11H1 [rev 10]

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

  • RightScript: Set DB2 parameter [rev 2]

  • RightScript: Start DB2 Administration Server [rev 5]

  • RightScript: Start DB2 [rev 2]

  • RightScript: Stop DB2 Administration Server [rev 5]

  • RightScript: Stop DB2 [rev 2]

  • See More

Revisions

Revision 17 | Apr 30, 2012

Update description

Discussion

Info

8 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