Hi All,
I am facing the escalating locks problem in db2 when i was running my batch processing application. I've had increase my locklist up to 20MB. Besides, I also commit the batch processing records by record basis. And sure that all the resultset are closed properly for every selection. But the problem still happen frequently in db2. I really have no idea how to solve the problem. Hope you all can give some valuable advices.
Thank you
regards
YHL