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