where the job logs getting stored

sathishmca · Post by **sathishmca** » Mon Oct 20, 2008 6:15 am

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

chulett · Post by **chulett** » Mon Oct 20, 2008 7:43 am

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

sjfearnside · Post by **sjfearnside** » Mon Oct 20, 2008 8:21 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.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 20, 2008 2:39 pm

By doing so you lose any job log purge settings you may have had.

sathishmca · Post by **sathishmca** » Tue Oct 21, 2008 12:01 am

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.

Is there any env variable or command to see the logs for particular job in UNIX ?

ArndW · Post by **ArndW** » Tue Oct 21, 2008 4:47 am

Yes, "dsjob -logdetail MyProject MyJob" would list the detailed log for job 'MyJob' in project 'MyProject'

sjfearnside · Post by **sjfearnside** » Tue Oct 21, 2008 5:52 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.

sathishmca · Post by **sathishmca** » Tue Oct 21, 2008 6:43 am

ArndW wrote:Yes, "dsjob -logdetail MyProject MyJob" would list the detailed log for job 'MyJob' in project 'MyProject' ...

Thanks..

Still i need logs of last run if suposse job might have throw some fatal errors or warnings ..How to get this info?

chulett · Post by **chulett** » Tue Oct 21, 2008 6:45 am

As already noted, use "dsjob" with the various "-log" functions. Read the Server Job Developer's Guide chapter on the Command Line Interface for explanations of their use.

sathishmca · Post by **sathishmca** » Tue Oct 21, 2008 6:48 am

chulett wrote:As already noted, use "dsjob" with the various "-log" functions. Read the Server Job Developer's Guide chapter on the Command Line Interface for explanations of their use. ...

Thank you very much..

sathishmca · Post by **sathishmca** » Wed Oct 22, 2008 11:52 pm

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?

chulett · Post by **chulett** » Thu Oct 23, 2008 12:21 am

If you are asking if you can clear job logs from the UNIX command line, the answer is no. Best to get your Auto Purge settings right and let that happen automatically.