Page 1 of 1

How to look into logs?

Posted: Wed Jan 23, 2008 1:42 am
by SHARAD123
Hi All,
How to view the datastage error log from administrator?

Posted: Wed Jan 23, 2008 6:39 am
by WoMaWil
(1) choose projects
(2) choose command
(3) use DS.TOOLS to find the jobnumber of the logfile
(4) write on the commandline "SELECT * FROM RTLOG_<num>"

Posted: Wed Jan 23, 2008 7:45 am
by ray.wurlod
You don't. You view it from Director. That's the main reason for having the Director client.

Posted: Wed Jan 23, 2008 7:47 am
by chulett
Which implies you need to know the job number for the job in question:

Code: Select all

SELECT JOBNO FROM DS_JOBS WHERE NAME = 'JobName';
Assuming that 'datastage error log' = job log, that is.