Guys,

I am running a stored procedure with a cursor and it does an update.It takes about 15-25 minutes to update 40,000.That is way too long can someone point me in a direction of where to look to make it run faster.I had set my isolation level to CS using the "DB2_SQLROUTINE_PREPOPTS=ISOLATION CS". I am not doing anything fancy just select and update(not using the cursor).Any help will be appreciated.

Thanks

Why not an updateable cursor?

I cant to updateable cursor because i am joing two tables in my select.When i use the declare/open/fetch. It was not releasing locks at commit point.Thanks petruk