首页 » 编程开发 » Informatica » 正文

Informatica中命令调用workflow的工具pmcmd使用方法

| Informatica | | 暂无评论 | 5281 views

pmcmd是C语言编写的一个专门使用命令来对workfflow流程进行控制管理的一个工具，有了它，我们就可以在shell脚本中很方便的使用命令来调用、暂停、挂起、覆盖workflow，pmcmd工具不需要单独安装，它是Powercenter自带的工具。下面介绍pmcmd的使用方法。

 

调用workflow命令格式：

Usage: pmcmd startworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder]
[<-startfrom> taskInstancePath [<-recovery|-norecovery>]]
[<-paramfile> paramfile]
[<-localparamfile|-lpf> localparamfile]
[<-osprofile|-o> OSProfile] [-wait|-nowait]
[<-runinsname|-rin> runInsName] workflow

使用示例：

pmcmd startworkflow -sv rep_newods -d Domain_newods -u Administrator -p tiger -f NEW_JOB wf_temp_data

注释：
上例子中，rep_newods代表需要连接的server即服务名，下图中的1；Domain_newods代表域，即我们在客户端菜单Repositories->Config Domains->Domains中配置的，下图中的2；“-u Administrator -p tiger”代表用户名和密码，不解释；“-f NEW_JOB”代表知识库下面的NEW_JOB文件夹，在这里指定workflow的存放路径；最后一个参数，当然就是workflow的名称咯。不明白的看下图：
1
如果运行以上命令遇到问题，提示报错“PCSF_46007 No gateway connectivity is provided for domain”，那么只需要向服务器端的系统添加系统环境变量就可以了，执行命令：“export INFA_DOMAINS_FILE=C:\Informatica\PowerCenter8.1.0\domains.infa”,PowerCenter8.1.0的安装路径下domains.infa的路径。

我们除了可以像上面那样直接通过一长串参数调用workflow外，还可以通过参数文件。
下面的例子是调用workflow中的wf_test，使用参数文件是myfile.txt：

pmcmd startworkflow -uv USERNAME -pv PASSWORD -s SALES:6001-f east -w wSalesAvg -paramfile ‘\$PMRootDir/myfile.txt’  wf_test

pmcmd命令调用workflow的介绍就到这里了，相信大家看了上面的说明已经理解了怎么使用，下面附上pmcmd中其他控制命令格式：

$ pmcmd -help

Informatica(r) PMCMD, version [8.6.0 HotFix9], build [392.0525], AIX 64-bit
Copyright (c) Informatica Corporation 1994 – 2009
All Rights Reserved.

Invoked at Wed Dec 30 14:42:02 2015

Usage: pmcmd help [command]
Usage: pmcmd version
Usage: pmcmd pingservice
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
Usage: pmcmd getserviceproperties
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
Usage: pmcmd getservicedetails
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[-all|-running|-scheduled]
Usage: pmcmd getrunningsessionsdetails
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
Usage: pmcmd startworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder]
[<-startfrom> taskInstancePath [<-recovery|-norecovery>]]
[<-paramfile> paramfile]
[<-localparamfile|-lpf> localparamfile]
[<-osprofile|-o> OSProfile] [-wait|-nowait]
[<-runinsname|-rin> runInsName] workflow
Usage: pmcmd stopworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] [<-runinsname|-rin> runInsName]
[-wfrunid workflowRunId] [-wait|-nowait] workflow
Usage: pmcmd abortworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] [-wait|-nowait]
[<-runinsname|-rin> runInsName]
[-wfrunid workflowRunId] workflow
Usage: pmcmd waitworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] [<-runinsname|-rin> runInsName]
[-wfrunid workflowRunId] workflow
Usage: pmcmd recoverworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] [<-paramfile> paramfile]
[<-localparamfile|-lpf> localparamfile]
[-wait|-nowait] [<-runinsname|-rin> runInsName]
[-wfrunid workflowRunId] workflow
Usage: pmcmd scheduleworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] workflow
Usage: pmcmd unscheduleworkflow
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] workflow
Usage: pmcmd getworkflowdetails
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder]
[<-runinsname|-rin> runInsName]
[-wfrunid workflowRunId] workflow
Usage: pmcmd starttask
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] <-workflow|-w> workflow
[<-paramfile> paramfile] [-wait|-nowait]
[<-recovery|-norecovery>] [<-runinsname|-rin> runInsName]
taskInstancePath
Usage: pmcmd stoptask
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] <-workflow|-w> workflow
[<-runinsname|-rin> runInsName] [-wfrunid workflowRunId]
[-wait|-nowait] taskInstancePath
Usage: pmcmd aborttask
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] <-workflow|-w> workflow
[<-runinsname|-rin> runInsName] [-wfrunid workflowRunId]
[-wait|-nowait] taskInstancePath
Usage: pmcmd waittask
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] <-workflow|-w> workflow
[<-runinsname|-rin> runInsName] [-wfrunid workflowRunId]
taskInstancePath
Usage: pmcmd gettaskdetails
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] <-workflow|-w> workflow
[<-runinsname|-rin> runInsName] taskInstancePath
Usage: pmcmd getsessionstatistics
<<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]>
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
[<<-usersecuritydomain|-usd> usersecuritydomain|<-usersecuritydomainvar|-usdv> userSecuritydomainEnvVar>]
[<-folder|-f> folder] <-workflow|-w> workflow
[-wfrunid workflowRunId]
[<-runinsname|-rin> runInsName]
taskInstancePath

Completed at Wed Dec 30 14:42:02 2015

发表评论