DataStage job doesn’t terminate/ slowness while terminating

DataStage job doesn’t terminate/ slowness while terminating

If your DataStage takes time to terminate/ you experience delays in the termination of an a job when it is run – you need to clear out &PH& directory

This happens when you don’t clean &PH& periodically.

The &PH& directory contains information about active stages that is used for diagnostic purposes

To clear the directory:

  1. Ensure that there are no jobs running anywhere on the system
  2. Alternatively – you can clear project wise – if it is a shared server
  3. Open the Administrator client, go to the Projects page, select the project whose file you want to clear, and click Command.
  4. In the Command Interface window, type the following command:
    CLEAR.FILE &PH&
  5. Click Execute to run the command and clear the file.
Author: Kuntamukkala Ravi

ETL Consultant by Profession, Webmaster by Passion

One thought on “DataStage job doesn’t terminate/ slowness while terminating

Leave a Reply

Your email address will not be published. Required fields are marked *