massmaharaj Posted November 23, 2012 Report Posted November 23, 2012 Severity Timestamp Node Thread Message Code Message INFO 11/23/2012 11:40:54 AM ND_01_INFO-DEVB PRE-SESS CMN_1954 [Pre/Post Session Command] Process id 44040230. Standard output and error: Informatica PMCMD, version [9.1.0 HotFix5], build [470.0712], AIX 64-bit Copyright Informatica Corporation 1994 - 2012 All Rights Reserved. Invoked at Fri Nov 23 11:40:51 2012 Connected to Integration Service: [IS_SHRD_DEV_01]. Starting workflow [wf_NAME] Waiting for workflow [wf_NAME] to complete Disconnecting from Integration Service Completed at Fri Nov 23 11:40:53 2012
massmaharaj Posted November 23, 2012 Author Report Posted November 23, 2012 we are working with pmcmd command it is connecting and disconnecting could you please let me know
bokuboy Posted November 23, 2012 Report Posted November 23, 2012 na frnd unnadu unix meedhane working.... adagana vadini
vikuba Posted November 23, 2012 Report Posted November 23, 2012 http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/how-to-execute-a-workflow-through-unix-shell-script-2623810 http://www.unix.com/shell-programming-scripting/167590-how-execute-pmcmd-command-unix.html you would hav to run this command in informatica folders where pmcmd .exe executable exists
vikuba Posted November 23, 2012 Report Posted November 23, 2012 [color=#000000][font=arial]First set the informatica bin directory in PATH [/font][/color] [color=#000000][font=arial]Do these in .bashrc or .kshrc or .shrc [/font][/color] [color=#000000][font=arial]PATH=/u01/Informatica/9.0.1/server/bin:$PATH [/font][/color] [color=#000000][font=arial]export PATH [/font][/color] [color=#000000][font=arial]LD_LIBRARY_PATH=/u01/Informatica/9.0.1/server/bin: $LD_LIBRARY_PATH [/font][/color] [color=#000000][font=arial]export LD_LIBRARY_PATH [/font][/color] [color=#000000][font=arial]PATH=/u01/Informatica/9.0.1/tomcat/bin:$PATH [/font][/color] [color=#000000][font=arial]export PATH [/font][/color] [color=#000000][font=arial]INFA_HOME=/u01/Informatica/9.0.1 [/font][/color] [color=#000000][font=arial]export INFA_HOME [/font][/color] [color=#000000][font=arial]Then run [/font][/color] [color=#000000][font=arial]pmcmd startworkflow -sv <Integration Service Name> -d <Domain Name> -u <Integration Service Username> -p <Password> -f <Folder Name> <Workflow> [/font][/color] [color=#000000][font=arial]That's it, now you can monitor the workflow progress in Workflow Monitor.[/font][/color]
jaffanajeffada Posted November 23, 2012 Report Posted November 23, 2012 ltt assalu workflow execute avutundha?
vikuba Posted November 23, 2012 Report Posted November 23, 2012 [size=3][font=arial, helvetica, sans-serif][b] Step 1: Check if you have PMCMD available. [/b] [color=#252324]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. [/color] [color=#252324]find . -name "PMCMD" –print , Command need to be executed at INFA application root directory.[/color] [color=#252324]Step 2: If PMCMD is available.[/color] [color=#252324] Check if execute access is there for all. User group and others should have execute access to this utility.[/color] [color=#252324]Step 3: Configure SHLIB_PATH environment variable.[/color][/font][/size] [indent=1][size=3][font=arial, helvetica, sans-serif]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).[/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324]/appl/inform/Informatica/9.0.1/server/bin[/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324]Configuring shlib_path variable will enable you to run this utility from your UNIX ID in a particular UNIX environment. [/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324]You need to execute below two commands at command prompt to configure shlib_path variable. [/color][/color][/color][/font][/size][/indent] [indent=2][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324]SHLIB_PATH=$PATH:/appl/inform/Informatica/ 9.0.1/server/bin[/color][/color][/color][/color][/font][/size][/indent] [indent=2][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]export SHLIB_PATH[/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]Now your setup is ready, You can use syntax given in next step to run start workflow with this utility. [/color][/color][/color][/color][/color][/color][/font][/size][/indent] [size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]Step 4: Syntax : PMCMD Start Workflow [/color][/color][/color][/color][/color][/color][/color][/font][/size] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]pmcmd startworkflow[/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]–uv USER_TEST[/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]–pv PASSWORD_TEST # See comments for more info on Uname/Password.[/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]–s ITG_SERVICE[/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]–f WF_FOLDER[/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]–paramfile ‘\$PMROOTDIR/PARAM_FILE.TXT’[/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]–wait WF_INFA_WF_TO_INVOKE [/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [indent=1][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324]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.[/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/indent] [size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][url="http://etllabs.com/wp-content/uploads/Informatica-PMCMD-Syntax.jpg"][img]http://etllabs.com/wp-content/plugins/image-shadow/cache/d990b3d3e44f61a6507826202ef93049.jpg[/img][/url][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size] [center][size=3][font=arial, helvetica, sans-serif][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#252324][color=#999999][url="http://etllabs.com/wp-content/uploads/Informatica-PMCMD-Syntax.jpg"]Informatica PMCMD Script Syntax[/url][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/color][/font][/size][/center]
massmaharaj Posted November 23, 2012 Author Report Posted November 23, 2012 vishayam vachi oke workflow 2 paramfiles untaayi parmfiles ni parameterize chesaam and we put -lpf and it has to run two times , workflow connect avuthundi disconnect avuthundi
Recommended Posts