Teradata Express 14.0 for Amazon EC2 Configuration Guide
Cloud Computing is a computing service provisioning and delivery model in which users get access to dynamically scalable computing capacity over the network in a pay-as-you-use payment scheme. While its attractiveness may differ depending on whom you've talked to, its service-oriented nature gives users two important benefits: ease of application deployment (someone else's hard works laying down the hardware and software foundation) and on-demand access anytime from anywhere. These characterstics make Cloud Computing ideally suited for developers who want to quickly try something out in an isolated "good" environment without the overhead of system setup or the capital expenses of paying for systems they no longer need after they are done.
Teradata Express 14.0 for Amazon EC2 runs on top of Novell SLES10 and the industry-leading Amazon EC2 Cloud Computing platform. It has Teradata database 14.0 and client utilities pre-installed and sample databases included. The old Express Edition limitation with 4GB storage has now been expanded to 1TB, giving developers more freedom to experiment with larger datasets and with more real-life development and testing needs. If you are interested, this post will show you how to automatically setup Teradata Express 14.0 for Amazon EC2 using an automated script. Note, this article assumes that you have some working knowledge of Amazon EC2 platform.
Please note that while this product is not officially supported, you can talk to other users and get help in the Cloud Computing forum.
- Have your Amazon AWS account credential ready (if you don't yet have an account, sign up at http://aws.amazon.com/).
- An SSH client (ssh, Putty, etc) will be needed to complete the Initialization porcess
- Register with us for Teradata Express 14.0 for Amazon EC2.
- Once you receive a confirmation email from us, proceed to the next section.
How to Connect to Amazon AMI Instance(s)
After receiving the confirmation from Teradata, log in to your Amazon EC2 account and go to your EC2 Dashboard.
Launch a New Instance of Teradata Express 14.0 for Amazon EC2
- Click the "
Launch Instance" button on the EC2 Dashboard.
- Select "
Classic Wizard" and then "
- Choose "
My AMIs" and select "
Private Images" from the pull-down menu.
- Select "ami-
- Cluster Compute (
cc1.4xlarge, 23GB) is the smallest configuration needed to support TD Express 14.0.
- Select your Availability Zone preference. If you pick "
No Preference" remember which one you get because you must create the disk volumes in the same zone as your TD Express 14.0 image. Click "
- No Advanced Instance Options are required to run TD Express 14.0. Hit "
- Add Tags if desired. No tags are required to run TD Express 14.0. Hit "
- Create a Key Pair if desired. A key pair is not required to run TD Express 14.0. You may want to use a key pair for added security for your instance. Click "
- Choose an existing Security Group or create a new one. The security group you choose must have the following ports open:
22- for SSH conncetivity
80- standard web port (HTTP) for Viewpoint connectivity
1025- Teradata database access port, for client tools and utilities
8080- alternate HTTP port.
- Hit "Launch".
Creating and Attaching Disk Volumes
- Return to your EC2 Dashboard.
- Under Elastic Block Storage select "
- Click "
- You will need to create two (2) volumes, each half the size of your desired database; e.g. for a 40GB database create two 20GB volumes.
- Important. The Availability Zone must be the same as the instance of TD Express 14.0 you wish to attached it to.
No Snapshotneeded. Click
- Repeat for the second Volume.
- Highlight the first of the new Volumes and hit
Attach Volumeunder the
- Choose your instance of TD Express 14.0 launched above.
- For the first device name it
- Repeat for the second Volume, but name it
- Wait for the volumes to complete the Attach process. To ensure that the process has completed, select each volume individually in the console, and under the
Detailstab, wait for the
Attachmentvalue to change to
Configure the Database
You are ready to connect to the instance and complete the initialization process. You can use a SSH client (ssh, Putty, etc) to connect to the external IP address of the instance, make sure you specify your rsa key file with the connection attempt if you have set one up. Setup scripts automatically run at the first log-in.
- Start your SSH client (ssh, PuTTy, etc.)
- From your EC2/Instances dashboard, hit the checkbox on your new instance.
- Get the public DNS for the instance you checked above in the form
- Copy and past the instance public DNS into your SSH client. Or if you have
sshinstalled on the command line, enter:
- Connect to the TD Express image via your SSH client.
- Your username and password are both:
- Set-up script will run and the first thing you will see is the Teradata Express License Agreement. Accept by hitting the Enter key.
- You will now see the set up screen below. Select (
[x]) each of the two drives using the space bar and arrow keys.
- Tab to the next section to set the super user password.
- Keep or disable the sample database and Viewpoint as desired.
- Tab to Next and hit Enter.
12. If you get an error indicating that Linux does not recognize one of your disks, type
reboot into the console. Wait two minutes and login again using the SSH client and you should see the screen below. Note that it may take a significant length of time for the configuration process to complete. Wait until this happens as seen below. When complete, select
Done. You hopefully now have a running Teradata instance!
Test your initialized Teradata Express instance
BTEQ is the standard Teradata command line query tool, and can be used to test your Teradata installation. Login to the EC2 instance as above.
- From the shell prompt:
TDExpress14.0_Sles10:~ # bteq
- When asked for your logon:
- When asked for your password:
- You should now be in the bteq session (you'll see a message
*** Logon successfully completed).
- Now, let's execute some SQL, e.g.
select * from dbcinfo;and you should see results similar to:
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
Or, similarly if you have downloaded TTU 13.10, you can use the SQL Assistant tool to run the same command.
Monitoring Teradata Express on EC2 using Viewpoint
You can connect to the Viewpoint running on the virtual machine. To see all you can do with Viewpoint look here.
The Viewpoint services are started automatically when you start up the virtual machine if you have configured it during the set-up process above. To login to Viewpoint follow the steps below.
- Get the public DNS for your EC2 instance (it shoudl be of the form
- Open a new browser window
- Paste the DNS into the top box.
- Login to Viewpoint as username =
adminand password =
- Towards the upper right of the main Viewpoint portal page, select
Admin > Teradata Systems.
- Add a System. Go to the
Setup > Generalform.
- System Nickname -
- Check the
System Enabledcheckbox next to the System Nickname.
- TDPID is set to only monitor localhost and cannot be modifed.
- Login Name = "
- Login Password = "
Enable all data collectors
- System Nickname -
- Under Setup Data Collectors. Set all data collectors to delete data after
- Under Setup/Monitor rates. Check Enable Session.
See the General Set Up Screen Bleow
Warning on Disk Space Data Collector
When starting yout TD EC2 instance for the first time, a timing error during initialization can occur. This will show up as a warning triangle next to the "Disk Space" data collector. When you click on the triangle the warning text is:
“Unable to retrieve Teradata database version or retrieved unknown Teradata database version null! Retrieved unknown Teradata database version null!”
This warning will clear itself during the next 12 hours as the system refreshes itself. You can also manually clear this warning by doing the following:
- Go back to your SSH interface.
- From the shell prompt:
- Wait to complete.
- Repeat Step 2.
The initialization glitch should now be cleared and should not return.
Starting a Portlet
- On the top right of your Viewpoint screen you will see a link "<< Back to Portal". Click it.
- You are now on the main Viewpoint screen and can now start adding portlets.
- Click on the "Add Content" pulldown menu
- Select "Monitoring:
- Select "Canary Response Times"
This portlet will periodically submit a query to the system and measure its response time. Sometimes called a system heartbeat.
You now have a fully functioning version of Teradata 14 running in the Amazon cloud. Have fun! And don't forget to terminate your instance if you are done with it. If you leave it running you will incur usage charges! Note: If you terminate your instance you will have to go through the setup again, and you will lose all your data. Make sure you backup your data and any needed Teradata configuration files in
Also, 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.