Job Does not Load...Hangs up

cosec · Post by **cosec** » Thu Jul 19, 2007 8:14 pm

I do a look up on the target database before loading the data.

I tried it with six records and my job worked....then when i tried it with 1500 records the job just froze.....and now i cant access the target table either...how do i correct it.....

the lookup is done on a DB2 stage and the target is also the same DB2 stage...

Should I separate this in to two jobs ? That is to load the contents to a has file in one job...and then use that hash file as a lookup in the second job ???

Will this fix ?? Pls advice

chulett · Post by **chulett** » Thu Jul 19, 2007 9:48 pm

You should preload and use a hashed file for the lookup - that's what they are there for, after all. Or solve your self-locking problem by setting your Transaction Size to 1.