1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2009, week 1 2 84 25_Re: Database Cleanup List16_mocion@libero.it16_mocion@LIBERO.IT30_Sun, 2 Aug 2009 20:55:05 +0200364_ISO-8859-1 Hi Jim

From 'DB2 9 for z/OS Technical Overview' :

"When you DROP a *clone* table, DB2 removes all associated SYSCOPY entries. This is different than what happens as result of a DROP of a base table.* However, as for base tables, DB2 does not delete SYSLGRNX information until the DBID/PSIDs are reused for a subsequent table space.*" [...] 87 33 18_REORG Switch Phase4_Anil21_alisha_kale@YAHOO.COM30_Sun, 2 Aug 2009 22:17:18 +0000374_utf-8 Env: DB2 V9 for z/OS Hi All !

One of my REORG jobs (SHRLEVEL REFERENCE) failed in the SWITCH phase, with a reason code of X'00C90080'. It was because the TS was in RO. I would have thought that I could RESTART(PHASE) after I start the TS in UT mode. However, I see that it restarted from the UNLOAD phase. Please help me understand what am I missing here. [...] 121 233 41_Re: Antwort: [DB2-L] Cost of Physical I/O14_John Mitchelle29_john.mitchelle@GOOGLEMAIL.COM30_Mon, 3 Aug 2009 10:57:42 +0100282_ISO-8859-1 How about Processor Cost of physical I/O ? Most of the DBA expert advise to reduce the I/O to reduce the CPU Usage ? However, in mainframe I/O processing is done via channel processors then how can we say that there is less CPU utilisation due to reduced I/O ? John [...] 355 365 58_Antwort: Re: [DB2-L] Antwort: [DB2-L] Cost of Physical I/O11_Roy Boxwell16_R.Boxwell@SEG.DE30_Mon, 3 Aug 2009 12:04:49 +0200498_ISO-8859-1 the IO itself is done by channel and/or the hardware but the decision "Is this row for me?" is done by your CPU...so reduce IO reduce CPU...





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

Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert [...] 721 495 62_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] Cost of Physical I/O11_Mike Turner19_mike.turner@GMX.COM30_Mon, 3 Aug 2009 11:50:02 +0100376_iso-8859-1 And there is cost associated with the I/O itself. CPU is needed to set up the channel program and initiate the I/O. CPU is also needed to handle I/O completion when it is signalled by the channel.

I often found, when turning on DB2 compression, that the additional CPU needed for compression is more than balanced by the CPU reduction from reduced I/O. [...] 1217 287 62_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] Cost of Physical I/O12_Isaac Yassin20_yassini@BEZEQINT.NET30_Mon, 3 Aug 2009 15:46:24 +0300605_iso-8859-1 DITTO

Isaac Yassin

---- Original message ---- >Date: Mon, 3 Aug 2009 11:50:02 +0100 >From: Mike Turner >Subject: Re: [DB2-L] Antwort: Re: [DB2-L] Antwort: [DB2- L] Cost of Physical I/O >To: DB2-L@WWW.IDUGDB2-L.ORG > > And there is cost associated with the I/O itself. > CPU is needed to set up the channel program and > initiate the I/O. CPU is also needed to handle I/O > completion when it is signalled by the channel. > > I often found, when turning on DB2 compression, that > the additional CPU needed for compression is more > than balanced by the [...] 1505 768 67_Re: Antwort: Re: [DB2-L] Antwort: Re: [DB2-L] Database Cleanup List15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Mon, 3 Aug 2009 09:22:17 -0400719_iso-8859-1 LOL... Thanks this gave me a good laugh. J











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





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: Thursday, July 30, 2009 12:27 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Antwort: Re: [DB2-L] Antwort: Re: [DB2-L] Database Cleanup List [...] 2274 97 59_Re: AW: [DB2-L] [JOB] DBA opportunity in Northwest Arkansas17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Mon, 3 Aug 2009 16:21:58 +0100351_utf-8 Interesting.

Must be a DBA thing ;-)

I did not mean a mace, I meant a regular baseball bat, that you sharpen with a big "bat sharpener" thing, like a pencil sharpener, but much bigger.

I leave it to your imagination what use you can put it to...

(apologies for continuing an off-track discussion, by the way)... [...] 2372 209 59_Re: AW: [DB2-L] [JOB] DBA opportunity in Northwest Arkansas10_Roger Hecq18_Roger.Hecq@UBS.COM30_Mon, 3 Aug 2009 13:05:36 -0400419_iso-8859-1 The sharpening is more of a courtesy than a necessity.



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

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dell'Anno, Aurora Sent: Monday, August 03, 2009 11:22 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AW: [DB2-L] [JOB] DBA opportunity in Northwest Arkansas [...] 2582 242 62_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] Cost of Physical I/O16_mocion@libero.it16_mocion@LIBERO.IT30_Mon, 3 Aug 2009 20:29:06 +0200500_ISO-8859-1 DITTO as well.

Even if a car is stopped and not running, you've a fuel consuption. When running, if you use gear, while using it you're consuming fuel even if, in that moment, there's no active propulsion for less than a seconds. If you use gear a lot of time active propulsion is reduced and some of fuel is consumed while using gear (even if your car is actually moving). The same for I/O: channel programs is a program 'communicating' with CPU so it's consumes CPU as well. [...] 2825 32 21_Regarding JDBC driver24_SUBSCRIBE DB2-L Karthick16_karthickn@HCL.IN30_Tue, 4 Aug 2009 12:00:09 +0000323_utf-8 Hi all,

I need information about JDBC drivers and how to find which type of driver exist in our subsystem.I am working in DB2 V8 CM in Z/OS v1.7.

It would be helpful if you refer any books regarding this or send me link.

Thank you all for your support in advance.

Regards, Karthick.N [...] 2858 94 33_AW: [DB2-L] Regarding JDBC driver12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 4 Aug 2009 14:11:38 +0200855_iso-8859-1 Karthick,

try the wonderful "DB2 UDB for z/OS V8 ODBC Guide and Reference (SC18-7423-03)".

You'll find a lot of information here:

http://www-01.ibm.com/support/docview.wss?uid=pub1sc18742303



Any info that anybody can provide on the above would be greatly appreciated.

With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Development and Product Support (E3) Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- THINK GREEN - DON'T PRINT THIS EMAIL UNLESS YOU REALLY NEED TO ! [...] 2953 133 20_Re: Package Versions11_Suresh Sane21_data_arch@HOTMAIL.COM30_Tue, 4 Aug 2009 09:59:28 -0500371_utf-8

George,

Thank you for the plug.

Anil,

In addition to syspackage, you need to worry about the plan_table as well as any "extended" plan_tables if you use them.

As one of the co-authors of this Redbook, I can be more specific. Sample queries B16, 17, and 18 should help.

Holler off-line if you want to discuss further. [...] 3087 35 23_-952 DB2 Connect V9.5 ?12_Bob Jeandron21_bob.jeandron@USDA.GOV30_Tue, 4 Aug 2009 17:54:39 +0000552_utf-8 We are running Db2 Connect V9.5 Unlimited Edition. We are also running DB2 UDB Z/OS V8 NFM. We can't be sure, but it appears that since going from DB2 Connect V8 to V9.5, we are getting -952s on some long running (>30secs) queries. Have reviewed the APAR for new ZPARM, SQLINTRP, and have the default of ENABLE. But, we have been on V8 NFM for about 2 years with no problems. -952s just started, we believe, with DB2 Conn. V9.5. We also have QUERYTIMEOUTINTERVAL = 0 in the db2cli.ini file. Any ideas? Anything new in DB2 Conn V9.5 that may [...] 3123 42 27_Re: -952 DB2 Connect V9.5 ?18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM30_Tue, 4 Aug 2009 14:14:36 -0400431_UTF-8 Bob: I have this same issue open now with IBM as a sev 1. We are running .NET on a windows 2008 server with Db2 Connect v9.5 I just found out that 'querytimeoutinterval=0' is NOT supported for .net applications. And with the 'interrupt' now set to 'Enabled' on Db2 z/OS v8 NFM that is causing our .net apps that run over 30 seconds to get the sql0952n interrupt errors. Seems other apps will work but the .net do not... [...] 3166 60 27_Re: -952 DB2 Connect V9.5 ?12_Kimberly May28_kim.may@THEFILLMOREGROUP.COM30_Tue, 4 Aug 2009 14:30:58 -0400496_utf-8 Are you using .NET as the client application? .NET does not honor querytimeoutinterval. Steve Whittaker of Progress Energy just learned this direct from the IBM Lab developer in response to an identical CritSit (critical situation) problem.

