Background processes are called "phantom" processes in DataStage, for reasons historical. These processes direct their output to files in &PH& which is a subdirectory in the project directory.
Do not use the sledgehammer approach proposed by rameshrr3. Instead use a gentler approach which removes only older records. That way, if there are running jobs, you will not trample on the files to which they are trying to redirect their output.
Code: Select all
find '&PH&' -atime +7 -exec rm {} \;
Beware that "&" and ";" are special characters in the shell, so need to be hard-quoted or escaped in the find command.
The number of files limit limits the number of files a process can have open simultaneously. By setting this to a larger value in
dsenv is means that a given DataStage process will be less likely to fail to open a file because it has no more file units available.
![Idea :idea:](./images/smilies/icon_idea.gif)
To execute a UNIX command from the Administrator client use the SH command.
Code: Select all
SH -c "find '&PH&' -atime +7 -exec rm {} \;"