C
ClearView News

How do you run DataStage job from command line?

Author

Christopher Ramos

Published Mar 21, 2026

How do you run DataStage job from command line?

Procedure
  1. Open a terminal session or a command line interface.
  2. Provide authentication information where necessary.
  3. Run the dsjob command to run the job. The following command runs the Build_Mart_OU job in the dstage project. The default parameters are used when running the job.

Keeping this in consideration, how do I run a DataStage job?

After you compile your job in the Designer client, you run it from the Director client.

Run the job.

  1. In the Director client, click the job that you want to run, then click Job > Run Now. The Job Run Options window opens.
  2. Select values for each of the parameters that you defined, or accept the default values.
  3. Click Run.

Subsequently, question is, how do I access my job log in DataStage? Answer

  1. Log in to DataStage Director.
  2. In Status view, select the job you want to view the log.
  3. Switch to Log view using "Log" button on the toolbar or View > Log menu.
  4. Choose View > Show All menu to display all log entries.
  5. Sort the log items in ascending time order.

Regarding this, how do I know if a job is running in DataStage?

To switch to this view, choose View > Status, or click the Status button on the toolbar. Use the Run Job Options dialog box to set job options when you run, validate, or schedule a job. You can check that a job or job invocation will run successfully by validating it.

How do I connect to DataStage?

Open a command line or terminal and make a new directory in the DataStage system to store the SSL certificate and key files. In the Db2 console, download the SSL certificate from the Connect your applications to the database page. From the main menu, click Connect.

In which situation is it appropriate to use a sparse lookup?

For scenarios where the number of input rows is significantly smaller (1:100 or more) than the number of reference rows in a DB2 or Oracle table, a Sparse Lookup might be appropriate.

How do you find the number of rows in a sequential file?

27) How do you find the number of rows in a sequential file? To find rows in sequential file, we can use the System variable @INROWNUM.

Which statement is accurate regarding usage of database stages?

Native database stages match columns by name. DataStage provides native Oracle database stages. Database stages cannot create tables and must be done externally.

What are the system variables in DataStage?

A set of variables containing useful system information. InfoSphere® DataStage® provides a set of variables containing useful system information that you can access from an output derivation or constraint. The value is replaced with 0.

What are the various types of lookups in Datastage?

The Lookup stage is one of three stages that join tables based on the values of key columns. The other two are: Join stage - Join stage. Merge stage - Merge Stage.

Where are project level message handlers defined?

You define a project level message handler in the Administrator, and this applies to all parallel jobs within the specified project. Job Level. From the Designer you can specify that any existing handler should apply to a specific job.

Where can a single Datastage job run?

Datastage EE is able to execute jobs on multiple CPUs (nodes) in parallel and is fully scalable, which means that a properly designed job can run across resources within a single machine or take advantage of parallel platforms like a cluster, GRID, or MPP architecture (massively parallel processing).

Where is the Dsjob command?

The following directories are the default for dsjob : Windows. C:\IBM\InformationServer\Server\DSEngine\bin. AIX, HP-UX, Linux.

How do I find long running jobs in Datastage?

"Inv_Rep3_word" and "stand1" is the running job names. We can use this command in shell script to get the list of running jobs whenever we want or can schedule in cron to get hourly report.

How do I export Datastage log?

Print out the Job Log to a flat file.
  1. Do one of the following to display the Print dialog box: Choose Project > Print .
  2. Choose the range of items to print in the Range area: select.
  3. Choose what to print by selecting in the Print what area:
  4. Select the Print to file check box.
  5. Click OK.

How do I view log in Datastage designer?

Click View > Job Log. To choose how the job log entries are displayed, click View Options on the toolbar on the Job Log pane. To see the latest job log entries, click Refresh on the toolbar. To choose whether to show all job log entries or only warning and fatal job log entries, click Filter Events on the toolbar.

Is DataStage an ETL tool?

IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition.

Can you send an email with job status from DataStage?

DataStage Job can use notification activity to send email or SMS on DataStage Job Failure or completion or based on any condition mentioned. DataStage Notification Activity Page contains: Include job status in email to provide job status information in the message.

What is DataStage repository?

The metadata repository is a shared component that stores design-time, runtime, glossary, and other metadata for product modules in the InfoSphere Information Server suite.

How do you deploy a DataStage job?

You can manage your InfoSphere DataStage jobs and associated assets in your source control system.

Deploy

  1. Define a package to specify the assets to deploy.
  2. Build the package to produce a package file.
  3. Copy the package file to the target system if necessary.
  4. Deploy the package on the target system.

What is a sequence job in DataStage?

IBM® InfoSphere® DataStage® includes a special type of job, known as a sequence job, that you use to specify a sequence of parallel jobs or server jobs to run. You specify the control information, such as the different courses of action to take depending on whether a job in the sequence succeeds or fails.
Transformer stages can have a single input and any number of outputs. It can also have a reject link that takes any rows which have not been written to any of the outputs links by reason of a write failure or expression evaluation failure.

Which are common services in DataStage?

The common services include: Scheduling services. These services plan and track activities such as logging, reporting, and suite component tasks such as data monitoring and trending. You can use the InfoSphere Information Server console and Web console to maintain the schedules.

What are the types of jobs available in DataStage?

You can create 4 types of Jobs in DataStage infosphere.
  • Parallel Job.
  • Sequence Job.
  • Mainframe Job.
  • Server Job.

What is DataStage tool?

DataStage (DS) is an ETL tool that can extract data, transform it, apply business principles and then load it to any specific target. It is a part of IBM's Information Platforms Solutions suite and also that of InfoSphere. DataStage makes use of graphical notations for constructing data integration solutions.