Datastage log

sun786 · Post by **sun786** » Mon Feb 07, 2005 6:58 am

Can some one let me know the path for the datastage log?

Thanks for your time.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Feb 07, 2005 7:04 am

If you are asking on the Server, it will be under your projects directory. You can find the project directory by selecting the project in DataStage Admin. You can see it on the (hash) file called RT_LOGnnn where nnn is the job number.

Alternatively (on the humour side), if you want from Client, it is on DataStage Director -> Log View.

ogmios · Post by **ogmios** » Mon Feb 07, 2005 8:31 am

Maybe it's time to make a FAQ item for this question

You cannot just read the "DataStage Log files" with vi e.g. you need something to get the log entries in readable format, either with dsjob or writing something in uv/BASIC to extract the entries. Also some third party add-on tools (search for dwnav) will do something like that already.

Ogmios.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Feb 07, 2005 8:35 am

You can access the hash file RT_LOGnnn as any normal hash-file in Unix and specify the account to be your project name.

You can obtain the column info using 'LIST DICT RT_LOGnnn' from your universe command mode from any project.