DSJOB命令位置:
E:\>cd E:\IBM\InformationServer\Server\DSEngine\bin
E:\IBM\InformationServer\Server\DSEngine\bin>ls
DFmodify.exe dsservice.exe modify_shm.exe
DSOLEInt.dll dssh.exe mv.exe
INfilter.exe dssmtpmail.exe nbasic.exe
NT_OshWrapper.exe dsutil.dll plock_init.exe
UVchange.exe fcl.dll plock_set.exe
UVdelete.exe file.stat.exe port_sql.exe
UVfile.exe filepeek.exe portuv.exe
UVread.exe fix_ntusers.exe pqic.exe
UVtlconvert.exe fixtool.exe prime.exe
UVwrite.exe fnuxi.exe printacct.exe
UtilWSClient.dll format.conv.exe pwd.exe
WebSrvLog.dll fpath.exe radix.exe
acct.restore.exe g.stat.det.exe record.exe
analyze.shm.exe get_prog_size.exe resize.exe
avail.exe get_shm_size.exe rm.exe
basic.exe group.stat.exe rmv.lbl.exe
blook.exe h.help.det.exe sdml.exe
catalog.exe h.test.det.exe setfile.exe
ccactive.dll hash.aid.exe show_sica.exe
ccactiveenu.dll hash.help.exe shrdump.exe
ccbridge.dll hash.test.exe smat.exe
ccpassive.dll help.exe sp.edit.exe
ccpassiveenu.dll hostname.exe spool.exe
cdict.exe init.catalog.exe sqlcat9.exe
claccount.exe kill.exe status.exe
clear.file.exe libicudata32.0.dll tapein.exe
cname.exe libicui18n32.0.dll tapetest.exe
conf.file.exe libicuio32.0.dll tiindex.exe
create.file.exe libicule32.0.dll tl_dsserver.exe
cvtsqlcat.exe libiculx32.0.dll tl_dsservice.exe
dcfreest.exe libicutu32.0.dll touch.exe
decatalog.exe libicuuc32.0.dll udtconv.exe
decompile.exe list_readu.exe updaccount.exe
del.catalog.exe ln.exe upduvtrans.exe
delete.file.exe load_NLS_shm.exe uv.exe
disect.exe load_shm_cat.exe uvbackup.exe
dlist.exe loadfile.exe uvbootd.exe
dsadmin.exe magrst.exe uvfilefix_server.exe
dsapi_server.exe make.map.exe uvfixfile.exe
dsapi_slave.exe map.exe uvinst.dll
dsdgci.dll master.exe uvmt.exe
dsdlockd.exe message.exe uvregen.exe
dsdperl.dll mkaccount.exe uvrestore.exe
dsengine.dll mkdbfile.exe uvsh.exe
dsgci.dll mkload.exe uvtic.exe
dsinst.dll mkschema.exe uvtidc.exe
dsjob.exe mksecure.exe uvwalk.exe
dslictool.exe mksqlassoc.exe vcatalog.exe
dsnetd.exe mksqlcol.exe verify.exe
dspipe.exe mksqlcon.exe vlist.exe
dsplugin.dll mksqlfile.exe vsum.exe
dsradmin.dll mksqlprm.exe vvoc.exe
dsrpcd.exe mksqlrefer.exe xref.exe
dssearch.exe mksqluniq.exe
DSJOB语法:
E:\IBM\InformationServer\Server\DSEngine\bin>dsjob
命令语法:
dsjob [-file | -domain -user
-password -server ]
[]
有效的主命令选项为:
-run
-stop
-lprojects
-ljobs
-linvocations
-lstages
-llinks
-projectinfo
-jobinfo
-stageinfo
-linkinfo
-lparams
-paraminfo
-log
-logsum
-logdetail
-lognewest
-report
-jobid
状态码为 -9999 DSJE_DSJOB_ERROR
部分参数说明:
-run 运行job
-stop 停止运行中的job
-lprojects 列出server中所有的工程
-ljobs 列出指定project中的所有的job
-linvocations列出指定job中的所有的invocation
-lstages 列出指定job中的所有的stage
-llinks 列出指定job中的所有的link
-projectinfo 列出指定project的信息
-jobinfo 列出指定job的信息
-stageinfo 列出指定stage的信息
-linkinfo 列出指定link的信息
-lparams 列出指定job的所有的parameter
-paraminfo 列出指定parameter的信息
-log 获得job的所有的日志
-logsum 获得job的所有的日志
-logdetail 获得job的所的详细日志
-stop 停止运行中的job
-lprojects 列出server中所有的工程
-ljobs 列出指定project中的所有的job
-linvocations列出指定job中的所有的invocation
-lstages 列出指定job中的所有的stage
-llinks 列出指定job中的所有的link
-projectinfo 列出指定project的信息
-jobinfo 列出指定job的信息
-stageinfo 列出指定stage的信息
-linkinfo 列出指定link的信息
-lparams 列出指定job的所有的parameter
-paraminfo 列出指定parameter的信息
-log 获得job的所有的日志
-logsum 获得job的所有的日志
-logdetail 获得job的所的详细日志
DSJOB用法范例:
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -lprojects
ANALYZERPROJECT
Sample
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -ljobs
无效参数:dsjob -ljobs
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -ljobs Sample
archGenData
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -linvocations Sample archGenD
ata
archGenData
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -lstages
无效参数:dsjob -lstages [-useid]
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -lstages Sample archGenData
Row_Generator_0
Row_Generator_3
Lookup_1
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -llinks Sample archGenData
无效参数:dsjob -llinks [-useid]
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -llinks Sample archGenData L
okup_1
DSLink2
DSLink4
DSLink6
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -projectinfo Sample
主机名 :datastag-lab
项目名称 :Sample
项目路径 :E:\IBM\InformationServer\Server\Projects\Sample
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -jobinfo
无效参数:dsjob -jobinfo [-useid]
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -jobinfo Sample archGenData
作业状态 :已运行,但带有警告(2)
作业控制器 :不可获得
作业开始时间 :Sat Jan 05 16:53:27 2013
作业 Wave 号 :4
用户状态 :不可获得
作业控制 :0
中间状态 :未在运行(99)
调用标识 :不可获得
最后运行时间 :Sat Jan 05 16:53:33 2013
作业进程标识 :0
调用列表 :archGenData
可重新启动的作业 :0
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -stageinfo Sample archGenData
Lookup_1
阶段类型 :PxLookup
位于行号 1000
阶段的最后一个错误:
阶段开始时间:Sat Jan 05 16:53:30 2013
阶段结束时间 :Sat Jan 05 16:53:33 2013
变量列表 :不可获得
阶段名称 :Lookup_1
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -linkinfo
无效参数:dsjob -linkinfo [-useid]
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -linkinfo Sample archGenData
Lookup_1 DSLink2
链接行计数 :1000
链接的最后一个错误 :
链接 DBMS 代码 :不可获得
SQL 状态 :不可获得
链接名称 :DSLink2
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -lparams Sample archGenData
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -log
无效参数:dsjob -log
[-info | -warn]
日志消息从标准输入中读入。
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -log Sample archGenData
请输入消息文本(以 Ctrl-d 终止)
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>e:
E:\>cd E:\IBM\InformationServer\Server\DSEngine\bin
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -logsum
无效参数:dsjob -logsum
[-type
T | BATCH>]
[-max ]
[-useid]
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -logsum Sample archGenData
0 已启动 Sat Jan 05 15:54:31 2013
正在启动作业 archGenData。
1 参考 Sat Jan 05 15:54:32 2013
环境变量设置: (...)
2 参考 Sat Jan 05 15:54:32 2013
并行作业已启动
3 参考 Sat Jan 05 15:54:32 2013
OSH script. (...)
..................................................................
..................................................................
87 已启动 Sat Jan 05 16:53:33 2013
作业 archGenData 已完成。
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -logdetail
无效参数:
dsjob -logdetail [-useid] [
id>]
dsjob -logdetail [-useid] [-wave ]
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -logdetail Sample archGenData
事件标识:73
时间 :Sat Jan 05 16:53:27 2013
类型 :已启动
用户 :DATASTAG-LAB\Administrator
消息 :
正在启动作业 archGenData。
事件标识:74
时间 :Sat Jan 05 16:53:28 2013
类型 :参考
用户 :DATASTAG-LAB\Administrator
消息 :
环境变量设置:
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t-
APT_COMPILER=cxx
APT_CONFIG_FILE=E:/IBM/InformationServer/Server/Configurations/default.a
pt
APT_ERROR_CONFIGURATION=severity, !vseverity, !jobid, moduleid, errorInd
ex, timestamp, !ipaddr, !nodeplayer, !nodename, opid, message
APT_LINKER=cxx
APT_LINKOPT=-s -W/dll -W/base:0x50000000 -W/Zc:wchar_t-
APT_MONITOR_MINTIME=10
...................
OSH script
# OSH / orchestrate script. for Job archGenData compiled at 16:05:04 05 1
月 2013
#################################################################
#### STAGE: Row_Generator_0
## Operator
generator
## Operator options
-schema record
(
CustID:int32 {cycle={init=10000}};
Int1:int32 {cycle={init=0, limit=29}};
Int2:int32 {cycle={init=1, limit=29}};
Int3:int32 {cycle={init=2, limit=29}};
Int4:int32 {cycle={init=3, limit=29}};
Middlelnit:string[1] {alphabet='abcdefghij1234567890'};
Zip:int32 {cycle={init=10000, incr=4734, limit=99999}};
CustDate:date {random={limit=20000}};
InsertUpdateFlagInt:int32 {random={limit=2}};
)
-records 1000
## General options
[ident('Row_Generator_0'); jobmon_ident('Row_Generator_0')]
## Outputs
0> [] 'Row_Generator_0:DSLink2.v'
;
..........................................
main_program: APT 配置文件:E:/IBM/InformationServer/Server/Configuratio
ns/default.apt
{
node "node1"
{
fastname "DATASTAG-LAB"
pools ""
resource disk "E:/IBM/InformationServer/Server/Datasets"
{pools ""}
resource scratchdisk "E:/IBM/InformationServer/Server/Sc
ratch" {pools ""}
}
}
.................................
用户 :DATASTAG-LAB\Administrator
消息 :
并行作业报告已成功完成
事件标识:87
时间 :Sat Jan 05 16:53:33 2013
类型 :已启动
用户 :DATASTAG-LAB\Administrator
消息 :
作业 archGenData 已完成。
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -report Sample archGenData r
port type = BASIC
无效参数:dsjob -report [-useid] [report type>]
report type = BASIC | DETAIL | XML
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -report Sample archGenData
**************************************************
JOB archGenData 的状态报告
已生成:2013-01-06 12:47:23
作业开始时间为 2013-01-05 16:53:27
作业结束时间为 2013-01-05 16:53:33
作业耗用时间为 00:00:06
作业状态为 2(已完成,但带有警告)
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>dsjob -run
无效参数:dsjob -run
[-mode ]
[-paramfile ]
[-param =]
[-warn ]
[-rows ]
[-wait]
[-opmetadata ]
[-disableprjhandler]
[-disablejobhandler]
[-jobstatus]
[-userstatus]
[-useid]
状态码为 -9999 DSJE_DSJOB_ERROR
E:\IBM\InformationServer\Server\DSEngine\bin>dsjob -run Sample archGenData
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
E:\IBM\InformationServer\Server\DSEngine\bin>
dsjob -run -mode NORMAL Sample arch
GenData
状态码为 0
E:\IBM\InformationServer\Server\DSEngine\bin>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15720542/viewspace-752183/,如需转载,请注明出处,否则将追究法律责任。
上一篇:
DS8.1安装
![user_pic_default.png](http://blog.itpub.net/images/user_pic_default.png)
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%>
<%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%if(items[i].items.total > 5) { %>
<%}%>
<%=items[i].items.items[j].createtime%>
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>: <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
转载于:http://blog.itpub.net/15720542/viewspace-752183/