1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2009, week 2 2 20 18_Re: Happy Birthday11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Thu, 8 Oct 2009 00:20:12 +0000362_Windows-1252 >Unfortunately all of them. 619, 409, etc. etc. 709, 7090, cdc 6400, etc. etc. >Are all vividly remembered.

Hamilton High School -- 1971 McMaster University -- CompSci for 'gifted' math students (IE: Marks .GT. 90%).

CDC CYBER 6000 (6600?)

FORTRAN, BASIC and CDC Assembler. Learned how to read (CDC) dumps at 14 years old. [...] 23 647 18_Re: Happy Birthday13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Wed, 7 Oct 2009 19:37:15 -0500665_ISO-8859-1 We just had dust that hadn't even come together to form anything yet... all I can remember was a big bang noise.... LOL

Willie

BOND Victor A wrote: > Wow! You had rocks? We just had lava. > > ------------------------------------------------------------------------ > *From:* DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] *On > Behalf Of *Irwin, Jim > *Sent:* Wednesday, October 07, 2009 1:42 PM > *To:* DB2-L@WWW.IDUGDB2-L.ORG > *Subject:* Re: [DB2-L] Happy Birthday > > My first computer was made out of rocks and Mammoth bones. Do I win?. > > > > *From:* DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] *On > [...] 671 1267 18_Re: Happy Birthday14_Fazio, Richard21_RFAZIO@TRANSUNION.COM30_Wed, 7 Oct 2009 21:06:34 -0500497_us-ascii That big bang noise was my when my abacus crashed...I tried to divide by zero.





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Wednesday, October 07, 2009 7:37 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Happy Birthday





We just had dust that hadn't even come together to form anything yet... all I can remember was a big bang noise.... LOL [...] 1939 176 47_AW: [DB2-L] DSSIZE on a partitioned tablespace.35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE30_Thu, 8 Oct 2009 07:32:43 +0200786_iso-8859-1 Marcia,

DSSIZE determines the maximum size of each partition.

Ruediger R黡iger Kurtz Abteilung Informatik Betrieb

HUK-COBURG Bahnhofsplatz 96444 Coburg Telefon 09561 96-44147 Telefax 09561 96-44104 E-Mail Ruediger.Kurtz@HUK-COBURG.de Internet www.HUK.de ============================================================= HUK-COBURG Haftpflicht-Unterst黷zungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021 Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg Vorsitzender des Aufsichtsrats: Werner Strohmayr. Vorstand: Dr. Wolfgang Weiler (Sprecher), Wolfgang Fla遠off, Stefan Gronbach, Klaus-J黵gen Heitmann, Dr. Christian Hofer. ============================================================= [...] 2116 179 39_Re: DSSIZE on a partitioned tablespace.28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Thu, 8 Oct 2009 12:45:21 +0530427_US-ASCII Hi Marcia,

Maximum 4 Gig per partition. From the manual,



DSSIZE integerG Specifies the maximum size for each partition, or for LOB table spaces, each data set. If you specify DSSIZE, you must also specify the NUMPARTS, MAXPARTITIONS, or LOB clause. The following values are valid: 1G 1 gigabyte 2G 2 gigabytes 4G 4 gigabytes 8G 8 gigabytes 16G 16 gigabytes 32G 32 gigabytes 64G 64 gigabytes [...] 2296 34 21_Isolation level of RS25_SUBSCRIBE DB2-L Anonymous17_ravi17s@YAHOO.COM30_Thu, 8 Oct 2009 07:58:25 +0000318_utf-8 Hi Folks,

We have few tables which collect the historical data.These tables are only used for Read only puprpose and hence set as RO.

Will there be any contention in terms of locking if many Batch and online application are trying to access these tables via SELECT with Isolation level of RS. [...] 2331 30 44_Deb Van Epps/MutualOMA is out of the office.0_30_Deb.Van.Epps@MUTUALOFOMAHA.COM30_Thu, 8 Oct 2009 05:00:31 -0500656_us-ascii I will be out of the office starting 10/07/2009 and will not return until 10/12/2009.





If you need immediate assistance please contact my manager Kevin Stettler x3185.



This e-mail and any files transmitted with it are confidential and are solely for the use of the addressee. It may contain material that is legally privileged, proprietary or subject to copyright belonging to Mutual of Omaha Insurance Company and its affiliates, and it may be subject to protection under federal or state law. If you are not the intended recipient, you are notified that any use of this material is strictly prohibited. [...] 2362 80 25_Re: Isolation level of RS10_Dave Nance16_dav1mo@YAHOO.COM30_Thu, 8 Oct 2009 03:13:53 -0700626_iso-8859-1 If they are started in RO then why the need for the restrictive locking? If the data is not going to change then you may as well use with UR to minimize your locking. David Nance ________________________________ From: SUBSCRIBE DB2-L Anonymous To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thu, October 8, 2009 3:58:25 AM Subject: [DB2-L] Isolation level of RS Hi Folks, We have few tables which collect the historical data.These tables are only used for Read only puprpose and hence set as RO. Will there be any contention in terms of locking if many Batch and online application are trying to access [...] 2443 214 18_Re: Happy Birthday20_Bruzdzinski, Michael27_Michael.Bruzdzinski@SSA.GOV30_Thu, 8 Oct 2009 07:02:57 -0400540_us-ascii LOL

I worked at a site that had the RCA SPECTRA, a CDC-3500 and a Burroughs B-6700 (love CANDE and WFL) . We then went to the SPERRY-UNIVAC 1100 series (later SPERRY and finally UNISYS after the merger with Burroughs)



Michael Bruzdzinski Social Security Administration DCS/OESAE/DDBS/DBSB 410-966-7185 (voice) 443-379-2282 (Blackberry)

The maxim is "qui tacet consentire." The maxim of the law is "Silence gives consent." - the character of Sir Thomas More in A Man for All Seasons by Robert Bolt [...] 2658 243 39_Re: DSSIZE on a partitioned tablespace.15_Smartcurl Zhang19_smartcurl@GMAIL.COM30_Thu, 8 Oct 2009 19:51:11 +0800418_ISO-8859-1 Hi all, I got a segmet tablespace reached it's limit,64G.DB2 automatically seperated this tablespace to 32 VSAM datasets,each one 2G. I'd like use this tablespace to continue hold more records, what should i do if don't want seperate into partition?

thanks.



Smartcurl zhang



On Thu, Oct 8, 2009 at 3:15 PM, Balachandran Chandrasekaran1 < balaccha@in.ibm.com> wrote: [...] 2902 59 13_Shuffle Join?9_Ray Houle32_raynald.houle@SCD.DESJARDINS.COM30_Thu, 8 Oct 2009 13:15:16 +0000431_utf-8 For data masking purposes, I am seeking to "join" two tables (probably with a different number of rows in each) using a random join predicate.

I was thinking of exploiting the following form of SQL:

select cola, colb, colc, cold from (select cola, colb, as randid from x) as tab1 inner join (select colc, cold, as randid from y) as tab2 on tab1.randid = tab2.randid [...] 2962 363 28_Re: Space Estimation in z/OS7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Thu, 8 Oct 2009 09:35:26 -0400536_ISO-8859-1 Thanks Carol, that gives me an idea as in what I should look out for.

Another question, about VSAM Extents.

z/OS 1.4 DB2 V7

