How to open or connect teradata database on AWS after creating EC2 instance or a stack ? Can anybody tell the steps to how to connect to teradata database in AWS and create one table ??
Any advise will be appreciable.
In the response below I am assuming that you have already opened ports 22 and 1025 on the AWS side allowing ssh / odbc type connections to your Teradata instance. If not please see the Teradata Getting Started manual on how to do this.
To connect to the Teradata Database on AWS first you can start by using Putty and you can click this link for the article in the Teradata Community Forum titled How to Connect to Teradata EC2 Instance using Putty you will need the keypair that you generated when you launched the instance. There is no password, just a key that you use to connect. Once connected to the database if you want to become root just type:
# sudo su -
Next check to see if your database is already up.
# pdestate -a
PDE state is RUN/STARTED.
DBS state is 5: Logons are enabled - The system is quiescent <== You shold see an indication like this or maybe it says users are logged in.
If your database is not up and has never been up you may need to run the tdc-start script where it starts the database for the first time running some scripts behind the covers
If it is not the first time the database has been up and it is down you can simply start the database like this:
# /etc/init.d/tpa start <== Note the space between "tpa" and the word "start"
Make sure your database is up by running:
# pdestate -a
Once the database is up, you can login using bteq as follows and create a sample table like this:
At this point if the d
password: ********* <=== Enter the dbc password
ct systemfe.t1 (c1 char(8), c2 char(8));
which is just a short cut for
create table systemfe.t1 (c1 char(8), c2 char(8));