Skip to main content

Delete job Log by invocation id from command line

Technote (FAQ)


Question

Is it possible to only purge/delete a job log by invocation id in multi-instance jobs from the DataStage command line?

Answer

No, this is not possible because log records for job invocations are stored together in the RT_LOG file for the job. Currently the purging mechanism only allows deletion by date/time and by number of previous runs, but it does not allow the identification of individual invocations within the log file,
Why is this different from DataStage Director Client?

In the DataStage Director, you can clean up the individual instance log. For example, take an ETL job named etl_a, which has 2 instances, etl_a.1 and etl_a.2. From DataStage Director, highlight etl_a.1, right-click, then select delete. This will delete etl_a.1 from job list. etl_a, while etl_a.2 will still remain in the job list.

In DataStage Director, the delete action described above only removes the invocation entry from the list of jobs and does not actually delete any log records, which remain in the log file until the purge mechanism discards them.

So the difference here is that the Director delete action only deletes records from RT_STATUS whereas the purging mechanism deletes records from RT_LOG.

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page

Please take a moment to complete this form to help us better serve you.

This material provides me with the information I need.






This material is clear and easy to understand.






Did the information help you to achieve your goal?

What updates, improvements, or related information would you like to see in this document?

Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.


Input the verification number to submit feedback:



Maintenance Window

Unscheduled Maintenance Window

There is no unscheduled maintenance scheduled at this time.

Document information

Product categories:

Software

Information Integration and Master Data Management

Information Integration Platform

InfoSphere DataStage


Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows


Software version:

6.0.1, 7.5, 8.0, 8.0.1, 8.1


Software edition:

All Editions


Reference #:

1397528


IBM Group:

Software Group


Modified date:

2009-09-09

Translate my page