How-tos
Provision dashDB for Analytics and Transactions SQL database for your move to the cloud
November 29, 2016 | Written by: Andrew Hilden
Categorized: Data Analytics | How-tos
Share this post:
It’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.
Get dashDB for Transactions SQL Database
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
- 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
- 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:\>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:\>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&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"
}
- 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:\>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 - After creating a service, you may want to create service keys and use those service keys to access the service directly.
C:\>cf create-service-key AwesomeDashDB keys1
Creating service key keys1 for service instance AwesomeDashDB as dashtxteam@ibm.com
com...
OK
C:\>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"
}
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.
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.
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.