confusion with Log file

Mhasan · Post by **Mhasan** » Tue Sep 18, 2007 9:59 pm

Hi ,
Can anybody tell me ..Is there any indication of job name with the log file ... Like if we look into the scratch path where we find so many log file crreated for diffrent job ..How we can find which log file is log file of My Job.....please suggest

Maveric · Post by **Maveric** » Tue Sep 18, 2007 10:35 pm

If you want the name of BAD file created during loading using load option then the name of the file will be present in the director log. If you are talking about the job logs then those are not stored in scratch space but in your project directory/project Or project directory/Project/RT_LOGXXX. XXX being a number. Do a search on RT_LOG, you will get more info. And these are hash file.

Mhasan · Post by **Mhasan** » Wed Sep 19, 2007 1:03 am

Thanks for the reply,
Actually Iam looking for the Log file name like Ora.XXX.XXX.log every time we run job it creates the Log file ...hOw to know which log file is for with Job ..in director i didnt find any file of name ora.....
I can do manual search but it will be very tedious Job... please let me know your suggestions...

ray.wurlod · Post by **ray.wurlod** » Wed Sep 19, 2007 1:23 am

The DataStage job log should report the pathname of the log/bad file that it used. And/or these probably are properties of the Oracle Enterprise stage.