Job Hangs when using hash file as a Lookup
Posted: Fri Feb 12, 2010 3:32 am
HI All
I have a job which hangs when using Hash file as a lookup.
My job design is like this
!-------------HASHFILE1
! !
! !
! !
! !
! !
DRS-----------TRANS1------------TRNAS2-----------SEQFILE
! !
! !
! !
! !
AGG------------HASHFILE2
The First HASHFILE1 is looked up with TRANS! and Second HASHFILE2 is looked up with HASHFILE2.The job is working fine as long as i dont use HASHFILE2 as lookup,there is no error message thrown ,upon running the job turns in waiting state. i.e hangs
Please advice
I have a job which hangs when using Hash file as a lookup.
My job design is like this
!-------------HASHFILE1
! !
! !
! !
! !
! !
DRS-----------TRANS1------------TRNAS2-----------SEQFILE
! !
! !
! !
! !
AGG------------HASHFILE2
The First HASHFILE1 is looked up with TRANS! and Second HASHFILE2 is looked up with HASHFILE2.The job is working fine as long as i dont use HASHFILE2 as lookup,there is no error message thrown ,upon running the job turns in waiting state. i.e hangs
Please advice