IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQLCODE -806: Bind isolation conflicts


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dirceu.alves

New User


Joined: 03 Aug 2005
Posts: 17

PostPosted: Wed Nov 12, 2008 5:12 am
Reply with quote

Hello everybody,

I got the following SQLCODE when running a program...

SQLCODE 806, Warning: BIND ISOLATION LEVEL RR CONFLICTS WITH TABLESPACE LOCKSIZE PAGE OR LOCKSIZE ROW AND LOCKMAX 0

What should I do to fix this problem?


Thanks in advance for your help on this... It's killing me...
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Nov 12, 2008 6:11 am
Reply with quote

Hello,

Quote:
What should I do to fix this problem?
Change the definition (lock specification) or discontinue using RR.

At the top of the page is a link to "IBM Manuals". Among them is "DB2 Messages & Codes". In that manual is the information about sqlcode 806.

The cause and solution are documented. If you read something that is not clear, post what you read and what is not clear. Someone will be able to clarify.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
No new posts JCL for pl1 db2 precompile, compile a... JCL & VSAM 4
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts SQLCODE=-204 SQLSTATE=42704 DB2 4
Search our Forums:

Back to Top