How do you reset a Dsjob command?

Posted on by Sherryl Cole

How do you reset a Dsjob command?

file —> Transformer —> seq. file) and run and reset the job by the following commands: 1. Run the job [sasaki@smbcetl1 ~ 10:27:16]$ /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -run -mode NORMAL -wait -jobstatus DSproj1 karajob waiting job…

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 to get datastage job status in unix?

To Properly check a job status from the command line: It is recommended that you run “dsjob -run” with the “-wait” option to run the job, then on a second command for dsjob you supply the “-jobstatus” for the same job/invocation ID.

How do I get a list of all Datastage jobs?

1. run dsjob -lprojects to get list of datastge projects. 2. run dsjob -ljobs to get list of jobs in a project.

How do I restart a Datastage job?

Procedure

  1. Select the job or invocation you want to reset in the Job Status view.
  2. Choose Job > Reset or click the Reset button on the toolbar. A message box appears.
  3. Click Yes to reset the tables. All the files in the job are reinstated to the state they were in before the job was run.

How do I run a job in putty?

Run putty.exe, it will look like this:

  1. Arrow # 1 is where you’re gonna put your host name or IP address of your server.
  2. Arrow # 2 is the button you’re gonna click (or you can simply press enter) immediately after entering your server host name of IP address.

How do you trigger a job in Unix?

Run a Unix process in the background

  1. To run the count program, which will display the process identification number of the job, enter: count &
  2. To check the status of your job, enter: jobs.
  3. To bring a background process to the foreground, enter: fg.
  4. If you have more than one job suspended in the background, enter: fg %#

How do I query a Datastage repository?

XMeta DB : Datastage Repository

  1. Query to list Projects. SELECT *
  2. List the folders within a project. SELECT *
  3. Query to retrieve the DS JOB information. SELECT.
  4. Query to list the jobs that are locked. SELECT.
  5. Query to list the stages within the job.
  6. Query to show the job details by folder.

How do I enable checkpoints in DataStage?

Both intermediate and target-blocking checkpoints can be inserted by setting the environment variable APT_CHECKPOINT_ENABLED to 1 . This is the most common setting for checkpointing. In some cases, it may be desired to manually restart a DataStage flow from a persisted checkpoint.

What are the putty commands?

Putty Commands

  • vi: It enables us to input a text editor.
  • grep: If we wish to find a specific string in a folder or file, it is the accurate command for us.
  • head: This command enables us to read the initial ten lines of the content in a file.

How do you automate Putty?

Automating SSH with Putty (Windows)

  1. Right click on the desktop/explorer.
  2. Select New > Shortcut.
  3. Enter the above putty command into the field labeled “Type the location of the item:”
  4. Enter a name for the shortcut (EG “SSH into my-device”) into the field labelled “Type a name for this shortcut”

What is the name of the job in dsjob?

-project is the name of the project containing the job. job is the name of the job. To run a job invocation, use the format job.invocation_id. job_id is an alias for the job that has been set using the dsjob -jobid command.

How to start and stop a dsjob job?

We can use the logon clause with any dsjob command. Starting a Job: We can start, stop, validate, and reset Datastage jobs using the –run option from the UNIX command line. Syntax : dsjob –run. [ –mode [ NORMAL | RESET | VALIDATE ] ] [ –param name=value ] [ –warn n ] [ –rows n ]

Can you use dsjob from the command line?

dsjob command: The dsjob command can be used from the UNIX command line to execute of the following tasks, All output from the dsjob command is in plain text without column headings on lists, or any other sort of description.