Tuesday, December 4, 2012

Setup Environment variables for PMCMD/PMREP

Setup Environmental variables for PMCMD/PMREP

The pmcmd is a command line client program that connects to integration service to run the workflow and schedule the workflow.

Set up the fallowing environmental variables to work with command line utilities.
• From desktop select my computer, right click, click on properties, select advanced tab, click on environmental variables.
• From user variables for admin click on new, press enter
Variable name : INFA_HOME
Variable value : C:\Informatica\PowerCenter8.6.0, click on ok.
• From system variables select the variable ‘path’ click on edit.
Variable name : path
Variable value : C:\Informatica\PowerCenter8.6.0\server\bin;
Click on OK.
Invoking PMCMD client:
Access the DOS Prompt .at command line type pmcmd, press enter. Issue the fallowing commands to work with pmcmd.


1. Connect:
It connects to the integration service with the fallowing syntax.

Pmcmd>connect –sv service –d domain –u user –p password

2. Start workflow:

It allows you to run the workflow on integration service.

Syntax : pmcmd>startworkflow –f folder workflow name

3. Set folder:

It activates the folder to run multiple workflows from the same folder.

Syntax : pmcmd>setfolder folder name

4. Unset folder:

It inactivate the currently activated folder.
Syntax: pmcmd>unsetfolder

Ex: unsetfolder

5. Get service properties:

PMCMD>getserviceproperties
Ex : Integration domain : Domain_servicename
Integration service: servicename
Integration service: [version [8.6.0], build [0612]]
Integration service allows running debug mappings.

6. Get service details:

Pmcmd>getservicedetails
It provides the current status of an integration service and objects running on integration service.

Ex :
No .of schedule workflows running on integration service
No .of scheduled workflows on integration service
No .of active session integration service
Current time on integration service
Stop time on integration service

7. Help: pmcmd>help

It provides the syntax for pmcmd commands.
Pmcmd>help scheduleworkflow
It provides the help for a command schedule workflow.

8. Schedule workflow:

It allows you to run the workflow at schedule times.

Syntax: pmcmd>scheduleworkflow –f folder workflow name

Ex : pmcmd>scheduleworkflow –f batch w_pmcmd
The default time out is 180 sec.

9. Disconnect:

It disconnects the pmcmd from integration service.
Syntax: pmcmd>disconnect

10. Exit:
It disconnects the pmcmd from integration service and close the pmcmd client program.
Ex: pmcmd>exit

4 comments:

  1. I am facing problem to connect and Work with PMCMD. your topics are very useful thank you very much Excellent kareem keep it up.Your blog is very usefull.

    Thanks

    ReplyDelete
  2. Hi Alex thanks for your comments keep in touch for more updates.

    ReplyDelete
  3. Very useful Blog....Especially for beginners....I have so many things as bits and pieces and once I came through your BlogSpot I sorted them out and ready for the job. Thanks a lot Kareem, for sharing your knowledge.

    ReplyDelete
  4. Very useful Blog....Especially for beginners....I have so many things as bits and pieces and once I came through your BlogSpot I sorted them out and ready for the job. Thanks a lot Kareem, for sharing your knowledge.

    ReplyDelete

Thank you :
- kareem