Run Vantage Express on UTM

Author: Adam Tworkiewicz
Last updated: April 5th, 2021

Overview

This quick start shows how to gain access to a Teradata database by running it on your local machine. There are many ways to install Teradata. This document optimizes for the lowest time to first query without spending money on cloud resources. Once you finish the steps you will have a working Teradata Vantage Express database on your computer.

Prerequisites

  1. A Mac computer. Both Intel and M1 chips are supported.

  2. 30GB of disk space and enough CPU and RAM to be able to dedicate at least one core and 4GB RAM to the virtual machine.

  3. Admin rights to be able to install and run the software.

Installation

Download required software

  1. The latest version of Vantage Express. If you have not used the Teradata downloads website before, you will need to register.

  2. The latest version of UTM.

Run UTM installer

  1. Install UTM by running the installer and accepting the default values.

Run Vantage Express

  1. Go to the directory where you downloaded Vantage Express and unzip the downloaded file.

  2. Start UTM, click on the + sign and select Virtualize.

  3. On Operating System screen select Other.

  4. On Other screen select Skip ISO Boot.

  5. On Hardware screen allocate at least 4GB of memory and at least 1 CPU core.

    UTM Hardware
  6. On Storage screen accept the defaults by clicking Next.

  7. On Shared Direct screen click Next.

  8. On Summary screen check Open VM Settings and click Save.

  9. Go through the setup wizard. You only need to adjust the following tabs:

    • Network - expose ssh (22) and Vantage (1025) ports on the host computer:

      UTM Network
  10. Map drives:

    • Delete the default IDE Drive.

    • Map the 3 Vantage Express drives by importing the disk files from the downloaded VM zip file. Make sure you map them in the right order, -disk1, -disk2, -disk3 . The first disk is bootable and contains the database itself. Disks 2 and 3 are so called pdisks and contain data. As you import the files UTM will automatically convert them fro vmdk into qcow2 format. Make sure that each disk is configured using the IDE interface:

      UTM Drives
  11. Save the configuration and start the VM.

  12. Once the VM is up, you will see its desktop environment. When prompted for username/password enter root for both.

    VM Login
  13. The database is configured to autostart with the VM. To confirm that the database has started go to the virtual desktop and start Gnome Terminal. In the terminal execute pdestate command that will inform you if Vantage has already started:

    To paste into Gnome Terminal press SHIFT+CTRL+V.
    watch pdestate -a

    You want to wait till you see the following message:

    PDE state is RUN/STARTED.
    DBS state is 5: Logons are enabled - The system is quiescent
    See examples of messages that pdestate returns when the database is still initializing.
    PDE state is DOWN/HARDSTOP.
    
    PDE state is START/NETCONFIG.
    
    PDE state is START/GDOSYNC.
    
    PDE state is START/TVSASTART.
    
    PDE state is START/READY.
    PDE state is RUN/STARTED.
    
    DBS state is 1/1: DBS Startup - Initializing DBS Vprocs
    PDE state is RUN/STARTED.
    
    DBS state is 1/5: DBS Startup - Voting for Transaction Recovery
    PDE state is RUN/STARTED.
    
    DBS state is 1/4: DBS Startup - Starting PE Partitions
    PDE state is RUN/STARTED.
  14. Now that the database is up, go back to the virtual desktop and launch Teradata Studio Express. When you first start it you will be offered a tour. Once you close the tour, you will see a wizard window to add a new connection. Select Teradata:

    New Connection Profile
  15. On the next screen, connect to the database on your localhost using dbc for the username and password:

    New Connection

Run sample queries

  1. We will now run some queries in the VM. To avoid copy/paste issues between the host and the VM, we will open this quick start in the VM. Go to the virtual desktop, start Firefox and point it to this quick start.

  2. Once in Teradata Studio Express, go to Query Development perspective (go to the top menu and select WindowQuery Development).

  3. Connect using the previously created connection profile by double-clicking on Database ConnectionsNew Teradata.

  4. Using dbc user, we will create a new database called HR. Copy/paste this query and run it by hitting the run query button (Run Query Button) or pressing F5 key:

    CREATE DATABASE HR
    AS PERMANENT = 60e6, -- 60MB
        SPOOL = 120e6; -- 120MB
    Were you able to run the query?
  5. Let’s create a sample table and insert some data and query it. We will first create a table to hold employee information:

    CREATE SET TABLE HR.Employees (
       GlobalID INTEGER,
       FirstName VARCHAR(30),
       LastName VARCHAR(30),
       DateOfBirth DATE FORMAT 'YYYY-MM-DD',
       JoinedDate DATE FORMAT 'YYYY-MM-DD',
       DepartmentCode BYTEINT
    )
    UNIQUE PRIMARY INDEX ( GlobalID );
  6. Now, let’s insert a record:

    INSERT INTO HR.Employees (
       GlobalID,
       FirstName,
       LastName,
       DateOfBirth,
       JoinedDate,
       DepartmentCode
    )
    VALUES (
       101,
       'Adam',
       'Tworkowski',
       '1980-01-05',
       '2004-08-01',
       01
    );
  7. Finally, let’s see if we can retrieve the data:

    SELECT * FROM HR.Employees;

    You should get the following results:

    GlobalID  FirstName  LastName   DateOfBirth  JoinedDate  DepartmentCode
    --------  ---------  ---------- -----------  ----------  --------------
         101  Adam       Tworkowski  1980-01-05  2004-08-01               1

Summary

In this guide we have covered how to quickly create a working Teradata environment. We used Teradata Vantage Express in a VM running on VMware. In the same VM, we ran Teradata Studio Express to issue queries. We installed all software locally and didn’t have to pay for cloud resources.

Did this page help?