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.

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.  

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...

To create users and groups for IBM Information Server: 1.        On the computer where you installed the clients, log in to the Web console, which is on the computer where the domain is installed. o          Windows: Click  Start  >  IBM Information Server  >  IBM Information Server Web Console  and log in to the console with your suite administrator credentials. o          Linux or UNIX:  Open Microsoft Internet Explorer on a Windows computer and go to the URL of the Web console. Log in to the Web console with your suite administrator credentials.  The URL takes the form  http:// host_server : port .  host_server  is the name or IP address of the computer where the domain is installed.  port  is the port number for the Web console. The default port number is 9080. 2.      ...

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...