Hi All,
When we run a job in DataStage job log can be viewed in Director. But where will these same information stored in UNIX? Will it be stored as a file? If so then can anybody please tell me what is the directory PATH where i will find the file in UNIX.
Thanks & Regards,
Rony
Path of job log files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada
Even though loveojha2 has answered your question, it wasn't a complete answer. The log files for DataStage jobs are stored in hashed files, which are not accessible from UNIX. There are different ways of reading these files or dumping them to text files (the dsjob unix program lets you do this with several options).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada
Logs are hashed files within the project directory. You really need to consider stopping this train of thought because the log information is not stored in a manner that is relational. The log for a job is dependent on its job number, which changes whenever you copy or import a job. Please accept this advice from us, use the APIs to get at log information.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Hi Rony,rony_daniel wrote:Thanks Arnd! I was able to get the job log details loaded onto a file with dsjob in UNIX.
But can you please tell me where these hashed files exist in the server.
Regards,
Rony
Could you please share the code or syntax - how you did get the log details to flat file using dsjob in unix.
Thanks
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada
The syntax is as follows :-Titto wrote:Hi Rony,rony_daniel wrote:Thanks Arnd! I was able to get the job log details loaded onto a file with dsjob in UNIX.
But can you please tell me where these hashed files exist in the server.
Regards,
Rony
Could you please share the code or syntax - how you did get the log details to flat file using dsjob in unix.
Thanks
dsjob -server <server> -user <username> -password <psw> -joblog -max 100 <Project Name> <Job Name> >> /home/<Filename>
1) Here max 100 means it will give the last 100 log data.
2) Filename is the name of the file in your unix server to which log data needs to be written.
Hope this helps you.
Regards,
Rony
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Let me stress again that there are no job log files (in the sense that they can be read using operating system utilities). DataStage maintains job log tables (which are implemented as hashed files, at least in current versions).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.