Kim

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bob Jeandron Sent: Tuesday, August 04, 2009 1:55 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] -952 DB2 Connect V9.5 ? [...] 3227 187 41_Re: Antwort: [DB2-L] Cost of Physical I/O14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM30_Tue, 4 Aug 2009 21:19:20 +0000429_utf-8 The relationship between table size and physical I/O cost comes from one of two sources

Access via index. DB2 indexs are b-trees. The number of levels in a b-tree is a function in part of table size. As index levels increase say from 3 levels to 4 levels an extra logical I/O is required to get to the leaf page. Even if the buffer is resident in the buffer pool there can be massive costs in terms of storage. [...] 3415 496 41_Re: Antwort: [DB2-L] Cost of Physical I/O23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Tue, 4 Aug 2009 18:08:03 -0400553_UTF-8 Avram,

Interesting information, but I think you missed John's question.

Mainframe Instructions are necessary to issue an IO to any device.

Eliminating IOs reduces the number of executed instructions, and that saves CPU cost, as well as the IO wait time.

Regards, Joel

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 [...] 3912 80 73_AUTO: Ashvin Amin/Dallas/IBM is out of the office. (returning 08/17/2009)11_Ashvin Amin17_ashvin@US.IBM.COM30_Tue, 4 Aug 2009 22:02:26 -0600475_US-ASCII



I am out of the office until 08/17/2009.

I will be out of the office on Vacation until Aug 17. I will repsond to your messages upon my return.

If you need immediate assistance, please contact Jack Mason at .... masonja@us.ibm.com or my manager, Maureen Kinard at ...mkinard@us.ibm.com



Note: This is an automated response to your message "DB2-L Digest - 4 Aug 2009 to 5 Aug 2009 (#2009-226)" sent on 8/4/09 19:00:02. [...] 3993 103 24_IBM Techsupport web site11_Roy Boxwell16_R.Boxwell@SEG.DE30_Wed, 5 Aug 2009 08:38:53 +0200498_ISO-8859-1 Hi!

Has anyone else noticed that that you cannot search anything anymore? I have been in email contact with IBM support but I was wondering if I missed something or if I am really get too old for all this stuff! What I did until yesterday was enter "5740xyr00" as main search and "select all areas" apart from education and PSP. Now I get 4 items back! Perhaps a friendly "lister" can tell me what I have done wrong or perhaps even IBM will get back in touch and tell me.... [...] 4097 122 38_Different results using SPUFI and ODBC14_Michael Knigge30_Michael.Knigge@SET-SOFTWARE.DE30_Wed, 5 Aug 2009 11:34:06 +0200526_ISO-8859-15 All,



we came accross a somehow strange thing using the z/OS ODBC-API for DB2. Let's have a look at the following SQL:

SELECT O.ORDWERT, ANZAHL FROM (SELECT DPRIEPT.POSY306.ORDWERT, COUNT(*) AS ANZAHL FROM DPRIEPT.POSY306 WHERE DPRIEPT.POSY306.ORDART = 70 AND DPRIEPT.POSY306.ORDWERT > '1' AND EXISTS (SELECT * FROM DPRIEPT.POSY301 WHERE DPRIEPT.POSY301.LAUF = 'E' AND DPRIEPT.POSY301.PRIMAID = DPRIEPT.POSY306.EINSTELLID ) GROUP BY DPRIEPT.POSY306.ORDWERT) AS O ORDER BY O.ORDWERT DESC; [...] 4220 132 57_Re: DB2 Data set OPENS causing severe response time issue19_Humphris,Richard P.24_Richard.Humphris@CNA.COM30_Wed, 5 Aug 2009 09:16:21 -0500613_us-ascii If DSMAX is set too low, you can be closing and re-opening datasets all day. On the production sub-systems my preference is to see zero (or near zero) opens during the prime business hours.

Note: Unless the newer releases of DB2 has fixed this, DB2 (itself) will not make intelligent decisions on which datasets to close when you hit dsmax (it will even close important sysibm.* tablespaces (which it will then immediately reopen, of course). And DB2's preference is to close the oldest dataset first, and therefore SYSIBM.* tablespaces will be the first ones closed the first time the DSMAX [...] 4353 127 49_Re: Locking question - z/OS V8 compatability mode19_Humphris,Richard P.24_Richard.Humphris@CNA.COM30_Wed, 5 Aug 2009 09:16:20 -0500572_us-ascii Or, how about adding a column with a "insert" timestamp... Then the select could be changed to only try fetching rows "inserted" at least one or two minutes ago (or longer)?

Perhaps this predicate would then allow you to exclude the uncommitted rows from locking up your select.

Rich Humphris

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ken Paris Sent: Saturday, July 25, 2009 9:04 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Locking question - z/OS V8 compatability mode [...] 4481 131 57_AW: [DB2-L] Locking question - z/OS V8 compatability mode35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 5 Aug 2009 17:00:06 +0200596_iso-8859-1 Hi

Did you consider activating the ZPARM SKIPUNCI? Then you will not see uncommitted inserted rows. ZPARM only works for row-level-locking.

Mit freundlichen Grüßen Walter Janißen

ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40198 Düsseldorf mailto:walter.janissen@itergo.com

Vorsitzender des Aufsichtsrats: Jürgen Vetter Geschäftsführung: Dr. Bettina Anders (Vorsitzende), Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön. Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...] 4613 356 62_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] Cost of Physical I/O9_Dee Reins21_rcwingman@COMCAST.NET30_Wed, 5 Aug 2009 15:42:05 +0000540_utf-8 I was in a SIG with some DB2 experts, and the guide line to compression was, if there was a 20% savings in disk space, then compression was cheaper than the additional I/O. This was also true for data sharing environments.

Compression has been working fine in my shop.

Dee ----- Original Message ----- From: "Isaac Yassin" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Monday, August 3, 2009 5:46:24 AM GMT -08:00 US/Canada Pacific Subject: Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] Cost of Physical I/O [...] 4970 53 38_Sizing DB2 tablespaces and indexes ???9_Dee Reins21_rcwingman@COMCAST.NET30_Wed, 5 Aug 2009 16:04:18 +0000409_utf-8

We are expanding our DB2 databases to accommodate an acquisition of another company.

In our test systems we load the converted data. I do a runstats on the table space and a stospace on the storage group.

I think that if I use SYSTABLESPACSTATS.NACTIVE that should give the the primary quantity for the tablespaces, and SYINDEXSPACESTATS.ACTIVE will give me the index sizing. [...] 5024 39 42_Re: Different results using SPUFI and ODBC14_Peter Vanroose17_pvanroose@ABIS.BE30_Wed, 5 Aug 2009 16:40:38 +0000363_UTF-8 > My program does the following: >[connection stuff] > >SQLPrepare() >SQLExecute() > >while(done) <=== This should rather be "while (! done)" ... >{ > SQLFetch() > SQLDescribeCol() > SQLGetData() >} > >[disconnection stuff]

Could this "while" loop be the culprit? Where and how is "done" set?

-- Peter Vanroose ABIS Training & Consulting [...] 5064 262 42_Re: Sizing DB2 tablespaces and indexes ???14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 5 Aug 2009 12:44:05 -0400359_us-ascii I'm lazier than you are: I think this kind of accuracy is only important for your dozen or so largest tablespaces; for the rest, set a size to the nearest million rows and set "SECQTY -1". It'll save you just oodles of work.

For the largest tablespaces, count the number and size of datasets and allocate based on what you see in DSLIST. [...] 5327 336 42_Re: Sizing DB2 tablespaces and indexes ???22_Leslie Pendlebury-Bowe21_db2dba@BTINTERNET.COM30_Wed, 5 Aug 2009 17:54:48 +0100389_us-ascii Phil

