1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2008, week 5 2 40 24_Re: SQL Query Innacuracy7_Jan tje25_jan.moeyersons@ADELIOR.BE31_Mon, 29 Sep 2008 09:10:43 +0000363_utf-8 On Fri, 26 Sep 2008 14:38:08 +0100, Kenny Fogarty wrote:

> >SUM(DEC((((BPGETPAGE - (BPSGT + BPNGT)) + BPFPAGESRD + BPLPP + BPDPP + >BPPGUPDAT)),15,6) / 30000) AS INTENSITY. > >SUM(CAST((BPGETPAGE - (BPSGT + BPNGT)) + (BPFPAGESRD + BPLPP + BPDPP + >BPPGUPDAT) AS DEC(15,4)))/ 30000 AS INTENSITY which gave me the answer [...] 43 23 40_Re: DB2 z/OS UNLOAD Utility and GRAPHICs12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Mon, 29 Sep 2008 11:41:44 +0000775_utf-8 Thanks for the suggestions.... the colleague concerned has gone off on two weeks holiday so I can't get him to test the vargraphic option. Will let you know.

Adam

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * 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 [...] 67 44 16_EMC Flash Drives0_24_dpetronella@PERSHING.COM31_Mon, 29 Sep 2008 09:20:53 -0400430_US-ASCII Does anyone have any experience with EMC Flash Drives, which I believe were announced in January?

We are looking for any feedback on perfomance gains specifically as it relates to DB2 v8 CM and NFM.

Are there any concerns with limiting the types of objects that go on these devices such as only volatile or non-volatile objects? What about the DB2 catalog and log datasets? And also DASD Image Copies? [...] 112 65 42_Re: Performance impact of update statement14_Avram Friedman25_IBMsysProg@GEEK-SITES.COM31_Mon, 29 Sep 2008 13:23:26 +0000556_utf-8 Are there any Variable length columns in the row? Is the table compressed?

Regardless to the answer to the two above questions there is additional over head for multible updates More calls to evaluate the SQL request Additional logging

A possitive answer to either of the first two questions make matters much worse. THe updated row resulting from each update statement many not fit in the same location as the prior row. So the row may (and lilky will) be relocated for each update statement with what ever overhead that entails. [...] 178 26 38_Re: DB2 z/os: Index screening question13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Mon, 29 Sep 2008 14:40:50 +0000778_utf-8 Thanks Terry and James, that was the info I was looking for.

Had to explain it to some one and realized, I didnt have 100% of the story for myself.

Much appreciated

Jack

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * 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 [...] 205 143 24_Re: PPRC and Log Suspend16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM31_Mon, 29 Sep 2008 12:38:13 -0500505_- Steve,

We've been doing DR for years without suspending log updates using EMC CONSISTENT split (or SNAP). They're supposed to be consistent, but they are not always in a very busy system.

It's been my experience that you will, in fact, have LPLs (and GRECPs if data sharing). They are easy to resolve. You may also experience dataset levelid errors or 00C90101 errors. You can do a LOGONLY RECOVER of the tablespace to fix these or a rebuild of the index if it's on an index pageset. [...] 349 162 9_DB2 error10_Paul Chang18_pyfchang@YAHOO.COM31_Mon, 29 Sep 2008 16:01:26 -0700314_iso-8859-1 Hi, I am new to the db2. Recently I ran into DB2 v8 crash problem often. Below are some error messages found in log file when crash arises. Looks like it is a semaphores issue based on log messages. The db2 is hosted in linux.I list information below. appreciate someone can help me on this issue. [...] 512 187 13_Re: DB2 error12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 29 Sep 2008 16:38:19 -0700320_us-ascii try turning off some of your event monitors. It looks like it choked getting memory starting a new one. I wouldn't depend on Control Center to show all the active ones to you, either. Look in SYSEVENTMONITOR and see which ones are active.

--- On Mon, 9/29/08, Paul Chang wrote: [...] 700 233 52_Re: Pinning a z/OS DB2 table in memory to reduce I/O13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Mon, 29 Sep 2008 17:32:58 -0700541_us-ascii Ray, if you are talking about storing an entire table in memory, I have done that as far back as version 5, and it's a piece of cake. We had a table suffering terrible "death by random I/O". I merely assigned its tablespace to an unused bufferpool, and made that pool large enough to hold the entire table. The tricky part is that you cannot exceed the actual storage of your operating system minus all other tasks' working sets. You may need the help of your sysprog to determine how much room you have -- trust me, it is NOT [...] 934 32 52_Re: Pinning a z/OS DB2 table in memory to reduce I/O11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 30 Sep 2008 00:45:49 +0000368_Windows-1252 >I merely assigned its tablespace to an unused bufferpool, and made that pool large enough to hold the entire table. >The tricky part is that you cannot exceed the actual storage of your operating system minus all other tasks' working sets. >You may need the help of your sysprog to determine how much room you have -- trust me, it is NOT unlimited. [...] 967 55 52_Re: Pinning a z/OS DB2 table in memory to reduce I/O10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Tue, 30 Sep 2008 08:39:55 +0200356_US-ASCII I did in the past, for a (relatively) small table very used by transactions. A quick study via IFCIDs to see if it could have been useful and we isolated it in its own BP (it's somewhat 'artificial').

This is different from pagefix option in V8 (parameter at system level), which could lead to some problem if memory is over-utilized. [...] 1023 63 19_DB2-L EDMPOOL IFCID13_Laila hosaini19_lshosaini@YAHOO.COM31_Mon, 29 Sep 2008 23:43:39 -0700613_iso-8859-1





HI Dear listers

some times we got edmpool full message,Following message:

DSNT500I +DSNM DSNGEPLC RESOURCE UNAVAILABLE 997 REASON 00C90089 TYPE 00000600 NAME EDM POOL SPACE

I'm interest to know about EDMPOOL events and what is the cause. Please tell me proper ICFID,I have tried ICFID 255,217,317,316,318. Thanks in Advance. L.S.H

______________________________________________________________________

* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________ 1087 28 23_Re: DB2-L EDMPOOL IFCID12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Tue, 30 Sep 2008 09:19:45 +0000266_utf-8 Hi Laila. Have you got a STATISTICs trace turned on? If you not you need to start one with at least classes 1, 3, 5 & 5.

Take a look at the IFCID documentation in DSNWMSGS in SDSNSAMP. A search on EDM will take you to relevant IFCIDs such as 0002. [...] 1116 149 23_Re: DB2-L EDMPOOL IFCID15_Debabrata Ghosh21_the_ghosh@HOTMAIL.COM31_Tue, 30 Sep 2008 11:37:36 -0400689_iso-8859-1

IFCID 2 , (29,30) and 31 should give you enough detail on EDM pool. IFCID 31 should be able to report on EDM Full condition







Date: Mon, 29 Sep 2008 23:43:39 -0700From: lshosaini@YAHOO.COMSubject: [DB2-L] DB2-L EDMPOOL IFCIDTo: DB2-L@www.idugdb2-l.org









HI Dear listers

some times we got edmpool full message,Following message:

DSNT500I +DSNM DSNGEPLC RESOURCE UNAVAILABLE 997 REASON 00C90089 TYPE 00000600 NAME EDM POOL SPACE I'm interest to know about EDMPOOL events and what is the cause. Please tell me proper ICFID,I have tried ICFID 255,217,317,316,318. Thanks in Advance. L.S.H [...] 1266 32 54_Catalog online reorg. criteria - SMS stogroup vs. VCAT3_K M25_kapilmathur2000@YAHOO.COM31_Tue, 30 Sep 2008 18:34:43 +0000566_utf-8 Hello,

I am at a DB2 on z/OS V8 shop with a VCAT-based DB2 Catalog. I wanted feedback/guidance re: the following .. What is generally accepted industry criteria to reorganize catalog & directory tablespaces? Is there the usual performance downside to not reorganizing them (as there is with application tablespaces) ? Do most DB2 (on z/OS) shops run online reorgs against DSNDB06 tablespaces? Is it advisable to convert the DB2 Catalog to SMS stogroup based vs. letting it remain VCAT-based? Are there any gotchas to keep in mind if one does this? [...] 1299 57 58_Re: Catalog online reorg. criteria - SMS stogroup vs. VCAT14_Wayne Driscoll22_wdriscoll8@COMCAST.NET31_Tue, 30 Sep 2008 14:51:47 -0500566_utf-8 Remember that STOGROUP has two separate meanings, one in the SMS world, and a second, separate meaning within DB2. While you cannot change the catalog to be DB2 STOGROUP managed (it must be VCAT defined), you can have the DSNDB06 and DSNDB01 datasets on SMS managed volumes but that simply means that the datasets have a storage class assigned. In order to use online reorg with the catalog, you must define the "J" copies of the datasets manually before you run the reorg. As far as how often the REORG needs to be run, remember that from DB2 V1 through [...] 1357 112 7_Goodbye14_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Tue, 30 Sep 2008 17:37:48 -0500522_iso-8859-1 Much to Rick Weaver's delight I am finally signing off!

Having worked from IMS/360 V2 (first with logical relationships) and DB2 since 1982 (19 years with IBM) then with BMC and latterly with CDB it has been a spectacular database journey via IMS/370 1.1.1 (aka cripple one) through DB2 making 50 tx/sec on a 3033 (Ted Codd sent 50 roses to Marilyn Bohl, then DB2 development manager) and the DB2 V5/6 and Y2K saga. DB2's 25th anniversary seems an appropriate time to give up the green screen life. [...] 1470 317 11_Re: Goodbye12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Tue, 30 Sep 2008 18:40:34 -0500525_US-ASCII Sniff. You'll be missed.





I still use your 'rapid replication of rubbish' when talking about remote disk mirroring for DR.





Please do stay in touch.





Rick Weaver Product Manager DB2 z/OS Solutions BMC Software

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Andy Lankester Sent: Tuesday, September 30, 2008 5:38 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Goodbye [...] 1788 298 11_Re: Goodbye12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 30 Sep 2008 18:50:04 -0500726_US-ASCII Good-bye Andy and good luck.





Gerald Hodge

HLS Technologies, Inc.





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Andy Lankester Sent: Tuesday, September 30, 2008 5:38 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Goodbye





Much to Rick Weaver's delight I am finally signing off!

Having worked from IMS/360 V2 (first with logical relationships) and DB2 since 1982 (19 years with IBM) then with BMC and latterly with CDB it has been a spectacular database journey via IMS/370 1.1.1 (aka cripple one) through DB2 making 50 tx/sec on a 3033 (Ted Codd sent 50 roses to Marilyn Bohl, then DB2 development [...]