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.

Prerequisites

  1. Have your Amazon AWS account credential ready (if you don't yet have an account, sign up at http://aws.amazon.com/).
  2. An SSH client (ssh, Putty, etc) will be needed to complete the Initialization porcess
  3. Register with us for Teradata Express 14.0 for Amazon EC2.
  4. 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

  1. Click the "Launch Instance" button on the EC2 Dashboard.
  2. Select "Classic Wizard" and then "Continue".
  3. Choose "My AMIs" and select "Private Images" from the pull-down menu.
  4. Select "ami-99f65af0".
  5. Cluster Compute (cc1.4xlarge, 23GB) is the smallest configuration needed to support TD Express 14.0.
  6. 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 "Continue".
  7. No Advanced Instance Options are required to run TD Express 14.0. Hit "Continue".
  8. Add Tags if desired. No tags are required to run TD Express 14.0. Hit "Continue".
  9. 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 "Continue".
  10. 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.


  1. Hit "Launch".
     

Creating and Attaching Disk Volumes

  1. Return to your EC2 Dashboard.
  2. Under Elastic Block Storage select "Volumes".
  3. Click "Create Volume".


  4. 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.
  5. Important. The Availability Zone must be the same as the instance of TD Express 14.0 you wish to attached it to.
  6. No Snapshot needed. Click Yes, Create.
  7. Repeat for the second Volume.
  8. Highlight the first of the new Volumes and hit Attach Volume under the More Menu.
  9. Choose your instance of TD Express 14.0 launched above.
  10. For the first device name it /dev/xvdf.
  11. Repeat for the second Volume, but name it /dev/xvdg.
  12. 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 Details tab, wait for the Attachment value to change to attached.

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.

  1. Start your SSH client (ssh, PuTTy, etc.)
  2. From your EC2/Instances dashboard, hit the checkbox on your new instance.
  3. Get the public DNS for the instance you checked above in the form ec2-174-XXX-XXX-XXX.compute-1.amazonaws.com
  4. Copy and past the instance public DNS into your SSH client. Or if you have ssh installed on the command line, enter: ssh root@ec2-174-XXX-XXX-XXX.compute-1.amazonaws.com
  5. Connect to the TD Express image via your SSH client.
  6. Your username and password are both: root
  7. Set-up script will run and the first thing you will see is the Teradata Express License Agreement. Accept by hitting the Enter key.
  8. You will now see the set up screen below. Select ([x]) each of the two drives using the space bar and arrow keys.
  9. Tab to the next section to set the super user password.
  10. Keep or disable the sample database and Viewpoint as desired.
  11. 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: .logon 127.0.0.1/dbc
  • When asked for your password: dbc
  • 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.

  1. Get the public DNS for your EC2 instance (it shoudl be of the form ec2-174-XXX-XXX-XXX.compute-1.amazonaws.com).
  2. Open a new browser window
  3. Paste the DNS into the top box.
  4. Login to Viewpoint as username = admin and password = teradata.
  5. Towards the upper right of the main Viewpoint portal page, select Admin > Teradata Systems.
  6. Add a System. Go to the Setup > General form.
    • System Nickname - TDExpres
    • Check the System Enabled checkbox 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
    • Click Apply.
  7. Under Setup Data Collectors. Set all data collectors to delete data after 50 MB and 1 week.
  8. 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:

  1. Go back to your SSH interface.
  2. From the shell prompt: TDExpress14.0_Sles10:~/etc/init.d/dcs restart 
  3. Wait to complete.
  4. Repeat Step 2.

The initialization glitch should now be cleared and should not return.

Starting a Portlet

  1. On the top right of your Viewpoint screen you will see a link "<< Back to Portal". Click it.
  2. You are now on the main Viewpoint screen and can now start adding portlets.
  3. Click on the "Add Content" pulldown menu
  4. Select "Monitoring:
  5. Select "Canary Response Times"

This portlet will periodically submit a query to the system and measure its response time. Sometimes called a system heartbeat.

 

Done

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 /etc/opt/teradata/tdconfig.

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.

Discussion
optimumoss 1 comment Joined 06/12
28 Jul 2012

Thanks for this useful EC2 Configuration guide. It works fine in a day but when I stopped and re-start the instance, I can't anymore use the Teradata EC2 v14.0. It has a warning on the TD system and most of the collectors.

It is also giving me a "RDBMS CRASHED OR SESSIONS RESET".

I have to terminate and re-install again.

Cliff L 34 comments Joined 04/12
30 Jul 2012

Hi,

When you restart the instance, log into the linux kernel and type the following command

/etc/init.d/tpa start

This will start the database.

See if that helps.

jwh_ws 4 comments Joined 04/11
09 Sep 2012

Before you do a tpa start take a look for /var/opt/teradata/tdtemp and delete the file panicloopdetected if it is there. If you do a tpa start with it present it won't start.

pritesh21 1 comment Joined 06/13
30 Jun 2013

Can you provide a schema for trial?

sahmed448 1 comment Joined 02/10
09 Sep 2013

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.
 
Thanks
Sahmed448

Cliff L 34 comments Joined 04/12
09 Sep 2013

Do you have port 1025 open? See the User Guide for all of the ports and their configuration.

giles.bill1 1 comment Joined 03/14
05 Mar 2014

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.

smazingo 35 comments Joined 04/09
06 Mar 2014

You can stop and start without losing data.

jdliau 1 comment Joined 09/13
01 May 2014

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?
 
 

mguard 1 comment Joined 05/14
14 May 2014

I registered myself for subscribing Teradata 14 express wizard. I have still not received a confirmation mail.
Can someone help me here please
 
 

@Danesh

tanzir 1 comment Joined 08/14
22 Aug 2014

It's very unfortunate to see that not only me, several others facing the same problem when they just use the procedures mentioned in this post. So what is wrong here? The documentation or the image we get access? I followed the exact same steps 2times and everytime I'm facing the same issue "RDBMS CRASHED OR SESSIONS RESET". Again both times I didn't see the blue screen for more than 10 minutes, after doing 2-3 steps, it just gone. Showing a black screen and if I connect from another console and try to login, I see "RDBMS CRASHED OR SESSIONS RESET".

smazingo 35 comments Joined 04/09
29 Aug 2014

try the reboot. perhaps the volumes did not complete the attach. i've seen this before as well and the reboot worked. steve

nitneo 1 comment Joined 03/11
07 Oct 2014

I registered myself for Teradata 14 for amazon ec2 . I have still not received a confirmation mail.
its been 3 days now.
can someone look into this ?

smazingo 35 comments Joined 04/09
07 Oct 2014

when i tried to add your account, it was currently registered, which means you should have access now.

ebenthomas 1 comment Joined 12/14
05 Jan 2015

Hello 
I have register with Teradata for Teradata Express 14.0 for Amazon EC2 it has been more than 3 days now but I have not receieved any confirmation email. 
Request you to please help in this regard.
Thanks 
Eben Thomas
 
 
 

mstock 2 comments Joined 03/15
10 Mar 2015

Hello,
cc1.4xlarge instances are no longer available. What would you recommend from the current ec2 instance types for this installation?
Thanks,
Michael

smazingo 35 comments Joined 04/09
10 Mar 2015

did you try c4.xlarge. thanks

mstock 2 comments Joined 03/15
11 Mar 2015

Hello,
Is it possible to get this AMI in the us-west-2 region (Oregon)?
Thanks!
Michael

cmontes 2 comments Joined 08/15
10 Aug 2015

Hello 
I have requested for the link to Teradata Express 14.x on Amazon EC2 but I have not receieved any confirmation email. 
Please advise.

monty24 1 comment Joined 07/14
20 Aug 2015

After installing from the AMI, I will always receive:
.logon 127.0.0.1/dbc

Password:

 

 *** Warning: RDBMS CRASHED OR SESSIONS RESET.  RECOVERY IN PROGRESS.

 

It takes a few minutes before the warning appears and during that time bteq eats one CPU.

 

I've configured and checked ntp to be running and time to be correct (although this is a single node).

I've checked that ping localhost works, as well as ping hostname assigned by AWS (although it is logon 127.0.0.1)

I've tpa to be started. It seems not always to start nicely. Restart makes no difference.

There is no panicloop file.

In /var/log/messages it reads:

 

ug 20 02:02:02 ip-192-168-177-65 Teradata[7043]: INFO: Teradata: 13018 #Event number 33-13018-00 (severity 0, category 11) 1 node online.

Aug 20 02:02:05 ip-192-168-177-65 Teradata[8305]: INFO: Teradata: 15070 #PDISK 0 has incorrect device number 1 in its tag

Aug 20 02:02:05 ip-192-168-177-65 Teradata[8305]: INFO: Teradata: 15070 #PDISK 1 has incorrect device number 0 in its tag

Aug 20 02:02:06 ip-192-168-177-65 Teradata[7043]: INFO: Teradata: 13896 #COD: DiskPerformance scaled to 100%

Aug 20 02:02:08 ip-192-168-177-65 Teradata[7043]: INFO: Teradata: 13896 #COD: CpuPerformance scaled to 100.0%

Aug 20 02:02:08 ip-192-168-177-65 PDE[7043]: Assert failed in 7043: rssget_scsi_address:proc partition file open failed at rss/rssldvlnx.c:1194

Aug 20 02:02:08 ip-192-168-177-65 Teradata[7043]: INFO: Teradata: 13815 #Event number 33-13815-00 (severity 10, category 12) Application not started because all AMPs are in NewProc or Fatal state.

Aug 20 02:02:08 ip-192-168-177-65 Teradata[8338]: INFO: Teradata: 8001 #Event number 34-08001-00 (severity 0, category 10), occurred on Thu Aug 20 02:02:08 2015 at 001-01 (Vproc 8192, partition 10, task 8338) in system tdexpress in Module gtwgateway, version PDE:14.00.00.01,TDBMS:14.00.00.01,PDEGPL:14.00.00.01,RSG:14.00.00.00,TGTW:14.00.00.00,TDGSS:14.00.00.00

Aug 20 02:02:08 ip-192-168-177-65 Teradata[8338]:  Starting Gateway

Aug 20 02:02:10 ip-192-168-177-65 csp[8346]: INFO: TdatTools: 29001 #csp: Searching for dumps in raw dump directory /var/opt/teradata/tddump

Aug 20 02:02:10 ip-192-168-177-65 csp[8346]: INFO: TdatTools: 29001 #csp: No dumps found, no dumps to process

 

 

The '#PDISK 0 has incorrect device number 1 in its tag' seems weird; it might be related to be snapshotting the original two added volums and then recreating them as maximum speed volumes, since I thought that recovery took very long, but that delay forever seems to be normal. Even in that case the error appeared.

 

Sofar the AMI no longer seems to run nicely. I would appreciate it when there would be some help; we would like to make our software also run on Teradata but have no plans on purchasing and configuring the large box.

cmontes 2 comments Joined 08/15
20 Aug 2015

Hmm I guess we cannot delete or edit our own comments here. Looks like this is also not a good place to get answers. I sure wish Teradata would update this guide. 

smazingo 35 comments Joined 04/09
21 Aug 2015

I am looking at this. I am have some unrelated issues right now.

Nick9381 1 comment Joined 10/11
09 Sep 2015

Hello,
I activated the vm, I completed the installation succesfully.
Unfortunately after few minutes of usage, executing test query with bteq I receive an error message that say database crashed; VM becomes unreachable. At this point I can only shutdown and start again the VM (not reboot because doesn't work).
Is there a log that I can read to understand what happen ? 
 
I used the c4.2xlarge "instance type" and I added two volumes of 40GB.
 
Thank you,
Nicola

mlenhardt 1 comment Joined 09/15
18 Sep 2015

For those who experience the "RDBMS CRASHED OR SESSIONS RESET" issue:
It might be the case that you are simply using the wrong password.
The configuration script running at first starup asks you to set a password.
If you set one at this point you will have to login with .logon 127.0.0.1/dbc but use your own password of course and not "dbc".
 

28 Nov 2015

Hello 

 

I have register with Teradata for Teradata Express 14.0 for Amazon EC2 it has been more than 3 days now but I have not receieved any confirmation email. 

Request you to please help in this regard.

 

Thanks

Rajkumar

smazingo 35 comments Joined 04/09
30 Nov 2015

your requests were approved over the US holiday weekend. Let me know if you can't access the AMI. thanks, steve

rajkumar.durai 1 comment Joined 11/14
03 Jan 2016

Hello,
 
I have resgisterd for this access three weeks before. but i didn't get any confirmation email for my aws access. I have also raised another request today.
 
Could you please look into my request and provide the teradata express  to my aws account.

smazingo 35 comments Joined 04/09
05 Jan 2016

you're registered now.

TealiumLabs 1 comment Joined 03/16
25 Mar 2016

Steve - Can you grant me access to the AMI?  I'm trying to setup a test for a mutual customer of ours.

skhurana333 1 comment Joined 01/16
01 Jun 2016

I am not able to find the ami-99f65af0 on aws can you share that with me i am already a registered member ?

You must sign in to leave a comment.