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
Tuesday, December 4, 2012
Setup Environment variables for PMCMD/PMREP
Subscribe to:
Post Comments (Atom)
Tags
Architecture of UNIX
(1)
Basic Unix Commands
(1)
Data warehousing Quiestions1
(1)
Debugger
(1)
Downloads
(1)
ETL Process
(1)
Fundamentals of UNIX
(1)
Get top 5 records to target without using rank
(1)
Home
(1)
How do you perform incremental logic or Delta or CDC
(1)
Incremental Loading for Dimension Table
(1)
Informatica Complete Reference
(1)
Informatica Functions
(1)
Informatica Powercenter Architecture
(1)
informatica project
(1)
Informatica Quiestions
(1)
Informatica Quiestions3
(1)
Informatica Real time Scenarios
(2)
Informatica scenarios
(3)
Integration Testing
(1)
Introduction of Unix
(1)
Oracle Queries
(1)
Power center Client
(1)
Separate rows on group basis
(1)
TESTING-User Acceptance Test
(1)
Unit Testing
(1)
Unix
(2)
What is informatica
(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.
ReplyDeleteThanks
Hi Alex thanks for your comments keep in touch for more updates.
ReplyDeleteVery 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.
ReplyDeleteVery 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