Stop Teradata SQL Assistant from getting Timeout

teradata

So often it happens that we execute SQL queries which dump the data into some volatile tables however when we return and check data in volatile table , we see that Teradata SQL Assistant connection timed out and has been disconnected. Then again we have to run same queries and do our analysis. So to overcome this why not run a process which should not consume any AMPCPU and also make sure that your connection stay active. We will create a stored procedure and will run it. And we can continue working in other tabs in Teradata SQL Assistant. You can use below Stored Procedure to make sure your connection stay active for the time you want it to be.

REPLACE PROCEDURE STAY_ACTIVE()
BEGIN
DECLARE VAR_CNTR1 TIMESTAMP;
DECLARE VAR_CNTR2 TIMESTAMP;
SET VAR_CNTR1 = CURRENT_TIMESTAMP(0);
SET VAR_CNTR2 = CURRENT_TIMESTAMP(0) + INTERVAL '600' SECOND;
REPEAT
SET VAR_CNTR1 = CURRENT_TIMESTAMP(0);
UNTIL VAR_CNTR1 > VAR_CNTR2
END REPEAT;
END;

The above proc will run for 600 seconds. You can modify the values like '600' SECOND, '60' MINUTE, '6' HOUR etc. To run the proc just call it.

CALL STAY_ACTIVE();

5 thoughts on “Stop Teradata SQL Assistant from getting Timeout”

  1. am new to TD.. last week I download TERADATA 15.. I don’t know how to connect with database.. TD13 having teradata service control.. But TD15 not having that.. pls anyone give step by step process to run that..

    how can we set an username and password before creating the connection??

      1. sorry I cant get anything.. I installed TD15. that’s it.. I don’t know hw to run this and how to make ODBC connection.. already am wasted more than a week.. so pls help me.. I need step by step process. my mail id is Prakash_nov29@yahoo.co.in

        1. Hi Prakash
          Generally if the installation is successful, you can see TD Service Control icon on Desktop. When you are saying “I installed TD15” I am assuming you have installed TTU 15.00. You can check for TD Service Control @ “C:\Program Files\Teradata\Teradata Express Tools\Teradata Service Control\TeradataService.exe”.
          Once you enable this service , to create DB User & Pass, you have to login into TD Administrator.

          1. am using windows 8 64bit OS.. i think TTU 15 not having service control.. will you install and check whether it having or not.. pls.. thanks in advance..

Leave a Reply to B PRAKASH Cancel reply

Your email address will not be published. Required fields are marked *