Error Logs

Database
Enthusiast

Error Logs

I'm a newbie and cannot find the error logs for Teradata (13.10).  I've googled and I get a million and one things about error logs but not what I'm looking for.  I'm looking for the logs that say if TD went down or is up and healthy - all that kind of stuff.  Or if you can give me the right words to search on I can find and read about it.

9 REPLIES
Enthusiast

Re: Error Logs

Hi,

This may help. While using a utility(say Fast load), in the script itself u can mention the error logs.

ex :

Drop table emp_er1;

Drop table emp_er2;

Drop table emp;

Create set table emp (

Empno smallint format '999' not null

,name varchar(20)

,salary decimal(8,2)

,city varchar(12)

,state varchar(2)

,doj date format 'YYYY-MM-DD')

Unique primary index (empno);

.set record vartext ",";

Begin loading emp

Errorfiles emp_er1

,emp_er2

;

Define

Empno (varchar(3))

,name (varchar(20))

,salary (varchar(8))

,city (varchar(12))

,state (varchar(2))

,doj (varchar(10))

File=c:\fl\emp_data.txt

;

Show

;

Insert into emp

(

Empno

,name

,salary

,city

,state

,doj

)

Values

(

:Empno

,:name

,:salary

,:city

,:state

,:doj

)

Later check the tables emp_er1 and emp_er2 .Hope this Helps

Cheers,

Subbu

Enthusiast

Re: Error Logs

Okay, thx, but let me ask it this way:

Let's say TD is down for some reason and you don't know why.  You have to go to some error logs and look up what happened right?  Where would you go?

Enthusiast

Re: Error Logs

For load utility hope this helps...folder depends on your db release... for 14.10:

For Windows:

    Program Files (x86)\Teradata\Client\14.10\Teradata Parallel Transporter\logs

Joe

Enthusiast

Re: Error Logs

If you are running into problems getting Teradata started, the first place to check for clues is in the log file:

1

tail /var/log/messages



May be if you can get this path

Enthusiast

Re: Error Logs

cool!  thx guys.  we're on linux.  I'll check out and see if I can find it.

Enthusiast

Re: Error Logs

For Linux

/var/log/boot.msg

This log contains messages produced during the current system boot.

You can also display the information from this log using the dmesg command. Most of the dmesg information is logged to /var/log/boot.msg.

/var/log/boot.omsg

This log contains messages produced during the previous system boot.

 

/var/log/messages

This is the main system log on the node.

This file contains all the messages generated by the kernel and various other programs while the system is up and running.

Cheers,

Subbu

Enthusiast

Re: Error Logs

hmmm.  i got permission denied.

Enthusiast

Re: Error Logs

You might be working on a client server. May be the admin can grant you the rights(not possible in many cases).

Enthusiast

Re: Error Logs

I just found out that only root has the rights.  TD runs the server, so I guess we can't see that.  Talked to the senior guy and he said he is able to figure out why the intance went down based on viewpoints alerts/messages.  So now I'm focusing on getting more adept at that.