How to clear the status files with Aix command interface

[jack_dcy]

Hi all,


we run the DSEE job with a job invocation id in Aix, so we have a large number of job instance in the Director everyday, we want to clear it with a Unix shell , so we can run it automatically everyday. how could we do this?

BTW, can we do a Universe shell command in the unix shell?

Thanks.

[ray.wurlod]

Is it the status file or the log that you want to clear? Your subject says status line, but your text suggests log file.

You can, of course, set automatic purging for log files (which are actually database tables in the Repository). Choose Job > Clear Log in Director with the job selected, and change the project defaults for automatic purging.

Otherwise you can clear either log or status tables using a DataStage (formerly known as UniVerse) shell. But you don't want to clear the status file; otherwise you would have to recompile jobs, and that can NOT be done automatically.

The problem with clearing either using SQL is that you have to be able to get the job number to determine which table to clear and you really should not clear the table, but delete any non-control records. A DataStage job log has three control records; one containing the next event number, one containing the purge settings, and one containing a list of job start event numbers. So there's more to it than you realize. Stay with the Director's auto-purge.

[jack_dcy]

hi ray,

thanks a lot.

what we want to delete , not only the log file, but also the job with invocation ID. the auto-purege action in administrator or director only clear the log file.

[Eric]

I think to clear the job with the Invocation ID from the director you would have to recompile the origianal job. (without InvocationID)

[kris]

I think to clear the job with the Invocation ID from the director you would have to recompile the origianal job. (without InvocationID)

You don't have to recompile the jobs to clear the log records for invocation ID's in director. Your purging criteria for that job applys to all the instantiated jobs with any invocation ID, because they are all going to same tables in the repository. So you wouldn't see any log in director for what you have purged.

The better way would be to enable Auto-purge of job log in general tab of administrator and choosing over number of days so that you will only see that many days log.

If you think you don't want to apply the purge criteria at the project level and want have criteria for only those jobs which are enabled for multiple instance, then you would have to do at the job level in director.

Hope this will help.

Kris~