Datastage常用命令

启动、停止服务
#uv -admin -start
#uv -admin -stop
 
导入dsx工程文件
dsimport.exe /H=hostname /U=username /P=password /O=omitflag /NUA project|/ALL|/ASK dsx_pathname1 dsx_pathname2 ...
dscmdimport /H=hostname /U=username /P=password /O=omitflag /NUA project|/ALL|/ASK pathname1 pathname2... /V
此处多了一个/V:
V. Use this flag to switch the verbose option on.
For example, the following command imports the components in the
file jobs.dsx into the project dstage1 on the R101 server:
dscmdimport /H=R101 /O=1 dstage1 C:/scratch/jobs.dsx
Messages from the import are sent to the console by default, but can
be redirected to a file using '>', for example:
dscmdimport /H=R101 /O=1 /NUA dstage99 c:/scratch/project99.dsx /V > c:/
scratch/importlog
You can simply type dscmdimport at the command prompt to get help
on the command options.
 
导出dsx工程文件
dsexport.exe /H hostname /U username /P password /O omitflag project pathname1
dscmdexport /H hostname /U username /P password /O omitflag project pathname /V
此处多了一个/V:
V. Use this flag to switch the verbose option on.
For example, the following command exports the project dstage2
from the R101 to the file dstage2.dsx:
dscmdexport /H R101 /O 1 dstage2 C:/scratch/dstage2.dsx
Messages from the export are sent to the console by default, but can
be redirected to a file using '>', for example:
dscmdexport /H R101 /O 1 dstage99 c:/scratch/project99.dsx /V > c:/
scratch/exportlog
You can simply type dscmdexport at the command prompt to get
help on the command options.
 
编译指定名称的JOB
dscc /h ip /u dsadm /p dsadm prjname /j jobname
 

Usage: dscc [@argfile] [/?] /h <value> [/o] [/u <value>] [/p <value>] <project>
[/j <value>] [/r <value>] [/bo <value>] [/f] [/ouc] [/rd <value>] [/rt <value>]
[/jt <value>] [/mful <value>] [/mfcgb <value>]

@argfile        Read arguments from a file.
/?              Show usage.
/h <value>      Name of Host to attach to
/o              Omit logon details
/u <value>      User Name
/p <value>      Password
project         Project To Attach to
/j <value>      Job to compile, * = All Jobs, cat\* = category
/r <value>      Routine to compile, * = All Routines, cat\* = category
/bo <value>     Build Op to compile, * = All Build Ops, cat\* = category
/f              Use the Force Compile
/ouc            Only Compile Uncompiled Objects
/rd <value>     Report Directory and Name
/rt <value>     Type of report to produce : X = xml, T = txt - default
/jt <value>     Job Type To Compile
        -1 (Default) = All Types
        0 = Server
        1 = Mainframe
        2 = Sequence
        3 = Parallel
/mful <value>   Mainframe Job Upload Profile
/mfcgb <value>  Mainframe Code Gen base directory location

 
显示project列表
dsjob -server ip -user dsadm -password dsadm -lprojects
 
显示project的job列表
dsjob -server ip -user dsadm -password dsadm -ljobs prjname
 
编译全部JOB
dscc /h ip /u dsadm /p dsadm prjname /j *
 
运行job,默认设置
dsjob -run prjname jobname
 
运行job,传递参数
dsjob -run -param /$date=20091128 prjname jobname
 
运行job,传递多个参数
dsjob -run -param /$srcuser=test -param /$srcpwd=test prjname jobname
 
运行job sequence,多个参数
dsjob -run -param srcuser=test -param srcpwd=test prjname jobname
 
运行job,不等待job运行完成
dsjob -server ip -user dsadm -password dsadm -run prjname jobname
 
运行job,等待job运行完成
dsjob -server ip -user dsadm -password dsadm -run -wait prjname jobname
 
查看job信息
dsjob -server ip -user dsadm -password dsadm -jobinfo prjname jobname
 
查看job日志
dsjob -server ip -user dsadm -password dsadm -logsum prjname jobname
 
查看job报告
dsjob -server ip -user dsadm -password dsadm -report prjname jobname
 
相关推荐
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页