The Datastage job can invoke the job or get information about the job and run reports and logs through the Dsjob command.
Install the DataStage directory for example c:\ascential\datastage\engine\bin>
The syntax for Dsjob is as follows:
Command Syntax:
dsjob [-file <file> <server> | [-server <server>] [-user <user>] [-passwod <password>]]
<primary command> [<arguments>]
Valid Primary command options are:
-run Run Job
-stop stop a job in operation
-lprojects lists all the projects in the server
-ljobs lists all the jobs in the specified project
-linvocations lists all the invocation in the specified job
-lstages lists all the stage in the specified job
-llinks lists all of the link in the specified job
-projectinfo lists information for the specified project
-jobinfo lists the information for the specified job
-stageinfo lists information for the specified stage
-linkinfo lists the information for the specified link
-lparams lists all parameter for the specified job
-paraminfo lists information for the specified parameter
-log get all the logs for the job
-logsum get all the logs for the job
-logdetail get the job's detailed log
-lognewest
-report get the job's detailed log
-jobid
-file parameters for a moment, also did not find any good explanation, hope Master can explain.
-server DataStage Project Name
-user User Name
-password Password
-primary command
-run
Invalid Arguments:dsjob-run
[-mode <normal | RESET | Validate>]
Normal running
Reset Reset
VALIDATE Verify job is feasible
[-param <name>=<value>]
Set Variable values
[-warn <n>]
Warn warning how many records to stop the job from running
[-rows <n>]
How many records have been run and the job stops running
[-wait]
Wait for how long to stop running
[-opmetadata <true | False>]
[-disableprjhandler]
[-disablejobhandler]
[-jobstatus]
Status of Jobstatus running
[-userstatus]
[-useid]
<project> <job|jobid>
1 dsjob-server 10.240.12.67-user peace.zhao-password yanzhang0717-run-mode NORMAL sysup1_mphasis_1 Sequential
The simplest run
2 C:\ascential\datastage\engine\bin>dsjob-server 10.240.12.67-user Peace.zhao-password Yanzhang0717-run-mode Normal-jobstatus Sysup1_mphasis_1 Sequential
Waiting for job ...
Finished waiting for job
Job Status: (1)
Status Code = 1
3 C:\ascential\datastage\engine\bin>dsjob-server 10.240.12.67-user Peace.zhao-password Yanzhang0717-run-mode Normal-param Input=7.txt-param Output=8.txt-j
Obstatus Sysup1_mphasis_1 Sequential
Waiting for job ...
Finished waiting for job
Job Status: (1)
Status Code = 1
-stop
Invalid arguments:dsjob-stop [-useid] <project> <job|jobid>
Stop a running job
-lprojects
List job in all servers
C:\ascential\datastage\engine\bin>dsjob-server 10.240.12.67-user Peace.zhao-password yanzhang0717-lprojects
Empty
Study
Sysup1_mphasis
Sysup1_mphasis_1
Sysup1_mphasis_2
Sysup1_mphasis_3
Tttt
up_20090204
Yes
Status Code = 0
-lprojects
-ljobs
-linvocations
-lstages
-llinks
-lparams
function and usage similar to-lprojects
-projectinfo to get project information
C:\ascential\datastage\engine\bin>dsjob-projectinfo Sysup1_mphasis_1
Host name:10.240.12.67
Project Name:sysup1_mphasis_1
Status Code = 0
-jobinfo
C:\ascential\datastage\engine\bin>dsjob-jobinfo Sysup1_mphasis_1 Sequential
Job Status:run OK (1)
Job Controller:not Available
Job Start Time:mon 06 15:04:33 2009
Job Wave Number:3
User Status:not Available
Job control:0
Interim Status:not RUNNING (99)
Invocation Id:not Available
Last Run Time:mon June 06 15:04:42 2009
Job Process id:0
Invocation List:sequential
Status Code = 0
-linkinfo
-paraminfo
Same as getting project and job information
-report
Get report of Job run
C:\ascential\datastage\engine\bin>dsjob–report
Invalid Arguments:dsjob-report [-useid] <project> <job|jobid> [Type>]
The type = BASIC | DETAIL | Xml
C:\ascential\datastage\engine\bin>dsjob-report Sysup1_mphasis_1 Sequential BASIC
**************************************************
ジョブのステータスレポート: Sequential
When own: 2009-07-06 15:26:27
ジョブ Start time = 2009-07-06 15:04:33
ジョブ finally time = 2009-07-06 15:04:42
ジョブ 経 time = 00:00:09
ジョブステータス= 1 (normal)
Status Code = 0
C:\ascential\datastage\engine\bin>dsjob-report Sysup1_mphasis_1 Sequential DETAIL
**************************************************
ジョブのステータスレポート: Sequential
When own: 2009-07-06 15:27:00
ジョブ Start time = 2009-07-06 15:04:33
ジョブ finally time = 2009-07-06 15:04:42
ジョブ 経 time = 00:00:09
ジョブステータス= 1 (normal)
ステージ: Sequential_file_1.ident1, the number of practising 7768800
ステージ the beginning of the time = 2009-07-06 15:04:36, the end of the moment = 2009-07-06 15:04:41, 経
Past time = 00:00:05
リンク: DSLink2, line number 7768800
リンク: DSLink2, line number 7768800
Status Code = 0
C:\ascential\datastage\engine\bin>dsjob-report Sysup1_mphasis_1 Sequential XML
<?xml version= "1.0" encoding= "UTF-8"?>
<job name= "Sequential"
Desc= ""
status= "1"
waveno= "3"
Startdatetime= "2009-07-06t15:04:33"
Enddatetime= "2009-07-06t15:04:42"
Elapsedtime= "00:00:09"
elapsedsecs= "9" >
<ParamSet>
<param name= "Input"
Type= "0"
Desc= ""
Value= "7.txt"/>
<param name= "Output"
Type= "0"
Desc= ""
Value= "8.txt"/>
</ParamSet>
<ComponentSet>
<stage name= "Sequential_file_1.ident1"
Stagestatus= "2"
Stagetype= "Ctransformerstage"
Desc= ""
Startdatetime= "2009-07-06t15:04:36"
Enddatetime= "2009-07-06t15:04:41"
Elapsedtime= "00:00:05"
elapsedsecs= "5" >
<InputLinks>
<link name= "DSLink2"
Linktype= "1"
Desc= ""
Stage= "Sequential_file_0"/>
</InputLinks>
<OutputLinks>
<link name= "DSLink2"
Linktype= "3"
Desc= ""
Stage= "Sequential_file_0"/>
</OutputLinks>
<InstanceSet>
<instance id= ""
Cpu= "3.25"
Pid= "6008" >
<link name= "DSLink2"
rowcount= "7768800"/>
<link name= "DSLink2"
rowcount= "7768800"/>
</Instance>
</InstanceSet>
</Stage>
</ComponentSet>
</Job>
Status Code = 0
Operation of the log
-log writes a log to the specified job
C:\ascential\datastage\engine\bin>dsjob-log
Invalid Arguments:dsjob-log
[-info |-warn]
<project> <job>
Log message was read from stdin.
-logsum
Invalid Arguments:dsjob-logsum
[-type <info | WARNING | FATAL | REJECT | Started | RESET | Batch>]
[-max <n>]
[-useid]
<project> <job|jobid>
Get information about the Run-time job
Max gets the most recent bar record
C:\ascential\datastage\engine\bin>dsjob-logsum-type Info-max Sysup1_mphas
Is_1 Sequential
INFO Mon June 06 15:01:34 2009
Sequential.. Sequential_file_1:プロジェクトデフォルトnlsマップjpn-sj
Isを Use します
INFO Mon June 06 15:01:34 2009
ステージsequential.. Sequential_file_1.ident1の 検 を finished しました.
INFO Mon June 06 15:04:33 2009
Environmental becomes number set: (...)
INFO Mon June 06 15:04:33 2009
SEQUENTIAL:NLS National Intelligence Reports をjp-japanese,jp-japanese,jp-japanese,jp-japane
Se,jp-japaneseへ setting
INFO Mon June 06 15:04:34 2009
Sequential.. Sequential_File_1.IDENT1:DSD. Stagerunアクティブステージを
Start しています. トレースモード= 0.
INFO Mon June 06 15:04:34 2009
Sequential.. Sequential_File_1.IDENT1:NLS National Intelligence Reports をjp-japanese,jp-japa
Nese,jp-japanese,jp-japanese,jp-japaneseへ setting
INFO Mon June 06 15:04:34 2009
Sequential.. Sequential_file_0:プロジェクトデフォルトnlsマップjpn-sj
Isを Use します
INFO Mon June 06 15:04:34 2009
Sequential.. Sequential_file_1:プロジェクトデフォルトnlsマップjpn-sj
Isを Use します
INFO Mon June 06 15:04:41 2009
Sequential.. Sequential_File_1.IDENT1:DSD. Stagerunアクティブステージを
Finally, します. (...)
INFO Mon June 06 15:32:32 2009
DD (...)
Status Code = 0
-logdetail
C:\ascential\datastage\engine\bin>dsjob-logdetail
Invalid Arguments:dsjob-logdetail [-useid] <project> <job|jobid> <first Event
id> [<last event id>]
First Event ID Log ID
Last Event ID final log ID
If the last event ID is empty, the default is the details of the
C:\ascential\datastage\engine\bin>dsjob-logdetail sysup1_mphasis_1 Sequential 1
0 11
Event id:10
Time:mon 06 14:38:07 2009
type:started
User:mphasisortc\peace.zhao
Message:
ジョブsequentialをリセットしています.
Event id:11
Time:mon 06 14:38:07 2009
Type:info
User:mphasisortc\peace.zhao
Message:
ステージsequential.. sequential_file_1.ident1をリセットしています.
-lognewest gets the last log ID of the specified log type
C:\ascential\datastage\engine\bin>dsjob-lognewest
Invalid arguments:dsjob-lognewest [-useid] <project> <job|jobid> [<event type>
]
Event Type = INFO | WARNING | FATAL | REJECT | Started | RESET | BATCH
C:\ascential\datastage\engine\bin>dsjob-lognewest Sysup1_mphasis_1 Sequential
INFO
Newest ID = 52
Status Code = 0
