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.

Posted by at

4 comments:

  1. UnknownApril 8, 2011 at 8:11 AM

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

    ReplyDelete
  2. sk md RafiJune 18, 2011 at 6:26 AM

    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. Meena AthmanathanOctober 11, 2011 at 5:24 PM

    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. hymadsOctober 12, 2011 at 9:54 AM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)