DB2 Transaction Logs filled by before sql

Developer9 · Post by **Developer9** » Wed Oct 15, 2014 8:24 am

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?

chulett · Post by **chulett** » Wed Oct 15, 2014 9:19 am

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

Developer9 · Post by **Developer9** » Wed Oct 15, 2014 9:21 am

I am deleting records based on a where clause

chulett · Post by **chulett** » Wed Oct 15, 2014 9:28 am

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?