How to look into logs?

SHARAD123 · Post by **SHARAD123** » Wed Jan 23, 2008 1:42 am

Hi All,
How to view the datastage error log from administrator?

WoMaWil · Post by **WoMaWil** » Wed Jan 23, 2008 6:39 am

(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>"

ray.wurlod · Post by **ray.wurlod** » Wed Jan 23, 2008 7:45 am

You don't. You view it from Director. That's the main reason for having the Director client.

chulett · Post by **chulett** » Wed Jan 23, 2008 7:47 am

Which implies you need to know the job number for the job in question:

SELECT JOBNO FROM DS_JOBS WHERE NAME = 'JobName';

Assuming that 'datastage error log' = job log, that is.