How-tos

Provision dashDB for Analytics and Transactions SQL database for your move to the cloud

Share this post:

dashDB HeroIt’s easy to provision IBM dashDB for Transactions and IBM dashDB for Analytics cloud offerings directly from Bluemix now. DashDB for Transactions SQL Database provides a dedicated, fully managed, OLTP-optimized solution that offers both DB2 and Oracle compatible options. Alternatively, harness the power of dashDB for Analytics with in-memory processing, RStudio and Cloudant integrations, in-database analytics, and much more.

Provision dashDB directly from Bluemix

PayGo provisioning is available for both of these offerings. You can purchase them directly from Bluemix by using your Bluemix subscription or a credit card. Choose the options that you want, click “Create,” and your system will soon be available on the Bluemix dashboard. It’s that easy.

Move data to the cloud using Bluemix Lift

You can use Bluemix Lift to move your on-premises data store to a dashDB for Analytics instance quicker and easier than you might have thought possible. Bluemix Lift leverages IBM Aspera to transport data in a highly efficient and secure way, achieving up to 10 times better performance than traditional data transfer methods.

Automate dashDB Provisioning

If you’re a re-seller or you just want to automate the provisioning of a new dashDB service instance, make sure that you take a look at the Bluemix command line or the Cloud Foundry REST API. You can use these in your applications or processes to get the services that you need without requiring the use of the Bluemix UI.

