Unable to access DBSCONTROL settings from View point and node

Teradata Database on AWS

Unable to access DBSCONTROL settings from View point and node

We want to disable block level compression for M4 type servers and i cant access console from viewpoint and node, How can i update dbscontrol settings for AWS AMI?

1 REPLY
Teradata Employee

Re: Unable to access DBSCONTROL settings from View point and node

In the AWS environment you should be able to ssh to your Teradata on Amazon instance as long as your have your keyfile and as long as you have port 22 opened for your IP address in the firewall settings. When you connect make sure the username you are using is ec2-user and that your Putty or SecureCRT connectrion is set to use your pem keyfile that you established when you launched your instance. SecureCRT in my opinion is easier to use for connecting to AWS. Here are a couple articles with connection instructions:

 

Configuring SecureCRT for Teradata Database on AWS Connections

Configuring PuTTY for Teradata Database on AWS Connections

 

After you get connected to Linux in your AWS Teradata system you will want to use sudo to switch to root and then you should be able to run dbscontrol manually from the command line:

 

# sudo su -

# /usr/tdbms/bin/dbscontrol

 

After you make your changes in dbscontrol do the following in dbscontrol to save your changes:

 

write

quit