Tuesday, 25 March 2014

working with PMCMD COMMAND USAGE IN INFORMATICA and How to run workflow in unix?

Informatica provides four built-in command line programs or utilities to interact with the informatica features. They are:
  • infacmd
  • infasetup
  • pmcmd
  • pmrep
The pmcmd is a command line utility provided by the informatica to perform the following tasks.
  • Start workflows.
  • Start workflow from a specific task.
  • Stop, Abort workflows and Sessions.
  • Schedule the workflows.
How to use PMCMD Command in Informatica:
1. Scheduling the workflow 
The pmcmd command syntax for scheduling the workflow is shown below:
pmcmd scheduleworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
You cannot specify the scheduling options here. This command just schedules the workflow for the next run.
2. Start workflow 
The following pmcmd command starts the specified workflow:
pmcmd startworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
3. Stop workflow 
Pmcmd command to stop the infromatica workflow is shown below:
pmcmd stopworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name
4. Start workflow from a task 
You can start the workflow from a specified task. This is shown below:
pmcmd startask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name -startfrom task-name
5. Stopping a task. 
The following pmcmd command stops the specified task instance:
pmcmd stoptask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name
6. Aborting workflow and task. 
The following pmcmd commands are used to abort workflow and task in a workflow:
pmcmd abortworkflow -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name

pmcmd aborttask -service informatica-integration-Service -d domain-name -u user-name -p password -f folder-name -w workflow-name task-name
Running workflow in UNIX? 

Syntax: pmcmd startworkflow -sv <service name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name>
Example
Pmcmd start workflow –service
${INFA_SERVICE} -domain 
${INFA_DOMAIN} -uv xxx_PMCMD_ID -pv PSWD -folder  
${ETLFolder} -wait ${ETLWorkflow} 

1 comment:

  1. How to abort a particular instance workflow using above method if I have more than 2 instances and wanted to particularly kill one of them

    ReplyDelete