By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Session tables problem when used from multiple threads

P: n/a
HI All,
I have a problem with calling stored procedure in
multithreaded environment.
This procedure utilizes session table to collect data and
cursor to return it back to java application . When 10 threads are
trying to use the same stored procedure, once one of the thread
finishes up and returns connection back to the pool I'm getting
exception from all other 9 stored procedures :

com.ibm.db2.jdbc.app.DB2DBException: SC_PE00003 in QTEMP type *FILE
not found.

SC_PE00003 is my temporary table within the stored procedure.
I've even tried to establish new connection from each thread thinking
that session table will be unique within the
connection, but looks like they are still sharing temporary table
probably because my application runs as a batch job.
I'm stuck. I can't figure out what to do ?. How I can make these
session tables be unique within the stored procedure, or if it's
impossible at least within the connection.

Thanks,
Roman
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.