Help in Deleting Session Logs

[unreal77]

Hi~~
I'm tired of deleting thousands of session logs in the repository manager every month.
Is there any way to solve this problem?
If you know it, please help me....

ps. My Informatica PowerCenter is version 5.1

 

[bardhaan]

Hi ,
You haven't stated clearly that every time you run a particular session, one log file is created or there is a single log file and it is updated or overwritten everytime you run that particular session.
a) If the case is second one, you have to go and manually delete the session logs, no other option.
b) If the case is first one, you can change it at session level.
Edit the session.Go to log and error handling tab.See the option SAVE SESSION LOGS BY TIMESTAMP is checked or not.Most probably it is checked.Uncheck it and check other option i.e. SAVE SESSION LOGS FROM LAST -- SESSION RUNS.
Put 0 at the -- place.Then click ok.
It will make the setting like that only a single log file will be there for that particular session and everytime you run the session it will be overw or updated.

I think this will solve your problem.
Please inform incase of any further problem.
Regards,
Ani.

 

[Casemore]

In addition to bardhaan's posting, if you did want to keep the sessions by timestamp but only wanted to keep, say, a week's worth of logs for each session that had been run then you could build a UNIX script (if you're running on UNIX, I'd assume you could do something similar on SQL Server?) to look for files older than 'today' - 7 days and remove them. Then just call this script from a post session command in one your session.

It would be handy if Informatica incorporated something like this into their logging options though......