the -1 was introduced to allow us to become lazy, the thing is it "works" and works "well". Well in my shop it does ;-)

I remember discussing the the maths/rules behind it with john Campbell in 2004 and I wondered if it would ever work, but it is a blessing that little setting and real success story that never seems to get much press, well until now :-) [...] 5664 185 42_Re: Sizing DB2 tablespaces and indexes ???10_Roger Hecq18_Roger.Hecq@UBS.COM30_Wed, 5 Aug 2009 13:44:26 -0400382_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...] 5850 672 42_Re: Sizing DB2 tablespaces and indexes ???15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Wed, 5 Aug 2009 13:50:28 -0400338_us-ascii I've done testing with this as well and found it to be awesome.

I recommend to people to get familiar and comfortable with it to implement at a minimum in test/development environments.

Especially if you have people going off and loading production size data into development tables that have been sized down. [...] 6523 242 42_Re: Sizing DB2 tablespaces and indexes ???12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM30_Wed, 5 Aug 2009 14:46:09 -0500752_UTF-8 Did any of you ALTER all your spaces to SECQTY -1 ? Mark.





"Coleman, Troy L" Sent by: DB2 Data Base Discussion List 08/05/2009 12:51 PM Please respond to DB2 Database Discussion list at IDUG



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject Re: [DB2-L] Sizing DB2 tablespaces and indexes ???











I’ve done testing with this as well and found it to be awesome. I recommend to people to get familiar and comfortable with it to implement at a minimum in test/development environments. Especially if you have people going off and loading production size data into development tables that have been [...] 6766 33 25_Hiperpools and V8 Upgrade16_Michael Woodruff26_michael.woodruff@WUSTL.EDU30_Wed, 5 Aug 2009 19:57:56 +0000323_UTF-8 Hello,

We are a month or so from upgrading our production system to V8 DB2 for z/OS.

I know that hiperpools go away in V8, but I am wondering if anyone knows anything I should look for or if anyone has had a bad experience with respect to hiperpools being converted to bufferpools after upgrading? [...] 6800 71 18_"orphan" datasets?13_Scott Goodell33_scott.goodell@VERIZONBUSINESS.COM30_Wed, 5 Aug 2009 20:15:50 +0000573_utf-8 I noticed a while back some VSAM datasets that looked somewhat like DB2 datasets having the same first three nodes of the name but only having a 4th and 5th node and those two nodes being mostly random characters. Recently I noticed more of these and then did a search across our various logical datacenters and found 25 different ones with varying VCAT and Database node names. Some of these were created as far back as 2002 and others within the past year thus spanning different DB2 versions. Below are a couple of examples of these datasets which have valid [...] 6872 192 22_Re: "orphan" datasets?0_22_sally.mir@WACHOVIA.COM30_Wed, 5 Aug 2009 16:58:39 -04006_UTF-8 7065 490 42_Re: Sizing DB2 tablespaces and indexes ???22_Leslie Pendlebury-Bowe21_db2dba@BTINTERNET.COM30_Wed, 5 Aug 2009 22:05:37 +0100467_us-ascii yes ... and it works.

_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Vickers Sent: 05 August 2009 20:46 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ???





Did any of you ALTER all your spaces to SECQTY -1 ? Mark.





"Coleman, Troy L" Sent by: DB2 Data Base Discussion List [...] 7556 118 28_Re: IBM Techsupport web site10_Todd Burch17_toddburch@MAC.COM30_Wed, 5 Aug 2009 16:50:43 -0500581_ISO-8859-1 Hi Roy. 5740XYR00 is the correct component ID. What link are you using?

Todd DB2 for z/OS Level 2 Tech Support



On Aug 5, 2009, at 1:38 AM, Roy Boxwell wrote:



Hi!

Has anyone else noticed that that you cannot search anything anymore? I have been in email contact with IBM support but I was wondering if I missed something or if I am really get too old for all this stuff! What I did until yesterday was enter "5740xyr00" as main search and "select all areas" apart from education and PSP. Now I get 4 items back! Perhaps a [...] 7675 77 42_Re: Sizing DB2 tablespaces and indexes ???12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 5 Aug 2009 18:05:29 -0700300_us-ascii I've also switched and use PRIQTY = -1 and SECQTY = -1. That way I never have to even worry about the number of rows at any time in the tablespace. 99.999% of the time no problems at all. Once in a while, we have a tablespace hit one of the piecesize limits, 2g, 4g etc. But that's it. [...] 7753 33 45_DB2 z/OS Opportunity at University of Georgia9_Mushtaq P14_mpasha@UGA.EDU30_Thu, 6 Aug 2009 02:49:45 +0000584_UTF-8 Hello, We have a immediate opening for DB2 z/OS DBA Specialist position in Athens, Georgia. If you are interested, please visit the below listed URL. This position will close within a week.

https://www.ugajobsearch.com/applicants/jsp/shared/frameset/Frameset.jsp?time=1249526621696

Also, if you need more information, you can email me at mpasha@uga.edu.

Thanks, Mushtaq Pasha, DBA University of Georgia

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 7787 253 42_Re: Sizing DB2 tablespaces and indexes ???12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM30_Thu, 6 Aug 2009 03:03:27 +0000600_utf-8 Yes we use it...

Cuneyt

AVEA BlackBerry® Servisi ile gönderildi.

-----Original Message----- From: Mark Vickers

Date: Wed, 5 Aug 2009 14:46:09 To: Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ???



Did any of you ALTER all your spaces to SECQTY -1 ? Mark.





"Coleman, Troy L" Sent by: DB2 Data Base Discussion List 08/05/2009 12:51 PM Please respond to DB2 Database Discussion list at IDUG [...] 8041 325 45_Antwort: Re: [DB2-L] IBM Techsupport web site11_Roy Boxwell16_R.Boxwell@SEG.DE30_Thu, 6 Aug 2009 07:05:28 +0200450_ISO-8859-1 I always start here

http://www14.software.ibm.com/webapp/set2/srchBroker/views/srchBroker.jsp?rs=112

Here is what I mailed IBM support about what I get and how to get back the missing data

enter 5740XYR00 as search, make sure you have "Date - newest first", select "all categories", select all boxes apart from "education" and "preventive service planning" click "go"

4 results returned (Should be 1000s!) [...] 8367 24 22_Re: "orphan" datasets?14_Peter Vanroose17_pvanroose@ABIS.BE30_Thu, 6 Aug 2009 10:32:51 +0000533_UTF-8 Just a wild guess... could it be indexes on declared temporary tables?

-- Peter Vanroose, ABIS Training & Consulting.

_____________________________________________________________________

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

_____________________________________________________________________

IDUG Europe Attendee Testimonial- "Conference was superb! Couldn’t fault anything. Very impressed." _____________________________________________________________________ 8392 419 42_Re: Sizing DB2 tablespaces and indexes ???14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Thu, 6 Aug 2009 13:09:53 +0200642_UTF-8 Yes, we did.

Great.... no more space-maintenance.





Patrick Steurs





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Cuneyt Goksu Sent: donderdag 6 augustus 2009 5:03 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ???





Yes we use it...

Cuneyt

AVEA BlackBerry® Servisi ile gönderildi.

________________________________

From: Mark Vickers Date: Wed, 5 Aug 2009 14:46:09 -0500 To: Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ??? [...] 8812 174 29_Re: Hiperpools and V8 Upgrade12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM30_Thu, 6 Aug 2009 08:18:04 -0400406_US-ASCII Michael, We did not encounter any problems. As an aside on the IVP's beware that some of them require a BP8K01 and BP16K01. Other than that no issues. HTH, Jeff





Michael Woodruff Sent by: DB2 Data Base Discussion List 08/05/2009 03:58 PM Please respond to DB2 Database Discussion list at IDUG [...] 8987 533 42_Re: Sizing DB2 tablespaces and indexes ???10_Roger Hecq18_Roger.Hecq@UBS.COM30_Thu, 6 Aug 2009 08:45:21 -0400382_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...] 9521 29 22_Re: REORG Switch Phase11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Thu, 6 Aug 2009 13:08:54 +0000437_utf-8 Hi Anil, What are the keywords you have specified with reorg. As Jobs with the SHRLEVEL REFERENCE, NOSYSREC, and SORTDATA options use RESTART(PHASE) to restart at the beginning of the UNLOAD phase.

