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.
After receiving the confirmation from Teradata, log in to your Amazon EC2 account and go to your EC2 Dashboard.
Launch Instance" button on the EC2 Dashboard.
Classic Wizard" and then "
My AMIs" and select "
Private Images" from the pull-down menu.
cc1.4xlarge, 23GB) is the smallest configuration needed to support TD Express 14.0.
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 "
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.
No Snapshotneeded. Click
Attach Volumeunder the
Detailstab, wait for the
Attachmentvalue to change to
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.
sshinstalled on the command line, enter:
[x]) each of the two drives using the space bar and arrow keys.
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!
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.
TDExpress14.0_Sles10:~ # bteq
*** Logon successfully completed).
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.
LANGUAGE SUPPORT MODE Standard
Or, similarly if you have downloaded TTU 13.10, you can use the SQL Assistant tool to run the same command.
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.
adminand password =
Admin > Teradata Systems.
Setup > Generalform.
System Enabledcheckbox next to the System Nickname.
Enable all data collectors
See the General Set Up Screen Bleow
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:
The initialization glitch should now be cleared and should not return.
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.
Hello, I am uanble to connect to my EC2 instance via SSH. I keep getting network time out error.
Issue: Database configuration, step 4
Any help will be appreciated.
Do you have port 1025 open? See the User Guide for all of the ports and their configuration.
Once this is configured can it be stopped then restarted and retain all the data. The reason being that this is required for demo purposes and I don't want to keep the instance running all the time due to cost reasons.
I install TD Express AMI on AWS i2.xlarge instance. However, we have to restart the database by executing "/etc/init.d/tpa start" twice this week.
I have two block devices (500GB each) attached to this instance. The rest of the configurations are the same as this guide. Anything I can check to debug the issue?