huge RT_LOG

[mystuff]

I am having a huge RTLOG file, although I have kept autopurge for every 10 days option.

Why will happen as such and any way to remove it, as its causing space issue.

[DSguru2B]

RT_LOG will be suffixed by a three digit number. Use that number to find what job it is (use the below query in the Administrator) and then go clear that jobs log from the director.

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO = 'nnn';

where nnn= your job number

[chulett]

But first you need to figure out why it is getting to be 'huge'. Is your job aborting? Keep in mind the fact that aborted jobs don't 'auto-clear' their logs.

Otherwise, the other thing that comes to mind are it must be chocked full of warnings. There's no reason a Server job should ever log a warning, it's a sign of either a flaw in the job's design or a database/tablespace/filespace issue that needs to be resolved. We see this when someone runs a job allowing unlimited warnings because they don't want it to abort - is that what you are doing?

If not, please let us know what in the heck you are finding in these huge logs.

[mystuff]

I just saw that the job has been deleted from the project. What shall I do in this cae?

[DSguru2B]

If the job got deleted then its RT_LOG should have disappeared too. If your wondering whether you can get it back, then the answer is,
"only from a backup", else its gone.

[chulett]

Are you sure it was deleted? Space issues in the DataStage installation filesystem can corrupt everything and make stuff 'disappear'. Search the forum for DS.TOOLS or DS.REINDEX for discussions on rebuilding the repository indices.

Otherwise - Repromote it from Version Control. Reimport using the Manager, either from Dev or a backup. Worst case, you'll need to recreate it.

[mystuff]

This job was not part of the design, so I wouldnt be bothered if its gone, We have backup of the job which are part of the design. But the log file from this is creating space problems. (just found from another version, that it gives plenty of warnings)

The RT_LOGnnn is still in there.

when I open the director, it gives an error

Code: Select all

DataStage Reporsitory Interface
Failed to open RT_LOGnnn

Or can I use

Code: Select all

DELETE FROM VOC WHERE NAME='' 

something like that? I tried using

Code: Select all

CLEAR.FILE

but didnt work

I also tried to replace it with new job, with same name. Will it be safe now to use mv command or will it create problems

[ray.wurlod]

Use DS.CHECKER

However, if you have already inflicted damage (like deleting a VOC entry), then DS.CHECKER will not work, and you will need to clear things manually.

Let us know.

Then analyze why the warnings are being generated, and re-design the job with a view to preventing them from occurring. No server job should ever generate a warning unless it is caused by environmental or data factors.

[DSguru2B]

Clear the logs of a few jobs. Make space. The try clearing the RT_LOG of that particular job.