Thanks Mukesh Jain Senior DB2 DBA & System programmer. +1 (517) 9801064

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 9551 191 9_RE DSSIZE15_Patrick Hignett32_Patrick.Hignett@SSSWORLDWIDE.COM30_Thu, 6 Aug 2009 14:17:52 +0100331_us-ascii I recently had a load into a partitioned TS with 33 parts, not defined as large, blow up no room in the partition so I changed it to use DSSIZE 4G and the load worked fine. Now some months later we need to load another big chunk of data and it blows up again as we now have more that the 4G in the current partition. [...] 9743 356 13_Re: RE DSSIZE13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM30_Thu, 6 Aug 2009 09:56:30 -0400576_us-ascii I believe that DSSIZE=4G is essentially equivalent to the old LARGE parameter. When you go beyond that to 8G up to 64G, your shop's ACS rules within SMS must allow the physical datasets to have the EA (extended addressing ?) attribute, or the allocation will fail and you cannot created the tablespace. As someone encountered a few weeks ago, the datasets do not get this attribute if you only ALTER the DSSIZE within DB2, you have to go thru dataset allocation somehow, either a new CREATE or maybe a LOAD REPLACE. Also, (and I'm not current on this so someone [...] 10100 288 13_Re: RE DSSIZE10_Roger Hecq18_Roger.Hecq@UBS.COM30_Thu, 6 Aug 2009 10:01:26 -0400382_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...] 10389 1038 42_Re: Sizing DB2 tablespaces and indexes ???15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Thu, 6 Aug 2009 10:20:11 -0400781_us-ascii

I wrote a blog on this "DB2 Sliding Scale Space Allocation" http://ibmsystemsmag.blogs.com/db2utor/2008/02/db2-sliding-sca.html









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





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Hecq Sent: Thursday, August 06, 2009 7:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ??? [...] 11428 1182 42_Re: Sizing DB2 tablespaces and indexes ???14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 6 Aug 2009 10:43:04 -0400430_us-ascii Cripes, Troy, I didn't know that the default for MGEXTSZ is "NO" ! Are you sure? Why would a fixed secondary size be the default?

--Phil Sevetson

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Coleman, Troy L Sent: Thursday, August 06, 2009 10:20 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ??? [...] 12611 1329 42_Re: Sizing DB2 tablespaces and indexes ???15_Coleman, Troy L19_Troy.Coleman@CA.COM30_Thu, 6 Aug 2009 11:00:20 -0400791_us-ascii I just checked. The default is "NO" in DB2 V8 and was changed to "YES" in DB2 9. Sorry I was looking at V8 I think when I wrote this.











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





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Thursday, August 06, 2009 9:43 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ??? [...] 13941 1486 42_Re: Sizing DB2 tablespaces and indexes ???14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 6 Aug 2009 13:30:24 -0400480_us-ascii I went and checked key prodsystem ZPARMs just in case, and my site is on "YES", so I'm covered. I'm glad the default changed, though. Default "YES" means the DBA's job is simpler.

--Phil Sevetson

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Coleman, Troy L Sent: Thursday, August 06, 2009 11:00 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ??? [...] 15428 1441 42_Re: Sizing DB2 tablespaces and indexes ???9_Dee Reins21_rcwingman@COMCAST.NET30_Thu, 6 Aug 2009 18:14:28 +0000435_utf-8 Thank you all.

We are in the process of converting from Version 8 to Version 9.

I will check with my DB2 system programmer to make sure the MGEXTSZ is set to yes.

Dee ----- Original Message ----- From: "Phil Sevetson" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thursday, August 6, 2009 10:30:24 AM GMT -08:00 Tijuana / Baja California Subject: Re: Sizing DB2 tablespaces and indexes ??? [...] 16870 60 29_IBM On Demand Conference 200913_Irwin Deutsch28_ideutsch@PRINCESSCRUISES.COM30_Thu, 6 Aug 2009 11:55:00 -0700341_US-ASCII Hi,

Anyone have any details on the DB2 for z/OS (V9) sessions in Las Vegas this October? I'm curious how technical these sessions are as I have to choose between conferences and classes - and I only get one choice. I couldn't find specifics on the web site.



Regards,

Irwin Deutsch Princess Cruises [...] 16931 50 42_Re: Sizing DB2 tablespaces and indexes ???0_19_tspdba001@GMAIL.COM30_Thu, 6 Aug 2009 19:41:59 +0000509_Windows-1252 Hi,

We tried to do the same on our development environments by setting priqty and secqty to -1 for newly created environments. After the environment was setup, we tried to load the tables and the load jobs took forever to run. So finally we had to cancel the load jobs and altered the priqty and secqty to 720 and 10800 respectively before resubmitting the load jobs. We are not sure how we can make this to work. We checked the MGEXTSZ zparm this set to NO right now. Please advise. [...] 16982 112 42_Re: Sizing DB2 tablespaces and indexes ???10_Roger Hecq18_Roger.Hecq@UBS.COM30_Thu, 6 Aug 2009 16:05:26 -0400511_us-ascii MGEXTSZ should be yes. Read the Install Guide. With MGEXTSZ YES, setting both PRIQTY & SECQTY = -1 works very nicely. Virtually eliminates the hassle of space management.

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

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of tspdba001@GMAIL.COM Sent: Thursday, August 06, 2009 3:42 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Sizing DB2 tablespaces and indexes ??? [...] 17095 395 13_Re: RE DSSIZE13_David Simpson22_dsimpson@THEMISINC.COM30_Thu, 6 Aug 2009 16:35:57 -0400316_us-ascii Once you take care of the extended addressability issues previously mentioned 64G is a good option. We benchmarked this a few years ago and found no difference in performance between 4G and 64G. Once the tablespace is "LARGE" (4G or greater), you have already paid the price for the larger RID length. [...] 17491 121 5_Blogs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 6 Aug 2009 17:03:26 -0400467_us-ascii Today's question: Is there a central aggregation point where someone is collecting the websites of people who blog about DB2 on the Mainframe? (I don't have an objection to LUW bloggers, but their material isn't often useful to mainframe DBAs.) Anyone?

I'm making preparations to start a blog about my efforts to learn non-Mainframe and multiplatform programming and database administration, and I'm wondering what others are doing in the field. [...] 17613 89 9_Re: Blogs11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Thu, 6 Aug 2009 21:06:41 +0000579_Windows-1252 I tend to think BLOGS are narcisstic, and haven't found a reason for them to exist! - Too busy driving to stop for gas!

-----Original Message----- From: "Sevetson, Phil"

Date: Thu, 6 Aug 2009 17:03:26 To: Subject: [DB2-L] Blogs



Today's question: Is there a central aggregation point where someone is collecting the websites of people who blog about DB2 on the Mainframe? (I don't have an objection to LUW bloggers, but their material isn't often useful to mainframe DBAs.) Anyone? [...] 17703 123 57_Re: DB2 Data set OPENS causing severe response time issue10_Dave Barry14_dbarry@UPS.COM30_Thu, 6 Aug 2009 17:15:49 -0400438_us-ascii We have DSMAX settings as high as 80,000. (Had to raise system ENQMAXA to 500,000 to tolerate it.)

We saw data sets being closed at as high a rate as 90/minute. Our problem was excessive CPU. It turned out to be a DASD space management product intercepting every open/close request in the system. We contacted the vendor for a circumvention. After applying a PTF, the difference in CPU consumption was very dramatic. [...] 17827 105 9_Re: Blogs16_Mark Labby - AES21_mlabby@AESSUCCESS.ORG30_Thu, 6 Aug 2009 17:23:46 -0400 17933 154 33_Re: IBM On Demand Conference 200913_Willie Favero21_wfavero@ATTGLOBAL.NET30_Thu, 6 Aug 2009 16:38:38 -0500551_ISO-8859-1 A formal agenda has not been published yet. Abstracts time slots just went out so an agenda can't be too far behind.

I would like to say you will not be disappointed attending IOD, however, everyone has different taste.

