Blog Archive

Search This Blog

Monday, March 4, 2013

Teradata Express 14.0 for VMware User Guide

Teradata Express for VMware (TDE-V) is a free, fully operational Teradata VM with up to one terabyte of storage. Imagine being able to install a fully operational Teradata database on your PC and be running queries in five minutes, easy as 1-2-3.
After installing VMware Server/Player and downloading your choice of VM, this is all it takes:
  1. Install the VM
  2. Start the VM and Teradata
  3. Use the Teradata Studio Express to run queries
To help you load data, the new Teradata EZLoader utility is included in the VM.
Depending upon your needs and the resources available on your PC, three versions of Teradata Express14.0 are available. Please note that the resources needed for Teradata Express are in addition to those needed by the operating system on your PC:
  • TD Express 14.0 with 4GB of storage. Requires 13 GB of disk space and 2.0 GB of RAM for the Virtual Machine.
  • TD Express 14.0 with 40GB of storage. Requires 18 GB of disk space and 2.5 GB of RAM for the Virtual Machine.
  • TD Express 14.0 with 1TB of storage. Requires 35 GB of disk space and 4.0 GB of RAM for the Virtual Machine.
A 64-bit virtualization-capable PC is required.  VMware provides a utility to check your system for 64 bit support at this link.
Please note that while the Teradata Express family of products is not officially supported, you can talk to other users and get help in the Cloud Computing forum. Note also that Japanese-language instructions for configuring TDE-V are available for download in PDF format.

Getting Started

The first task is to make sure you have a system capable of handling VMware and VM’s. There are plenty of details on the VMware site but here are some basic requirements that you should be aware of before getting started:
  1. Since the SLES10 VM’s are 64-bit, your CPU must support 64-bit operation.
  2. Your CPU must also support Virtualization. Generally there is a BIOS setting which enables this. Google the topic for your particular CPU for more information but most recent PC’s support both 64-bit and Virtualization.
As soon as you determine your system supports the requirements you can proceed:
It's time to run VMware Player and start Teradata Express.  From the VMware Player Welcome page, choose "Open a Virtual Machine" and click your way through your file directory to the Teradata Express folder, looking for the "TDExpress14.0_sles10.vmx" file.


Figure 1. Loading the TD Express virtual machine in VMWare Player
I MOVED IT!
This step is very important.  As you click through the virtual image directories, VMware is looking for the .vmx file, in order to start the image.  Once you find it, double-click or choose the 'Open' option.  VMware will now present you with a dialog box asking if you copied or moved this image.  Be sure to choose  'I MOVED IT'!
  1. VMware Player and VMware Server are both available for free download from the VMware site and both will work. This tutorial describes using VMware Server (hosted on a Windows system). If you have not already done so, make your choice and install VMware on your system.
  2. Disk space is a big consideration. 4 GB, 40GB and 1TB versions of TDE-V are available depending on your resources and need. Typically you don't actually need the full amount of available disk space (although this would be advisable) to install and get started. Also, isolating VM’s on their own physical disks (if available) can improve performance. Some additional information about disk space is provided below.
  3. Download the appropriate TDE-V image from the downloads section.
  4. If you do not already have 7-zip download it here
  5. Create a directory on your C:\ drive named "virtual-machines". After unzipping (7-zip) the file you will end up with something like “C:\virtual-machines\TD14..”.
  6. Now you need to add the VM to the VMware inventory. Using VMware Player (see Figure 1 above for reference):
    1. Click on Open A Virtual Machine
    2. Drill down under inventory, highlight the folder (sles10_TD1400) and item in contents (sles10.vmx), OK
  7. The VM will show up in the Library under the Home tab and can be started and stopped from there.
  8. Double click on the TD Express image to start.
  9. Login into the SLES10 VM with username root and password root.
  10. Wait. The image will take some time to initialize.
  11. Test with bteq (bteq is the standard Teradata command line query tool. It can be invoked from the Linux command line in the Gnome window as follows.
    1. From the shell prompt: TDExpress14.0_Sles10:~ # bteq
    2. When asked for your logon: .logon 127.0.0.1/dbc
    3. When asked for your password: dbc
    4. You should now be in the bteq session (you'll see a message *** Logon successfully completed).
    5. Now, let's execute some SQL, e.g. select * from dbcinfo; and you should see results similar to:
      1
      2
      3
      4
      5
      6
      7
      8
      9
      10
      select * from dbcinfo;
       *** Query completed. 3 rows found. 2 columns returned.
       *** Total elapsed time was 1 second.
      InfoKey                        InfoData
      ------------------------------ --------------------------------------------
      LANGUAGE SUPPORT MODE          Standard
      RELEASE                        14.00.00.01
      VERSION                        14.00.00.01
    6. And you can now quit bteq by executing: quit

Figure 2. Testing Teradata using BTEQ

Monitoring Teradata Express using Viewpoint

You have the option of running Viewpoint on the virtual machine. To see all you can do with Viewpoint look here.
Viewpoint services are not automatically started. To begin the Viewpoint services click on the "Viewpoint Start" icon on the Teradata Express desktop.
To login to Viewpoint follow the steps below.
  1. Open a Gnome terminal. Firefox is included in the image and is able to run inside the virtual machine.
  2. Start Firefox: TDExpress14.0_Sles10:~ # firefox &
    • The "&" starts firefox in the background.
  3. Wait. Firefox will take a couple of minutes to initialize.
  4. The Viewpoint page should come up automatically, but if it doesn't, enter this URL: http://localhost/c
  5. Login to Viewpoint as username = "admin" and password = "teradata".
  6. Towards the upper right of the main Viewpoint portal page, click "Admin" then "Teradata Systems"
  7. Add a System. Under Setup/General
    • System Nickname - "TDExpress"
    • Check the System Enabled box, next to the System Nickname
    • TDPID is set to only monitor localhost and cannot be modifed
    • Login Name = "viewpoint"
    • Login Password = "viewpoint"
    • Check Enable all data collectors.
    • Apply
  8. Under Setup/Data Collectors. Set all data collectors to delete data after 50 MB or 1 week
  9. Under Setup/Monitor rates. Check Enable Session.
See the General Set Up Screen Bleow

Loading Data

On the Teradata version 14.0 VM’s the new EZloader utility is included for fast and easy data loads. Here's an example of loading some data from a comma-separated file (i.e. a CSV). From BTEQ, run the following:











CREATE user vmtest AS password=vmtest perm=524288000 spool=524288000;
CREATE SET TABLE vmtest.test ,
NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT (
Test_field1 INTEGER,
Test_field2 INTEGER)
PRIMARY INDEX ( Test_field1 );

Create a file called test with contents that look something like this:
1,1
2,2
3,3

Run the load utility:
/opt/teradata/client/13.0/tbuild/bin/tdload -f test -u vmtest -p vmtest -t test
That is it, data loaded!

Source

1 comment: