Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: -911 on open cursor statement

    Will a program retrun a -911 return code on an open cursor statement?
    Thanks for any resopnses

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Thann
    Will a program retrun a -911 return code on an open cursor statement?
    Sometimes.

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    SQLCODE -911 indicates a timeout or deadlock.
    A materialised cursor reads all matching rows at OPEN time, so indeed in that case the presence of a lock may indeed cause a timeout.
    Unless something else is going on, it should be sufficient to retry to open the cursor in such cases.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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