Tuesday, December 15, 2009

Checking TD Version from UNIX

How would you check what version of teradata is being used in your UNIX env?

You simply have to create a bteq script:

bteq<<EOF

.logon databasename/username,pwd;

.show version

.QUIT

EOF

And run the script.

Or, you can do the same on commandline.

4 comments:

  1. OR you can always run the query:
    SELECT * FROM DBC.DBCINFO;

    ReplyDelete
  2. u r given good information tips for us.
    i have one doubt ,we r creating volatile table for intermediate calculation but it take lot of time. how to tune this table,PLS give me some tips to solve this problem.

    thanks & regards
    rafi.tdata@gmail.com
    MPHASIS

    ReplyDelete
  3. Hi Rafi,
    Make sure you have chosen the right Primary Index. Based on the data distribution and also based on how you will join with this table in future.
    You could run explain on your sql and see which step takes more I/O, and try to tune that step.
    Hope this helps.

    ReplyDelete
  4. how we delete parent table if the parent table having relation ship with child table

    ReplyDelete