I understand that maximum possible extents here is 255 (hope I remember correctly). But, again, is there any threshold you adhere to? We here, have a threshold of say 70 extents - which is a little over a quarter. Question here is 'how much is a RED flag?' In other words, when can I expect seeing out-of-extents error? Is that practically after reaching 255 or any earlier? [...] 3326 390 47_AW: [DB2-L] DSSIZE on a partitioned tablespace.35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Thu, 8 Oct 2009 15:36:09 +0200405_iso-8859-1 Hi

DSSIZE is only allowed for partitioned tablespaces, so 64 GB is the max for segmented tablespaces. To get more rows into it, you can check your FREEPAGE/PCTFREE-values or check if the tablespace is compressed (not only COMPRESS YES, but rows must be compressed indeed).

What is the reason to not to go for partitioned tablespace? Because you have to drop and recreate it? [...] 3717 338 39_Re: DSSIZE on a partitioned tablespace.28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Thu, 8 Oct 2009 19:27:14 +0530401_US-ASCII I am afraid you may have to convert this into partitioned. Depending upon your availability needs, you could try altering the FREEPAGE, PCTFREE and do a REORG. It is risky as well. Sometimes even specifying small % for these parameters would make your tablespace actually grow after the reorg if the free spaces and pages were utilized by inserts/updates before (It has happened to me). [...] 4056 331 28_Re: Space Estimation in z/OS28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Thu, 8 Oct 2009 19:31:37 +0530276_US-ASCII z/OS 1.4 DB2 V7

:-) Good to see the same environment, I am fighting with. We are also finding it hard to get DASD volumes and very recently, we had a project to stop using the TAPES where ever possible. And, our weekly backup of DB2 is just single copy ! [...] 4388 741 39_Re: DSSIZE on a partitioned tablespace.13_Bright, Randy20_Randy_Bright@BMC.COM30_Thu, 8 Oct 2009 08:11:30 -0600503_us-ascii All the other suggestions of reducing PTCFREE and FREEPAGE or compression are good but only a temporary solution if you expect continued growth. Partitioning is the only long-term answer. If you don't have an index appropriate for traditional partitioning and you are on DB2 V9, Partitioned by Growth was developed for just this type of tablespace. You might want to look into that. As with any different structure there are pros and cons with converting, but PBG may be your best option. [...] 5130 195 28_Re: Space Estimation in z/OS9_Mike Bell21_mbell11a1@VERIZON.NET30_Thu, 8 Oct 2009 09:18:38 -0500344_US-ASCII The limits are 1. extents on a single volume - 123 2. total extents across multiple volumes 255

At some version of z/os, if a new extent is allocated at the end of the previous extent, z/os will consolidate them into a single extent. I don't remember the version that started this sorry. It is called extent consolidation. [...] 5326 42 19_Local Latch Suspend10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Thu, 8 Oct 2009 14:40:54 +0000392_UTF-8 Here's an issue I can't quite get my mind around. We have one of many web services. This one goes after a single, stand-alone DB2 subsystem on z/os from WebSphere. It inserts into and reads (both single records) one table, this table is the only one in it's tablespace and database. The tablespace is universal-segmented. The volume is around 20000 transactions per hour (40k SQL) [...] 5369 419 39_Re: DSSIZE on a partitioned tablespace.14_Wayne Driscoll18_wdrisco@US.IBM.COM30_Thu, 8 Oct 2009 09:48:06 -0500458_US-ASCII If you are DB2 V9, you could convert to a partition by growth (PBG) tablespace. If lower version of DB2, you could try compression, as long as the rows are long enough that don't already have 255 rows per page. Other than that, I don't see anyway around partitioning.

=============================================== Wayne Driscoll OMEGAMON DB2 L3 Support/Development wdrisco(AT)us.ibm.com =============================================== [...] 5789 226 49_Question about Ascential 7.5.2 and DB2 LUW on AIX12_John Lendman27_lendman@PALMBEACH.K12.FL.US30_Thu, 8 Oct 2009 11:03:27 -0400424_us-ascii We are trying to get Ascential 7.5.2 to work with our PeopleSoft applications and we can not find in the doc what db2 package name we need to use.

Has anyone done this recently and would know what package they are looking for here?





DB2 Wire Protocol]

Driver=/psoft/Ascential/DataStage/branded_odbc/lib/VMdb219.so

Description=DataDirect 4.20 DB2 Wire Protocol Driver [...] 6016 17 28_Re: Space Estimation in z/OS11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Thu, 8 Oct 2009 16:02:54 +0000433_Windows-1252 >Another question, about VSAM Extents.

>z/OS 1.4 >DB2 V7

>I understand that maximum possible extents here is 255 (hope I remember correctly).

The maximum (at those levels) is 123 on a single volume and 255, in total.

You are really back-leveled.

At 1.7 (IIRC), the number of extents supported imcreases dramatically. But, even 1.7 is out of support. - Too busy driving to stop for gas! 6034 28 28_Re: Space Estimation in z/OS11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Thu, 8 Oct 2009 16:07:19 +0000411_- >At some version of z/os, if a new extent is allocated at the end of the previous extent, z/os will consolidate them into a single extent. I don't remember the version that started this sorry. It is called extent consolidation.

z/OS 1.7 -- the same release that introduced 7000 extents.

But (IIRC), the consolidation does not happen on the first volume. - Too busy driving to stop for gas! [...] 6063 126 47_Re: Reorg compression dictionary and partitions12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 8 Oct 2009 09:20:21 -0700367_us-ascii We have only ever specified Compress at the Tablespace level and not at any partition level. We never specify anything at the partition level. So we always expected it to default from the tablespace definition.

Up to V9, we never ran into any situation where this was an issue. Certainly something is different with V9. Now the question is what? [...] 6190 183 31_IBM's DB2 Log Analyzer question13_Campbell, Jim26_Jim.Campbell@COURTS.WA.GOV30_Thu, 8 Oct 2009 11:20:37 -0700437_us-ascii Hi,

I'm tracking a unit of work using the Log Analyzer I am seeing something I think should not be there. The program I'm tracking attempts to insert a row but it fails with a duplicate key error so it regenerates the key and attempts the insert again which is successful. What I'm seeing on the log report and on the undo/redo SQL is the failed INSERT shown as a committed statement and then the successful insert. [...] 6374 241 18_Re: Happy Birthday35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Thu, 8 Oct 2009 00:39:35 -0400670_iso-8859-1 Octal...

Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1

tel. (732) 972-1261 fax.(732) 972-9416 ----- Original Message ----- From: "wfavero@attglobal.net" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, October 07, 2009 5:18 PM Subject: Re: [DB2-L] Happy Birthday [...] 6616 210 18_Re: Happy Birthday15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Thu, 8 Oct 2009 19:11:13 -0400651_us-ascii I was an operator on a Sperry 90/80. That was a blast.. lots of lights and switches to IPL the sytem.



Troy Coleman CA, Inc. Principal Product Manager Office: +1630 505 6025 Mobile: +1224 343 0073 Blog: http://ibmsystemsmag.blogs.com/db2utor/ Twitter: http://twitter.com/DB2utor Twitter: http://twitter.com/troycoleman Linkedin: http://www.linkedin.com/in/troylcoleman

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Wednesday, October 07, 2009 3:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Happy Birthday [...] 6827 31 25_Re: Isolation level of RS25_SUBSCRIBE DB2-L Anonymous17_ravi17s@YAHOO.COM30_Fri, 9 Oct 2009 01:00:25 +0000442_utf-8 Hi,