To use the Cloud Foundry CLI to create a service, download it here and install it

    1. Log in to your Bluemix account:
      C:\cf_cli>cf login
      API endpoint: https://api.ng.bluemix.net
      Email> dashtxteam@ibm.com
      Password>
      Authenticating...
      OK
      Targeted org dashtxteam@ibm.com
      Select a space (or press enter to skip):
      1. batcave
      2. async
      Space> 2
      Targeted space async
      API endpoint:   https://api.ng.bluemix.net (API version: 2.54.0)
      User:           dashtxteam@ibm.com
      Org:            dashtxteam@ibm.com
      Space:          async
    2. Create the dashDB service by running the following command:
      C:\cf_cli>cf create-service <service_name> "<plan_name>" "<service_instance_name>" -c "<parameters_file>"

      where <service_name> represents either “dashdb” for analytical workloads or “dashdb for transactions” for transactional (OLTP) workloads<plan_name> is the plan you want to provision.
      For the dashDB service you can specify one of the following plans:

      • SMP Small
      • SMP Medium
      • SMP Large
      • MPP Small

      For the dashDB for Transactions service, you can specify one of the following plans:

      • EnterpriseForTransactions2.8.500
      • EnterpriseTransactional12.128.1400″

      <service_instance_name> is whatever you want to call the service instance that appears in Bluemix.
      <parameters file>

        is a file in json format that you can use to pass in options to tailor the service. The following parameters are available:

      • Oracle_compatible: Specify either “yes” or “no” for the service instance to be Oracle compatible.
      • High_availability: If you are creating a dashDB for Transactions SQL Database service, specify either “yes” or “no” to configure the service with high availability.
      • Datacenter: The location where you want the service to be created:
        us-south:Dallas
        us-south:dallas – federal
        us-south:Houston
        us-south:queretaro
        us-south:San Jose
        us-south:Seattle
        us-south:Toronto
        us-south:Washington d.c
        us-south:Montreal
        us-south:wdc – federal
        us-south:Sao Paulo
        eu-gb:London
        eu-gb:Paris
        eu-gb:Milan
        eu-gb:Frankfurt
        eu-gb:Amsterdam
        eu-gb:Oslo
        au-syd:Hong Kong
        au-syd:Singapore
        au-syd:Sydney
        au-syd:Melbourne
        au-syd:Tokyo
        au-syd:Chennai

      Here is an example of the command in action:

      C:\&gt;cf create-service dashDB "SMP Small" "AwesomeDashDB" -c c:\parameters.json
      Creating service instance AwesomeDashDB in org dashtxteam@ibm.com / space async as dashtxteam@ibm.com...
      OK
      Create in progress. Use 'cf services' or 'cf service AwesomeDashDB' to check operation status.
      Attention: The plan `SMP Small` of service `dashDB` is not free.  The instance `AwesomeDashDB` will incur a cost.  Contact your administrator if you think this is in error.
      C:\&gt;cf service AwesomeDashDB
      Service instance: AwesomeDashDB
      Service: dashDB
      Bound apps:
      Tags:
      Plan: SMP Small
      Description: A flexible and powerful data warehouse for enterprise-level analytics.
      Documentation url: https://console.ng.bluemix.net/docs/services/dashDB/dashDB.html
      Dashboard: https://dashdbrm.ng.bluemix.net/dashDBRM/launchdashboard?region=us-south&amp;instance_id=a35cd3a6-46b2-45e9-ac3a-23da51b92d00
      Last Operation
      Status: create in progress
      Message: dashDB system is being built
      Started: 2016-11-27T19:03:49Z
      Updated: 2016-11-27T19:06:26Z

      In the Parameters.json I specified the following options:
      {
      "oracle_compatible":"no",
      "datacenter":"us-south:Dallas"
      }
    3. Check the status of your provision request. Depending on the location and plan, a dashDB service instance might take some time to provision. You can run the following command to check the provisioning status:
      C:\&gt;cf service AwesomeDashDB

      Service instance: AwesomeDashDB
      Service: dashDB
      Bound apps:
      Tags:
      Plan: SMP Small
      Description: A flexible and powerful data warehouse for enterprise-level analyti
      cs.
      Documentation url: https://console.ng.bluemix.net/docs/services/dashDB/dashDB.ht
      ml
      Dashboard: https://dashdbrm.ng.bluemix.net/dashDBRM/launchdashboard?region=us-so
      uth&instance_id=a35cd3a6-46b2-45e9-ac3a-23da51b92d00Last Operation
      Status: create in progress
      Message: dashDB system is being built
      Started: 2016-11-27T19:03:49Z
      Updated: 2016-11-27T19:06:26Z
    4. After creating a service, you may want to create service keys and use those service keys to access the service directly.
      C:\&gt;cf create-service-key AwesomeDashDB keys1
      Creating service key keys1 for service instance AwesomeDashDB as dashtxteam@ibm.com
      com...
      OK

      C:\&gt;cf service-key AwesomeDashDB keys1
      Getting key keys1 for service instance AwesomeDashDB as dashtxteam@ibm.com
      {
      "db": "BLUDB",
      "dsn": "DATABASE=BLUDB;HOSTNAME=dashdb-enterprise-small-yp-09-04.services.dal.blu
      emix.net;PORT=50000;PROTOCOL=TCPIP;UID=bluadmin;PWD=HIDDEN_PASSWORD;",
      "host": "dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net",
      "hostname": "dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net",
      "https_url": "https://dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net:8
      443",
      "jdbcurl": "jdbc:db2://dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net:
      50000/BLUDB",
      "password": "HIDDEN_PASSWORD",
      "port": 50000,
      "ssldsn": "DATABASE=BLUDB;HOSTNAME=dashdb-enterprise-small-yp-09-04.services.dal.
      bluemix.net;PORT=50001;PROTOCOL=TCPIP;UID=bluadmin;PWD=HIDDEN_PASSWORD;Security
      =SSL;",
      "ssljdbcurl": "jdbc:db2://dashdb-enterprise-small-yp-09-04.services.dal.bluemix.n
      et:50001/BLUDB:sslConnection=true;",
      "uri": "db2://bluadmin:HIDDEN_PASSWORD@dashdb-enterprise-small-yp-09-04.services
      .dal.bluemix.net:50000/BLUDB",
      "username": "bluadmin"
      }

 

More How-tos stories
May 1, 2019

Two Tutorials: Plan, Create, and Update Deployment Environments with Terraform

Multiple environments are pretty common in a project when building a solution. They support the different phases of the development cycle and the slight differences between the environments, like capacity, networking, credentials, and log verbosity. These two tutorials will show you how to manage the environments with Terraform.

Continue reading

April 29, 2019

Transforming Customer Experiences with AI Services (Part 1)

This is an experience from a recent customer engagement on transcribing customer conversations using IBM Watson AI services.

Continue reading

April 26, 2019

Analyze Logs and Monitor the Health of a Kubernetes Application with LogDNA and Sysdig

This post is an excerpt from a tutorial that shows how the IBM Log Analysis with LogDNA service can be used to configure and access logs of a Kubernetes application that is deployed on IBM Cloud.

Continue reading