Wierd Problem with Shared Container

ak77 · Post by **ak77** » Wed Jan 18, 2006 12:22 pm

Hi everybody,

I created a shared container and am using it in a different job
This job has four of this shared containers and they are all writing to one sequential file. The performance characteristics( meaning the Show Performance in the Designer) is not displayed in one of the links but the monitor option in Director shows the characteristics for all the links

Has anybody had this problem?

Thank you

Kishan

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2006 3:33 pm

The operating system will only allow one writer at a time to a sequential file. This is not a DataStage problem - it's a design issue. Have the shared container write to a different file in each instance - make the file name a container parameter.

ak77 · Post by **ak77** » Fri Jan 20, 2006 3:17 pm

Ray -

I see what you mean but I was using a LinkCollector to write to a single file and also four different sequential files
It does the same meaning it wont show any information on one of the links

I am not sure why its happening
Initially I had this problem in 6.0.1 and another friend of mine told he has the problem in 7.5 also

Thanks
Kishan

ray.wurlod · Post by **ray.wurlod** » Fri Jan 20, 2006 7:35 pm

Can you see the performance statistics inside the container, if you open it from the job design?

chulett · Post by **chulett** » Fri Jan 20, 2006 8:54 pm

No, that's one of the 'problems' with shared containers. There's no way to get performance statistics for the stages inside them.

ak77 · Post by **ak77** » Tue Jan 24, 2006 7:06 pm

Thanks Ray and Chulet,

I didnt try looking into the Shared container
But I just brought this issue because I wanted to know if it was a problem with DataStage

Kishan

ray.wurlod · Post by **ray.wurlod** » Tue Jan 24, 2006 7:35 pm

Performance statistics on Designer are only a "nice to have" anyway. You can always get the link row counts from the job log, or programmatically once the job has finished processing rows.