Db2 SQL Tutorial 2 – Getting Started with Db2 and DSM

Here it is, your guide on getting started with Db2! Working with new software can be stressful, so my goal is to make this as easy as possible for you. Fortunately, Db2 setup is not too challenging.

Db2 Editions

Before we dive in and start downloading stuff, I want to take a moment to explain a few of the different editions of Db2. First off, we will be using Db2 for Linux, UNIX, and Windows. The edition we will be using is called Developer Community Edition (You may hear it as Developer-C) which is a full-fledged version of Db2 with the only limitation that it is only to be used for development.



When you build an application with Db2, you can deploy a free version of Db2 which will work great but has limited capabilities. This is called the  Express-C edition. This edition is great because we are able to use Db2 in a production environment, but this edition may not meet the needs for your application.

If you are releasing an application, there are multiple editions that can meet your needs exactly.


The important thing to know is that the various editions of Db2 share the same code. Thus, switching between versions is not an obstacle when it comes to scalability.

Installation

First, download Db2 Developer Community Edition here.

Go through the simple installation steps.

You are going to want to make sure that you check all boxes (Docker, Data Studio, and Db2) so we download everything we are going to need for these blogs.

It will then ask for some credentials.

The first set of credentials is for Data Server Manager (DSM), which is a tool used to work with the database. The next set of credentials is for the database itself (user…? learn more about authentication). You will also get an option of which sample database to install. I recommend you install the database for transactional workloads if you are unsure:

Once you click continue, Docker will be installed. Docker is a tool that is used by Db2.

Does Db2 Developer edition come with DSM Enterprise or base edition?
https://www.ibm.com/developerworks/downloads/im/dsm/index.html and what changes are there in this newest version? Are parts of data studio moved to DSM or does data studio do everything DSM does plus more? Is DSM enough to do everything with the database or do you need data studio? If you need it why is it optional in the installation?

The primary tool we are going to be using is DSM, which allows us to easily work with our Db2 Database. Within DSM we can execute SQL against our database.

Let’s get into the next part to learn more!

Leave a Reply

Your email address will not be published. Required fields are marked *