Installing the Db2 Big SQL Sandbox

You can install the Db2 Big SQL Sandbox on any computer that is running on the Mac, Windows 10, or Windows 7 operating systems.

Before you begin

The Db2 Big SQL Sandbox has the following system requirements:

Operating system

Mac OS X Yosemite 10.10.3 or later, Windows 10 Enterprise, Education, or Pro, and Windows 7 (all versions that allow Hyper-V)

Hardware

4 processor cores

At least 12 GB of RAM and 16 GB of free disk space

If your operating system is Windows, enable Virtualization Technology (VT-X) in the BIOS of your computer.

If your operating system is Windows 10 Enterprise edition and you sign into your computer with Azure Active Directory, you must create a local account that Docker can use to access your local filesystem.

  1. Click Start > Settings > Other people > Add someone else to this PC.
  2. At the bottom of the page, select I don’t have this person’s sign-in information, and at the bottom of the next page, select Add a user without a Microsoft account.
  3. Enter information for the local account, such as user name and password.
  4. Change the account type of the local account to administrator.
    1. Click Start > Settings > Account > Other people.
    2. Click Change account type.
    3. Under Account type, select Administrator > OK.
  5. Switch to the new account, and access C:\Users\<AzureAD_user> in File Explorer. Request access to the folder when prompted.
  6. Sign out of the new account and sign in with your Azure Active Directory account.
  7. During the installation process, when Docker asks for credentials to access your local filesystem, supply the username and password of the new local account.

If you use an older toolbox-based version of Docker, uninstall it before you install the Sandbox application.

On Windows systems, if Docker is already installed, make sure that Docker is set to run Linux containers (the default). If Docker is set to run Windows containers, switch to Linux containers in the Docker menu.

If you have other containers that run on your computer, stop them before you install the Sandbox application because your computer might have resource constraints.

Procedure

  1. Download the exe (Windows) or dmg (Mac) file on your laptop from the IBM Db2 Big SQL Marketplace web page.
  2. Run the file.

    The Sandbox installer downloads the image from Docker. In addition, the installer installs other software, such as Docker, if the software is not already installed on your computer.

    You might be prompted to create a Docker Cloud account and to change the Docker settings.

  3. When the installation is complete, add the following entry to the /etc/hosts file (Mac) or the C:\Windows\System32\drivers\etc\hosts file (Windows) so that you can access the sample Zeppelin notebooks that come with the Sandbox.
    127.0.0.1       sandbox.bigsql.ibm.com    localhost

Results

When the installation completes, you will see the following screen.

Figure 1. IBM Db2 Big SQL Sandbox installer final screen
Final screen of the IBM Db2 Big SQL Sandbox installer

You can log into the Apache Ambari dashboard to view the services in your cluster, or you can log in to Apache Zeppelin to explore the sample notebooks. You can click either of the two icons now, but it takes a few minutes for all of the services to start. Then, you can start exploring Db2 Big SQL.