I have found presentations in past have always been excellent. My biggest problem has always been which session to attend in each time slot rather than trying to find a session to attend... if you can get hold of an agenda from last year, you can at least get a flavor for what tends to be available. [...] 18088 181 9_Re: Blogs13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Thu, 6 Aug 2009 16:49:45 -0500384_windows-1252 Craig Mullins (http://www.db2portal.com/blog.html) and I (http://it.toolbox.com/blogs/db2zos/) both have blogs that cover DB2 for z/OS. And although I do tend to mention my Grandson occasionally, I do try to minimize stuff about me and concentrate on stuff I think anyone following my blog might be interested although I do tend to occasionally go off the deep end. [...] 18270 159 9_Re: Blogs13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Thu, 6 Aug 2009 16:54:51 -0500350_ISO-8859-1 Phil, if you are seriously considering getting into blogging, you can use one of the free blogging services like Wordpress.com or check out http://it.toolbox.com/blogs/ . This is were my blog is hosted. They are excellent to deal with, very professional, and you would sharing technical blogging space with hundreds of other blogs... [...] 18430 23 41_Doug Holliday/Alcan is out of the office.13_Doug Holliday23_doug.holliday@ALCAN.COM30_Thu, 6 Aug 2009 17:58:30 -0400550_US-ASCII I will be out of the office starting 08/06/2009 and will not return until 08/17/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- "Conference was superb! Couldn’t fault anything. Very impressed." _____________________________________________________________________ 18454 48 9_Re: Blogs14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Fri, 7 Aug 2009 08:02:29 +1000634_ISO-8859-1 You think these are narcisstic and should not exist http://it.toolbox.com/blogs/db2zos http://it.toolbox.com/blogs/db2luw ?

James Campbell

On 6 Aug 2009 at 21:06, Ted MacNEIL wrote:

> > I tend to think BLOGS are narcisstic, and haven't found a reason for them to exist! > - > Too busy driving to stop for gas! > > From: "Sevetson, Phil" > Date: Thu, 6 Aug 2009 17:03:26 -0400 > To: > Subject: [DB2-L] Blogs > Today´s question: Is there a central aggregation point where someone is collecting the websites > of people who blog about DB2 on the Mainframe? (I don´t have an [...] 18503 167 33_Re: IBM On Demand Conference 200915_Kalena, Michael27_Michael.Kalena@JPMORGAN.COM30_Thu, 6 Aug 2009 18:56:33 -0400553_us-ascii You don't want the IBM Conference, they have gone way down in quality and content. Take a class instead.





I offer this to help not to offend and this is just my personal opinion.





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









_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin Deutsch Sent: Thursday, August 06, 2009 2:55 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IBM On Demand Conference 2009 [...] 18671 115 39_Performance issue with a delete process10_Teldb2kals22_teldb2kals@TELSTRA.COM30_Thu, 6 Aug 2009 23:18:17 +0000313_utf-8 Hi,

We are on v8 (NFM). We have a batch process that deletes data from a table based on a timestamp field (timestamp older than, say, 100 days). There is also a parameter that determines the commit count. (for example, if this is 1000, then a commit is performed for every 1000 rows committed). [...] 18787 51 9_Re: Blogs10_Todd Burch17_toddburch@MAC.COM30_Thu, 6 Aug 2009 18:26:00 -0500549_US-ASCII Hi Phil. Several years ago, I too decided I needed to broaden my horizons, and spread out and away from the mainframe. That was circa early '05. My focus was programming, and not so much database administration.

I started with C, then C++, then Java, then in Dec 2006, I bought my first Mac, started learning UNIX, then activated APACHE on my Mac, installed PHP & MYSQL, and so I've been doing this for a while. I've written CGI programs in C to handle FORM data from web pages as well. Last fall, I installed DB2 for Mac on my [...] 18839 35 9_Re: Blogs11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Thu, 6 Aug 2009 23:41:10 +0000663_Windows-1252 Yes ------Original Message------ From: James Campbell Sender: DB2 Data Base Discussion List To: DB2 List ReplyTo: DB2 List Sent: Aug 6, 2009 18:02 Subject: Re: [DB2-L] Blogs

You think these are narcisstic and should not exist http://it.toolbox.com/blogs/db2zos http://it.toolbox.com/blogs/db2luw ?

James Campbell

On 6 Aug 2009 at 21:06, Ted MacNEIL wrote:

> > I tend to think BLOGS are narcisstic, and haven't found a reason for them to exist! > - > Too busy driving to stop for gas! > > From: "Sevetson, Phil" > Date: Thu, 6 Aug 2009 17:03:26 -0400 > To: > Subject: [DB2-L] Blogs > Today´s [...] 18875 128 43_Re: Performance issue with a delete process9_Mike Bell21_mbell11a1@VERIZON.NET30_Thu, 6 Aug 2009 18:56:06 -0500458_us-ascii

Note - this is just a guess - I suspect there is one index that has the timsstamp column in it - as you delete rows, the index gets empty pages. Each time you commit, those empty pages are still there. When you restart, it has to read the index, skipping all the empty index pages. It seems like this can't be the only problem because I doubt that DB2 would have enough empty pages for 7,000 deletes to make a major performance impact. [...] 19004 216 43_Re: Performance issue with a delete process10_Teldb2kals22_teldb2kals@TELSTRA.COM30_Fri, 7 Aug 2009 00:37:20 +0000498_utf-8 Thanks, Mike.

This is a third-party supplied code, so we don't have too much control over it. We do have the option of changing specific procs if needed, but not unless absolutely necessary.

This is not the only table, we have 3-4 other tables with which we have the same problem, and I have now changed the process to use online REORG WITH DISCARD, atleast for the time being. (But the online reorg is also causing a couple of timeouts every day during the final phases). [...] 19221 73 28_Re: IBM Techsupport web site12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 7 Aug 2009 01:13:51 +0000615_utf-8 Sometimes I find that the easier search is on the web, starting at http://www.ibm.com/support/search.wss? rs=64&tc=SSEPEK&dc=DB550&dtm

Roger Miller, DB2 for z/OS

On Wed, 5 Aug 2009 16:50:43 -0500, Todd Burch wrote:

>Hi Roy. 5740XYR00 is the correct component ID. What link are you >using? > >Todd >DB2 for z/OS Level 2 Tech Support > > >On Aug 5, 2009, at 1:38 AM, Roy Boxwell wrote: > > >Hi! > > Has anyone else noticed that that you cannot search anything >anymore? I have been in email contact with IBM support but I was >wondering if I missed something or if [...] 19295 99 13_Re: RE DSSIZE12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 7 Aug 2009 01:29:29 +0000468_utf-8 Here is one small additional point.

If DSSIZE is 64GB and page size is 4KB, then the maximum number of partitions is 256. Some situations call for more partitions. There is a table showing MAXPARTITIONS as a factor of DSSIZE and page size. http://localhost:8801/help/topic/com.ibm.db29.doc.sqlref/db2z_sql_createtabl espace.htm

Roger Miller, DB2 for z/OS

On Thu, 6 Aug 2009 16:35:57 -0400, David Simpson wrote: [...] 19395 75 33_Re: IBM On Demand Conference 200912_Roger Miller19_millerrl@US.IBM.COM30_Fri, 7 Aug 2009 01:37:27 +0000387_utf-8 We have four tracks with 19 one hour slots for the DB2 for z/OS and tools technical program. While the program has not yet gone to press, we have sessions from most of the people you could ask for from customers, Gold consultants, and developers.

Roger Miller, DB2 for z/OS

On Thu, 6 Aug 2009 18:56:33 -0400, Kalena, Michael wrote: [...] 19471 453 43_Re: Performance issue with a delete process9_Ford Wong14_fordie@SHAW.CA30_Thu, 6 Aug 2009 20:26:15 -0600496_us-ascii Hello,

This is a basic guess. Do you have any referrential integrety issues. Eg a dependent table without a supporting index? For each delete of a parent row, DB2 will scan the dependent table(s) to ensure that RI is not violated and this can be very ugly?

Ford

----- Original Message ----- From: Teldb2kals Date: Thursday, August 6, 2009 6:39 pm Subject: Re: [DB2-L] Performance issue with a delete process To: DB2-L@WWW.IDUGDB2-L.ORG [...] 19925 295 43_Re: Performance issue with a delete process10_Teldb2kals22_teldb2kals@TELSTRA.COM30_Fri, 7 Aug 2009 03:15:26 +0000614_utf-8 Thanks, Ford. No, this is not due to RI issues, as the performance hit happens on the select. And that too only after about 6-7 successful quick selects.

Regards, Kals. On Thu, 6 Aug 2009 20:26:15 -0600, Ford Wong wrote:

>Hello, > >This is a basic guess. Do you have any referrential integrety issues. Eg a dependent table without a supporting index? For each delete of a parent row, DB2 will scan the dependent table(s) to ensure that RI is not violated and this can be very ugly? > >Ford > >----- Original Message ----- >From: Teldb2kals >Date: [...] 20221 186 22_Re: "orphan" datasets?24_Ravichandran Krishnasamy26_ravi.krishnasamy@GMAIL.COM30_Thu, 6 Aug 2009 22:44:00 -0500332_windows-1252 Hi Scott, I have seen similar problem in my shop when some of the CDB REORG Utility jobs failed. Orphan Datasets are created by third party DB2 utilities that operate outside DB2 environment like CDB REORG. If these utilities are not terminated correctly, then you might see orphan Datasets.

Thanks, -Ravi. [...] 20408 30 9_Re: Blogs22_Leslie Pendlebury-Bowe21_db2dba@BTINTERNET.COM30_Fri, 7 Aug 2009 09:44:49 +0100308_US-ASCII Can I just say that had it not been for Willie's blogs I would have been up a stream without a paddle on several occasions.

I do not read them every day but I visit monthly and enjoy the posts. I suppose at the end of the day it's the usual, if you don't like them then don't read them. [...] 20439 24 9_Re: Blogs11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Fri, 7 Aug 2009 10:28:09 +0000626_- >I suppose at the end of the day it's the usual, if you don't like them then don't read them.

I don't.

- Too busy driving to stop for gas!

_____________________________________________________________________

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

_____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 20464 120 43_Re: Performance issue with a delete process0_22_agentlease@HOTMAIL.COM30_Fri, 7 Aug 2009 12:02:51 +0100528_UTF-8 Hi,

I performed a similar operation for a client in the UK to delete 1 billion rows.

I used a simple method of deleting 500 rows at a time. The delete process ran 24 hours a day and had no impact on the database and thus no locking contention.

Thanks



----- Original Message ----- From: "Teldb2kals" Newsgroups: bit.listserv.db2-l To: Sent: Friday, August 07, 2009 12:18 AM Subject: [DB2-L] Performance issue with a delete process [...] 20585 204 9_Re: Blogs14_Lyon, Lockwood20_Lockwood.Lyon@53.COM30_Fri, 7 Aug 2009 08:11:38 -0400659_us-ascii I blog on mainframe DB2 database adminstration at:

http://it.toolbox.com/blogs/database-administration/

- Lock Lyon



________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Thursday, August 06, 2009 5:03 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Blogs





Today's question: Is there a central aggregation point where someone is collecting the websites of people who blog about DB2 on the Mainframe? (I don't have an objection to LUW bloggers, but their material isn't often useful to mainframe DBAs.) Anyone? [...] 20790 97 13_Re: RE DSSIZE16_Bruce Williamson21_DBA@WILLIAMSON.NET.AU30_Fri, 7 Aug 2009 13:02:47 +0100615_utf-8 Howzit Roger?

Please will you send that link again as it appears to be a bit mangled in my email.

Cheers Bruce

On Friday 07 August 2009 02:29:29 Roger Miller wrote: > Here is one small additional point. > > If DSSIZE is 64GB and page size is 4KB, then the maximum number of > partitions is 256. Some situations call for more partitions. There is a > table showing MAXPARTITIONS as a factor of DSSIZE and page size. > http://localhost:8801/help/topic/com.ibm.db29.doc.sqlref/db2z_sql_createtab >l espace.htm > > Roger Miller, DB2 for z/OS > > On Thu, 6 Aug 2009 16:35:57 -0400, David [...] 20888 59 51_Will CA Insight read Audit trace records from SMF ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Fri, 7 Aug 2009 18:00:53 +0530313_US-ASCII Hello List,

I am trying to figure out if CA's Insight has any program (like NSIGHTRW) that would read audit trace records from SMF ? I would also be interested to hear or know what other (vendor) products that are available and good for achieving this. As of now, I just of IBM's PE for DB2. [...] 20948 256 9_Re: Blogs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 7 Aug 2009 09:44:24 -0400426_us-ascii Ted, in that case please don't read my blog and definitely don't comment on it. --Phil Sevetson

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL Sent: Thursday, August 06, 2009 5:07 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs

I tend to think BLOGS are narcisstic, and haven't found a reason for them to exist! [...] 21205 369 9_Re: Blogs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 7 Aug 2009 09:48:12 -0400448_us-ascii Funny. Five minutes ago I saw your latest post appear in a keyword summary from ittoolbox, and subscribed to your blog. Small world.

--Phil S,

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lyon, Lockwood Sent: Friday, August 07, 2009 8:12 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs

I blog on mainframe DB2 database adminstration at: [...] 21575 323 9_Re: Blogs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 7 Aug 2009 09:49:37 -0400666_us-ascii I've requested a blogspot from ittoolbox. They say I'll have one within a few days.

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Thursday, August 06, 2009 5:55 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs

Phil, if you are seriously considering getting into blogging, you can use one of the free blogging services like Wordpress.com or check out http://it.toolbox.com/blogs/ . This is were my blog is hosted. They are excellent to deal with, very professional, and you would sharing technical blogging space with hundreds of other blogs... [...] 21899 28 44_Paul P Packham/GIS/CSC is out of the office.14_Paul P Packham16_ppackham@CSC.COM30_Fri, 7 Aug 2009 14:48:55 +0100357_US-ASCII I will be out of the office starting 07/08/2009 and will not return until 17/08/2009.

I'm on Leave, returning 17th August. For urgent queries please contact Mick Graley on +44(0)1246214871, otherwise I will respond when I return. For a Union query please contact Colin W Walker or any of the other reps. Colin's number is 01246 21 4699 [...] 21928 83 9_Re: Blogs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 7 Aug 2009 09:54:18 -0400323_us-ascii Todd, I'm taking a path similar to yours, but staying on Intel machines. If I go to Apache it'll be through building a LAMP (Linux/Apache/MySQL/PHP) server. Right now, I'm working in C -- fascinating language -- and will be following on with C++ when I'm satisfied with my progress in C, and Java after that. [...] 22012 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:46 -0400332_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] RE DSSIZE" sent on 8/7/09 8:02:47 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 22042 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:46 -0400477_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 4:44:49 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 22072 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:46 -0400477_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 6:28:09 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 22102 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:46 -0400477_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 8:11:38 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 22132 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:46 -0400362_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Performance issue with a delete process" sent on 8/7/09 7:02:51 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 22162 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:47 -0400477_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 9:44:24 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 22192 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:46 -0400370_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "[DB2-L] Will CA Insight read Audit trace records from SMF ?" sent on 8/7/09 8:30:53 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 22222 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:47 -0400477_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 9:48:12 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 22252 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:47 -0400477_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 9:54:18 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 22282 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:47 -0400477_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 9:49:37 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 22312 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 10:01:47 -0400363_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "[DB2-L] Paul P Packham/GIS/CSC is out of the office." sent on 8/7/09 9:48:55 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 22342 199 9_Re: Blogs12_jim harrison24_jimh_listsub@VERIZON.NET30_Fri, 7 Aug 2009 10:05:19 -0400311_ISO-8859-1 C is a strange creature. I learned it in the late 80's/early 90s. I actually wrote a DOS directory utility that I released as shareware on the Fidonet BBS backbone. There was actually a mainframe BBS echo back then. I forget who all was on there, but there were some DB2 DBAs I found out later. [...] 22542 286 55_Re: Will CA Insight read Audit trace records from SMF ?13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM30_Fri, 7 Aug 2009 10:18:19 -0400931_iso-8859-1 Hello Bala, Have you tried a report using IBM PE for DB2 ? This is what we run on a daily basis:

