Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / September 2007

Tip: Looking for answers? Try searching our database.

SQL0906N while opening cursor

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
db2dude - 24 Sep 2007 23:33 GMT
I am having an issue where I get an SQL0906N while I try to open a
cursor. The error says that the function is disabled due to a prior
error however I am not able to determine what that means.

The cursor does an insert into a table and the 'sql' itself is valid
otherwise the procedure would have errored at the "prepare" part.

Whats more confusing is that this procedure runs just fine on our TESt
environment and only starts misbehaving on the QA.

Any insights on what this could be? Are there any parameters or
registry variables which might be causing this kind of issue ?

The env is DB2 V9.1 FP2 on AIX 5.3 64Bit.
db2dude - 25 Sep 2007 19:06 GMT
> I am having an issue where I get an SQL0906N while I try to open a
> cursor. The error says that the function is disabled due to a prior
[quoted text clipped - 10 lines]
>
> The env is DB2 V9.1 FP2 on AIX 5.3 64Bit.

Turns out the problem was due to DB2_SETUID_COMM_BUFFER registry
variable being set. The resolution was to compile the procedure with
BLOCKING ALL (other option was to unset the registry variable or
increase the aslheap/rqrioblk which we did not try).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.