August 26, 2016 | Written by: Simon Lightstone
Categorized: Community | Data Analytics
Share this post:
You might have heard of dashDB, IBM’s new hybrid database engine. It’s 100% DB2-compatible, which means there’s tons to love about it. There’s a lot of newly-released enhancements that make using dashDB even easier, like the high availability plans for dashDB for Transactions.
But what does all this mean for DB2 users? Here’s a quick rundown.
- #1: Fully compatible with DB2This means, you can connect with any recent DB2 driver, and all your DB2 tools should work with dashDB. IBM dashDB and DB2 use a common core engine. IBM dashDB is a drop-in replacement.
- #2: It deploys in a few clicksWith dashDB, you can create an encrypted cloud database in a few clicks. The handy web console includes everything you need, including an SQL editor and data import tools. Daily backups are included. You can get started on the Bluemix page for dashDB.For a database optimized for web, transactional or mixed-purpose workloads, choose a plan marked as dashDB for Transactions. Be sure to choose a “pay per use” plan to get instant activation. “Subscription” plans are set up manually by IBM; this allows customers to specify special requests, such as Oracle compatibility mode. Aside from this subtle difference, the plans are the same.For a cloud database optimized for analytics workloads, complete with in-memory column-organized tables and IBM’s BLU acceleration, choose a dashDB for Analytics plan. (Often simply labelled as “dashDB”). Compare that simplicity to rolling your own DB2, or using other cloud providers that require in-depth configurations. As soon as your database is provisioned, you can start running SQL commands from the web console.
- #3: It’s extremely low cost (or free) to get startedIBM dashDB for Analytics has a 1 GB free tier for the Entry plan. The free tier has instant activation. That means you can get a free cloud data warehouse in less than 30 seconds.IBM dashDB for Transactions, while not free, has by-the-day billing and instant activation (pay per use plans only). This makes it great for experimentation, building proof-of-concepts or troubleshooting a DB2 database by quickly launching a fresh one.For those new to DB2, you can also install DB2 Express-C, a totally free version of DB2.
- #4: It plugs in to cool new toolsBluemix is a candy store for developers. Maybe you love DB2, but you’ve been dying to try node.js or Watson APIs. You can connect them to your dashDB instance with a few clicks and very little code. Many Bluemix services have free tiers to make experimenting easy.
- #5: Database Conversion Workbench lets you get onto the cloud fasterIBM created a specialized tool to let people move on-premise databases into the cloud. (It will also help you move Oracle or Netezza databases to dashDB or DB2.) You can download the tool here. Alternatively, you can also migrate using Data Studio or DataWorks.
- #6: You can get high availability out-of-the-boxWith a dashDB for Transactions high availability plan, you can instantly deploy 2 servers in HA, to help minimize downtime. At this time, both servers are located in the same data center. If you need servers deployed in different data centers, contact your IBM representative.
IBM dashDB offers a lot of advantages to DB2 users. Imagine the time and cost of setting up 2 high availability DB2 servers for your next project, with encryption and daily backups, all inside a secure facility.
Check out dashDB
Now, you can achieve the same result with just a few clicks using dashDB.