Deleting instance\jobs\Logs in Director automatically
Moderators: chulett, rschirm, roy
Deleting instance\jobs\Logs in Director automatically
Hello Everyone,
i know that using some routines, we can delete job's logs.
But is there a way to delete instances\jobs runs in the director using a keyword that is in the name of the job instead of deleting jobs manually job by job ?
Sometimes i have to delete some runs using a keyword like DC_YYYYMMDD on a job name as JcRun.DC_20130529145400.
Thanks
Carlos
i know that using some routines, we can delete job's logs.
But is there a way to delete instances\jobs runs in the director using a keyword that is in the name of the job instead of deleting jobs manually job by job ?
Sometimes i have to delete some runs using a keyword like DC_YYYYMMDD on a job name as JcRun.DC_20130529145400.
Thanks
Carlos
Auto Purge ?
I think i have not expressed well my needs.
I have to purge instances in the director module using a keyword used in the instance name.
Example :
if i have 60 instances by each jobs and 10 jobs, that will do 600 logs in the director.
Each instance have the establishment name and the day run.
I want to delete juste some establishment and for a specific day.
How can i do that without making it manually ?
I think i have not expressed well my needs.
I have to purge instances in the director module using a keyword used in the instance name.
Example :
if i have 60 instances by each jobs and 10 jobs, that will do 600 logs in the director.
Each instance have the establishment name and the day run.
I want to delete juste some establishment and for a specific day.
How can i do that without making it manually ?
Last edited by CLOPES on Fri May 31, 2013 7:25 am, edited 1 time in total.
I understood want you wanted, what I don't see right now why you'd "need" to do this kind of selective purge rather than just letting auto purge handle a full day or number of runs. As noted, you'd need to go under the covers and know how to delete records from hashed files to play this game.CLOPES wrote:I want to delete juste some establishment and for a specific day.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Look near the bottom of the DSParams file in the project directory on the DataStage engine. This is where the values that determine the location of logging are stored. One of them is ORLogging. What values do these have?
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hello everyone,
Thanks for your feedbacks both.
I'm working on 8.5 version.
Most of the jobs are in server edition.
I don't have access to the server but when i take a log to administrator parameters, all DB2 parameters are empty.
Does it means that all logs are in Universe database ?
As i don't know enough the new version, can i delete jobs using the web admin module ?
Thanks for your feedbacks both.
I'm working on 8.5 version.
Most of the jobs are in server edition.
I don't have access to the server but when i take a log to administrator parameters, all DB2 parameters are empty.
Does it means that all logs are in Universe database ?
As i don't know enough the new version, can i delete jobs using the web admin module ?
Sorry but I'm not really sure what that means or what that has to do with job logs.CLOPES wrote:I don't have access to the server but when i take a log to administrator parameters, all DB2 parameters are empty.
Jobs or job logs?CLOPES also wrote:can i delete jobs using the web admin module ?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers