Guru Of Geeks

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.  

General Job Administration APT_CHECKPOINT_DIR APT_CLOBBER_OUTPUT APT_CONFIG_FILE APT_DISABLE_COMBINATION APT_EXECUTION_MODE APT_ORCHHOME APT_STARTUP_SCRIPT APT_NO_STARTUP_SCRIPT APT_STARTUP_STATUS APT_THIN_SCORE

APT_CONFIG_FILE  is the file using which DataStage determines the configuration file (one can have many configuration files for a project) to be used. In fact, this is what is generally used in production. However, if this environment variable is not defined then how DataStage determines which file to use? 1)If the APT_CONFIG_FILE environment variable is not defined then DataStage look for default configuration file (config.apt) in following path: 1)Current working directory. 2)INSTALL_DIR/etc, where INSTALL_DIR ($APT_ORCHHOME) is the top level directory of DataStage installation.