//DB2AUDIT EXEC PGM=DB2PM //STEPLIB DD DSN=SYSMVS.OMEGAMON.SYSB.RKANMODU,DISP=SHR // DD DSN=SYSMVS.OMEGAMON.BASE.RKANMOD,DISP=SHR //*STEPLIB DD DSN=SYSDB.DB2PM.SDGOLOAD,DISP=SHR //INPUTDD DD DSN=MXG.PDBMVS.DB2SMF(+0),DISP=SHR //DPMLOG DD SYSOUT=*,DCB=BLKSIZE=133 //SYSOUT DD SYSOUT=*,DCB=BLKSIZE=133 //JOBSUMDD DD SYSOUT=*,DCB=BLKSIZE=133 //AURPTDD DD DSN=SYSDB.PROD.DB2AUDIT.DAILY(+1),DISP=(,CATLG), // DCB=(RECFM=FBA,LRECL=133,BLKSIZE=0), // UNIT=(SYSALLDA,3),SPACE=(CYL,(450,450),RLSE) //MSGRPTDD DD SYSOUT=*,DCB=BLKSIZE=133 //SYSPRINT DD SYSOUT=*,DCB=BLKSIZE=133 //SYSUDUMP DD SYSOUT=*,DCB=BLKSIZE=133 //AUDWORK DD SPACE=(CYL,(1000,500),,CONTIG),UNIT=(SYSDA,6) //$ORTPARM DD DSN=MXG.PROD.PARMLIB(DYNALOC),DISP=SHR //SYSIN DD * AUDIT REDUCE REPORT LEVEL(SUMMARY) REPORT LEVEL(DETAIL) TYPE(ALL) DB2PM EXEC /* [...] 22829 314 55_Re: Will CA Insight read Audit trace records from SMF ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Fri, 7 Aug 2009 19:57:25 +0530485_US-ASCII Hello Kirk,

