BIGPAATHSHALA.COM: DS JOB COMMANDS WITH EXAMPLES

C:\IBM\InformationServer\Server\DSEngine\bin>ls dsjob*

dsjob.exe

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server

Command Syntax:

dsjob [-file <file> <domain> <DataStage server> | -domain <domain> -user

<user> -password <password> -server <DataStage server>]

<primary command> [<arguments>]

Valid primary command options are:

-run

-stop

-lprojects

-ljobs

-linvocations

-lstages

-llinks

-projectinfo

-jobinfo

-stageinfo

-linkinfo

-lparams

-paraminfo

-log

-logsum

-logdetail

-lognewest

-report

-jobid

Status code = -9999 DSJE_DSJOB_ERROR

C:\IBM\InformationServer\Server\DSEngine\bin>uname -a

Windows_NT ADMIN 5 02 586

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -lprojects demo

Invalid arguments: dsjob -lproject

Status code = -9999 DSJE_DSJOB_ERROR

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -projectinfo demo

Host Name : admin

Project Name : demo

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -lprojects

ANALYZERPROJECT

demo

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run demo Seq_SeqPXJob

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -stop demo Seq_SeqPXJob

Error stopping job

Status code = -99 DSJE_REPERROR

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run demo Seq_SeqPXJob

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -stop demo Seq_SeqPXJob

Error stopping job

Status code = -99 DSJE_REPERROR

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -jobstatus demo Seq_SeqPXJob

Waiting for job...

Finished waiting for job

Job Status : (2)

Status code = 2

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -jobstatus demo fileset_SeqPXJob

Error running job

Status code = -2 DSJE_BADSTATE

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -jobstatus demo fileset_SeqPXJob

Error running job

Status code = -2 DSJE_BADSTATE

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -jobstatus demo Seq_JobParms_SeqPXJob

Error running job

Status code = -2 DSJE_BADSTATE

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -reset RESET demo Seq_JobParms_SeqPXJob

Invalid arguments: dsjob -run

[-mode <NORMAL | RESET | VALIDATE>]

[-param <name>=<value>]

[-warn <n>]

[-rows <n>]

[-wait]

[-opmetadata <TRUE | FALSE>]

[-disableprjhandler]

[-disablejobhandler]

[-jobstatus]

[-userstatus]

[-useid]

Status code = -9999 DSJE_DSJOB_ERROR

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -mode RESET demo Seq_JobParms_SeqPXJob

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -jobstatus demo Seq_JobParms_SeqPXJob

Waiting for job...

Finished waiting for job

Job Status : (2)

Status code = 2

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -mode RESET demo fileset_SeqPXJob

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -jobstatus demo fileset_SeqPXJob

Waiting for job...

Finished waiting for job

Job Status : (3)

Status code = 3

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -parm Input_path=E:\Source_Files\ -parm Outp

ut_path=E:\Tgt_Files\ demo Seq_JobParms_SeqPXJob

Invalid arguments: dsjob -run

[-mode <NORMAL | RESET | VALIDATE>]

[-param <name>=<value>]

[-warn <n>]

[-rows <n>]

[-wait]

[-opmetadata <TRUE | FALSE>]

[-disableprjhandler]

[-disablejobhandler]

[-jobstatus]

[-userstatus]

[-useid]

Status code = -9999 DSJE_DSJOB_ERROR

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -param Input_path=E:\Source_Files\ -param Ou

tput_path=E:\Tgt_Files\ demo Seq_JobParms_SeqPXJob

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -run -param Input_path=E:\Source_Files\ -param Ou

tput_path=E:\Tgt_Files\ -warn 0 demo Seq_JobParms_SeqPXJob

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>dsjob -domain admin:9080 -user IBM

-password server -server ADMIN -logdetail demo Seq_JobParms_SeqPXJob

l;C:\IBM\InformationServer\Server\Projects\demo\RT_BP5.O;C:\IBM\InformationServe

r\Server\DSEngine\bin;C:\IBM\InformationServer\Server\Projects\demo\buildop;C:\I

BM\InformationServer\Server\Projects\demo\wrapped;C:\oraclexe\app\oracle\product

\10.2.0\server\bin;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\

Program Files\Oracle\jre\1.1.8\bin;C:\PROGRA~1\MKSTOO~1\mksnt;C:\PROGRA~1\MKSTOO

~1\bin;C:\PROGRA~1\MKSTOO~1\bin\X11;C:\PROGRA~1\MKSTOO~1\mksnt;C:\IBM\Informatio

nServer\ASBNode\lib\cpp;C:\IBM\InformationServer\ASBNode\apps\proxy\cpp\vc60\MT_

dll\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\IBM\SQLLIB\BI

N;C:\IBM\SQLLIB\FUNCTION;C:\IBM\SQLLIB\SAMPLES\REPL;C:\IBM\SQLLIB\BIN;c:\Program

Files\Microsoft SQL Server\90\Tools\binn\

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.sh;.ksh;.csh;.

sed;.awk;.pl

