Hello,
I am working in datastage 7.5.1A and we have jobs that use a view to lookup into a Preload table and also looks at the actual table that we are going to be loading every week. We are using it like a hash because it has been quicker. The problem we are coming across is that every time we try to do a lookup and update with the preload table we get a deadlock error. We are basically doing a look up and then updating or inserting depending upon the data within the lookup. I think its deadlocking because the data is not committing quick enough to be seen by the view. Is there anyway we can tweek this to make it work more efficiently. Thanks
I am working in datastage 7.5.1A and we have jobs that use a view to lookup into a Preload table and also looks at the actual table that we are going to be loading every week. We are using it like a hash because it has been quicker. The problem we are coming across is that every time we try to do a lookup and update with the preload table we get a deadlock error. We are basically doing a look up and then updating or inserting depending upon the data within the lookup. I think its deadlocking because the data is not committing quick enough to be seen by the view. Is there anyway we can tweek this to make it work more efficiently. Thanks