Posts

Showing posts with the label ETL

Error 81015 when logging into DataStage

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

InfoSphere DataStage List of Error Codes

API error codes in numerical order Code Error Token Description 0 DSJE_NOERROR No  InfoSphere DataStage  API error has occurred . -1 DSJE_BADHANDLE Invalid  JobHandle . -2 DSJE_BADSTATE Job is not in the right state (compiled, not running). -3 DSJE_BADPARAM ParamName  is not a parameter name in the job. -4 DSJE_BADVALUE Invalid  MaxNumber  value. -5 DSJE_BADTYPE Information or event type was unrecognized. -6 DSJE_WRONGJOB Job for this  JobHandle  was not started from a call to  DSRunJob  by the current process. -7 DSJE_BADSTAGE StageName  does not refer to a known stage in the job. -8 DSJE_NOTINSTAGE Internal engine error. -9 DSJE_BADLINK LinkName  does not refer to a known link for the stage in question. -10 DSJE_JOBLOCKED The job is locked by another process. -11 DSJE_JOBDELETED The job has been deleted. -12 DSJE_BADNAME Invalid project name. -13 DSJE_BADTIME Invalid  StartTime  or  EndTime ...

Starting IBM Information Server and WebSphere Application services

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>

Shutting down the IBM Information Server[DataStage] and WebSphere Application services WAS

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

Create Users and Groups for IBM Information Server DataStage

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

Cleaning the DataStage Server

Below are the list of the things you will have to do to safely clean and restart your server. The first task (in UNIX and WINDOWS) that you will have to perform is to stop the Datastage services.  The services that have to be stopped are the dsrpc service,  dstelnet service, DSEngine service,  ASBAgent service and Logging Agent service.  

Setting environment variables for the parallel engine in DataStage

Setting environment variables for the parallel engine in DataStage You set environment variables to ensure smooth operation of the parallel engine. Environment variables are set on a per-project basis from the Administrator client. Procedure 1. Click Start > All Programs > IBM Information Server > IBM InfoSphere DataStage and QualityStage Administrator, and log in to the Administrator client. 2. Click the Project tab, and select a project. 3. Click Properties. 4. On the General tab, click Environment. 5. Set the values for the environment variables as necessary.   Environment variables for the parallel engine Set the listed environment variables depending on whether your environment meets the conditions stated in each variable.