I would love to, if we have one :-) We just have CA's Insight for Performance Monitoring. If it doesn't have this capability, we may have to think of PE.

Thanks for your response.

Regards, Bala.









"Hampton, Kirk" Sent by: DB2 Data Base Discussion List 07/08/2009 19:48 Please respond to DB2 Database Discussion list at IDUG [...] 23144 79 9_Re: Blogs9_Don Leahy19_don.leahy@LEACOM.CA30_Fri, 7 Aug 2009 10:29:18 -0400661_windows-1252 Try http://db2usa.blogspot.com/

No narcissism there; very little narrative at all, in fact. The blog contains a frequently updated list of links to interesting articles DB2 written by IBM and others.



On Thu, Aug 6, 2009 at 7:41 PM, Ted MacNEIL wrote: > Yes > ------Original Message------ > From: James Campbell > Sender: DB2 Data Base Discussion List > To: DB2 List > ReplyTo: DB2 List > Sent: Aug 6, 2009 18:02 > Subject: Re: [DB2-L] Blogs > > You think these are narcisstic and should not exist > http://it.toolbox.com/blogs/db2zos > http://it.toolbox.com/blogs/db2luw > ? > > James Campbell > > On [...] 23224 404 55_Re: Will CA Insight read Audit trace records from SMF ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Fri, 7 Aug 2009 20:16:16 +0530512_US-ASCII I just found myself that Insight has the capability to display audit traces too. Sorry for bothering you all.

Cheers, Bala.









Balachandran Chandrasekaran1/India/IBM@IBMIN Sent by: DB2 Data Base Discussion List 07/08/2009 19:57 Please respond to DB2 Database Discussion list at IDUG



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject Re: [DB2-L] Will CA Insight read Audit trace records from SMF ? [...] 23629 999 55_Re: Will CA Insight read Audit trace records from SMF ?16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Fri, 7 Aug 2009 10:52:46 -0400283_us-ascii Cheers Bala - you are absolutely correct Insight can do this. In fact we provide a couple of different methods to accomplish this. Either in a batch reporting job - or we can import the SMF data into a DB2 table so you can use SQL / IQL to generate the needed reports. [...] 24629 126 9_Re: Blogs7_Ed Long19_rdhm99a@PRODIGY.NET30_Fri, 7 Aug 2009 07:58:41 -0700490_utf-8 The internet and its spawn, like blogs, are one of the greatest forces in history for ensuring free speech. Much like vanity publishing, any one can do it. Unlike vanity publishing, its effectively free to blog.

Free speech doesn't necessarily equate to useful information; I offer as exhibit A, The Drudge report, essentially a blog that makes money and news even if its often incorrect. Self promotion is not necessarily narcissitic, it's just bidness (Texas spelling). [...] 24756 406 55_Re: Will CA Insight read Audit trace records from SMF ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Fri, 7 Aug 2009 20:29:25 +0530543_UTF-8 Hi Steen, Thanks for the prompt reply. I do have several IQL requests that capture performance data. I did not notice the sample requests AUDCL* provided with R11.5. I was just too fast to ask, I think.

I am now exploring them to use them on batch.

Thanks once again.











"Rasmussen, Steen" Sent by: DB2 Data Base Discussion List 07/08/2009 20:22 Please respond to DB2 Database Discussion list at IDUG [...] 25163 12 9_Re: Blogs11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Fri, 7 Aug 2009 15:03:09 +0000167_Windows-1252 >Ted, in that case please don’t read my blog and definitely don’t comment on it.

Never have even looked for it. - Too busy driving to stop for gas! 25176 74 9_Re: Blogs10_Todd Burch17_toddburch@MAC.COM30_Fri, 7 Aug 2009 10:14:15 -0500496_US-ASCII A great resource that I used / use with C is the forum here: http://cboard.cprogramming.com/c-programming/

You can back up higher in their directory structure to get to the C++ forums, and others as well. They have a few tutorials that are good, and lots of good snippets for common programming tasks. Some folks are quite pedantic regarding syntax, cross platform compatibility and ANSI compliancy, but otherwise, most are very helpful. Lots of Intel programmers there too. [...] 25251 96 9_Re: Blogs10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV30_Fri, 7 Aug 2009 10:17:48 -0500417_us-ascii This would be a great conversation to have on one of the blogs.........

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Todd Burch Sent: Friday, August 07, 2009 10:14 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs

A great resource that I used / use with C is the forum here: http://cboard.cprogramming.com/c-programming/ [...] 25348 25 9_Re: Blogs10_Todd Burch17_toddburch@MAC.COM30_Fri, 7 Aug 2009 10:25:36 -0500638_US-ASCII This is a tough group...

On Aug 7, 2009, at 10:17 AM, Irwin, Jim wrote:

This would be a great conversation to have on one of the blogs.........

_____________________________________________________________________

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

_____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 25374 53 9_Re: Blogs13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Fri, 7 Aug 2009 17:34:12 +0200450_us-ascii Yeah, but if you can make it here you can make it anywhere. It's up to you, Todd Burch, Tooood Buuuuurch!! With apologies to Ol' Blue Eyes - and anyone else out there wot reads this.

Hey, it's Friday.



Raymond

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Todd Burch Sent: 07 August 2009 16:26 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs [...] 25428 46 9_Re: Blogs10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV30_Fri, 7 Aug 2009 10:34:42 -0500452_us-ascii It's full of bitter, scarred and beat-down dinosaurs :)

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Todd Burch Sent: Friday, August 07, 2009 10:26 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs

This is a tough group...

On Aug 7, 2009, at 10:17 AM, Irwin, Jim wrote:

This would be a great conversation to have on one of the blogs......... [...] 25475 118 9_Re: Blogs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 7 Aug 2009 11:44:43 -0400374_us-ascii I'm done talking about it for now but I'll be blogging about it when I get started. Not in this forum, as I mostly won't be talking about DB2.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: Friday, August 07, 2009 11:18 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs [...] 25594 171 9_Re: Blogs10_Roger Hecq18_Roger.Hecq@UBS.COM30_Fri, 7 Aug 2009 11:51:43 -0400566_iso-8859-1 You can always ask Willie about his 'cycle



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

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ed Long Sent: Friday, August 07, 2009 10:59 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Blogs