PIDTOK=5312

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 10, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=170a

ProgramFiles=C:\Program Files

PWD=C:\IBM\InformationServer\Server\Projects\demo

PX_DBCONNECTHOME=C:/IBM/InformationServer/Server/DSComponents

ROOTDIR=C:/PROGRA~1/MKSTOO~1

SHELL=C:/PROGRA~1/MKSTOO~1/mksnt/sh.exe

SMTP_Server=10.154.26.1

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP

TERM=console

TERMCAP=C:\PROGRA~1\MKSTOO~1\etc\termcap

TERMINFO=C:\PROGRA~1\MKSTOO~1\usr\lib\terminfo

TMP=C:\WINDOWS\TEMP

UNIVERSE_CONTROLLING_TERM=1

UNIVERSE_PARENT_PROCESS=5312

USER=ADMIN\Administrator

USERPROFILE=C:\Documents and Settings\Default User

VS80COMNTOOLS=C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\

WHO=demo

WV_GATEWAY_CFG=C:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app

windir=C:\WINDOWS

Event Id: 129

Time : Fri Feb 08 08:02:16 2008

Type : INFO

User : ADMIN\Administrator

Message :

Parallel job initiated

Event Id: 130

Time : Fri Feb 08 08:02:16 2008

Type : INFO

User : ADMIN\Administrator

Message :

OSH script

# OSH / orchestrate script for Job Seq_JobParms_SeqPXJob compiled at 07:

57:50 08 FEB 2008

#################################################################

#### STAGE: Sequential_File_1

## Operator

import

## Operator options

-schema record

{final_delim=end, delim=','}

(

empno:int32 {quote=none};

empname:ustring[max=255];

deptno:int32 {quote=none};

)

-file '[&"Input_path"]emp.txt'

-rejects continue

-reportProgress yes

## General options

[ident('Sequential_File_1'); jobmon_ident('Sequential_File_1')]

## Outputs

0> [] 'Sequential_File_1:DSLink3.v'

;

#################################################################

#### STAGE: Sequential_File_2

## Operator

export

## Operator options

-schema record

{final_delim=end, delim=',', quote=double}

(

empno:int32 {quote=none};

empname:ustring[max=255];

deptno:int32 {quote=none};

)

-file '[&"Output_path"]Emp_Opt.txt'

-overwrite

-rejects continue

## General options

[ident('Sequential_File_2'); jobmon_ident('Sequential_File_2')]

## Inputs

0< [] 'Sequential_File_1:DSLink3.v'

;

# End of OSH code

Event Id: 131

Time : Fri Feb 08 08:02:16 2008

Type : INFO

User : ADMIN\Administrator

Message :

Parallel job default NLS map ASCL_MS1252, default locale OFF

Event Id: 132

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: IBM WebSphere DataStage Enterprise Edition 8.0.1.4458

Event Id: 133

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: orchgeneral: loaded

orchsort: loaded

orchstats: loaded

Event Id: 134

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: Explanation:

Step has 2 operators.

???, invoked with args: -schema record {final_delim=end, delim=","} ( em

pno: int32 {quote=none}; empname: ustring[max=255]; deptno: int32 {quote=none}

; ) -file E:\Source_Files\emp.txt -rejects continue -reportProgress yes

output port 0 bound to data entity "Sequential_File_1:DSLink3.v"

???, invoked with args: -schema record {final_delim=end, delim=",", quot

e=double} ( empno: int32 {quote=none}; empname: ustring[max=255]; deptno: int3

2 {quote=none}; ) -file E:\Tgt_Files\Emp_Opt.txt -overwrite -rejects continue

input port 0 bound to data entity "Sequential_File_1:DSLink3.v"

Step has 1 data entity.

Data "Sequential_File_1:DSLink3.v"(an Orchestrate data set)

written by operator "Sequential_File_1"

read by operator "Sequential_File_2"

Event Id: 135

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: Dump:

{

text="import\n-schema record {final_delim=end, delim=\",\"} ( empno: i

nt32 {quote=none}; empname: ustring[max=255]; deptno: int32 {quote=none}; )\n-

file 'E:\\\\Source_Files\\\\emp.txt'\n-rejects continue\n-reportProgress yes\n[

ident('Sequential_File_1'); jobmon_ident('Sequential_File_1')]\n0> [] 'Sequentia

l_File_1:DSLink3.v'\n;\nexport\n-schema record {final_delim=end, delim=\",\", qu

ote=double} ( empno: int32 {quote=none}; empname: ustring[max=255]; deptno: in

t32 {quote=none}; )\n-file 'E:\\\\Tgt_Files\\\\Emp_Opt.txt'\n-overwrite\n-reject

s continue\n[ident('Sequential_File_2'); jobmon_ident('Sequential_File_2')]\n0<

[] 'Sequential_File_1:DSLink3.v'\n;",

line=1, column=1, name="", qualname="",

op={

text="import\n-schema record {final_delim=end, delim=\",\"} ( emp

no: int32 {quote=none}; empname: ustring[max=255]; deptno: int32 {quote=none};

)\n-file 'E:\\\\Source_Files\\\\emp.txt'\n-rejects continue\n-reportProgress y

