Results 1 to 3 of 3

Thread: Help !!!!

  1. #1
    Join Date
    Aug 2004
    Posts
    11

    Unanswered: Help !!!!

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by actions123
    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?
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Aug 2004
    Posts
    11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •