IBM DB2 on Cloud
IBM Db2 on Cloud is a public cloud ( IBM Cloud ) fully managed solution for transactional workloads. It is part of the Common SQL engine across all deployment options. IBM delivers an environment designed , managed and sized to meet those needs.
- Available pre-configured to optimally support transactional workloads
- Load & Go functionality gives fast time to value
- Can scale up (bigger servers) or scale out (multiple servers).
- Oracle PL/SQL compatibility. Supports numerous data connectivity methods & types
- Easy-to-use web console to quickly load or migrate data
- Enterprise grade security
- Data encrypted at rest and in motion
- Tools provided for loading structured, semi-structured, or unstructured data
- Elastic scale up/down of compute and storage independently
- Start projects without waiting for IT infrastructure
- Quickly load data or migrate data from other sources
£216 per instance per month
- Free trial available
IBM United Kingdom Ltd
|Software add-on or extension||Yes, but can also be used as a standalone service|
|What software services is the service an extension to||IBM Db2 on Cloud helps you solve real problems and drive business value with applications, infrastructure and services. It weaves together the services, infrastructure and data to rapidly bring ideas to production. Scale is managed to your business and building systems is simplified.|
|Cloud deployment model||
Maintenance is typically scheduled in advance and occurs approximately every six weeks at a predefined time. This includes updates to the environment and the database software. If urgent fixes are required, then maintenance may need to be scheduled outside of the regular schedule.
The service is not available while maintenance is applied. Maintenance is typically scheduled for 1-4 hours, but IBM makes all efforts to minimize the outage time and actual outage time is usually much less. For environments using the HA plan, maintenance is typically applied in a rolling fashion and the outage is generally only a few minutes.
|Email or online ticketing support||Email or online ticketing|
|Support response times||Support levels based on urgency of request , standard IBM support levels 1-4|
|User can manage status and priority of support tickets||No|
|Phone support availability||24 hours, 7 days a week|
|Web chat support||No|
|Onsite support||Yes, at extra cost|
Free Support: All trial customers of IBM Cloud receive ticketed support, but no response time objectives are offered. Ticket severity is limited to severity 4.
Basic Support: All customers who have purchased IBM Cloud but have not purchased support receive ticketed support, but no response time objectives are offered. Ticket severity is limited to severity 4.
Standard Support: All customers in an IBM Cloud account that have purchased Standard Support receive ticketed, technical support with the response time objectives defined below. Premium Support: Any customers in an IBM Cloud account who have purchased Premium
Support receive ticketed support with improved response times, priority handling, and a Client Success Manager assigned to your account. A Client Success Manager will be made available for up to 8 hours a week to provide a rapid route into the IBM Cloud organization, providing proactive and focused attention to help clients achieve maximum value from the environment quickly.
Note: All customers are provided free technical support through our community support at:
https://developer.ibm.com/bluemix/ or on Stack Overflow at:
Our Development staff monitors both forums.
|Support available to third parties||Yes|
Onboarding and offboarding
This is mainly provided through online training and documentation which users can access for free. IBM Cloud contains a wealth of material to help customers gain value from their Db2 on Cloud environment quickly and easily. This includes Getting Started guides, videos, Youtube channel tutorials, showcases, sample data, etc. etc.. Examples of how to get started can be found at
https://developer.ibm.com/clouddataservices/docs/dashdb/get-started/ and at
|End-of-contract data extraction||IBM will return the Client Data within a reasonable period in a reasonable and common format upon receiving written instructions from the Client prior to termination or expiration.|
The Proof of Entitlement(PoE)
will specify whether the IBM SaaS renews
automatically, proceeds on a continuous use basis, or terminates at the end of
the term. For automatic renewal, unless Client provides written notice not to
renew at least 90 days prior to the term expiration date,
the IBM SaaS will
automatically renew for the term specified in the PoE. For continuous use, the
IBM SaaS will continue to be available on a month to month basis until Client provides 90 days written notice of termination. The IBM SaaS will remain available to the end of the calendar month after such 90 day period.
Using the service
|Web browser interface||Yes|
|Application to install||No|
|Designed for use on mobile devices||Yes|
|Differences between the mobile and desktop service||As the web console is accessed via a browser, there are no differences in functionality when accessed via a fully compatible browser on a mobile device eg tablet).|
|Accessibility standards||None or don’t know|
|Description of accessibility||GUI Web console and standard data connectivity through ODBC/JDBC ODATA|
|Accessibility testing||None known|
|What users can and can't do using the API||
There are 2 APIs supported:
1. The service creation APIs provided by IBM Cloud.
For a tutorial on provisioning Db2 on Cloud automatically, see the following developerWorks article:
Provision Db2 on Cloud for your move to the cloud
2. IBM Db2 on Cloud specific APIs.
IBM Db2 on Cloud supports all load APIs and r-script APIs at this time.
The API reference can be found here:
|API documentation formats||
|API sandbox or test environment||No|
|Independence of resources||
The architecture of IBM cloud services maintains logical separation of client data. Internal rules and measures separate data processing, such as inserting, modifying, deleting, and transferring data, according to the contracted purposes.
All resources are dedicated to a single client
|Service usage metrics||Yes|
|Metrics types||As an account owner or a billing manager, you can use the Usage Dashboard page to see the real-time charges for the runtimes and services that are used per month in your organizations. You can see the runtime GB-hours and service consumption in all regions, or you can select to see a particular region and space, for the past 12 months. Click a particular month to see the usage for that month. The charges shown represent the amount that you, as the account owner, are billed for that month.|
|Supplier type||Not a reseller|
|Staff security clearance||Other security clearance|
|Government security clearance||Up to Developed Vetting (DV)|
|Knowledge of data storage and processing locations||Yes|
|Data storage and processing locations||
|User control over data storage and processing locations||Yes|
|Datacentre security standards||Complies with a recognised standard (for example CSA CCM version 3.0)|
|Penetration testing frequency||At least once a year|
|Penetration testing approach||‘IT Health Check’ performed by a Tigerscheme qualified provider or a CREST-approved service provider|
|Protecting data at rest||
|Data sanitisation process||Yes|
|Data sanitisation type||Explicit overwriting of storage before reallocation|
|Equipment disposal approach||Complying with a recognised standard, for example CSA CCM v.30, CAS (Sanitisation) or ISO/IEC 27001|
Data importing and exporting
|Data export approach||
IBM Db2 on Cloud data can be easily exported through standard utilities available to users via the web console. The link points to a tutorial demonstrating just how simple this is.
You can connect IBM Db2 on Cloud to Microsoft Excel so that you can easily move data between the two tools
|Data export formats||CSV|
|Data import formats||
|Other data import formats||
|Data protection between buyer and supplier networks||
|Other protection between networks||IBM will encrypt content not intended for public or unauthenticated viewing when transferring content over public networks. Further, unless excluded by a TD, IBM will enable use of a cryptographic protocol, such as HTTPS, SFTP, and FTPS, for Client’s secure transfer of content to and from the Cloud Service over public networks.|
|Data protection within supplier network||
Availability and resilience
IBM provides a 99.95% availability SLA for Platform Services
) configured for high availability and distributed across multiple IBM Cloud public regions;
ii) provisioned across multiple dedicated or local environments in geographically separated data-centers
In addition, IBM provides a 99.5% availability service level for multiple instances of a Platform Service provisioned within a single dedicated or local environment.
|Approach to resilience||Available at request.|
|Outage reporting||The current health and status for IBM Cloud and the Db2 on Cloud service can be found here: https://developer.ibm.com/bluemix/support/#status. Status updates, including notifications for upcoming maintenance, can be found on the right hand side of the panel. Notifications specific to Db2 on Cloud can be shown by entering "Db2 on Cloud " as a filter. There is also an RSS feed for these notifications which customers can subscribe to. These updates for upcoming maintenance are typically provided about 48 hours prior to the maintenance event -- although it may be a shorter amount of time for more urgent, unexpected updates (such as applying an important security fix).|
Identity and authentication
|User authentication needed||Yes|
|Other user authentication||
Db2 on Cloud authenticates users against a local OpenLDAP repository. Clients have full control over who is granted access. Client access via Db2 on Cloud web administration console UI, or through connections to one of Db2 on Cloud’s
external ports. No direct command line or SSH access is allowed by end users. Users are authenticated based on a local LDAP repository that is managed alongside Db2 on Cloud . Management and monitoring predefined for assignment to client users
and do not include any access to the database’s data. User data access can be defined at a fine grained level.
|Access restrictions in management interfaces and support channels||IBM maintains individual role-based authorization of privileged accounts that is subject to regular validation. A privileged account is a duly authorized IBM user identity with administrative access to a Cloud Service, including associated infrastructure, networks, systems, applications, databases and file systems.|
|Access restriction testing frequency||At least every 6 months|
|Management access authentication||Username or password|
Audit information for users
|Access to user activity audit information||Users contact the support team to get audit information|
|How long user audit data is stored for||Between 1 month and 6 months|
|Access to supplier activity audit information||Users contact the support team to get audit information|
|How long supplier audit data is stored for||Between 1 month and 6 months|
|How long system logs are stored for||Between 1 month and 6 months|
Standards and certifications
|ISO/IEC 27001 certification||Yes|
|Who accredited the ISO/IEC 27001||Bureau Veritas|
|ISO/IEC 27001 accreditation date||11/12/2015|
|What the ISO/IEC 27001 doesn’t cover||The infrastructure and platform this offering is run on is ISO/IEC 27001 compliant. The current SaaS application is also compliant.|
|ISO 28000:2007 certification||No|
|CSA STAR certification||Yes|
|CSA STAR accreditation date||20/04/2016|
|CSA STAR certification level||Level 1: CSA STAR Self-Assessment|
|What the CSA STAR doesn’t cover||The infrastructure and platform this offering is run on has a CSA STAR Self-Assessment certificate. The SaaS side of this offering currently does not have this. The IBM CSA Star Self-Assessment can be viewed here https://cloudsecurityalliance.org/star-registrant/softlayer/|
|Other security certifications||Yes|
|Any other security certifications||
|Named board-level person responsible for service security||Yes|
|Security governance certified||Yes|
|Security governance standards||ISO/IEC 27001|
|Information security policies and processes||
IBM has an Information Technology (IT) Security policy that establishes the requirements for the protection of IBM's worldwide IT systems and the information assets they contain, including networks and computing devices such as servers, workstations, host computers, application programs, web services, and telephone systems within the IBM infrastructure. IBM’s IT Security policy is supplemented by standards and guidelines, such as the Security Standards for IBM's Infrastructure, the Security and Use Standards for IBM Employees and the Security Guidelines for Outsourced Business Services. Such are reviewed by a cross-company team led by the IT Risk organization every six months.
IBM has a dedicated Vice President of IT Security who leads a team responsible for IBM's own enterprise data security standards and practices. Responsibility and accountability for executing internal security programs is established through formal documented policies. IBM Services teams also have dedicated executives and teams who are responsible for information and physical security in the delivery of our client services.
|Configuration and change management standard||Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402|
|Configuration and change management approach||IBM maintains policies and procedures to manage risks associated with the application of changes to its Cloud Services. Prior to implementation, all changes to a Cloud Service, including its systems, networks and underlying components, will be documented in a registered change request that includes a description and reason for the change, implementation details and schedule, a risk statement addressing impact to the Cloud Service and its clients, expected outcome, rollback plan, and documented approval by IBM management or its authorized delegate.|
|Vulnerability management type||Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402|
|Vulnerability management approach||With each Cloud Service, as applicable and commercially reasonable, IBM will a) perform penetration testing and vulnerability assessments before production release and routinely thereafter, b) enlist a qualified and reputable independent third-party to perform penetration testing and ethical hacking at least annually, c) perform automated management and routine verification of underlying components’ compliance with security configuration requirements, and d) remediate any identified vulnerability or noncompliance with its security configuration requirements based on associated risk, exploitability, and impact. IBM takes reasonable care to avoid Cloud Service disruption when performing its tests, assessments, scans, and execution of remediation activities.|
|Protective monitoring type||Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402|
|Protective monitoring approach||IBM maintains and follows policies requiring administrative access and activity in its Cloud Services’ computing environments to be logged and monitored, and the logs to be archived and retained in compliance with IBM’s worldwide records management plan. IBM monitors privileged account use and maintain security information and event management policies and measures designed to a) identify unauthorized administrative access and activity, b) facilitate a timely and appropriate response, and c) enable internal and independent third party audits of compliance with such policies. IBM systematically monitors the health and availability of production Cloud Service systems and infrastructure at all times.|
|Incident management type||Conforms to a recognised standard, for example, CSA CCM v3.0 or ISO/IEC 27035:2011 or SSAE-16 / ISAE 3402|
|Incident management approach||
-maintains and follows incident response policies aligned with NIST guidelines for computer security incident handling, and will comply with data breach notification requirements under applicable law.
-investigates security incidents, including unauthorised access or use of content or the Cloud Service, of which IBM becomes aware, and, if warranted, define and execute an appropriate response plan.
-promptly notifies Client upon determining that a security incident known or reasonably suspected by IBM to affect Client has occurred.
-provides Client with reasonably requested information about such security incident and status of applicable remediation and restoration activities performed or directed by IBM.
|Approach to secure software development best practice||Supplier-defined process|
Public sector networks
|Connection to public sector networks||No|
|Price||£216 per instance per month|
|Discount for educational organisations||No|
|Free trial available||Yes|
|Description of free trial||Entry level multi-tenant instance.|