Menu

Navigation

How do I access my job log in DataStage?

Posted on by Arif Clayton

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.

Where are DataStage logs stored?

The default location is Websphere\AppServer\profiles\InfoSphere\logs with the name ISauditLog_0. log. For example, if DataStage is installed on unix, audit log file will be created in /opt/IBM/Websphere/AppServer/profiles/InfoSphere/logs directory.

Where do you monitor DataStage jobs?

You can use the IBM® InfoSphere® DataStage® and QualityStage® Operations Console to monitor the job runs, services, system resources, and workload management queues on several IBM InfoSphere Information Server engines.

How do I check DataStage logs in Unix?

Answer

  1. dsjob -logdetail MyProj MyJob -wave 0. will provide all the detail job log records for the most recent execution.
  2. dsjob -logdetail MyProj MyJob -wave -1. will provide all the detail job log records for the prior execution.
  3. dsjob -logdetail MyProj MyJob -wave -2.

How do I export my work log from Datastage?

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 run a Dsjob command in Unix?

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.

How do I export DataStage logs?

What is audit table in DataStage?

The audit data tables for job runs contain information about the IBM® InfoSphere® DataStage® and QualityStage® jobs that are currently running or that have finished running. The JobRunLog table contains all the events that are emitted by the job runs in the JobRun table that match the monitoring configuration settings.

How do I export Datastage logs?

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.

What are the Unix commands used in DataStage?

DataStage UNIX Commands

  • •Check the permissions. 1.Log on to server as dsadm or root.
  • •
  • Log on to server as dsadm or root.
  • cd $DSHOME.
  • source the environment:
  • Check for DataStage client connections.
  • Check for jobs processes:
  • Check datastage shared memory segments:
Posted In Q&A