Guru Of Geeks

We can use 'stty' to hide the password entry in UNIX command prompt, which is like entering password when you login to the UNIX. stty: 'stty' sets options for your terminal Ex : stty erase \^h --- set the backspace as erase key stty sane stty

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.

FTP auto-login.  "ftp" to a site and have the password stored. For instance, here's a sample ".net" file in a user's home directory for uploading to sourceforge. Note, sourceforge will take any password, so m@temp.com is used here for login "anonymous".

Install an RPM Package    RPM packages have file naming conventions like package-5.1-7.i868.rpm, which include the package name (package), version (2.0), release (4), and architecture (i386). Also notice that RPM understands FTP and HTTP protocols for installing and querying remote RPM files. rpm -ivh package-5.1-7.i868.rpm rpm -i ftp://ftp.redhat.com/pub/redhat/RPMS/package-1.0-1.i386.rpm rpm -i http://oss.oracle.com/projects/firewire/dist/files/kernel-2.4.20-18.10.1.i686.rpm

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

This script can use to daily send the system statistics server. It will also reformat the output to replace tabs with 5 spaces so it will display nicely on your email client. 

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.  

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

cron is a Nix utility that allows tasks to be automatically run in the background at regular intervals by the cron daemon. These tasks are often termed as cron jobs in Nix.  Crontab (CRON TABle) is a file which contains the schedule of cron entries to be run and at specified times. This document covers following aspects of Unix cron jobs  Crontab Restrictions  Crontab Commands  Crontab file – syntax  Crontab Example  Crontab Environment  Disable Email  Generate log file for crontab activity

To start IBM Information Server and WebSphere Application services:    1. Start WebSphere Application Server. Windows Click  All Programs  >  IBM WebSphere  >  Application Server [v6/v7/..]  >  Profiles >  default  >  Start the server . If you installed IBM Information Server in a different WebSphere Application Server profile, you must select the correct profile. Your path will vary if you installed IBM Information Server in a different location or used a different profile.   C:\IBM\WebSphere\AppServer\bin\profiles\default\bin\startServer.bat server1 -username <WAS_Username> -password <WAS_Password>

To shut down the IBM Information Server services and WebSphere Application Server services: 1.        Stop the following services:   ASB  Agent, Logging Agent, DataStage  Telnet Service, DSRPC Server, and DataStage Engine Resource Service .  The engine services will only be present if you installed both the services tier and the engine tier on the same machine. Windows To stop the services: a.        Log in with a user that has local administrator privileges.       b.        Stop these services in the order that they appear in the table. Note:  On Windows, you can use the Services Administrative Tool or the  sc  command line tool to stop services.  Order that services must be stopped before backing up IBM Information Server Service Full Name Service Short Name Process Name DSRPC Service dsrpc dsrpcd...

1) ASB Agent ASB agent is a Java background process run on the server or on the computer where the DataStage engine and client tiers are installed. When a service that runs on the Service tier receives a service request that needs processing on Information Server components then this agent receives this request and pass it on. In Linux, it is running as daemons that are named ASBAgent. In Windows, running as services that are named ASBAgent. ASB agents include: Connector access services agent Conveys service requests between the ODBC driver components on the engine tier and the connector access services component on the services tier. InfoSphere Information Analyzer  agent Conveys service requests between the engine components on the engine tier and the  InfoSphere Information Analyzer  services component on the services tier. InfoSphere Information Services Director  agent Conveys service requests between the engine components on the engin...