Database Sequencer and DB2EE Stage

kaps · Post by **kaps** » Thu Mar 24, 2011 3:07 pm

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:

Code: Select all

	    DB2_EE_stage 
		        | 
		        |
		        |
		        |
SeqFile----->Join Stage----->DataSet

Appreciate your time...

Thanks

chulett · Post by **chulett** » Thu Mar 24, 2011 3:28 pm

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

kaps · Post by **kaps** » Thu Mar 24, 2011 3:51 pm

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

chulett · Post by **chulett** » Thu Mar 24, 2011 4:56 pm

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