Tuesday, 17 March 2015

Workflow Execution through PMCMD

Executing PMCMD command on UNIX and Syntax

By  on May 15, 2011

Steps to start workflow through PMCMD command, Generally we get below error while executing PMCMD first time. This error actually tells that utility you are trying to execute is not available. 

/usr/lib/hpux64/dld.so: Unable to find library '1:/home/build3p /PMReleases/90/ HP –   UX.IPF.64/xml /pmxerces2_7_0 /lib/libpmxerces-c.sl.27′.Killed

Step 1: Check if you have PMCMD available. 

If you have informatica installed on your system that doesn't mean you can execute this utility also, Use below command to find out this utility availability for your informatica installation. If not, Talk to your admin to check that your organization license has this utility in it or not.  

find . -name "PMCMD" –print , Command need to be executed at INFA application  root directory.

Step 2: If PMCMD is available.

  Check if execute access is there for all. User group and others should have execute access to this utility.

Step 3: Configure SHLIB_PATH environment variable.

Bottom line, To run this utility, you got to configure the SHLIB_PATH environment variable to include below directory (Path may differ for your setup).

/appl/inform/Informatica/9.0.1/server/bin

Configuring shlib_path variable will enable you to run this utility from your UNIX ID in a particular UNIX environment. 

You need to execute below two commands at command prompt to configure shlib_path variable. 

SHLIB_PATH=$PATH:/appl/inform/Informatica/ 9.0.1/server/bin

export SHLIB_PATH

Now your setup is ready, You can use syntax given in next step to  run start workflow with this utility. 

Step 4:  Syntax : PMCMD Start Workflow 

pmcmd startworkflow

–uv USER_TEST

–pv PASSWORD_TEST  # See comments for more info on Uname/Password.

–s ITG_SERVICE

–f WF_FOLDER

–paramfile '\$PMROOTDIR/PARAM_FILE.TXT'

–wait WF_INFA_WF_TO_INVOKE 

For easy understanding I have kept every pmcmd startworkflow  parameter attributes in new line. You need to remove newline character and keep only one space before each parameter. At last your command will look like one shown in below picture.

Informatica PMCMD Script Syntax

Informatica PMCMD Script Syntax

 

 

 

 

No comments:

Post a Comment