The internet and its spawn, like blogs, are one of the greatest forces in history for ensuring free speech. Much like vanity publishing, any one can do it. Unlike vanity publishing, its effectively free to blog. [...] 25766 54 79_Jos=?ISO-8859-1?Q?=E9_Ram=F3n_V=E1zquez_Alonso_est=E1_?= ausente de la oficina.25_Jose Ramon Vazquez Alonso25_jrvazqueza@BANCOPASTOR.ES30_Fri, 7 Aug 2009 18:02:32 +0200621_ISO-8859-1



Estaré ausente de la oficina desde el 07/08/2009 y no volveré hasta el 07/09/2009.

Responderé a su mensaje cuando regrese. _____________________________________________________________________

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

_____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 25821 333 9_Re: Blogs13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Fri, 7 Aug 2009 11:13:07 -0500659_ISO-8859-1 Phil,

Make you post a link here for us to follow once you get your initial post out of the way... and if you need any assistance with ittoolbox, please ask.. they have hosted my blog for quite a few years now.

Good luck

Willie

Sevetson, Phil wrote: > > I've requested a blogspot from ittoolbox. They say I'll have one > within a few days. > > > > ------------------------------------------------------------------------ > > *From:* DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] *On > Behalf Of *Willie Favero > *Sent:* Thursday, August 06, 2009 5:55 PM > *To:* DB2-L@WWW.IDUGDB2-L.ORG > *Subject:* Re: [...] 26155 60 17_IRLM LOCK REQUEST9_Dinu Paul21_dinucpaul@YAHOO.CO.IN30_Fri, 7 Aug 2009 16:05:15 +0000368_utf-8 Hi All,

One of our system is giving IRLM locks while running too many utilities together. Most of them are LOAD utilities.

We are in DB2 z/OS V8 in a data sharing environment.

Application team is running more than 1k LOAD jobs everyday and some of them are failing with below messages and it will put the TS into recoverpending status. [...] 26216 108 21_Re: IRLM LOCK REQUEST13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Fri, 7 Aug 2009 11:31:04 -0500377_us-ascii Take a look at the size of your SYSUTILX directory space -- if it seems excessively large then take a look at PK83996/UK46749. We went through a rash of this a few months ago as DB2 is apparently holding the UTSERIAL lock while referencing SYSUTILX, which was growing uncontrollably. Assuming this is the issue you can work around it by re-initializing SYSUTILX. [...] 26325 162 17_DB2 9 Family Test14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 7 Aug 2009 12:48:03 -0400570_us-ascii Okay, I think I've got it down to merely aggravated from a basis of infuriated.

Someone in the know, please tell me: why are DB2 z/OS DBAs expected to pass a test which is almost totally about DB2 LUW (If you believe the book by Roger Sanders)? I'm going through Sanders' book DB2 9 Fundamentals: Certification Study Guide, and in the chapters about DCL and DDL and databases and there's almost no information about z/OS (in the DCL chapter he politely notes that several of the things we're being taught to do don't work on DB2 for zSeries and DB2 [...] 26488 206 9_Re: Blogs15_Leon Katsnelson15_leon@CA.IBM.COM30_Fri, 7 Aug 2009 10:47:54 -0400640_US-ASCII

I guess to each his own.

I find that I get most of my best information from blogs not traditional media. I also find that I learn the most interesting bits from blogs an twitter (which drives me to blogs). I guess I am different because I am always looking at the technologies that are up and coming not stable stuff that has been there for a long time and is documented in minute details in the product docs. However, even for stable well documented stuff I find that blogs run by consultants Dave Beulke (http://davebeulke.com/), Robert Catterall (http://www.catterallconsulting.com/roberts_blog.html), Craig [...] 26695 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 10:05:19 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 26725 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 10:29:18 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 26755 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400375_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Will CA Insight read Audit trace records from SMF ?" sent on 8/7/09 10:59:25 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 26785 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400375_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Will CA Insight read Audit trace records from SMF ?" sent on 8/7/09 10:27:25 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 26815 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400375_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Will CA Insight read Audit trace records from SMF ?" sent on 8/7/09 10:18:19 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 26845 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 10:58:41 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 26875 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:14:15 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 26905 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:25:36 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 26935 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400375_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Will CA Insight read Audit trace records from SMF ?" sent on 8/7/09 10:46:16 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 26965 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:17:48 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 26995 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400341_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] IRLM LOCK REQUEST" sent on 8/7/09 12:31:04 PM.

You will receive a notification for each message you send to this person while the person is away. [...] 27025 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:51:43 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 27055 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:03:09 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 27085 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:47 -0400375_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Will CA Insight read Audit trace records from SMF ?" sent on 8/7/09 10:52:46 AM.

You will receive a notification for each message you send to this person while the person is away. [...] 27115 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:34:12 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 27145 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:34:42 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 27175 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400337_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "[DB2-L] IRLM LOCK REQUEST" sent on 8/7/09 12:05:15 PM.

You will receive a notification for each message you send to this person while the person is away. [...] 27205 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 11:44:43 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 27235 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 12:13:07 PM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 27265 33 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400445_ISO-8859-1 I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "[DB2-L] José Ramón Vázquez Alonso está ausente de la oficina." sent on 8/7/09 12:02:32 PM.

You will receive a notification for each message you send to this person while the person is away. _____________________________________________________________________ [...] 27299 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400478_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "Re: [DB2-L] Blogs" sent on 8/7/09 10:47:54 AM.

You will receive a notification for each message you send to this person while the person is away.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 27329 29 72_AUTO: Bud Greenman/IT/ONGOV is out of the office. (returning 08/17/2009)0_21_BudGreenman@ONGOV.NET30_Fri, 7 Aug 2009 16:02:48 -0400337_US-ASCII I am out of the office until 08/17/2009.

I will respond to your message when I return.



Note: This is an automated response to your message "[DB2-L] DB2 9 Family Test" sent on 8/7/09 12:48:03 PM.

You will receive a notification for each message you send to this person while the person is away. [...] 27359 93 23_SQL to remove dupes. ??9_Dee Reins21_rcwingman@COMCAST.NET30_Fri, 7 Aug 2009 22:21:58 +0000727_utf-8

I am trying to identify duplicates . The SQL is wroing but I can't see to figure out why

Please help :-(





SELECT DISTINCT FK_TCPSERQASR_NBR, FK_TCPCIRCDSGNID , COUNT(FK_TCPCIRCDSGNID) OCCURS FROM CTCPXD.TCPCKCD ORGA WHERE OCCURS > 1 GROUP BY FK_TCPSERQASR_NBR, FK_TCPCIRCDSGNID ORDER BY FK_TCPSERQASR_NBR, FK_TCPCIRCDSGNID WITH UR ; DSNT408I SQLCODE = -206, ERROR: OCCURS IS NOT VALID IN THE CONTEXT WHERE IT IS USED DSNT418I SQLSTATE = 42703 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXORSO SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL [...] 27453 185 27_Re: SQL to remove dupes. ??13_David Simpson22_dsimpson@THEMISINC.COM30_Fri, 7 Aug 2009 18:27:52 -0400338_iso-8859-1 No DISTINCT is necessary here as the GROUP BY will take care of that. I think you also want COUNT(*) instead of a column name as an argument. Whenever you filter on a column function (an aggregate), it goes in the HAVING instead of the WHERE. You can think of the HAVING as a WHERE clause that happens AFTER the grouping. [...] 27639 196 27_Re: SQL to remove dupes. ??9_Dee Reins21_rcwingman@COMCAST.NET30_Fri, 7 Aug 2009 22:53:04 +0000608_utf-8 thank you that worked.

Dee ----- Original Message ----- From: "David Simpson" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, August 7, 2009 3:27:52 PM GMT -08:00 Tijuana / Baja California Subject: Re: SQL to remove dupes. ??





No DISTINCT is necessary here as the GROUP BY will take care of that. I think you also want COUNT(*) instead of a column name as an argument. Whenever you filter on a column function (an aggregate), it goes in the HAVING instead of the WHERE. You can think of the HAVING as a WHERE clause that happens AFTER the grouping. [...]