Posts

Showing posts with the label DataSet

Orchadmin Command : DataStage

Orchadmin is a command line utility provided by datastage to research on data sets. The general callable format is :  $orchadmin <command> [options] [descriptor file] 1. Before using orchadmin, you should make sure that either the working directory or the $APT_ORCHHOME/etc  contains the file “config.apt” OR The environment variable $APT_CONFIG_FILE  should be defined for your session.

What can you delete to free up disk space in IBM InfoSphere Information 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 ...

Deleting temporary lookuptable files in IBM InfoSphere DataStage

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.

Managing and Deleting Persistent Data Sets within IBM InfoSphere Datastage

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

Setting up "CRON" Jobs in Linux

If you want to use the emacs editor for editing cron jobs, then, set the following in your "/home/user/.bash_profile" EDITOR=emacs Then, to edit cron jobs $ crontab -e You may want to put in the following header