where the job logs getting stored
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Mon Mar 03, 2008 10:58 pm
- Location: Chennai
where the job logs getting stored
Hi all,
I need help on the following,
Where the job logs getting stored in UNIX server and how to clear the logs via UNIX server instead of using Datastage director/clear log?
Thanks in Advance.
Regards,
Sathish Bhojan
I need help on the following,
Where the job logs getting stored in UNIX server and how to clear the logs via UNIX server instead of using Datastage director/clear log?
Thanks in Advance.
Regards,
Sathish Bhojan
Sathish Bhojan
Job logs are stored in hashed files under the associated project directory. They take the name of RT_LOGnnn where 'nnn' is the internal number assigned to the job in the repository.
You can access them using the 'dsjob' function, which supports the same log access functions as does DataStage:
-logsum
-logdetail
-lognewest
You can access them using the 'dsjob' function, which supports the same log access functions as does DataStage:
-logsum
-logdetail
-lognewest
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
I have used the following procedures to clear log files. I am using DataStage V8.0.1.
- Logon on to the administrator client for the domain
- Select the Projects tab
- Select the project containing the log file
- Select the command button
- In the command window; enter the following command -
'CLEAR.FILE RT_LOGXXX', without the quotes, where XXX is the number.
- Logon on to the administrator client for the domain
- Select the Projects tab
- Select the project containing the log file
- Select the command button
- In the command window; enter the following command -
'CLEAR.FILE RT_LOGXXX', without the quotes, where XXX is the number.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 43
- Joined: Mon Mar 03, 2008 10:58 pm
- Location: Chennai
Is there any env variable or command to see the logs for particular job in UNIX ?sjfearnside wrote:I have used the following procedures to clear log files. I am using DataStage V8.0.1.
- Logon on to the administrator client for the domain
- Select the Projects tab
- Select the project containing the log file
- Select the command button
- In the command window; enter the following command -
'CLEAR.FILE RT_LOGXXX', without the quotes, where XXX is the number.
Sathish Bhojan
Yes, "dsjob -logdetail MyProject MyJob" would list the detailed log for job 'MyJob' in project 'MyProject'
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
I have used the following to find the number used to associate a job to its RT_LOGXXX file, where XXX is the number.
- Logon to the administrator client
- Select the project
- Select the command button
at the command window enter the following command without the quotes.
"SELECT NAME,JOBNO FROM DS_JOBS WHERE NAME NOT LIKE '\\%';"
This will provide a list of the jobs for the project and the corresponding number for each job. This number will be the same number used in the RT_LOGXXX file name.
- Logon to the administrator client
- Select the project
- Select the command button
at the command window enter the following command without the quotes.
"SELECT NAME,JOBNO FROM DS_JOBS WHERE NAME NOT LIKE '\\%';"
This will provide a list of the jobs for the project and the corresponding number for each job. This number will be the same number used in the RT_LOGXXX file name.
-
- Participant
- Posts: 43
- Joined: Mon Mar 03, 2008 10:58 pm
- Location: Chennai
-
- Participant
- Posts: 43
- Joined: Mon Mar 03, 2008 10:58 pm
- Location: Chennai
-
- Participant
- Posts: 43
- Joined: Mon Mar 03, 2008 10:58 pm
- Location: Chennai
chulett wrote:Job logs are stored in hashed files under the associated project directory. They take the name of RT_LOGnnn where 'nnn' is the internal number assigned to the job in the repository.
You can access ...
Hi Chulett..
You told that all log info stored in hashfiles ..Can we clear the logs depends on jobs in UNIX?
Sathish Bhojan