1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2007, week 5
2 157 51_Re: FW: [BULK] Re: [DB2-L] Visual Explain Matchcols12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 29 Sep 2007 14:53:59 -0700549_iso-8859-1 There's a button on VE that says ENABLE VE. Have you done this? It sets up all the required VE tables for the Authid signed in on.<br><br>Myron --- "Nichols, Suzanne" <Suzanne_Nichols@KYFBINS.COM> wrote:<br><br>> Listers, > > With the feedback I got from the list, I understand were I should be > getting the detail I need. I have discovered that with my version of > Visual Explain, when I > click on index or table objects on the I get information but when I > click IXSCAN, FETCH or NLJOIN, I do not get data. We downloaded the > [...]
160 31 50_Re: Stored Procedure - max data that can be passed12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 29 Sep 2007 14:57:14 -0700668_iso-8859-1 Depends upon the version of DB2. V7 is 32k less some overhead. V8 is about 2meg less some overhead. I'm not sure for V9 but suspect it's at least this size. --- "Smith, Allan" <Allan_Smith@KYFBINS.COM> wrote:<br><br>> Does anyone know what will be the maximum data that can be passed to a > stored procedure? > > Thanks > > --------------------------------------------------------------------------------- > Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home > page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select > "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. > The IDUG [...]
192 25 51_Re: FW: [BULK] Re: [DB2-L] Visual Explain Matchcols15_Patrick Bossman18_bossman@US.IBM.COM31_Sat, 29 Sep 2007 23:56:32 -0400350_ISO-8859-1 Hello, It sounds like you're connecting Visual Explain to a DB2 for z/OS V7. The detailed costing information is only available when you connect to DB2 for z/OS V8 (as early as CM). If the necessary explain tables are not built - VE should trigger them to get built when an explain is done - but only if connected to DB2 for z/OS V8. [...]
218 42 50_Re: Stored Procedure - max data that can be passed11_Mike Kalena16_mkalena@BEAR.COM31_Sun, 30 Sep 2007 12:23:15 -0400359_windows-1252 On Thu, 27 Sep 2007 09:21:49 -0400, Smith, Allan <Allan_Smith@KYFBINS.COM> wrote:<br><br>>Does anyone know what will be the maximum data that can be passed to a >stored procedure? > >Thanks ><br><br>Each parm can be any data type, including CLOB, BLOB. We have several SPs that pass in LOBs and our largest number or parms for an SP is 249. [...]
261 22 50_Re: Stored Procedure - max data that can be passed14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Sun, 30 Sep 2007 20:13:14 +0000587_iso-8859-1 > We have several SPs that pass in LOBs and our largest number or parms for an SP is 249. At the other end of the spectrum: we have a SP returning an XML file as a single VARCHAR(32000) argument. But the procedure can be called iteratively; the client just "glues together" all received fragments. -- Peter Vanroose ABIS Training & Consulting __________________________________________________________ Går det långsamt? Skaffa dig en snabbare bredbandsuppkoppling. Sök och jämför hos Yahoo! Shopping. http://shopping.yahoo.se/c-100015813-bredband.html?partnerId=96914325 [...]
284 56 50_Re: Stored Procedure - max data that can be passed12_Myron Miller22_myronwmiller@YAHOO.COM31_Sun, 30 Sep 2007 16:00:31 -0700316_iso-8859-1 I know for a fact in early in V7 that if the total length of the parms exceeded 32k, the procedure will fail with an error. I wrote tested this extensively as we have a number of app's that pass CLOBs of VARCHAR( 32000) as a max.<br><br>Myron<br><br><br><br>--- Mike Kalena <mkalena@BEAR.COM> wrote: [...]