How to check &PH&

How many times have you heard, "Is there anything in &PH&?"? That many. The following is everything you every wanted to know about &PH&, and then some.

When a DataStage job runs, it creates one or more phantom processes on your DataStage server. Generally, one phantom process for the job, and one for each active stage within the job. Each phantom process has its own log file that records information about the process's execution. This information may be useful for debugging problems.

Log files are created in the folder &PH&. A &PH& folder exists in each DataStage project folder. A DataStage job phantom will create a log file in the &PH& folder named with the prefix DSD.RUN_, a DataStage active stage will create a log file in the &PH& folder named with the prefix DSD.StageRun_. All log files end with a time and date suffix. The time is seconds since midnight, and the date in a Universe julian date. These dates and times are usually close to those found in DataStage Director on the Control event Starting job ...

A useful tool is to create a routine in DataStage Designer that will suggest a log file name. The source of this routine is:

Ans = "DSD.RUN_":Iconv(TheTime,"MTS"):"_":Iconv(TheDate,"D-YMD[4,2,2]")

TheDate and TheTime are the routine arguments. Get the job's run date and time from DataStage Director, the use the test button for this routine in DataStage Designer to compute a suggested log file name.

Another useful piece of information is the DataStage job's number. An easy way to find a job number is with DataStage Administrator. In DataStage Administrator, select a project on the Projects tab, then press the Command button. Enter the command:

LIST DS_JOBS JOBNO WITH NAME = "your job name"

Press the Execute button, and your job's name and number will be displayed.

Armed with a job's name, run date, and run time, and a suggested log file name, finding the actual log file is based on the operating system of your DataStage server. The following steps assume a workstation with capabilities similar to Windows Server and My Computer or Explorer.

For Windows servers, and Unix servers with SAMBA:

For other Unix servers:

To be determined.

If you have any additions for this page, email them to me at

Copyright 2016 Another IT Co