All,

my multithreaded C-Application crashes when it executes two SQLs at the same time. I use the C-API from IBM (ODBC-compatible) to execute my SQL queries.

When two threads are executing a SQL-Statement at the same time (i. e. "SET CURRENT SQLID = xxx"), my appl crashes and gives me the message

CEE0814S INSUFFICIENT STORAGE WAS AVAILABLE TO EXTEND THE STACK.

Per default a thread gets 131072 (128 K) Bytes stack space and I've enlarged it to 1048576 Bytes (1 MB) but nothing changed.

I'm using so called "NULL Connects" and my DSNAOINI contains:

[COMMON]
MVSDEFAULTSSID=DB2E
MULTICONTEXT=1
CONNECTTYPE=1
THREADSAFE=1
TRACEFILENAME=DD:DSNAOTRC
MAXCONN=0
[DB2E]
MVSATTACHTYPE=CAF
PLANNAME=MYPLAN


The ODBC Environment Handle get allocated in the main-thread and the connections, connection Handles and statement handles get allocatd within the threads...


Any idea?!?!?!?!?

Thank you,
Michael

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Reply via email to