When the table is in RO mode and when the application use RS isolation level Understand RS in not required)

Is the lock level is on TABLE which prevents concurrency of the applications ?

What type of lock will be held on the tables ?

With Thanks !!!

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 6859 431 35_Re: IBM's DB2 Log Analyzer question16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Fri, 9 Oct 2009 00:52:20 -0400345_us-ascii Jim - this doesn't seem right to me. Did you call support to see if they can help. If it's a bug it should not be too hard to re-create. It's the first time I hear about such a scenario.





Steen Rasmussen CA

Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals [...] 7291 221 47_Re: Reorg compression dictionary and partitions0_24_hhuang@DCCSH.ICBC.COM.CN30_Fri, 9 Oct 2009 12:53:56 +0800498_GB2312 An interesting case. I hope someone could give a reasonable explaination.

Have you dumped the dataset that made by failed REORG (or even job output could be helpful)? If so, we can DSN1PRNT to show whether the part 2 was really compressed or not. If compressed, the cause is new built compression dictionary, which may give poorer compress rate. If not compressed, the cause is DB2 bug? or some new "as design" introduced by DB2 9. You'd better connect to your IBM tech support. [...] 7513 278 53_Usage of cursor : different behaviour from Zos to LUW13_Gerard Le Roy24_gerard.le.roy@WANADOO.FR30_Fri, 9 Oct 2009 07:01:28 +0200314_iso-8859-1 Hello,

We migrated from Z/Os (DB2 V7) to AIX (DB2 V9.1) 1 month ago and one program has a strange behaviour.

Sometimes it works fine as it had done for years under ZOs, and sometimes it does not.

Having a look on the program I discovered they use the following kind of logic : [...] 7792 36 25_Re: Isolation level of RS14_Peter Vanroose17_pvanroose@ABIS.BE30_Fri, 9 Oct 2009 08:10:43 +0000458_UTF-8 Bonnie Baker has written some very good summaries, with examples (especially in the IBM Database Management magazine, http://www.ibm.com/developerworks/data/dmmag/) on locking internals of DB2, including the differences between RS and e.g. RR and CS. Yesterday she had a very enlighting session on locking at IDUG, where the RS topick was discussed in detail. She referred to a new article of hers to appear in the DB magazine within a few weeks. [...] 7829 89 27_Re: Stored Procedure Limits0_24_hhuang@DCCSH.ICBC.COM.CN30_Fri, 9 Oct 2009 16:14:08 +0800308_GB2312 Refer to SQL REFERENCE, the only documented limit I found is 32767, for the number of parameters in one procedure, because SYSIBM.SYSROUTINES.PARM_COUNT is SMALLINT. But I think 32767 is too big to be the real limit and to be used. The max amount of data can be passed for one paramenter is 32K. [...] 7919 73 49_Re: DB2 will not release mounted log archive tape0_24_hhuang@DCCSH.ICBC.COM.CN30_Fri, 9 Oct 2009 16:34:52 +0800692_GB2312 Ivan

Please check your DB2 ZPARM "DEALLCT". And this parameter could be updated online.











"Krnic, Ivan" 发件人: DB2 Data Base Discussion List 2009-10-01 19:24



收件人 DB2-L@WWW.IDUGDB2-L.ORG 抄送

主题 [DB2-L] DB2 will not release mounted log archive tape















DB2 will on occasion call for mount of old archived tape log in order to perform particular work. Once done, DB2 does not release this tape. It remains allocated until it is recycled. Is there a way to dismount this tape prior to recycle??? [...] 7993 32 25_Re: Isolation level of RS14_Peter Vanroose17_pvanroose@ABIS.BE30_Fri, 9 Oct 2009 08:13:27 +0000400_UTF-8 On Thu, 8 Oct 2009 03:13:53 -0700, Dave Nance wrote: > If they are started in RO then why the need for the restrictive locking? > If the data is not going to change then you may as well use with UR to minimize your locking.

Or better, if you don't want "dirty reads", use CS with bind option "CURRENT DATA(NO)". (This is the default in DB2 9, but not in DB2 v8.) [...] 8026 52 47_DB2 for z/OS V8 - JDBC and multi row processing12_Jim McAlpine22_jim.mcalpine@GMAIL.COM30_Fri, 9 Oct 2009 10:58:09 +0100339_ISO-8859-1 We have a distributed application that uses JDBC access to a z/OS DB2 V8 database via a vpn tunnel across the internet. It seems that this may benefit greatly from the V8 new function of multi row processing. Is anyone aware of any articles or manuals dealing with implementing multi row processing with JDBC applications. [...] 8079 37 18_Re: Happy Birthday16_Richard Sandford24_rsandford@HEALTHPLAN.COM30_Fri, 9 Oct 2009 10:18:17 +0000299_UTF-8 I started programming in BAL on a 360/20 in 1969, went to operating/programming Burroughs, B263 and B3500 in USAF, then to 360/75 in 1974. The range of IBM machines since then is too large to remember ... Now working in DB2 on z10 processor. Nice trip down memory lane.

Thanks ... [...] 8117 90 25_Re: Isolation level of RS10_Dave Nance16_dav1mo@YAHOO.COM30_Fri, 9 Oct 2009 03:30:03 -0700584_iso-8859-1 Peter, My point is that since his table is in RO (Read Only) mode an isolation level of UR is just as good as RR. Unless you want to serialize who can read the table. Since the table is in RO there will be no dirty read. It will just mean the least restrictive locks are on the data. I agree that normal processing should be using CS, but in the case mentioned it would not matter one way or the other. David Nance ________________________________ From: Peter Vanroose To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Fri, October 9, 2009 4:13:27 AM Subject: Re: [...] 8208 92 27_Re: Stored Procedure Limits10_Todd Burch17_toddburch@MAC.COM30_Fri, 9 Oct 2009 07:01:21 -0500525_US-ASCII I was writing a UDF last weekend, and noticed the VARCHAR 32K limit for passing variables. It seems the limits might be tied to the longest VARCHAR column, as I first tried a "RETURNS VARCHAR(32767)" and I got a CREATE FUNCTION error. I checked the SQL Reference for LIMITS, and saw the longest VARCHAR column to be 32,704. So, I coded that and it worked. I didn't try anything in between as I was in a hurry. A few minutes of playing with a bogus CREATE PROCEDURE (or CREATE FUNCTION) would verify that limit. [...] 8301 217 16_Quiesce Question14_Galeos Antonis19_AGaleos@EUROBANK.GR30_Fri, 9 Oct 2009 15:42:43 +0300364_iso-8859-7 Dear Listers hi,





We are at DB2 V8 for z/OS , We are thinking to change a Quisce for tablespaces from WRITE YES to WRITE NO . Does anyone know the effect of this change?

Notice that some of these tablespaces has been created with the parameter TRACKMOD NO





另豉礴 冕脶轱

DB2 DBA for z/OS [...] 8519 253 33_AW: [DB2-L] Isolation level of RS35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Fri, 9 Oct 2009 15:01:10 +0200458_iso-8859-1 Hi

The question is: Does RO as any influence on local locking for static SQL? My understanding is, that local locking will not be affected, but global locking will, because there is no inter-read/write interest for that tablespace. If it has, then locking will change during differnt execution of a package, depending on the mode of the tablespace. I am not sure, if DB2 will not take any page-locks, if a tablespace is started as RO. [...] 8773 54 57_Re: Usage of cursor : different behaviour from Zos to LUW9_Ray Houle32_raynald.houle@SCD.DESJARDINS.COM30_Fri, 9 Oct 2009 13:35:18 +0000542_utf-8 Salut Gerard,

For Q1, no unpredictable behavior. Your application's locking strategy for reads (nothing specified so it should be the default) is CS: lock a row in share, get next row, release previous row lock get next... When your application then updates (in this case deletes) a row, the lock type is upgraded to some form of exclusive lock (for that row). Exclusive locks should be held until a commit or rollback. In other words, two actions (read & delete) from a single application (single thread) should work fine. [...] 8828 358 39_Re: DSSIZE on a partitioned tablespace.12_Weaver, Rick19_Rick_Weaver@BMC.COM30_Fri, 9 Oct 2009 07:50:40 -0600362_us-ascii As Wayne Driscoll said, DB2 9 Partition By Growth is perfect for this situation. I just finished giving 2 presentations at EMEA IDUG extolling the virtues of PBG.

I have a technique that can reduce the outage time to convert from SEGMENTED to PBG. Contact me at rick_weaver@bmc.com offline if you are interested. [...] 9187 58 37_Insert Select with Commit_Count ? LUW9_Ray Houle32_raynald.houle@SCD.DESJARDINS.COM30_Fri, 9 Oct 2009 13:59:26 +0000331_utf-8 I am seeking to 鈥渃opy鈥 the data from one table to another (in the context of an extended ALTER鈥 table change requiring a DROP / CREATE).

Using EXPORT / IMPORT requires knowledge / availability / access of sufficient OS level file system鈥 not to mention the IOs required to write and read to said file(s). [...] 9246 358 20_Re: Quiesce Question11_Mike Turner19_mike.turner@GMX.COM30_Fri, 9 Oct 2009 15:21:11 +0100608_iso-8859-7 Hi Antonis

WRITE NO does not write updated pages from the bufferpool before the Quiesce, WRITE YES does write from the bufferpool. Whether this is significant or not depends on why you are doing the Quiesce.

If the Quiesce is just before taking a backup using non-DB2 methods, like DSN1COPY, DFDSS, or third-party Image Copy utilities, then the backup will not represent the data at the Quiesce point because these utilities read from the dataset and do not go via the bufferpool. If you backup using IBM DB2 COPY utility then WRITE is not important because COPY reads from the [...] 9605 324 30_DB2 LUW pureScale News Release17_Phil Gunning GTS125_pgunning@GTS1SOFTWARE.COM30_Fri, 9 Oct 2009 12:30:41 -0400669_us-ascii DB2 pureScale provides for very high scalability, workload balancing, and high availability in a shared disk environment for OLTP and other workloads. This is a culmination of years of development and positions DB2 very well against Oracle RAC.

Phil





The press release is available at

http://www.prnewswire.com/news-releases/ibm-purescale-technology-redefines-t ransaction-processing-economics-63845227.html













Phil Gunning

IBM Information Champion

www.gts1software.com

" Cowards die many times before their deaths: [...] 9930 37 19_pureScale announced21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET30_Fri, 9 Oct 2009 13:04:17 -0400676_iso-8859-1 pureScale for DB2 LUW was announced today. There is additional information posted in my blog...

http://it.toolbox.com/blogs/db2zos/true-continuous-availability-comes-to-db2 -luw-34678

-- Willie My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos Houston, TX, USA





-------------------------------------------------------------------- mail2web.com Enhanced email for the mobile individual based on Microsoft Exchange - http://link.mail2web.com/Personal/EnhancedEmail

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 9968 36 18_Re: Happy Birthday15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV30_Fri, 9 Oct 2009 10:08:45 -0700271_utf-8 Remember when you started out, and the "OLD FARTS" would go down memory lane and you had no idea what they were talking about? Well, if you know what people are talking about in this thread, you are an "OLD FART", If not then you're still wet behind the ears! [...] 10005 123 57_Re: Usage of cursor : different behaviour from Zos to LUW13_Gerard Le Roy24_gerard.le.roy@WANADOO.FR30_Fri, 9 Oct 2009 22:55:43 +0200566_iso-8859-1 Thanks Ray, Q1 : I really think that there can be a problem with this kind of logic. Here extracted from SQL Reference Vol 2 concerning OPEN : << Effect of temporary tables: In some cases, the result table of a cursor is derived during the execution of FETCH statements. In other cases, the temporary table method is used instead. With this method the entire result table is transferred to a temporary table during the execution of the OPEN statement. When a temporary table is used, the results of a program can differ in these ways: An error can [...] 10129 251 28_DB2 pureScale -- White Paper12_Phil Gunning25_pgunning@GTS1SOFTWARE.COM30_Fri, 9 Oct 2009 20:28:43 -0400773_us-ascii Here is a link:





http://download.boulder.ibm.com/ibmdl/pub/software/dw/data/purescale/DB2_pur eScale_Whitepaper.pdf













Phil Gunning

IBM Information Champion

www.gts1software.com

" Cowards die many times before their deaths:

The valiant never taste of death but once" Shakespeare

See us at IBM IOD, 24-28 Oct 2009, Las Vegas, NV

Database Industry Analyst

DB2 Consulting, Books on DB2, Outsourcing, Education, Remote Support

http://it.toolbox.com/blogs/db2-for-luw

DB2 9.7 Early Access Program --

http://www-01.ibm.com/software/data/db2/technology-sandbox/

Direct +1.610.451.5801

Toll Free 888.241.1070 [...] 10381 45 45_Sherri Sterling/OIT/BPD is out of the office.0_29_Sherri.Sterling@BPD.TREAS.GOV30_Fri, 9 Oct 2009 21:31:15 -0400585_US-ASCII

I will be out of the office starting 10/09/2009 and will not return until 10/19/2009.

I will respond to your message when I return.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

_____________________________________________________________________

IDUG Europe Attendee Testimonial- 揟he main reason for my attendance at IDUG - Europe was general training and rekindling enthusiasm. I took away more knowledge and enthusiasm IDUG did the job!" 10427 394 51_Re: AW: [DB2-L] DSSIZE on a partitioned tablespace.15_Smartcurl Zhang19_smartcurl@GMAIL.COM31_Sat, 10 Oct 2009 12:32:46 +0800582_ISO-8859-1 Yes,I have to unload this huge table,and I think it would take a lot of work.I am kind of lazy man. :)

2009/10/8 Walter Jani遝n

> Hi > > DSSIZE is only allowed for partitioned tablespaces, so 64 GB is the max for > segmented tablespaces. To get more rows into it, you can check your > FREEPAGE/PCTFREE-values or check if the tablespace is compressed (not only > COMPRESS YES, but rows must be compressed indeed). > > What is the reason to not to go for partitioned tablespace? Because you > have to drop and recreate it? > [...] 10822 348 39_Re: DSSIZE on a partitioned tablespace.15_Smartcurl Zhang19_smartcurl@GMAIL.COM31_Sat, 10 Oct 2009 12:36:43 +0800589_ISO-8859-1 OK, thank you everyone, BMC guys.I will try PBG.

On Fri, Oct 9, 2009 at 9:50 PM, Weaver, Rick wrote:

> As Wayne Driscoll said, DB2 9 Partition By Growth is perfect for this > situation. I just finished giving 2 presentations at EMEA IDUG extolling the > virtues of PBG. > > I have a technique that can reduce the outage time to convert from > SEGMENTED to PBG. Contact me at rick_weaver@bmc.com offline if you are > interested. > > > Rick Weaver > Product Manager > DB2 z/OS Solutions > BMC Software > > > ------------------------------ [...] 11171 157 35_Re: IBM's DB2 Log Analyzer question12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 10 Oct 2009 10:51:43 +0200591_iso-8859-1 Hi,

I think he meant IBM Log Analyzer - NOT CA Log Analyzer (from the Subject line)







---- Original message ---- >Date: Fri, 9 Oct 2009 00:52:20 -0400 >From: "Rasmussen, Steen" >Subject: Re: [DB2-L] IBM's DB2 Log Analyzer question >To: DB2-L@WWW.IDUGDB2-L.ORG > > Jim - this doesn't seem right to me. Did you call > support to see if they can help. If it's a bug it > should not be too hard to re-create. It's the first > time I hear about such a scenario. > > > > Steen Rasmussen > CA > > Sr Engineering Services [...] 11329 30 24_Apply for IDUG CPC, 201020_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM31_Sat, 10 Oct 2009 14:49:55 +0300467_us-ascii Would you like to be part of the IDUG CPC Team for 2010 in Europe ?

If you're interested, please go the following URL and submit your application. http://www.idug.org/apply-now/index.html

And if you have question, please contact with me.

Regards, Cuneyt Goksu IDUG 2010 Conf. Chair.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 11360 81 60_AUTO: Alan Brown is out of the office (returning 10/19/2009)10_Alan Brown20_alanbrown@US.IBM.COM31_Sat, 10 Oct 2009 10:01:08 -0400496_US-ASCII



I am out of the office until 10/19/2009.

I am on vacation. You will receive this notification once.

If you need immediate technical assistance, please contact Pete Kohler (pkohler@us.ibm.com) at (203) 486-5716.

I will respond to your message when I return. You will receive this message only once.





Note: This is an automated response to your message "Re: [DB2-L] IBM's DB2 Log Analyzer question" sent on 10/10/09 4:51:43. [...] 11442 92 41_Re: Insert Select with Commit_Count ? LUW13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Sat, 10 Oct 2009 10:58:16 -0700537_windows-1252 Ray,

I'm sure you're aware of this, but insert ... select has archive logging implications, too - just like a recoverable load. Although you could argue that a load copy isn't quite the same as additional log records. ;-)

Anyway, IIRC, Serge Rielau's "SQL on Fire!" presentations from a couple of years ago (2007 I think) provided some good examples of how to do this. I think his examples were based on deleting rows with a commit count, but it shouldn't be too hard to adapt this for your requirements. [...] 11535 48 46_Restart of a TABLESPACE REORG SHRLEVEL(CHANGE)3_Dan22_djnardinidb2@GMAIL.COM31_Sat, 10 Oct 2009 20:18:54 +0000335_UTF-8 Hi all,

I have a question about the restart of a tablespace using SHRLEVEL(CHANGE). The IBM Utilities book (DB2 Version 9.1 for z/OS Utilit Guide and Reference) on page 519 lists the acceptable restart phases for each step of the reorg. For SHRLEVEL CHANGE, the only step available for a restart is the SWITCH phase. [...] 11584 61 18_Re: Happy Birthday0_22_DB2information@AOL.COM29_Sun, 11 Oct 2009 16:28:33 EDT671_US-ASCII Wayne, I agree. A note from Ed. Benoit

Ed. Benoit Recovery Knowledge DB2 Automation Recovery is our Only Business



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the most respected DB2 magazine - IDUG Solutions Journal Technical atricles from world famous authors in DB2's most prestigious, peer reviewed magazine now on-line! _____________________________________________________________________ [...] 11646 142 36_IDUG Solutions Journal (Summer 2009)10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 12 Oct 2009 08:19:58 -0400505_iso-8859-1

Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com

Last update on Monday, October 5th 2009



Summer 2009 issue of IDUG Solutions Journal is available on line.



Current issue contains following articles:





- Escaping the REBIND blues in DB2 9 for z/OS by Adarsh Pannu and Terry Purcell





- Best practices- DB2 9 for z/OS migration by Roger Miller [...] 11789 145 58_Redpaper DB2 9 for z/OS: Buffer Pool Monitoring and Tuning10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 12 Oct 2009 08:21:47 -0400702_iso-8859-1

Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com

Last update on Monday, October 12th 2009





IBM just published a draft version of a new Redpaper, "DB2 9 for z/OS: Buffer Pool Monitoring and Tuning, REDP-4604-00".

Abstract DB2 buffer pools are a key resource for ensuring good performance.This is becoming increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor.A System z processor can be configured with large amounts of storage which, if used wisely, can help compensate by using [...] 11935 105 51_Re: DB2 for z/OS V8 - JDBC and multi row processing14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Mon, 12 Oct 2009 08:04:44 -0500455_us-ascii For network applications just don't bother, ddf already returns your result set by blocks rather than rows unless you have OPTIMIZE for 1 ROW coded in your query. For your local applications (running in the same z/OS image) you should look into utilizing this feature. This is specially true for CICS applications where not only you will avoid multiple cross memory calls but possibly multiple task switches in between the calls. HTH Khalid [...] 12041 287 32_Re: DB2 pureScale -- White Paper14_Matthew Donald26_matthew.b.donald@GMAIL.COM31_Tue, 13 Oct 2009 00:32:19 +1100609_windows-1252 Great quote from Larry Ellison - " I make fun of a lot of other databases梐ll other databases, in fact, except the mainframe version of DB2. Its a first-rate piece of technology." But the quote its taken from is one the better anti-Microsoft rants I read for a while:

"So whats Microsofts single greatest innovation? Take your time. 桰ts a trick question. There arent any. All that money Microsoft spends on research; what have they got to show for it? Nothing! Compare that to IBMs research results. IBM invented the disk drive, they invented core memory, they invented the scanning [...] 12329 331 27_Re: Stored Procedure Limits19_Claypool, Alisa@EDD25_Alisa.Claypool@EDD.CA.GOV31_Mon, 12 Oct 2009 07:22:05 -0700695_us-ascii Thanks for the response.





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Todd Burch Sent: Friday, October 09, 2009 5:01 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Stored Procedure Limits





I was writing a UDF last weekend, and noticed the VARCHAR 32K limit for passing variables. It seems the limits might be tied to the longest VARCHAR column, as I first tried a "RETURNS VARCHAR(32767)" and I got a CREATE FUNCTION error. I checked the SQL Reference for LIMITS, and saw the longest VARCHAR column to be 32,704. So, I coded that and it worked. I didn't try [...] 12661 26 27_Re: Stored Procedure Limits14_Peter Vanroose17_pvanroose@ABIS.BE31_Mon, 12 Oct 2009 14:51:09 +0000671_UTF-8 VARCHAR(32704) is indeed the longest possible parameter. Unless you use CLOB or the like, of course.

-- Peter Vanroose, ABIS Training & Consulting.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________ [...] 12688 236 27_Re: Stored Procedure Limits0_17_db46@CHRYSLER.COM31_Mon, 12 Oct 2009 11:03:57 -0400412_US-ASCII Is there a limit for language based stored procedures as far as the number of parameters? We've come across what seems to be a 15 variable limit here. This has been discovered by the fact that although everything 'seems' to be okay, when we 'call' the SP (from say command editor which uses DRDA), it just sits there with 16 parms and never returns. But when we go down to 15 parms, then it works. [...] 12925 273 36_Re: How do you move a LOB tablespace16_Wolters, Jeff B.24_Jeff.Wolters@PGNMAIL.COM31_Mon, 12 Oct 2009 13:44:34 -0400382_us-ascii I have DBA who has a question he'd like posted on the LISTSERV:

We are DB2 V8 on Z/OS 1.9, CPU model is 2096, processor is Z9X.













I have 6 tablespaces defined as LOB that I need to move to free up a pack. REORG won't move them.





Do I have to drop/recreate the tablespaces to move them? [...] 13199 275 36_Re: How do you move a LOB tablespace15_Kalena, Michael27_Michael.Kalena@JPMORGAN.COM31_Mon, 12 Oct 2009 14:46:41 -0400734_us-ascii We do it by stopping the LOB table space, then using DFDSS to move the underlying dataset(s), and starting the spaces.





We also take a back up first (just to be extra safe).





Michael Kalena 973-793-2133 Michael.Kalena@jpmorgan.com





DB2 Info Page at hBSC

(http://whsysops1.is.bear.com/db2/ )





_____

From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Wolters, Jeff B. Sent: Monday, October 12, 2009 1:45 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] How do you move a LOB tablespace [...] 13475 311 36_Re: How do you move a LOB tablespace10_Roger Hecq18_Roger.Hecq@UBS.COM31_Mon, 12 Oct 2009 15:15:41 -0400547_US-ASCII The Recover utility should reallocate the tablespaces on the desired volume(s). Otherwise, you should be able to move the data sets with DFDSS. You would have to stop the tablespaces for that.

Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492





________________________________

From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Wolters, Jeff B. Sent: Monday, October 12, 2009 1:45 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] How do you move a LOB tablespace [...] 13787 38 36_Johanna Wilson is out of the office.14_Johanna Wilson26_Johanna_Wilson@MOH.GOVT.NZ31_Tue, 13 Oct 2009 15:52:57 +1300755_US-ASCII I will be out of the office starting 13/10/2009 and will not return until 15/10/2009.

