Guru Of Geeks

Following are unix process list for a healthy DS system (Engine + Services + Metadata repository)

InfoSphere DataStage clients are not connecting. How can I trace the dsrpcd daemon to see what the problem is.

Problem The dsrpcd service is termination immediately after the DataStage Engine has completed the start up process Symptom In the rpc.out trace file you will see error message of ' get service by name bombed errno=0 '

Update your .bash_profile with following details . /opt/IBM/InformationServer/Server/DSEngine/dsenv source ~/profile Now create a new file profile in your home Directory and add with following details

For help, enter: "help". To exit, enter: ".","exit", or "quit" istool export -help istool export [ Options ] qjb - Job Sequence   sjb - Server Job   pjb - Parallel Job   srt - Server routine   tbd - Table Definition   tfm - Transform

Linux: [root@ibmiis9 ~]# cd /opt/IBM/InformationServer/Server/PXEngine/ [root@ibmiis9 PXEngine]# export APT_ORCHHOME=`pwd` [root@ibmiis9 PXEngine]# cd java/ [root@ibmiis9 java]# ./jobmoninit stop JobMonApp has been shut down. [root@ibmiis9 java]# ./jobmoninit start JobMonApp has been started. [root@ibmiis9 java]#

Maintenance mode To prevent users from authenticating to  IBM® InfoSphere® Information Server  during maintenance, you can place it into maintenance mode with the SessionAdmin command. Use the same command to take  InfoSphere Information Server  out of maintenance mode and to determine the current maintenance mode. Placing  InfoSphere Information Server  in maintenance mode is useful when you do routine maintenance such as applying a fix pack or backing up the system. When in maintenance mode, only users with the suite administrator role and system users can authenticate. Note also that in the Web admin console,   Maximum Sessions   is not editable while  InfoSphere Information Server  is in maintenance mode.

Problem When trying to open a job in Designer client in DataStage (DS), message indicates the job is locked by another user.

Automatically starting and stopping the AppWatcher process Configure the AppWatcher process to automatically start after restarting the engine system. About this task On Windows, the AppWatcher process is implemented by a service called DataStage AppWatcher Service. By default, this service is not configured to automatically start when the system is started. You can configure this service by modifying the settings for the service in the control panel. On UNIX and Linux, you can update the DataStage Engine startup script to automatically start and stop the AppWatcher process.

Activating and deactivating   IBM InfoSphere DataStage   editions and feature packs Run the   LicensingServiceAdmin   command-line tool to change the  InfoSphere® DataStage®  features that were activated when the services tier was installed. The tool can activate or deactivate  InfoSphere DataStage  editions and feature packs within your suite if  InfoSphere DataStage  is installed.

Viewing a list of activated   IBM InfoSphere DataStage   editions and feature packs Run the   LicensingServiceAdmin   command line tool to list the activated  IBM® InfoSphere® DataStage®  editions and feature packs within your suite. Before you begin You must have at least Suite User authority.

There are Three methods to unlock the DataStage jobs: –  Using DataStage Administrator Tool.   –  Using UV Utility   –  Using DataStage Director

Location of command: UNIX: /opt/IBM/InformationServer/Clients/istools/cli Windows: IBM\InformationServer\Clients\istools\cli

When attempting to open a job log in Director, user gets the following error message: Error selecting from log file RT_LOG### Error was: Unable to open DICT 'RT_LOG###'. This is because the D_RT_LOG file is missing from the projects directory.

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.

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.  

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.

Unable to connect to host error 81015 when logging into IBM InfoSphere DataStage (DS): Failed to connect to host: <hostname>, project: UV  (The connection has timed out (81015))