Page 1 of 1

Records missing in the sequential file

Posted: Tue Nov 23, 2010 11:48 pm
by kamesh
Hello Everyone,

I am trying to write two sets of data containg 5 records each to the same sequential file in an APPEND mode after the tranformations in a parallel job. But, my sequential file contains only 5 records after the job runs even though log shows that 5 records are consumed by each of the seq file stages. I also tried changing the job to run in single node configuration and changed all the stages execution mode to sequential without any success.
As far as I can understand this may be due to write lock of the sequential file which gets released only on completion of the job.

Please note that this scenario work perfectly in a server job when we use hashed file stage.

Code: Select all

Row generator -> Transformer -> Transformer 
                        |             |
                        v             v
                     Seq File     Seq File

Posted: Wed Nov 24, 2010 12:37 am
by ray.wurlod
Moderator: please move to Enterprise Edition (parallel) forum

Once it's there we will provide an answer. Meanwhile do some research on the restrictions of writing to Sequential files from DataStage and how parallel jobs are executed (particularly contrasted to server jobs).

Posted: Wed Nov 24, 2010 12:45 am
by kamesh
Sorry Ray, I just moved it to Parallel forum.

Posted: Wed Nov 24, 2010 7:00 am
by chulett
No, you reposted it, I on the other hand would have moved it for you. Being a Moderator and all. However, I do have this silly habit of sleeping for a couple of hours at night. :wink: