DataStage_FAQ(1)

1.What are the ways to execute datastage jobs?

A job can be run using a few different methods:

 

* from Datastage Director (menu Job -> Run now...)

* from command line using a dsjob command

* Datastage routine can run a job (DsRunJob command)

* by a job sequencer

 

2.How to invoke a Datastage shell command?

Datastage shell commands can be invoked from :

 

* Datastage administrator (projects tab -> Command)

* Telnet client connected to the datastage server

 

3.How to stop a job when its status is running?

To stop a running job go to DataStage Director and click the stop button (or Job -> Stop from menu). If it doesn't help go to Job -> Cleanup Resources, select a process with holds a lock and click Logout

 

If it still doesn't help go to the datastage shell and invoke the following command: ds.tools

It will open an administration panel. Go to 4.Administer processes/locks , then try invoking one of the clear locks commands (options 7-10).

 

4. How to release a lock held by jobs?

Go to the datastage shell and invoke the following command: ds.tools

It will open an administration panel. Go to 4.Administer processes/locks , then try invoking one of the clear locks commands (options 7-10).

 

5. How to run and schedule a job from command line?

To run a job from command line use a dsjob command

Command Syntax: dsjob [-file

 

6. User privileges for the default DataStage roles?

The role privileges are:

 

* DataStage Developer - user with full access to all areas of a DataStage project

* DataStage Operator - has privileges to run and manage deployed DataStage jobs

* -none- - no permission to log on to DataStage

 

7. What is a command to analyze hashed file?

There are two ways to analyze a hashed file. Both should be invoked from the datastage command shell. These are:

 

* FILE.STAT command

* ANALYZE.FILE command

 

8. Is it possible to run two versions of datastage on the same pc?

Yes, even though different versions of Datastage use different system dll libraries.

To dynamically switch between Datastage versions install and run DataStage Multi-Client Manager. That application can unregister and register system libraries used by Datastage.

 

9. How to send notifications from Datastage as a text message (sms) to a cell phone

There is a few possible methods of sending sms messages from Datastage. However, there is no easy way to do this directly from Datastage and all methods described below will require some effort.

 

The easiest way of doing that from the Datastage standpoint is to configure an SMTP (email) server as a mobile phone gateway. In that case, a Notification Activity can be used to send message with a job log and any desired details. DSSendMail Before-job or After-job subroutine can be also used to send sms messages.

If configured properly, the recipients email address will have the following format: 600123456@oursmsgateway.com

 

If there is no possibility of configuring a mail server to send text messages, you can to work it around by using an external application run directly from the operational system. There is a whole bunch of unix scripts and applications to send sms messages.

In that solution, you will need to create a batch script which will take care of sending messages and invoke it from Datastage using ExecDOS or ExecSh subroutines passing the required parameters (like phone number and message body).