I don't have any solution for your problem but have you looked at native SQL Stored Procedures ? They run in DBM1 rather than another address space using TCB/SRBs from client address spaces. They don't have to make cross memory calls for SQL execution. Native procedures invoked via DDF are zIIP eligible. Unless you have a lot of Java SPs already coded, I'd suggest that you take a look at this option. HTH Mohammad
On Tue, 18 Aug 2009 06:21:57 -0500, Betsy Jeffery <[email protected]> wrote: >We're in the process of setting up Java Stored Procedures address spaces >(DSNxWLMx) for DB2 9.1 and I cannot get the settings for the Java Heap sized >to allow more than 2 tcbs to run concurrenty (NUMTCB setting in DB2/WLM) >due to exhausting memory. I've tried: increasing the LE HEAP settings, >increasing the region in address space created for the stored procedure, >setting -Xms and -Xmx (but I didn't figure out how to do that one). Does >anyone have any suggestions/solutions to getting the settings right for DB2 >Java stored procedures? >Thanks, >Betsy Jeffery > ---------------------------------------------------------------------- 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
