1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2008, week 5
2 54 25_Re: About Lock Escalation13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 28 Apr 2008 20:31:52 -0500552_ISO-8859-1 So... does anyone know what they are saving all that "above the bar" memory for?<br><br>Willie<br><br>Ted MacNEIL wrote: >> You could be surprised about how many sysprogs consider memory as it was in XA, if not before. >> And this for all products like DB2, DFSORT, CICS......... >> You can say 'above bar' a zillion of times but.... >> > > > I have also seen this 'attitude' on the IBM-Main list. > They want to restrict access to memory above the bar, and 'resent' the fact that DB2 V8: > 1. Ignores the restrictions. > 2. Is desgned [...]
57 102 54_[any] Standard Unit of work for capacity / performance14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Tue, 29 Apr 2008 03:48:56 +0000402_utf-8 Willie, The issue is not saving all that "above the bar" memory for ...<br><br>It is rather a classic view of capacity and performance management.<br><br>SLA's are established by 'user' input for response and thruput requirements. The tech folks then contribute the other parts of the matrix ... cost and unit of work specifications. There may be some negotiation, but not so much any more. [...]
160 64 12_Re: net.data40_=?UTF-8?B?w4RybGVicmFuZHQgTWljaGFlbA==?=28_Michael.Arlebrandt@VOLVO.COM31_Tue, 29 Apr 2008 06:51:16 +0200392_UTF-8 Hi Maxine,<br><br>We are also running Net.Data and plans to go to DB2 v9 within the next couple of month. The answer I got from IBM is that Net.Data will still be supported as long as DB2 v8 is supported. So probably until 2010-2011 something<br><br>Of course as soon as I have v9 installed in our test environment I will test our Net.Data macros and see if they still works fine. [...]
225 160 51_Re: rfc: feature request: page segmentation control26_Sorensen Henrik (KSFI 442)33_henrik.sorensen@CREDIT-SUISSE.COM31_Tue, 29 Apr 2008 07:54:25 +0200660_US-ASCII Interesting idea with THREAD CLUSTER. Would mind to expand on what you have in mind ?<br><br>thanks Henrik<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Avram Friedman Sent: Monday, April 28, 2008 4:43 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] rfc: feature request: page segmentation control<br><br>1) I am not sure Row Level Locking will help when two almost concurrent units of work try to insert into the same page. The problem is every page data page contains header information like the location of the next chunk of free space. Sort of strikes me that the [...]
386 28 28_DB2 replication requirements13_Laila hosaini19_lshosaini@YAHOO.COM31_Mon, 28 Apr 2008 23:55:44 -0700309_us-ascii Hi dear listers.... I 'm trying to activate Replication between 2 DB2's,which one is DB2 V9 on Z/OS, another one is a DB2 V7 on OS/390 V2.10 . is this true? "On Software requirements we need a (PTF(UQ86842))". WITHOUT THIS ptf WHAT WOULD BE HAPPENED? please guide me... Thanks in advance. L.S.H [...]
415 234 25_Re: About Lock Escalation0_28_Massimo.Scarpa@PHOENIXSPA.IT31_Tue, 29 Apr 2008 09:02:02 +0200449_US-ASCII It seems to me to hear someone I know very well. So there are x Gb offline of central storage, so we are next to change a machine without using that memory bought for.....nothing ?. 'You never know' is the answer'. Nice planning of expensive resource.<br><br>So SORT is constrained, DB2 is constarined in small BPs. WLM reaches PI of 4. But everything work well as it's not paging. Memory doesn't blossom overnight, molds during days. [...]
650 88 33_Re: A Question for the List Admin11_Mike Turner29_michael_turner@COMPUSERVE.COM31_Tue, 29 Apr 2008 09:49:48 +0100391_utf-8 I don't think the Conceal option is relevant. My email does not have Conceal selected, but if I reply to one of my posts in Outlook it correctly sets DB2-L@www.idugdb2-l.org as the return address. For some posters (Joel is one - sorry Joel, no slur intended!), if I reply to one of their posts then Outlook sets their personal email as the return address thus bypassing the list. [...]
739 107 12_Re: net.data0_23_j.p.slot@RN.RABOBANK.NL31_Tue, 29 Apr 2008 12:28:09 +0200502_iso-8859-1 Hello Michael,<br><br>I am also looking forward to the results of your tests. We have not implemented v9 as we first want to get rid of our net.data programs.<br><br>Regards,<br><br>Jaap Slot IT Architect Rabobank Nederland Utrecht, The Netherlands<br><br><br><br>-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Ärlebrandt Michael Verzonden: dinsdag 29 april 2008 6:51 Aan: DB2-L@www.idugdb2-l.org Onderwerp: Re: [DB2-L] net.data [...]
847 17 11_Just a Test28_=?utf-8?B?VGVkIE1hY05FSUw=?=18_eamacneil@YAHOO.CA31_Tue, 29 Apr 2008 12:20:06 +0000721_- I'm doing this at the request of the list admin - Too busy driving to stop for gas!<br><br>_____________________________________________________________________<br><br>* IDUG 08 Dallas, TX, USA * May 18-22, 2008 * http://IDUG.ORG/lsNA * _____________________________________________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available [...]
865 66 33_Re: A Question for the List Admin20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM31_Tue, 29 Apr 2008 15:34:42 +0300694_iso-8859-9 Hi,<br><br>Listserv setup is "Reply-To: DB2 Database Discussion list at IDUG <DB2-L@www.idugdb2-l.org>"<br><br>But you email header contains. "Reply-To: eamacneil@yahoo.ca"<br><br>I think it's specific to your client settings.<br><br>Regards, Cuneyt, IDUG Volunteer.<br><br><br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On > Behalf Of Ted MacNEIL > Sent: Monday, April 28, 2008 11:23 PM > To: DB2-L@www.idugdb2-l.org > Subject: [DB2-L] A Question for the List Admin > > > When I send an e-mail to IBM-Main, MXG-L, CICS-L, or RACF-L, the > replyto is the list in question. > When I send an e-mail to DB2-L, the replyto is [...]
932 197 33_Re: A Question for the List Admin0_21_mlabby@AESSUCCESS.ORG31_Tue, 29 Apr 2008 08:59:18 -0400
1130 75 32_Re: DB2 replication requirements14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Tue, 29 Apr 2008 13:19:43 +0000326_utf-8 PQ86842 seems to be related to performance and char translation for lobs. It adds some SYSIBM.SYSDUMMY* tables as well as code changes.<br><br>More important DB2 V7 is very close to end of support. OS/390 2.10 is very old. UQ86842 is from 2004 so may not be migratable to V8 (with fallback support) at your levels. [...]
1206 101 21_Log analyzer question17_McCormack, Mark A27_mamccormack@STATESTREET.COM31_Tue, 29 Apr 2008 09:40:41 -0400410_us-ascii Ivan,<br><br>We regularly capture on summary and general reports log information on sysibm tables in DSNDB06. I can find no evidence that we have captured any information on sysibm tables in DSNDB01. For example, CREATE TABLE would update sysibm tables in DSNDB06.SYSDBASE and in DSNDB01.DBD01. We seem to capture only the DSNDB06 stuff. So maybe the IBM log analysis tool does some but not all. [...]
1308 46 19_[AD]z/OS OSC TABLES9_Eric West25_ewest@HLSTECHNOLOGIES.COM31_Tue, 29 Apr 2008 14:00:04 +0000
1355 37 16_test of reply to0_21_mlabby@AESSUCCESS.ORG31_Tue, 29 Apr 2008 10:07:14 -0400
1393 152 33_Re: A Question for the List Admin28_=?utf-8?B?VGVkIE1hY05FSUw=?=18_eamacneil@YAHOO.CA31_Tue, 29 Apr 2008 14:08:10 +0000418_Windows-1252 I already did the test, and it worked. Now I have to check out my BlackBerry settings. I changed id's so that this wouldn't happen, but it appears that RIM is helping me, again!<br><br>- Too busy driving to stop for gas!<br><br>-----Original Message----- From: mlabby@AESSUCCESS.ORG<br><br>Date: Tue, 29 Apr 2008 08:59:18 To:DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] A Question for the List Admin [...]
1546 121 21_About Lock Escalation17_McCormack, Mark A27_mamccormack@STATESTREET.COM31_Tue, 29 Apr 2008 10:42:26 -0400422_us-ascii So, Ed, back to your original question ...<br><br>We are using NUMLKTS = 25000 NUMLKUS = 50000<br><br>We have an automation routine in place which generates an email whenever an escalation occurs. We at least know when and where it occurs, and we can request changes to eliminate it. Lock escalation does not happen often in this shop. In addition we have a few processes which LOCK TABLE IN EXCLUSIVE MODE. [...]
1668 51 25_Re: Log analyzer question14_Wayne Driscoll22_wdriscoll8@COMCAST.NET31_Tue, 29 Apr 2008 10:10:54 -0500332_iso-8859-1 The log only contains updates to tables that are updated via SQL (or SQL-Like, in the case of DSNDB06). DSNDB01 is not a DB2 formatted database (DSNDB06 is only sort-of). Because of this, DSNDB01 changes are not logged. The logging of DSNDB06 cannot be used to create INSERT and/or UPDATE statements to the catalog. [...]
1720 36 36_Locking when extending a DB2 dataset15_Steve Schuering31_steven.schuering@EXELONCORP.COM31_Tue, 29 Apr 2008 15:17:48 +0000674_utf-8 Recently we had this problem in one of our development environments.<br><br>03.20.28 STC15308 DSNP007I -DB2C DSNPXTN0 - EXTEND FAILED FOR 984 984 DB2C.DSNDBD.CIMSPFX1.C02T01XA.I0001.A001. 984 RC=00C90096 984 CONNECTION-ID=DB2CALL, CORRELATION- ID=CS17ARF1, 984 LUW-ID=*<br><br>********************* Text Below Copyright (c) 2008, IBM ******************* 00C90096 Explanation: The page, row or LOB lock on the page or subpage identified by NAME in message DSNT500I or DSNT501I caused the total number of page, row or LOB locks concurrently held to reach the installation maximum number of page, row or LOB locks (NUMLKUS) allowed for a single agent in the system. [...]
1757 228 51_Re: rfc: feature request: page segmentation control14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Tue, 29 Apr 2008 15:25:08 +0000355_utf-8 Henrik, My limitted experience with enhancements lead me to think one has to be careful about the line between idea and method. Any vendor has a self interest in maintaining there ownership of there products. They do not want to be put in the posistion of some one comming along and saying you developed this to my specification so you owe me. [...]
1986 78 28_Converting local time to GMT0_29_rambabu.x.vanama@JPMCHASE.COM31_Tue, 29 Apr 2008 11:37:12 -0400631_US-ASCII Hello Listers, Is there any function in DB2 V8 to conert local time to GMT?<br><br>-Ram Vanama<br><br>----------------------------------------- This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. [...]
2065 111 21_Log analyzer question17_McCormack, Mark A27_mamccormack@STATESTREET.COM31_Tue, 29 Apr 2008 11:47:09 -0400541_us-ascii Wayne,<br><br>Changes to objects in DSNDB01 must be logged. Otherwise, it would not be possible to run the RECOVER TABLESPACE utility on anything in DSNDB01. The log record format may be different from those for changes to garden-variety objects. I wouldn't be surprised since (as you point out) the catalog and directory are 'different'. My experience with the IBM Log Analysis tool indicates that it can do some things with log records on the catalog but not with those on the directory. That was what Ivan was asking about. [...]
2177 46 25_Re: Log analyzer question16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 29 Apr 2008 11:47:19 -0400447_us-ascii Using CA Log Analyzer you can generate a report illustrating which directory "tables" were updated, but like Wayne mentioned - it isn't SQL statements - only a report detailing which DB01 objects were touched and the number of updates, deletes, inserts.<br><br>Steen Rasmussen CA Principal Technical Specialist DB2 tools IBM Certified Database Associate - DB2 9 Fundamentals IBM Certified Database Administrator - DB2 9 DBA for z/OS [...]
2224 27 32_Re: Converting local time to GMT9_Ken Bateh22_ken.bateh@MILLIKEN.COM31_Tue, 29 Apr 2008 17:04:03 +0000307_utf-8 DB2 can accept a time in any format as input. DB2 interprets the input time based on the punctuation and then provides time output in the format you specify for this parameter. If you use LOCAL, you must provide a time exit routine to perform time formatting.<br><br>Installation Panel = DSNTIP4 [...]
2252 231 32_Re: Converting local time to GMT14_Arnold, Mark S20_Mark.Arnold@BNSF.COM31_Tue, 29 Apr 2008 12:18:15 -0500741_us-ascii From the developerworks article "DB2 Basics: Fun with Dates and Times" (http://www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211y ip3.html <http://www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211y ip3.html> )<br><br>To get the current time or current timestamp adjusted to GMT/CUT, subtract the current timezone register from the current time or timestamp:<br><br><br><br>current time - current timezone current timestamp - current timezone<br><br><br><br><br><br>_____<br><br>From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of rambabu.x.vanama@JPMCHASE.COM Sent: Tuesday, April 29, 2008 10:37 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Converting local time to GMT [...]
2484 270 32_Re: Converting local time to GMT13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 29 Apr 2008 13:32:27 -0400325_us-ascii Hi Ram,<br><br>You can use special registers to do that Assuming your parmlib values are set, you should be able add special register CURRENT TIMEZONE to the value. For example, if you have current timestamp as local time (I believe that's controlled by parmlib value whether it is GMT or local), you can issue [...]
2755 513 33_Re: A Question for the List Admin35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 29 Apr 2008 14:19:55 -0400496_iso-8859-1 testing reply...<br><br>Joel<br><br>Joel Goldstein Responsive Systems Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts Group Buffer Pool performance too! www.responsivesystems.com tel. (732) 972-1261 fax.(732) 972-9416 ----- Original Message ----- From: mlabby@AESSUCCESS.ORG Newsgroups: bit.listserv.db2-l To: DB2-L@www.idugdb2-l.org Sent: Tuesday, April 29, 2008 8:59 AM Subject: Re: [DB2-L] A Question for the List Admin [...]
3269 181 32_Re: Converting local time to GMT13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 29 Apr 2008 14:29:20 -0400515_us-ascii Whooops. As Mark points out,<br><br>you subtract the current timezone from current timestamp, NOT add it.<br><br>Sorry, It'll never happen again.<br><br>Dave<br><br><br><br><br><br>The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...]
3451 166 32_Re: Converting local time to GMT0_19_askwe@OPTONLINE.NET31_Tue, 29 Apr 2008 19:49:39 +0000713_us-ascii Ram,<br><br>It should be: SELECT TIME (CURRENT TIMESTAMP - CURRENT TIMEZONE)<br><br>Regards, Agus Kwee Themis Training http://www.themisinc.com<br><br><br><br>----- Original Message ----- From: rambabu.x.vanama@JPMCHASE.COM Date: Tuesday, April 29, 2008 3:15 pm Subject: [DB2-L] Converting local time to GMT To: DB2-L@www.idugdb2-l.org<br><br>> Hello Listers, > Is there any function in DB2 V8 to conert local time to GMT? > > -Ram Vanama > > ----------------------------------------- > This communication is for informational purposes only. It is not > intended as an offer or solicitation for the purchase or sale of > any financial instrument or as an official confirmation of any > transaction. [...]
3618 324 32_Re: Converting local time to GMT0_29_rambabu.x.vanama@JPMCHASE.COM31_Tue, 29 Apr 2008 17:22:25 -0400770_US-ASCII Thank you much. This is what I wanted to know.<br><br>-Ram<br><br><br><br><br><br><br><br>"Seibert, Dave" <Dave.Seibert@COMPUWARE.COM> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 04/29/2008 01:32 PM Please respond to DB2 Database Discussion list at IDUG <DB2-L@www.idugdb2-l.org><br><br><br><br>To DB2-L@www.idugdb2-l.org cc<br><br>Subject Re: [DB2-L] Converting local time to GMT<br><br><br><br><br><br><br><br><br><br><br><br>Hi Ram,<br><br>You can use special registers to do that Assuming your parmlib values are set, you should be able add special register CURRENT TIMEZONE to the value. For example, if you have current timestamp as local time (I believe that's controlled by parmlib value whether it is GMT or local), you can issue [...]
3943 34 12_Re: net.data12_Susan Gudell28_susan.gudell@CPA.STATE.TX.US31_Wed, 30 Apr 2008 02:07:27 +0000539_utf-8 We also have net.data macros running in our shop and are just beginning the process of upgrading to DB2 9. We asked IBM the same question several months ago since it was not clear to us if the macros would work or not and, based on their reply, our net.data applications are being rewritten, as we are not counting on them working (even though they still might -- just can't count on it since IBM did not test). Here is the answer we received: " -5799WZY00 - 07/09/18-13:31- Action taken: reviewed customer question and checked [...]
3978 59 36_Stored Procedure and Network Traffic0_18_renusharma@AOL.COM31_Tue, 29 Apr 2008 22:10:20 -0400490_us-ascii <br><br>Hello List<br><br>I want some help for deciding Stored procedure over simple SQL. I have a cognos?applications ?which gets 3 million rows from DB2 server and builds a cube. Cognos in turn creates iqd which calls 2 views.I want to overcome the network problem because its taking 20 hrs to build the cube . I am suggesting STORED Procedure over Simple SQL .But there is lot of opposition , as people are saying its sending 3 million rows so store proc won't be helpful. [...]
4038 142 24_z/OS V9 CLONE question..0_16_R.Boxwell@SEG.DE31_Wed, 30 Apr 2008 08:09:17 +0200413_iso-8859-1 Hi all!<br><br>Perhaps I am being mighty stupid this morning but when I do an EXCHANGE command I do not see the LDS being renamed. (Personally I think this is a good thing! If DB2 has to rename VSAM datasets it will be *slow*) When I browse the VSAM datasets the I0001 still contains the "base" data and the I0002 contains the "clone" data...according to Willies blog the LDS's should be renamed. [...]
4181 229 28_Re: z/OS V9 CLONE question..14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 30 Apr 2008 08:37:40 +0100309_iso-8859-1 NO - That's not what Willie (and John) are saying<br><br>The LDSs are not renamed, the "INSTANCE" column in the catalog is changed from "1" for the base to "2" (and vice versa for the clone)<br><br>The datasets keep their names, but the "pointers" from the catalog to those datasets flip over [...]
4411 284 28_Re: z/OS V9 CLONE question..11_Mike Turner29_michael_turner@COMPUSERVE.COM31_Wed, 30 Apr 2008 09:28:14 +0100368_iso-8859-1 Hi Roy<br><br>I don't think Willie was trying to say the datasets are renamed. From a quick look at the V9 Technical Overview Redbook (SG24-7330), what I think happens on Exchange is:<br><br>1. The table names are swapped.<br><br>2. The column INSTANCE in SYSTABLESPACE is updated to show which dataset holds the base (non-clone) version of the table. [...]
4696 358 45_Antwort: Re: [DB2-L] z/OS V9 CLONE question..0_16_R.Boxwell@SEG.DE31_Wed, 30 Apr 2008 11:04:03 +0200461_iso-8859-1 Thats what I have experienced - Its just odd that the blog entry clearly states "LDS rename" weird huh?<br><br><br><br><br><br>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<br><br>Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert [...]
5055 430 45_Antwort: Re: [DB2-L] z/OS V9 CLONE question..0_16_R.Boxwell@SEG.DE31_Wed, 30 Apr 2008 13:37:10 +0200347_iso-8859-1 then what is this text saying<br><br><br><br><br><br>Flipping around instance numbers in the VSAM LDS data sets will only happen when you are messing around with clone tables.<br><br><br><br><br><br>I thought my english was pretty good! It certainly *reads* like a VSAM rename should be happening (I am glad it is not by the way!) [...]
5486 401 49_Re: Antwort: Re: [DB2-L] z/OS V9 CLONE question..16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 30 Apr 2008 08:24:28 -0400409_iso-8859-1 Another neat way to find out which INSTANCE belongs to which TABLE at any point in time is using the -DISPLAY utility. It has some new content to get used to.<br><br><br><br><br><br>NAME TYPE PART STATUS<br><br>-------- ---- ----- -----------------<br><br>IDUGUTS1 TSB1 0001 RW,COPY<br><br>IDUGUTS1 TSC2 0001 RW<br><br>IDUG1TYQ IXB1 L* RW<br><br>IDUG1TYQ IXC2 L* RW<br><br>IDUGTB1R IXB1 L* RW [...]
5888 98 28_Re: z/OS V9 CLONE question..13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 30 Apr 2008 08:09:58 -0500385_ISO-8859-1 I worded it that way to generate a discussion on this list.... NOT... (smile)...<br><br>Rename was an unfortunate choice of words. The catalog is actually changed to reflect which instance of the data is actually going to be treated as the base table. The I0001 pageset will change from being treated as the base and clone, but it will always remain the I0001 pageset. [...]
5987 92 45_Antwort: Re: [DB2-L] z/OS V9 CLONE question..0_16_R.Boxwell@SEG.DE31_Wed, 30 Apr 2008 15:18:32 +0200343_iso-8859-1 thanks! That clears up a thing or two! By the way the answers to my three questions are:-<br><br>What VSAM dataset(s) will be there? What is the value in CLONE? What is the value in INSTANCE?<br><br>The I0002 are there, the I0001 are all deleted<br><br>CLONE contains a N<br><br>INSTANCE is 2<br><br>Which is all 100% correct! [...]
6080 20 40_Re: Locking when extending a DB2 dataset12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Wed, 30 Apr 2008 14:30:49 +0000488_utf-8 Hi Steve. Do you have any diagnostics re the object for which the lock request failed? The extend failed for dataset DB2C.DSNDBD.CIMSPFX1.C02T01XA.I0001.A001 but the lock was most likely related to a DB2 internal function (catalog or directory etc).<br><br>______________________________________________________________________<br><br>* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________ [...]
6101 60 40_Re: Stored Procedure and Network Traffic12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 30 Apr 2008 13:37:56 -0700330_iso-8859-1 Are you sending a lot of result rows with very few SQL statements or a lot of SQL? If the latter, then a SP is better, if the former, then a SP will not be of much help and in fact, could actually hurt you.<br><br>Old rule of thumb: Lots of SQL statements, use SP : Lots of rows, one SQL statement use direct SQL. [...]
6162 96 40_Re: Stored Procedure and Network Traffic10_Mark Stone17_mastone@GMAIL.COM31_Wed, 30 Apr 2008 13:43:08 -0700410_ISO-8859-1 The SP would only really be helpful if it somehow reduced the network traffic by performing numerous steps in a single process on the server side.<br><br>The way you described it, you would simply be swapping a dynamic SQL with a Static SP, both returning the same result set to the Cognos process. You may be better off adding the OPTIMIZE FOR statement to your SQL to improve data buffering. [...]