While I am away if the matter is urgent, please contact Tod Cooper, Commercial & Procurement.



**************************************************************************** Statement of confidentiality: This e-mail message and any accompanying attachments may contain information that is IN-CONFIDENCE and subject to legal privilege. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. **************************************************************************** [...] 13826 76 30_Re: AW: [DB2-L] Happy Birthday10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 13 Oct 2009 09:38:12 +0200373_US-ASCII Even in last IDUG in Rome there was no one under 30, at least among attendes in my thread (thread B - z/OS II). Even in expo area I didn't see no one under that age. Anyway it's common to send to

conferences expert people, but I know some companies are hiring young peole under 30 (in the range 24-29). This means over 40 are out of the market. :-(((( [...] 13903 190 30_Re: AW: [DB2-L] Happy Birthday6_Leslie21_db2dba@BTINTERNET.COM31_Tue, 13 Oct 2009 11:57:26 +0100504_US-ASCII Max

there is nobody under 40 in my office, and I would say 60%+ are over 50., with some (10%) over 60.

The following article is interesting but not about DB2.

http://www.cio.co.uk/opinion/veitch/2009/06/16/the-mainframe-skills-conundru m/

Leslie



_____

From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Max Scarpa Sent: 13 October 2009 08:38 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AW: [DB2-L] Happy Birthday [...] 14094 71 28_Re: Space Estimation in z/OS10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 13 Oct 2009 13:21:52 +0200393_UTF-8 In Rome there was a great presentation about extents by Steve Thomas, BMC. It gives an outlook to DASDs technology and some consideration about extents from Db2 point of view.

Max Scarpa







Massimo Scarpa - Ufficio Sistemi Cesve Servizi Informatici Bancari v. Longhin, 1 - 35129 Padova Tel. 049.8067111 - Fax. 049.8067300 E-Mail: mscarpa@cesve.it [...] 14166 347 28_Re: Space Estimation in z/OS7_DB2 DBA21_the.db2.dba@GMAIL.COM31_Tue, 13 Oct 2009 07:22:17 -0400582_ISO-8859-1 That sounds like a sensible 'threshold', thank you and all the other people for helping me out.

Josh





On Thu, Oct 8, 2009 at 10:18 AM, Mike Bell wrote:

> The limits are > 1. extents on a single volume - 123 > 2. total extents across multiple volumes 255 > > At some version of z/os, if a new extent is allocated at the end of the > previous extent, z/os will consolidate them into a single extent. I don't > remember the version that started this sorry. It is called extent > consolidation. > > Unless you [...] 14514 77 27_How to find lock duration ?14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Tue, 13 Oct 2009 08:43:42 -0500422_us-ascii I'm trying to find how long certain locks are being held, something like "thread x locked object y from timea to timeb". I didn't find anything like this readily available in any of the tools we have. Looking at IFCIDs it seems #0021 has the information about locks acquired and released. Is processing this IFCID my only option ? Are there better ways of getting this information ? Thanks in advance Khalid [...] 14592 119 21_additional processor?25_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE31_Tue, 13 Oct 2009 13:44:22 +0000436_utf-8 *** cross-posted in IBM-MAIN, CICS-L, DB2-L ***

Hi,

If having the choice between a z10-BC with 2 or 3processors, and if NOT taking (or having to take) into account the price aspect, is it possible to investigate wether a 2- or a 3-processor system might better suit us?

I assume it may be possible to gather info about a latent demand for a processor. Where to look at in RMF,or in SMF to find this out? [...] 14712 53 50_Re: Restart of a TABLESPACE REORG SHRLEVEL(CHANGE)13_Bright, Randy20_Randy_Bright@BMC.COM31_Tue, 13 Oct 2009 10:49:49 -0500516_utf-8 It looks like no one has picked this up so I'll take a shot.

During SHRLEVEL CHANGE Reorg log records updating the tablespace and indexes must be accumulated to be applied to the Reorged object once the shadow dataset is reloaded. If the Reorg fails before the log records are applied, the log accumulation stops for several reasons, but the main reason is there is no way to determine how long it will be before the Reorg is restarted. How long do you want to accumulate log records? Hours? Days? [...] 14766 177 25_Re: additional processor?12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 13 Oct 2009 10:18:10 -0700501_iso-8859-1 I do believe you'll need a CAPACITY/PERFORMANCE monitoring tool (as opposed to a database modelling tool). The last one I used was called BEST/1. It will pick out the SMF/RMF data needed, after you pick the timeframe and workload you want to model . Generally, you'd want the fastest processor available for good CICS throughput. You'd want more (albeit slower) processors for maximizing parallellism. A good modelling tool should be able to show you which is best for your situation. [...] 14944 38 28_UNION- limiting rows fetched5_anand19_mahadea@LABCORP.COM31_Tue, 13 Oct 2009 19:39:38 +0000 14983 100 22_db2 9 install and cics11_Diana Nagel16_dknagel@BEPC.COM31_Tue, 13 Oct 2009 15:37:00 -0500485_us-ascii We are installed db2 9 on our test region and across the board trans have increased two fold at minimum. Is there anything in the the db2 setup that would cause this. I have all the workfiles 4k and 32k and plenty of workfiles.I have gone thru all the parms and all set at default. We are current on maintenance.I then worked with ibm and found that cics was the concern. We have since changed priorties in our cics region and it got worse. We use cics 2.3 and z\os 1.9. [...] 15084 96 26_Re: db2 9 install and cics11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 13 Oct 2009 20:41:03 +0000584_Windows-1252 LU6.2 -- a change in the MCT? Did CPU go up as well? - Too busy driving to stop for gas!

-----Original Message----- From: Diana Nagel Date: Tue, 13 Oct 2009 15:37:00 To: Subject: [DB2-L] db2 9 install and cics

We are installed db2 9 on our test region and across the board trans have increased two fold at minimum. Is there anything in the the db2 setup that would cause this. I have all the workfiles 4k and 32k and plenty of workfiles.I have gone thru all the parms and all set at default. We are current [...] 15181 219 25_Re: additional processor?13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM31_Tue, 13 Oct 2009 17:15:35 -0400297_iso-8859-1 I believe that the comments on this list in the past have been (and I tend to agree with them) that for the same number of MSUs (MIPS), throughput is better with more, slower processors rather than fewer, faster ones, so if I had your choice, I would go with the 3-processor unit. [...] 15401 83 32_Sort processing time for a query10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 13 Oct 2009 21:20:53 +0000271_utf-8 Hi,

System is Z/OS, DB2 v8. We have a database that has just been copied across from Aix DB2 (v8.2) to z/OS DB2. I have a query joining 3 tables, that seems to take about a minute and a half to run on z/OS. It was completing in about 10 seconds on Aix. [...] 15485 25 41_Doug Holliday/Alcan is out of the office.13_Doug Holliday23_doug.holliday@ALCAN.COM31_Tue, 13 Oct 2009 22:57:29 -0400660_US-ASCII I will be out of the office starting 10/13/2009 and will not return until 10/14/2009.

I will respond to your message when I return.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations! Did you miss out on attending an IDUG conference? Many of the presentations were recorded and are available on our website! _____________________________________________________________________ [...] 15511 33 63_AUTO: Colin J Page2 is out of the office (returning 16/10/2009)13_Colin J Page218_CJPAGE2@UK.IBM.COM31_Wed, 14 Oct 2009 04:03:54 +0100394_US-ASCII I am out of the office until 16/10/2009.

I am out of the office on a course Wed 14th & Thu 15th October. I will try to pick up emails when possible. For any urgent issues please contact my manager Gerry McFadden on 07714-664759.

Regards, Colin



Note: This is an automated response to your message "Re: additional processor?" sent on 13/10/09 22:15:35. [...] 15545 211 26_Re: db2 9 install and cics6_Leslie21_db2dba@BTINTERNET.COM31_Wed, 14 Oct 2009 07:54:56 +0100281_us-ascii Hi Diana I'm no CICS expert, I am assuming the IBM people traced the txn in DB2 and were able to show the time was in CICS that way? If so which traces did they use.

If it were me looking at it I would ask myself if there was some form of conversion going on. [...] 15757 44 26_Re: db2 9 install and cics10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 14 Oct 2009 10:28:39 +0200581_US-ASCII Is CICS version (2.3) correct in your message ?

Max Scarpa

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations! Did you miss out on attending an IDUG conference? Many of the presentations were recorded and are available on our website! _____________________________________________________________________ 15802 64 26_Re: db2 9 install and cics9_Tony Saul30_generalemaillists@YAHOO.COM.AU31_Wed, 14 Oct 2009 01:39:01 -0700322_utf-8 Hi Diana,

I would start by comparing the cpu usage of the DB2 and CICS regions to see what is using more. If you are happy with IBM's findings that it is CICS.

In CICS you can add RMI=YES to your MCT (monitoring control table) and that will provide details of the time spent in the DB2 interface. [...] 15867 71 32_Re: UNION- limiting rows fetched11_Mike Bracey22_mike_bracey@UK.IBM.COM31_Wed, 14 Oct 2009 08:50:07 +0000383_UTF-8 Your query works in DB2 9 for z/OS but not in DB2 for z/OS V8. The enhancement to the SQL is documented in the manuals but can also be found in the redbook SG24-7330 DB2 V9 Technical overview chapter 6.5, which you can find here: http://www.redbooks.ibm.com/abstracts/SG247330.html

Mike

On Tue, 13 Oct 2009 19:39:38 +0000, anand wrote: [...] 15939 189 30_Re: AW: [DB2-L] Happy Birthday16_Andreopoulou Zoi24_z.andreopoulou@TTBANK.GR31_Wed, 14 Oct 2009 11:48:28 +0300486_iso-8859-7 There was at least one attendee under 30 in IDUG in Rome...

I am 26 years old and I was there...

I started working with DB2 and z/OS three years ago...





Zoe Andreopoulou

DB2 DBA

Hellenic Postbank





From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Max Scarpa Sent: Tuesday, October 13, 2009 10:38 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AW: [DB2-L] Happy Birthday [...] 16129 135 32_Re: UNION- limiting rows fetched14_Peter Backlund21_BacklundDB2@TELIA.COM31_Wed, 14 Oct 2009 11:19:30 +0200 16265 53 25_Re: additional processor?7_Jan tje25_jan.moeyersons@ADELIOR.BE31_Wed, 14 Oct 2009 10:28:45 +0000394_utf-8 On Tue, 13 Oct 2009 13:44:22 +0000, jan.vanbrabant@telenet.be wrote:

>*** cross-posted in IBM-MAIN, CICS-L, DB2-L *** > >Hi, > >If having the choice between a z10-BC with 2 or 3processors, >and if NOT taking (or having to take) into account the price aspect, >is it possible to investigate wether a 2- or a 3-processor system might better suit us? [...] 16319 25 32_Re: UNION- limiting rows fetched5_anand19_mahadea@LABCORP.COM31_Wed, 14 Oct 2009 12:23:27 +0000484_UTF-8 Thanks Mike and Peter. I'll look up that redbook. I'm trying to create some test data by pulling the first 10 rows from 1 table and the first 10 rows from a second table. Just need a few rows, don't really care about order by and all that.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...] 16345 477 26_Re: db2 9 install and cics11_Diana Nagel16_dknagel@BEPC.COM31_Wed, 14 Oct 2009 08:36:35 -0500430_us-ascii Les, Yes, thank you working with ibm...traces ifcids 100-102, 70-79 were extracted and showed class 1 times were awful....thats why working with cics setup - the db2 times all appear to be subsecond...

diana

From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Leslie Sent: Wednesday, October 14, 2009 1:55 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 9 install and cics [...] 16823 336 27_Re: Stored Procedure Limits16_Robert Catterall21_rfcatterall@GMAIL.COM31_Wed, 14 Oct 2009 10:49:55 -0400572_ISO-8859-1 Dean,

When you cite the situation in which a call to an SP with 16 parameters "sits there," while a call with 15 parameters works, are you talking about calls to two different stored procedures, one defined with 16 parameters and the other with 15, or is the called stored procedure the same in both cases? If the CALL is to resolve correctly on the DB2 server, the number of parameters specified on the CALL has to match the number of parameters specified in the definition of the called stored procedure. You might well be aware of this already - [...] 17160 168 46_Re: DB2 V9 z/OS - how to get rid of claimers ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Wed, 14 Oct 2009 14:57:10 +0530490_US-ASCII I was just wondering if putting the subjected tablespace (and indexspace) in UT mode could help claimers be off the object.

Would the Start command with ACC(UT) force the claimers to die even the ones that hold locks ?













Nenad Vidak Sent by: DB2 Data Base Discussion List 01/10/2009 10:58 Please respond to DB2 Database Discussion list at IDUG [...] 17329 176 46_Re: DB2 V9 z/OS - how to get rid of claimers ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Wed, 14 Oct 2009 16:23:28 +0530291_US-ASCII (For some reason, I did not see this message sent for more than an hour. So, I am sending it out again. If comes out as duplicate, I am sorry ! )

I was just wondering if placing the subjected tablespace (and indexspace) in UT mode could help claimers be off the object. [...] 17506 399 27_Re: Stored Procedure Limits0_17_db46@CHRYSLER.COM31_Wed, 14 Oct 2009 11:18:12 -0400427_US-ASCII I am 'calling' it from my db2 client on my PC via command editor.

It is not a SP to SP call. Just call sysproc.prdt02k (parm1, parm2, .... parm16)

Dean J. Burchill 248-576-3957 (8) 776-3957





Robert Catterall Sent by: IDUG DB2 Discussion List 10/14/2009 10:59 AM Please respond to IDUG DB2 Discussion list [...] 17906 404 23_Stored Procedure Limits0_17_db46@CHRYSLER.COM31_Wed, 14 Oct 2009 11:34:23 -0400380_US-ASCII I am 'calling' it from my db2 client on my PC via command editor.

It is not a SP to SP call. Just call sysproc.prdt02k (parm1, parm2, .... parm16)

Yes, I know that DB2 SP's can be loaded (like java - same name different number of parameters). Of course if the number of parms don't match with the name, then you get an sql code (-444 or -440 I think). [...] 18311 519 26_Re: db2 9 install and cics16_Robert Catterall21_rfcatterall@GMAIL.COM31_Wed, 14 Oct 2009 12:28:33 -0400497_windows-1252 OK, I'll grasp at a straw myself: If the test region in which you're seeing the poor CICS-DB2 transaction elapsed times is CPU-constrained, it's conceivable that the subtask TCBs associated with the CICS-DB2 transactions are getting in the way of the CICS AOR's main task TCB if you have PRIORITY set to EQUAL for your DB2ENTRY and DB2CONN resources - my recollection is that EQUAL means that the subtask TCBs will have a priority that is slightly higher than the main task TCB. [...] 18831 46 25_Re: additional processor?15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Wed, 14 Oct 2009 09:41:37 -0700523_utf-8 Don't forget to factor in a ZIIP processor, which always runs at full speed, cost less, and doesn鈥檛 get used in calculating the cost of software running on the box.

Wayne Campbell DB2 DBA Administrative Office of the Courts (360) 705-5268 Email: wayne.campbell@courts.wa.gov

-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jan tje Sent: Wednesday, October 14, 2009 3:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] additional processor? [...] 18878 165 27_Re: Stored Procedure Limits0_17_db46@CHRYSLER.COM31_Wed, 14 Oct 2009 12:47:14 -0400354_US-ASCII The problem isn't with the size of each parameter, but with the number of parms.

I can create the SP just fine, but when I try to call it from command editor on my local DB2 client (using DRDA) it just sits there and never actually invokes the SP (put a debug statement on the first line of executable code and it never gets there). [...] 19044 528 27_Re: Stored Procedure Limits16_Robert Catterall21_rfcatterall@GMAIL.COM31_Wed, 14 Oct 2009 12:51:25 -0400569_ISO-8859-1 Yeah, not getting an error code would make you think that a "not found" situation has not occurred.

A long shot: have you, by chance, tried the call (with 16 parameters) from the command line processor, versus the command editor?

Robert



On Wed, Oct 14, 2009 at 11:34 AM, wrote:

> > I am 'calling' it from my db2 client on my PC via command editor. > > It is not a SP to SP call. Just call sysproc.prdt02k (parm1, parm2, .... > parm16) > > Yes, I know that DB2 SP's can be loaded (like java - same [...] 19573 397 30_Re: AW: [DB2-L] Happy Birthday13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 14 Oct 2009 10:01:28 -0700355_us-ascii Zoe, you are a breath of fresh air. Since I'm never going to retire, you and I will be raking in the big bucks when all these other old guys retire.

I'd like to thank everyone for posting on this thread. I know it wasn't meant for me, but I just turned 50 last Friday, and it was nice to see all the happy birthday wishes from DB2-L! [...] 19971 549 27_Re: Stored Procedure Limits0_17_db46@CHRYSLER.COM31_Wed, 14 Oct 2009 13:20:20 -0400533_US-ASCII Yes, same result

Dean J. Burchill 248-576-3957 (8) 776-3957





Robert Catterall Sent by: IDUG DB2 Discussion List 10/14/2009 01:17 PM Please respond to IDUG DB2 Discussion list



To DB2-L@www.idugdb2-l.org cc

Subject Re: [DB2-L] Stored Procedure Limits











Yeah, not getting an error code would make you think that a "not found" situation has not occurred. [...] 20521 87 27_Re: Stored Procedure Limits10_Todd Burch17_toddburch@MAC.COM31_Wed, 14 Oct 2009 12:30:46 -0500278_US-ASCII Can you call it locally on z/OS?

You can start a performance trace with IFCID 184 / 185 on z/OS and see what comes through (if you have a way to analyze the records).

Or, you could kick off a DRDA trace too. (Don't ask me how - I work RDS, not DDF!) [...] 20609 247 46_Re: DB2 V9 z/OS - how to get rid of claimers ?0_21_BudGreenman@ONGOV.NET31_Wed, 14 Oct 2009 13:53:00 -0400449_US-ASCII Simple answer: No. You have to term any threads (claimers) first then issue the stop command before starting back up in UT mode

Bud Greenman Applications Programming Manager





From: Balachandran Chandrasekaran1 To: DB2-L@WWW.IDUGDB2-L.ORG Date: 10/14/2009 11:57 AM Subject: Re: [DB2-L] DB2 V9 z/OS - how to get rid of claimers ? Sent by: IDUG DB2 Discussion List [...] 20857 455 30_Re: AW: [DB2-L] Happy Birthday10_Roger Hecq18_Roger.Hecq@UBS.COM31_Wed, 14 Oct 2009 14:26:12 -0400523_US-ASCII Cathy, We were just celebrating the 11th anniversary of your 39th birthday!

It isn't that nobody noticed Zoe. They all just figured that Zoe was accompanying a parent.

Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492





________________________________

From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Taddei, Cathy Sent: Wednesday, October 14, 2009 1:01 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AW: [DB2-L] Happy Birthday [...] 21313 752 26_Re: db2 9 install and cics11_Diana Nagel16_dknagel@BEPC.COM31_Wed, 14 Oct 2009 14:37:28 -0500669_us-ascii This looks pretty good....certainly items we have discussed off and on...Will pass on to systems guy.

Thanks diana

From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Catterall Sent: Wednesday, October 14, 2009 11:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 9 install and cics

OK, I'll grasp at a straw myself: If the test region in which you're seeing the poor CICS-DB2 transaction elapsed times is CPU-constrained, it's conceivable that the subtask TCBs associated with the CICS-DB2 transactions are getting in the way of the CICS AOR's main task TCB if you have PRIORITY set to EQUAL for [...]