es\n[ident('Sequential_File_1'); jobmon_ident('Sequential_File_1')]\n0> [] 'Sequ

ential_File_1:DSLink3.v'",

line=1, column=1, name=import, qualname=Sequential_File_1,

wrapout={},

wrapperfile=import, kind=non_wrapper_cdi_op, exec_mode=none,

args="'record {final_delim=end, delim=\",\"} ( empno: int32 {quot

e=none}; empname: ustring[max=255]; deptno: int32 {quote=none}; )'-file'E:\\\\

Source_Files\\\\emp.txt'-rejects'continue'-reportProgress'yes'",

output={ text="\n0> [] 'Sequential_File_1:DSLink3.v'", line=13,

column=1, name="", qualname="Sequential_File_1[o0]",

data="Sequential_File_1:DSLink3.v"

}

op={

text="\nexport\n-schema record {final_delim=end, delim=\",\", quo

te=double} ( empno: int32 {quote=none}; empname: ustring[max=255]; deptno: int

32 {quote=none}; )\n-file 'E:\\\\Tgt_Files\\\\Emp_Opt.txt'\n-overwrite\n-rejects

continue\n[ident('Sequential_File_2'); jobmon_ident('Sequential_File_2')]\n0< [

] 'Sequential_File_1:DSLink3.v'",

line=15, column=1, name=export, qualname=Sequential_File_2,

wrapout={},

wrapperfile=export, kind=non_wrapper_cdi_op, exec_mode=none,

args="'record {final_delim=end, delim=\",\", quote=double} ( empn

o: int32 {quote=none}; empname: ustring[max=255]; deptno: int32 {quote=none};

)'-file'E:\\\\Tgt_Files\\\\Emp_Opt.txt'-overwrite'-rejects'continue'",

input={ text="\n0< [] 'Sequential_File_1:DSLink3.v'", line=27,

column=1, name="", qualname="Sequential_File_2[i0]",

data="Sequential_File_1:DSLink3.v"

}

data={ text="\n0> [] 'Sequential_File_1:DSLink3.v'", line=13, column=1

name="Sequential_File_1:DSLink3.v",

qualname="Sequential_File_1:DSLink3.v",

partwrapout={},

collwrapout={},

dir=flow, kind=ds, writer=Sequential_File_1,

reader=Sequential_File_2, pp=none, trunc=default,

ident="Sequential_File_1:DSLink3.v"

}

Event Id: 136

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: APT configuration file: C:/IBM/InformationServer/Server/Co

nfigurations/2node_Config.apt

{

node "node1"

{

fastname "ADMIN"

pools ""

resource disk "C:/IBM/InformationServer/Server/Datasets"

{pools ""}

resource scratchdisk "C:/IBM/InformationServer/Server/Sc

ratch" {pools ""}

}

node "node2"

{

fastname "ADMIN"

pools ""

resource disk "C:/IBM/InformationServer/Server/Datasets"

{pools ""}

resource scratchdisk "C:/IBM/InformationServer/Server/Sc

ratch" {pools ""}

}

Event Id: 137

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: This step has no datasets.

It has 1 operator:

op0[1p] {(sequential APT_CombinedOperatorController:

(Sequential_File_1)

(APT_RealFileExportOperator in Sequential_File_2)

) on nodes (

node1[op0,p0]

)}

It runs 1 process on 1 node.

Event Id: 138

Time : Fri Feb 08 08:02:18 2008

Type : WARNING

User : ADMIN\Administrator

Message :

Sequential_File_1,0: Field "empno" has import error and no default value

; data: {e m p n o}, at offset: 0

Event Id: 139

Time : Fri Feb 08 08:02:18 2008

Type : WARNING

User : ADMIN\Administrator

Message :

Sequential_File_1,0: Import warning at record 0.

Event Id: 140

Time : Fri Feb 08 08:02:18 2008

Type : WARNING

User : ADMIN\Administrator

Message :

Sequential_File_1,0: Import unsuccessful at record 0.

Event Id: 141

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

Sequential_File_1,0: Import complete; 11 records imported successfully,

1 rejected.

Event Id: 142

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

Sequential_File_2,0: Export complete; 11 records exported successfully,

0 rejected.

Event Id: 143

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: Step execution finished with status = OK.

Event Id: 144

Time : Fri Feb 08 08:02:18 2008

Type : INFO

User : ADMIN\Administrator

Message :

main_program: Startup time, 0:01; production run time, 0:00.

Event Id: 145

Time : Fri Feb 08 08:02:20 2008

Type : INFO

User : ADMIN\Administrator

Message :

Parallel job reports successful completion

Event Id: 146

Time : Fri Feb 08 08:02:20 2008

Type : STARTED

User : ADMIN\Administrator

Message :

Finished Job Seq_JobParms_SeqPXJob.

Status code = 0

C:\IBM\InformationServer\Server\DSEngine\bin>