MultiCloud Marketplace

IBM

IBM - DB2 Express-C 10.5 FP1

Open in Dashboard

Published by IBM on Sep 24, 2013Revision: 2

Description

This ServerTemplate will install IBM DB2 Express-C 10.5 on your server with NoSQL JSON support.

DB2 Express-C is the FREE edition of the enterprise-class IBM DB2 database server. It has a powerful database engine that supports advanced relational and NoSQL capabilities. DB2 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, JSON, etc., and is well suited for a variety of Web, NoSQL, transactional, analytical, ERP, and other business applications.

There is no-charge for the use of DB2 Express-C software in this server template. If you require support or additional features you can easily upgrade to other editions of DB2.

New in DB2 10.5

DB2 Express-C 10.5 includes support for managing and querying JSON data. To start using NoSQL with DB2 you will need to (for db2inst1 user):

root)      su - db2inst1
db2inst1)  cd /home/db2inst1/sqllib/json/bin
db2inst1)  db2nosql -db MYDB
nosql)     enable(true)

See more at: DB2 NoSQL JSON Capabilities


This ServerTemplate uses Chef; for a RightScript based ServerTemplate, see: Base ServerTemplate for Linux (RSB)

Key Features:

  • Includes ibm-rightscale cookbook which has scripts to:
    • Install DB2 Express-C 10.5
    • Start DB2
    • Start DB2 Administration Server
    • Stop DB2
    • Stop DB2 Administration Server
    • Create Database
    • Backup Database (and optionally save to cloud: s3/softlayer)
    • RestoreDatabase (and optionally download from cloud: s3/softlayer)

Other Features:

  • Basic set of recipes for a RightLink-based server with logging, monitoring, alerts, etc.
  • MultiCloud Images that reference the latest supported images with a frozen software repository date that has been tested.
  • Basic set of alerts for most server type monitoring.

Documentation:
Release Notes
Tutorial


Supported public compute clouds:

  • Amazon Web Services EC2
  • SoftLayer

Supported MultiCloud Images:

  • CentOS 6
  • Ubuntu 12.04
  • RHEL 6

Contents

  • Cookbook: yum v2.2.1

  • Cookbook: iptables v0.9.3

  • Cookbook: logging v13.5.0.2

  • Cookbook: logging_rsyslog v13.5.0.2

  • Cookbook: logging_syslog_ng v13.5.0.2

  • Cookbook: rightscale v13.5.0.2

  • Cookbook: sys v13.5.0.2

  • Cookbook: sys_firewall v13.5.0.2

  • Cookbook: ibm-db2-express-c v0.1.0

  • Cookbook: driveclient v1.0.0

  • Cookbook: cloudmonitoring v0.1.5

  • Cookbook: apt v1.9.3

  • Cookbook: sys_ntp v13.5.0.2

  • Cookbook: block_device v13.5.0.2

  • MultiCloudImage: SoftLayerImage_Ubuntu_12.04_x64_v13.5 [rev 7]

  • MultiCloudImage: SoftLayerImage_Storage_Ubuntu_12.04_x64_v13.5 [rev 7]

  • MultiCloudImage: SoftLayerImage_Storage_CentOS_6.4_x64_v13.5 [rev 7]

  • MultiCloudImage: SoftLayerImage_CentOS_6.4_x64_v13.5 [rev 7]

  • MultiCloudImage: RightImage_Ubuntu_12.04_x64_v13.5_HVM_EBS [rev 12]

  • MultiCloudImage: RightImage_Ubuntu_12.04_x64_v13.5_EBS [rev 12]

  • MultiCloudImage: RightImage_Ubuntu_12.04_x64_v13.5 [rev 33]

  • MultiCloudImage: RightImage_RHEL_6.4_x64_v13.5_EBS [rev 10]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5_HVM_EBS [rev 11]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5_EBS [rev 12]

  • MultiCloudImage: RightImage_CentOS_6.4_x64_v13.5 [rev 43]

  • Recipe: ibm-db2-express-c::stop_db2

  • Recipe: ibm-db2-express-c::start_db2_administration_server

  • Recipe: logging::default

  • Recipe: ibm-db2-express-c::start_db2

  • Recipe: ibm-db2-express-c::restore_database

  • Recipe: ibm-db2-express-c::default

  • Recipe: rightscale::do_security_updates

  • Recipe: rightscale::install_rightimage_extras

  • Recipe: rightscale::install_tools

  • Recipe: rightscale::setup_cloud

  • Recipe: rightscale::setup_monitoring

  • Recipe: rightscale::setup_security_update_monitoring

  • Recipe: rightscale::setup_security_updates

  • Recipe: rightscale::setup_server_tags

  • Recipe: rightscale::setup_timezone

  • Recipe: ibm-db2-express-c::create_database

  • Recipe: sys::setup_swap

  • Recipe: ibm-db2-express-c::backup_database

  • Recipe: sys_firewall::default

  • Recipe: sys_firewall::do_list_rules

  • Recipe: sys_firewall::setup_rule

  • Recipe: block_device::setup_ephemeral

  • Recipe: sys_ntp::default

  • Recipe: ibm-db2-express-c::stop_db2_administration_server

  • See More

Revisions

Revision 2 | Sep 24, 2013

Update description

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