DSXchange

Hi

I read from a Seq file and do a lookup to database to get the nextval from the DB2 sequencer using DB2UDB/Enterprise Stage and write the output to a Dataset. I have a constant value on both sides of the join to join. EE stage returns the same number for all the records as a nextval. I have tried changing the Partitioning to different types but getting the same result.

This works with normal DB2API stage but it takes quite a while when the volume is high like in millions. What am I doing wrong ? I was not sure if the EE stage will make a differnece in performance but still want to try and understand it....

Job Design is:
Appreciate your time...

Thanks

Fixed your job design for you - you need to use code tags not quote tags to preserve whitespace.

Thanks Craig...I will remember that...Any Idea on the actual Issue ?

If I did I would have posted it. Maybe later when I have some spare time to ponder it...