type 2 implementaion in update problem

[ravi_tubati]

hi folks,

while running the job type 2 implemetaion insert or update ca,t be done. Always job running mode. it will not whether successes or failure . Any one help me on this is really appricaiable

Thanks,
Ravi

[ArndW]

Ravi,

you will need to explain a bit more about what your problem really is in order for anyone to be able to help you. I assume by "type 2" you mean you are doing a slowly changing dimension in your job. What database? What part of the job is hanging? Is it on the first row?

[chulett]

And you are correct that you can't use the 'Insert or update' action. You need to separate the two actions into different links as you'll need to insert all rows and possibly update old ones.

[ravi_tubati]

my databse db2 .In datastage iam trying to type2 which existing record then update ,new record will be insert when i am trying to start this operation my job hangup it can,t be perform successes or failure .
Can any one help me

[ray.wurlod]

Have your DB2 DBA show you that you are introducing self-locking processes. Then design your job in a way that this does not occur. Take note of the advice given by Arnd and Craig.