1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2009, week 3 2 225 17_DB2 V8, Z/OS 10.116_Proctor, William25_William.Proctor@TGSLC.ORG31_Mon, 14 Sep 2009 19:01:51 -0500577_us-ascii Hello, Thanks for all input in advance. We have a new online application that is going into production this weekend that uses global temporary tables to create result sets that are then passed back to the GUI and then dropped. They are being created in the 32k tablespace in the temp database even though it is a small table. When doing stress testing on it after reaching 70 threads we are starting to get delays due to locking on the temp tablespace after getting to around 130 consecutive users everything starts timing out and response time dies. It is doing [...] 228 432 21_Re: DB2 V8, Z/OS 10.112_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 15 Sep 2009 07:47:24 +0300712_utf-8 Hi,

Add more 32kb tablespaces in the temp DB and spread them over the DASD farm.

Isaac Yassin

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Proctor, William Sent: Tuesday, September 15, 2009 3:02 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 V8, Z/OS 10.1

Hello,

Thanks for all input in advance. We have a new online application that is going into production this weekend that uses global temporary tables to create result sets that are then passed back to the GUI and then dropped. They are being created in the 32k tablespace in the temp database even though it [...] 661 315 22_Re: OSC and LOB spaces11_Roy Boxwell16_R.Boxwell@SEG.DE31_Tue, 15 Sep 2009 11:08:13 +0200497_UTF-8 you're right of course...The LOBTS1 is populated with BINDs and the LOBTS2 is populated with the DSC , never ending, extract. I have completely dropped all OSC installations and now all is well (apart from we have no OSC but then again..that is not soooo bad!!)

Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-StraÃŸe 5 40470 DÃ¼sseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...] 977 62 22_Re: OSC and LOB spaces10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 15 Sep 2009 12:37:13 +0200317_US-ASCII Hi

I did some snall tests with OSC and GUI was nice but I've found the behind there's some garbage and I've found it a heavy tool (in test), so we decided to clear all stuff and to use mainframe tools or Visual explain. I didn't remember it well, but OSC didn't need LOB TS to work......or not ? [...] 1040 33 49_How do you turn off html formatting in the email?12_George White25_george_white@VANGUARD.COM31_Tue, 15 Sep 2009 11:22:41 +0000567_utf-8 In my digest for DB2-L, most of the text looks like this:

Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable