Recent content by TeraOz

I pretty sure TSET doesn't actually move data - I've used it to copy table definitions/statistics from production to test systems for troubleshooting and prototyping purposes. How you might do this depends on what you are attempting to achieve. If you simply want to do explains on your...

PMON (part of TD manager, but also present on the Teradata demo cd) is a good place to start especially with R4 and R5 where you can see SQL being run. It has an AMP CPU Skew display on the sessions screen. Anything with a high value you can display the sql of and find your problem query -...

Hi Michael, Are you attempting to do this in SQL, a stored procedure, a macro, or perhaps some other (external to DB) language... The approach taken obviously depends on the environment being used. What is the purpose of the variable you are attempting to define? If it is just a parameter to...

I would suggest that you write a wrapper in c for your bteq jobs that takes two command line args, one for the script file to use, and another for the bteq log output filename. This is a pretty simple program. I have attempted to do this sort of thing exclusively within VB (using stdin/stdout...

At first I was inclined to agree with BillDHS re disclosing admin user and default password - i.e. not a good idea, however after a few seconds came to the conclusion that whoever administers a system and leaves the default password for DBC (or any other DBMS/OS default user) deserves what they...

To remove the requirement that you add the <hostname>cop<n> aliases to your hosts file you can add them to the dns directly. It can be a big deal visiting many workstations just to update hosts files, so much better to add the cop IP addresses to your site's DNS database. Contact the...