File update issue

myukassign · Post by **myukassign** » Wed Sep 17, 2008 3:34 am

I got a problem in updating file by multiple sequncers.

Enviorment
========

JobA open sequnetial FileA and hash in to HashA then using a transformer increment a field value then update FileA again.

When I run jobA individually, there is no issue. Its running successfully. But this JobA is a common job for me and it is using in many sequncers.

The problem is, when at a time two sequncers call JobA then it willtry to write the FileA at a time. Then an error will be thrown.

Can anyone help me how to handle this issue?

ray.wurlod · Post by **ray.wurlod** » Wed Sep 17, 2008 3:36 am

This is an operating system restriction (not a DataStage issue) - only one writer at a time to a file.

You need to work around that restriction. Maybe with files with the process ID as part of the file name. Certainly with parameterized file names.