hi,
i want to list the name of job which takes more time for execution through unix shell scripting.
first, i want to know how to read the RT_LOG FILE which will be stored as hash . whether this file can be readable or not through unix scripting ? and how to find the particular log file for a job name.
if there is any websites which explains about the DATASTAGE UNIVERSE.
PLEASE LET ME KNOW....
THANKS & REGARDS,
KAMAL :D
To trace the time taken for execution for a particular job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What you seek to do is cumbersome, though possible. The dsjob command includes options for reading the job log; you must provide the project name and job name whose log you wish the command to access.
To get the job number associated with a job name from UNIX (which you don't need to use the dsjob command), be in the project directory and execute dssh with the relevant query, for example There are various commands for reading hashed files from the operating system; usually SQL executed in a dssh shell is easiest to manage.
Apart from what you can glean on DSXchange, I don't believe there is any website that describes the contents of the Repository database associated with a DataStage project.
To get the job number associated with a job name from UNIX (which you don't need to use the dsjob command), be in the project directory and execute dssh with the relevant query, for example
Code: Select all
dssh "SELECT JOBNO FROM DS_JOBS WHERE NAME = 'JobName';"
Apart from what you can glean on DSXchange, I don't believe there is any website that describes the contents of the Repository database associated with a DataStage project.
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.