Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Issue with running command task on PC 8.1.1 sp2

Status
Not open for further replies.

vicsap

Technical User
Sep 25, 2006
10
US
I have recently upgraded from PC 7.1.3 to PC 8.1.1 sp2 on HP-UX box.
I ran some workflows containing session tasks and those ran fine.

Currently I am having problem in running command tasks. We have some perl scripts sitting on Unix box and the command tasks call those scripts and run those.
We have 6 repositories on test box. Earlier with 7.1.3 version , we had 6 inidividual param files and 6 corresponsing cfg files for each repository. We used to start each repository using startpm.ksh TSTx (x = 1 to 6) for each repository and it used to start the repository by picking up the variables from the param file.

With PC 8.1.1 , we dont have startpm.ksh command anymore as its now SOA based architecture. So I have few questions now.

What changes do I need to make in order to run command task on any individual repository service
Also how can I run same command task on 2 different repository services at the same time.

Also guys what changes do I need to make in .profile file for informatica user :
On 7.1.3 I had $PATH $INFA_HOME and $SHLIB_PATH containing /pc , /repositoryserver and /ocbc included.

What shall I replace those with for PC 8.1.1?

Please let me know if any question isnt very clear.


Regards
Vik
 
I am not positive I get what you are saying.

Are you asking how to reuse a workflow "command task" across multiple repositories? Or are you asking how to call a command task from outside using SOA?
 
Thanks for the reply.
We have 6 repositories in our test env.Till version 7.1.3 , we had individual .param file and .cfg file for each repository and we had the priv to run same work flow in different repositories at the same time. Basically each repository had a connection to its own target database instance. So we could perform 6 parallel testing efforts.

So far I haven't seen the concept of .cfg and .param file anymore in 8.1.1. I am able to run workflow in one repository at a time by harcoding its parameter file path in .profile file.

I was thinking how can I run same workflow in all 6 repositories at the same time as I was doing that in PC 7.1.3

I hope my question is more clear now

Regards
Vik
 
Hi Vik,

My experience is limited to 8.1.1 and mostly in a Windows environment.

My understanding of 8.1.1 is that workflows are owned by the repository. There is no ability to define a single workflow that runs across multiple repositories in 8.1.1.

You could maintain the workflow in one repository, then use a script to export and import into the other repositories... and subsequently launch the workflows.
 
I guess you used version control in 7.1.3. to migrate workflows between repositories?

Ties Blom

 
Do you have the 6 repositories on one integration service? Is that why you have to switch between repositories? Or do they each have their own service?

In 7.1 (at least on Windows), you could only associate one repository to one ETL server. Maybe the UNIX version was different?

"I think we're all Bozos on this bus!" - Firesign Theatre [jester]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top