PMCMD command

[jlito]

Hi,

Anyone of you guys who knows how to use the pmcmd command using Control-M? The thing is I want to run the different session(s)/workflow(s) using the pmcmd command built in Control-M.

Thanks in advance,
Jlito

 

[Dagon]

All Control-M does is call a UNIX script, so all you need to do is wrap a shell script around pmcmd to set up the correct environment (LD_LIBRARY_PATH etc) and maybe a cd to the PowerCenter home directory. The just get Control-M to call your shell script.

 

[jlito]

Hi Dagon,

I'm still not clear of the procedures that I need to do. Can you give me a sample script (unix and control-M)? I think we need to check on the status of the Informatica job then execute. But if not, what am I going to do next? Can Control-M check the status so it will not proceed to the next job that is to be executed.

thanks and regards,
Jlito

 

[Dagon]

I'm not Control-M expert, so I can't tell you in detail how to set it up. I've only ever supplied a few scripts to run using it. But it can certainly check the return status of jobs - I believe it can even check log files for error strings or job success messages.

The pmcmd command does return a UNIX status if it fails (providing you use the flag which waits for the job to complete), so all you would need is something like:

cd <powercenter_directory>
# set up LD_LIBRARY_PATH etc
./pmcmd start <user> <path> <port> <session name> 1 1
returnvalue=$? return $returnvalue