DSXchange

Hi Guru's

I am using a DB2 connector stage which has a before sql to delete data, as the array size option in this stage cannot be used for before sql , transaction logs are getting filled up, Is there any other way i can do this delete by committing after every few thousand records?

Only if you write some SQL PL and call it Before SQL. You're not deleting all records, are you?

I am deleting records based on a where clause

OK, then you will definitely need something 'procedural' if you think intermittent commits are the answer. Have you talked to your DBA about possibly increasing the log sizes?