Guru Of Geeks

DataStage Error:   Job xxx is being accessed by another user    Take below steps to get rid of locks in datastage -- In web console check active sessions and if job is listed disconnect session. To view all active sessions: In the Web console, click the Administration tab. In the Navigation pane, select Session Management > Active Sessions The Active Sessions pane shows the users that are currently connected to the server.

What can you delete to free up disk space in IBM InfoSphere Information Server when disks are becoming full? What to do ???? Here are some things you can do to clean up space: Clear the &PH& file in the Project directory. There is a &PH& directory in each DataStage project directory, which contains information about active stages that is used for diagnostic purposes. The &PH& directory is added to every time a job is run, and needs periodic cleaning out. To clear the file from within DataStage: Ensure there are no DataStage jobs running anywhere on the system by running "ps -ef | grep dsrpc" From the DataStage Administrator, go to the Projects page, select the project whose file you want to clear and click the Command button. The Command Interface dialog box opens. Type the following into the command field: CLEAR.FILE &PH& (all uppercase) Click Execute to run the command and clear the file. For additional information, go to  Command ...

How should we manage cleaning up the &PH& directories for my DataStage projects? Can the process be automated? Files in the  &PH&  directories under DataStage project directories store runtime information when jobs are run and need to be cleared out periodically.  

When a DataStage job with a lookup stage aborts, there may be lookuptable files left in the resource directories and they will consume space. The filenames are similar to "lookuptable.20091210.513biba" When a job aborts it leaves the temporary files for postmortem review in the resource directories. Usually that is done in scratch, however, for lookup files, they are created in resource. Lookup filesets will not go away, just like regular datasets.

Data Sets sometimes take up too much disk space. This technote describes how to obtain information about datasets and how to delete them.