1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2010, week 1 2 128 55_Re: DB2-L Digest - 28 Feb 2010 to 1 Mar 2010 (#2010-57)16_Sheryl M. Larsen18_smlsql@COMCAST.NET31_Sun, 28 Feb 2010 22:34:26 -0600668_utf-8 DB2-L automatic digest system wrote: >LOL, Thanks Phil. > >I hope all is well. > > > >Troy Coleman >CA >Principal Product Manager >Tel: +1-630-505-6000 X46025 >Fax: +1-630-505-6608 >Mobile: +1-224-343-0073 >Troy.Coleman@ca.com > > >From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger >Sent: Saturday, February 27, 2010 3:20 PM >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? > > > >Well, I really didn't intend this to be an on-going eMail discussion (that's why I started the poll - so people could go there and have their say) > > > >BUT [...] 131 104 15_Re: REORP issue15_Smartcurl Zhang19_smartcurl@GMAIL.COM30_Mon, 1 Mar 2010 15:49:35 +0800619_ISO-8859-1 How about change the status with ACCESS(FORCE),then run REPAIR utility?

On Fri, Feb 26, 2010 at 12:39 PM, SrinivasG wrote:

> A Tablespace is in REORP state. > When I ran a REORG with SHRLEVEL NONE , it gives me the error > > REASON 00C2010D > TYPE 00000220 > NAME DSNC.DSNDBC.DBENR.ENR.I0001.A001 > > Where upon I run REPAIR LEVELID utility. But then I get an error saying > that the Tablespace is REORG Pending. > > How do I get out of this loop? > > Regards, > Srinivas G > > _____________________________________________________________________ > > * IDUG North [...] 236 395 15_Re: REORP issue9_SrinivasG21_SRINIVASG@INFOSYS.COM30_Mon, 1 Mar 2010 13:57:31 +0530558_us-ascii I have tried that. The Tablespace is still in REORP state.

Regards, Srinivas G

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Smartcurl Zhang Sent: Monday, March 01, 2010 1:20 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] REORP issue

How about change the status with ACCESS(FORCE),then run REPAIR utility? On Fri, Feb 26, 2010 at 12:39 PM, SrinivasG > wrote: A Tablespace is in REORP state. When I ran a REORG with SHRLEVEL NONE , it gives me the error [...] 632 651 15_Re: REORP issue16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Mon, 1 Mar 2010 06:39:47 -0600473_us-ascii If you are able to alter you zparms set DLDFREQ off and DB2 will stop checking. Then after your REORG turn it back on.

Cheers,

Dan





Daniel L Luksetich

IBM Information Champion

IBM Certified Database Administrator - DB2 9 for z/OS

IBM Certified System Administrator - DB2 9 for z/OS

IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database Administration for UNIX, Windows, and OS/2 [...] 1284 69 13_Zparm AUDITST12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM30_Mon, 1 Mar 2010 08:49:25 -0500301_US-ASCII DB2 V8 Z/os

We are being asked to turn this on within Zparm which will start the trace on DB2 start-up. The way i read it within ADMIN manual on the limitations is that if we do not have audit turned on for any tables, it sounds like we would be tracing nothing. Is that correct? [...] 1354 133 44_Andy Ward's presentations about DB2 for z/OS10_DB2usa !!!19_db2usa3@HOTMAIL.COM30_Mon, 1 Mar 2010 10:40:05 -0500434_iso-8859-1

Hi DB2 user,

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

Last update on Monday, March 1st 2010





Here are several Andy Ward's presentations about DB2 for z/OS available on different websites:





- By the Pool with the (IF)cids by Andy Ward





- Lies, Damned Lies & Statistics by Andy Ward [...] 1488 47 42_Experiences with "current client_applname"15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV30_Mon, 1 Mar 2010 16:40:14 +0000636_UTF-8 We are DB2 Ver 8.1 NFM on z/OS.

We have CICS and Batch programs accessing a particular stored procedure.

Over and above the userid security I have been chewing on how to restrict a stored procedure to only certain programs. Today I stumbled a special register called “current client_applname” in the SQL reference manual. I do not know if this is used more for distributed applications. Does anyone have experience using this special register in a CICS/Batch environment? I am visualizing the stored proc getting the calling program name using the special register and allowing further execution only if it [...] 1536 82 46_Re: Experiences with "current client_applname"13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Mon, 1 Mar 2010 12:08:54 -0500591_utf-8 Hi Tonmoy,

You probably know this, but it's not clear from your post. It is the responsibility of the application to set this special register.

As long as that is consistently done in your suite of Apps, I believe it can do what you want.

Dave

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then [...] 1619 38 32_Where Clause on a VARCHAR Column14_Vidya Attuluri27_vidya.attuluri@MARRIOTT.COM30_Mon, 1 Mar 2010 17:34:16 +0000312_UTF-8 Hello,

We have in one of the queries a where clause like WHERE COLUMN > '' (without a blank in between the single quotes). This query when it uses index, it is returning the data and when it uses Tablespace Scan it is not returning any data (infact every row in the table should be satisfied). [...] 1658 256 36_[AD] IBM DB2 Connect Class March 8th7_Kim May28_kim.may@THEFILLMOREGROUP.COM30_Mon, 1 Mar 2010 13:54:58 -0500373_US-ASCII All,





This class is now in the guaranteed to run zone.if you are interested in attending, you've got a week to get yourself registered. If I can help with last minute travel or getting you coordinated for remote delivery, please give me a call at 410-465-6335.





Registration and course outline are on the IBM site: [...] 1915 620 26_Re: Bounce DB2 every day ?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Mon, 1 Mar 2010 20:37:59 -0000482_us-ascii Cathy,

that is a good point.

However, I guess if you do not need your data online all the time at all, you can afford to IPL...



Thanks.



Aurora



Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com http://www.ca.com/



P please don't print this e-mail unless you really need to! [...] 2536 448 17_Re: Zparm AUDITST12_Kirk Hampton37_kirk.hampton@ENERGYFUTUREHOLDINGS.COM30_Mon, 1 Mar 2010 14:46:01 -0600438_us-ascii Hi Jeff,

We have been running for years with AUDITST=(4,5,6)

We also have a DB2/PM job that runs every day against the previous day's SMF tape to produce an Audit report.

We are DB2 v8 on z/OS v1.9

I don't exactly know about "tracing nothing", there may still be slight overhead,

but I do know that if you have no tables with auditing turned on, there will be no audit records in the SMF. [...] 2985 141 36_Re: Where Clause on a VARCHAR Column11_Suresh Sane21_data_arch@HOTMAIL.COM30_Mon, 1 Mar 2010 16:00:19 -0600618_iso-8859-1

Vidya - I am wondering if this has to do with the 2 zparms - PADIX and RETVLCFK.





Can you state what the values are?





Thx

Suresh





> Date: Mon, 1 Mar 2010 17:34:16 +0000 > From: vidya.attuluri@MARRIOTT.COM > Subject: [DB2-L] Where Clause on a VARCHAR Column > To: DB2-L@WWW.IDUGDB2-L.ORG > > Hello, > > We have in one of the queries a where clause like WHERE COLUMN > '' (without > a blank in between the single quotes). This query when it uses index, it is > returning the data and when it uses Tablespace Scan it is not [...] 3127 41 36_Re: Where Clause on a VARCHAR Column14_Vidya Attuluri27_vidya.attuluri@MARRIOTT.COM30_Mon, 1 Mar 2010 22:32:13 +0000363_UTF-8 Suresh,

The zparms are set to as follows:

RETVLCFK=NO PADIX=YES

But what surprises me is , if I code my WHERE clause as WHERE COLUMN > ' ', then it works great (a blank in between single quotes). The problems seems to be only when it is null string - no blank in between single quotes ('') and the access type is Table Space scan. [...] 3169 128 24_DB2 Support Quality Poll12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Mon, 1 Mar 2010 23:46:19 +0100339_iso-8859-1

Dear Listers,

a couple of days ago, I started a poll on the support quality that IBM provides for DB2. This was triggered by the disappointment of the Oracle guys in my team with their support quality, paired with questions on Listserv about what could companies persuade into *not* migrating away from DB2. [...] 3298 643 26_Re: Bounce DB2 every day ?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Mon, 1 Mar 2010 14:52:40 -0800389_us-ascii Yeah, but...if your platform is highly available and people know it, then they might think up reasons to access it 24x7.

When programmers say "we cycle DB2 daily" or "we IPL weekly", people might think the mainframe is not a highly available platform, not that you architected it for reduced availability and do not understand or value its high availability features. [...] 3942 131 28_Re: DB2 Support Quality Poll10_Todd Burch17_toddburch@MAC.COM30_Mon, 1 Mar 2010 17:11:25 -0600453_US-ASCII Can I vote?

Todd DB2 for z/OS Level 2.





On Mar 1, 2010, at 4:46 PM, Peter Suhner wrote:

Dear Listers,

a couple of days ago, I started a poll on the support quality that IBM provides for DB2. This was triggered by the disappointment of the Oracle guys in my team with their support quality, paired with questions on Listserv about what could companies persuade into *not* migrating away from DB2. [...] 4074 34 28_Re: DB2 Support Quality Poll16_Harold Pritchett14_harold@UGA.EDU30_Mon, 1 Mar 2010 18:29:25 -0500711_ISO-8859-1 Todd Burch wrote: > Can I vote? > > Todd > DB2 for z/OS Level 2.

Probably shouldn't, but I think the fact that an IBM level 2 support person is active on a user mailing list speaks for itself!

Harold DB2 for LUW admin and janitor...

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * If you are going to attend only one conference this year, this is it! * _____________________________________________________________________ http://www.IDUG.org/mentor Mentoring should be a rewarding experience for everyone... IDUG is offering up to $1600 off when you both come to [...] 4109 92 28_Re: DB2 Support Quality Poll13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Mon, 1 Mar 2010 18:13:15 -0600520_ISO-8859-1 Gee, I was going to ask the same question?

Willie

Todd Burch wrote: > Can I vote? > > Todd > DB2 for z/OS Level 2. > > > > On Mar 1, 2010, at 4:46 PM, Peter Suhner wrote: > > Dear Listers, > > a couple of days ago, I started a poll on the support quality that IBM > provides for DB2. This was triggered by the disappointment of the Oracle > guys in my team with their support quality, paired with questions on > Listserv about what could companies persuade into *not* migrating away > from [...] 4202 115 17_Re: Zparm AUDITST12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 2 Mar 2010 02:50:58 +0000691_UTF-8 Audit classes 1, 2, 7, and 8 occur without regard to audited tables, while audit classes 3 - 6 are only for audited tables.

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc .admin/dacdes.htm#dacdes

Roger MIller, DB2 for z/OS

On Mon, 1 Mar 2010 14:46:01 -0600, Kirk Hampton wrote:

>Hi Jeff, > >We have been running for years with AUDITST=(4,5,6) > >We also have a DB2/PM job that runs every day against the previous day's >SMF tape to produce an Audit report. > >We are DB2 v8 on z/OS v1.9 > >I don't exactly know about "tracing nothing", there may still be slight >overhead, > >but I [...] 4318 127 28_Re: DB2 Support Quality Poll15_Chris Hoelscher21_choelscher@HUMANA.COM30_Mon, 1 Mar 2010 23:00:41 -0500466_US-ASCII you were going to ask if Todd Burch could vote?

Chris Hoelscher IDMS/DB2 Database Architect Humana Inc 502-476-2538 choelscher@humana.com

you only need to test the programs that you want to work correctly











From: Willie Favero To: DB2-L@WWW.IDUGDB2-L.ORG Date: 03/01/2010 07:24 PM Subject: Re: [DB2-L] DB2 Support Quality Poll Sent by: IDUG DB2-L [...] 4446 84 55_Quarterly Los Angeles DB2 User Group - OC 3/4 & LAX 3/513_Mark DePledge20_mark.depledge@CA.COM30_Tue, 2 Mar 2010 05:13:21 +0000685_UTF-8 More info at http://www.laadb2ug.org/

10:00am - 11:30am: DB2 9.7 and DB2 pureScale - Bernie Schiefer

Learn how the advancements of DB2 9.7 is helping to deliver greater business value with low operational costs, high reliability and increased ease of use with Enhanced Storage Optimization, XML, Online Schema Changes and Oracle compatibility.

12:30pm - 2:00pm: Risk Management: Understanding the New Options in Data Protection for DB2 and Files - Ulf Mattsson - CTO of Protegrity and inventor of more than 20 patents in the areas of Encryption Key Management, Policy Driven Data Encryption, Internal Threat Protection, Data Usage Control and Intrusion [...] 4531 38 36_Re: Where Clause on a VARCHAR Column14_Peter Vanroose17_pvanroose@ABIS.BE30_Tue, 2 Mar 2010 07:55:17 +0000530_UTF-8 > The problems seems to be only when it is null string > - no blank in between single quotes ('') > and the access type is Table Space scan.

This is very weird, since indeed all rows should be returned (except for the ones having NULL in that column). This is certainly not related to any zParm setting. Never seen this before, nor heard of it. Are you sure that the index is up-to-date w.r.t. the table data? Maybe run an UNLOAD to check the data content, or even just a RUNSTATS to check that the table is not [...] 4570 377 82_Re: [DB2 for z/OS] Is there a limitation as to the # of rows to discard with reorg37_=?Windows-1252?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE30_Tue, 2 Mar 2010 10:50:14 +0100630_Windows-1252 Hi Larry,

I forwarded your ideas to my colleague and here's what she did:

She created a 2nd table, one column only, that contained all the entries that were supposed to be deleted. She then altered the first table, adding an extra column To_be_deleted char(1) nullable.

Before the run, she altered the 1st table's locksize to TABLESPACE so as to avoid possible -904s, ran an Update-Job with UPDATE table1 set To_be_deleted = 'Y' where pk-column in (Select col1 from table2). This job ran for about 80 seconds. Afterwards she re-altered the tablespace to locksize PAGE, as it was before. The [...] 4948 26 15_OSC successor ?11_Nenad Vidak21_nenad.vidak@GMAIL.COM30_Tue, 2 Mar 2010 10:38:18 +0000612_UTF-8 Hello, according to IBM, the OSC has been replaced with the IBM Data Studio ( stand-alone and IDE release) and two Optim products. Which of them is a real, free of charge OSC successor? Regards, Nenad

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * ** The most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 4975 62 36_Re: Where Clause on a VARCHAR Column14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Tue, 2 Mar 2010 12:08:17 +0100447_UTF-8 IMHO this could indeed be a problem in DB2, related to the access path, because AFAIK the VARCHAR columns are stored in the indexes in their maximum length, padded with blanks, and the length field is not accessible by simply accessing the index. So the index scan could involve other semantics on WHERE than the table space scan does (although I also would have assumed all rows to be returned in both cases). I would ask IBM on this. [...] 5038 84 15_OSC successor ?16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Tue, 2 Mar 2010 06:05:00 -0600866_UTF-8 The free product is called IBM Data Studio.

http://www-01.ibm.com/software/data/optim/data-studio/features.html

I did a podcast with Jay Bruce of IBM on the subject back in October. You can find that here:

http://www.db2expert.com/podcasts/db2_Cocktail_Hour_34_tune.mp3

You can still download OSC here:

https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-db2zosc

Cheers, Dan

Daniel L Luksetich IBM Information Champion IBM Certified Database Administrator - DB2 9 for z/OS IBM Certified System Administrator - DB2 9 for z/OS IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database Administration for UNIX, Windows, and OS/2 IBM Certified Solutions Expert - DB2 UDB V7.1 Family Application Development IBM Certified Advanced Technical Expert - DB2 Data Replication [...] 5123 965 82_Re: [DB2 for z/OS] Is there a limitation as to the # of rows to discard with reorg11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 2 Mar 2010 13:19:37 +0100403_ISO-8859-1 another reason that DB2-Listserv gets my vote as "Best Resource for DB2 z/OS on the Net" (and of course a large cold beer delivered in the attached file as thanks!)





Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strae 5 40470 Dsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...] 6089 193 19_Re: OSC successor ?11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 2 Mar 2010 13:20:40 +0100490_ISO-8859-1 I use the windows Stand alone version and yes its free and yes (after a bit of fiddling) it does what VE and its friends used to do.





Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strae 5 40470 Dsseldorf/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 Dsseldorf, HRB 37894 Geschftsfhrung: Siegfried Frst, Gerhard Schubert [...] 6283 271 28_Re: DB2 Support Quality Poll10_Roger Hecq18_Roger.Hecq@UBS.COM30_Tue, 2 Mar 2010 08:27:55 -0500382_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. [...] 6555 337 28_Re: DB2 Support Quality Poll13_Michael Ebert18_mebert@AMADEUS.COM30_Tue, 2 Mar 2010 14:10:24 +0000389_ISO-8859-1 An additional consideration: if you google for DB2 information, you generally get good quality hits. For Oracle, however, you only get results for outdated versions (pre-9i); it seems like newer information gets actively suppressed. This leaves you to look for info in Metalink, which is a less than pleasurable experience - the new flash-based version didn't change that. [...] 6893 113 19_Re: OSC successor ?11_Nenad Vidak21_nenad.vidak@GMAIL.COM30_Tue, 2 Mar 2010 14:31:42 +0000362_UTF-8 Hello Roy,

thanks for your answer. I managed to setup the Data Studio but when I try "Tune Query.." or "Generate Access Plan Report" it complains that Basic Query Tuner packages are not bound. How I'm supposed to bind those packages?

Regards, Nenad



On Tue, 2 Mar 2010 13:20:40 +0100, Roy Boxwell wrote: [...] 7007 309 49_AD: This weeks DB2 Tech Talk from Cogito and HMNA13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Tue, 2 Mar 2010 09:49:36 -0500297_us-ascii Hi all,

I just wanted to take a moment to remind you of this weeks DB2 Tech Talk

The registration numbers are looking very healthy (or if you are the presenter, like me, they are starting to look scary!) - so if you were planning to attend, I suggest you register ASAP [...] 7317 113 28_Re: DB2 Support Quality Poll10_Todd Burch17_toddburch@MAC.COM30_Tue, 2 Mar 2010 08:52:08 -0600327_US-ASCII Hey Dr. Michael.

Actually, it is not uncommon for the people making the buying decisions to work with IBM support. Just last week, I was on a support call where the customer (CIO) said "this is why I buy IBM".

"this" being the support they received.

Are they on the day-to-day calls? No way. [...] 7431 98 36_Re: Where Clause on a VARCHAR Column14_Vidya Attuluri27_vidya.attuluri@MARRIOTT.COM30_Tue, 2 Mar 2010 15:15:47 +0000345_UTF-8 Hi,

We tried same query in one of the other subsystems we have and there it returns the data irrespective of the access path chosen. This is the test subsystem. May be we have more recent maintenance on test subsystems.

Regards Vidya On Tue, 2 Mar 2010 12:08:17 +0100, Bernd Oppolzer wrote: [...] 7530 286 59_Re: Quarterly Los Angeles DB2 User Group - OC 3/4 & LAX 3/535_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM30_Tue, 2 Mar 2010 10:17:15 -0500418_utf-8 It's great to see this user group active, and providing knowledge to the DB2 community. We participated in your tools fair in 1999.

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 [...] 7817 102 28_Re: DB2 Support Quality Poll10_Max Scarpa16_mscarpa@CESVE.IT30_Tue, 2 Mar 2010 16:25:23 +0100339_US-ASCII I've no direct experience with Oracle support (luckily, I'd say, from previous reply) but in a previous company they closed mainframe to move to Oracle. Many of sysprogs where 'converted' from ZOS/DB2 to UNIX/Oracle so they experimented both support services and I heard their comments during interregnum (or MF euthanasia). [...] 7920 1493 98_[Fluff] RE: [DB2-L] [DB2 for z/OS] Is there a limitation as to the # of rows to discard with reorg14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 2 Mar 2010 10:28:26 -0500530_iso-8859-1 Another beer bigot. Doesn't anyone send scotch any more?

________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: Tuesday, March 02, 2010 7:20 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 for z/OS] Is there a limitation as to the # of rows to discard with reorg



another reason that DB2-Listserv gets my vote as "Best Resource for DB2 z/OS on the Net" (and of course a large cold beer delivered in the attached file as thanks!) [...] 9414 158 19_Re: OSC successor ?12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 2 Mar 2010 07:36:04 -0800636_utf-8 You've got to setup data studio. Go to the configuration screen and do the configuration. There will be a panel there that will allow you to bind all the packages needed as well as creating all needed tables. Myron ________________________________ From: Nenad Vidak To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tue, March 2, 2010 9:31:42 AM Subject: Re: [DB2-L] OSC successor ? Hello Roy, thanks for your answer. I managed to setup the Data Studio but when I try "Tune Query.." or "Generate Access Plan Report" it complains that Basic Query Tuner packages are not bound. How I'm supposed to bind those packages? [...] 9573 39 28_Re: DB2 Support Quality Poll10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 2 Mar 2010 16:48:40 +0000495_UTF-8 1) DB2 platform (z/OS, LUW, etc.): z/OS



2) Maint/support contract for this product (yes/no):yes



3) Support rating (1=poor to 5=excellent, with 3=satisfactory):2 (only because CA is worse)



4) Comments on what should be improved (e.g. difficult to contact, sluggish responses, useless answers, code fixes take too long, etc.):

Long, long PE chains, problems take far too long to get resolved, first level support is very hit and miss [...] 9613 87 30_set current package path usage13_Walters, Paul28_Paul.A.Walters@SALLIEMAE.COM30_Tue, 2 Mar 2010 12:02:57 -0500404_utf-8 We are having a discussion about using set current package path in a legacy cics/batch application.

I have found some references that this statement is only usable for applications that are not running under a plan. Is this correct? I cannot locate a reference from an IBM manual on this.

We currently are using set current packageset and we are binding our plans with a pklist. [...] 9701 161 28_Re: DB2 Support Quality Poll15_Andrew Lawinger17_alawinger@MMM.COM30_Tue, 2 Mar 2010 11:05:01 -0600270_US-ASCII Peter, I see Jorg lumped CA into a poll. Was your intention to find out about IBMs support... or was it to find out about support in general for the DB2 environment. I took it to be only IBM based on "poll on the support quality that IBM provides for DB2" [...] 9863 137 41_Antwort: [DB2-L] DB2 Support Quality Poll12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 2 Mar 2010 18:26:36 +0100451_us-ascii <<
Thanks, Michael.

Starting in 2009 with Oracle 11g as a newbie I found Oracle and the support of Oracle - what support ??????

DB2-L is okay. And for Oracle DBA's there is - as far as I have seen - only one not-Oracle-driven site: www.lazydba.com . [...] 10001 279 19_Re: OSC successor ?18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM30_Tue, 2 Mar 2010 10:51:10 -0700472_utf-8 Thank you Nenad, for creating this post. I was about to create a post on "Data Studio" as I just started working on "Data Studio" and I was getting the same error, the error that "Basic Query Tuner Package" is not bound.

I looked for the "Configuration" screen/section but didn't find that. Our Systems Programmer did run the DSNTIJOS job (to create the necessary tables and create the binds). Please let me know if you find any more info on this error. [...] 10281 435 28_Re: DB2 Support Quality Poll12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Tue, 2 Mar 2010 12:18:25 -0600624_US-ASCII Todd:





I was never a CIO, but I did manage seven data centers in the mid eighties. When we had a major problem, I was likely to be on the call.





The issue with support is not what you get correct, but what you perceived as getting wrong. We have our own Z/9 and the support is always there when needed. In fact they usually call us before we know there is a problem. Software is always more difficult because the environments have permutations that cannot be anticipated. Software is more difficult to diagnosis because gathering the information presents disclosure [...] 10717 28 19_Re: OSC successor ?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 2 Mar 2010 17:00:45 +0000642_UTF-8 Not all the features of OSC will migrate into the free version of IBM Data Studio a couple of features will only be available with $. OSC will work with DB2 9 so you don't need to upgrade and lose functions until you got to DB2 10

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * ** The most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 10746 570 15_PAGE LATCH high12_Jose Antonio17_jamorcillo@CAM.ES30_Tue, 2 Mar 2010 19:32:01 +0100324_iso-8859-1 Hello List!





We have detected a high PAGE LATCH. Could it be related to parameter VDWQT from buffer pools? We have set it by default. We have a

high volumen of transactions inserting into a table space and I'm not sure but I think we should change this table space to a specific [...] 11317 427 19_Re: PAGE LATCH high8_duam lee20_duam_lee@HOTMAIL.COM30_Tue, 2 Mar 2010 19:10:48 +0000342_Windows-1252

Hi Jose,





I had seen the page latch was due to index page latch in the past when more concurrent threads were trying to insert voluminous records to a table. When we insert or update to maintain a constitency the latches are taken on index pages. But wait for some valuable comments from group [...] 11745 1158 19_Re: PAGE LATCH high12_Jose Antonio17_jamorcillo@CAM.ES30_Tue, 2 Mar 2010 20:18:46 +0100758_iso-8859-1 Hi Duam





This table hasn't got any indexes so it must be a different page latch!





thanks a lot!

Jos













________________________________

De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de duam lee Enviado el: martes, 02 de marzo de 2010 20:11 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: Re: [DB2-L] PAGE LATCH high





Hi Jose,

I had seen the page latch was due to index page latch in the past when more concurrent threads were trying to insert voluminous records to a table. When we insert or update to maintain a constitency the latches are taken on index pages. But wait for some valuable comments from [...] 12904 159 19_Re: OSC successor ?12_Martin Hubel17_Martin@MHUBEL.COM30_Tue, 2 Mar 2010 14:20:40 -0500 13064 26 20_DSNRLST01 Bufferpool10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 2 Mar 2010 17:02:58 +0000593_UTF-8 Should the RLF tablespace and index be placed in BP0, an applciation BP< or it's very own BP? We've had some odd IRLM page latch waits (long waits) on DSNRLST01 on an old subsystem.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * ** The most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 13091 75 24_Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Tue, 2 Mar 2010 14:27:22 -0500324_ISO-8859-1 Hello:

DB2 V7 z/OS 1.4

I received a request from a user. The user is using a reporting tool and can't specify database name explicitly. The tool internally creates tables in the default database. He wanted to know if it is OK to go ahead and let the tool create the tables in default database. [...] 13167 347 28_Re: Significance of DSNDB04!13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Tue, 2 Mar 2010 14:36:04 -0500478_utf-8 Hello Josh.





If this reporting tool is designed to run on z/OS DB2, I suggest you consider putting it in the box and sending it back.

In my experience it is completely unacceptable in most shops to allow dynamic creation of user tables in the default database without giving you a choice. Accidentally putting crap there happens, but for a product to rely on it, to me, is the sign of a product that doesn't know its way around DB2 on z. [...] 13515 50 24_Re: DSNRLST01 Bufferpool13_Case, Missy J24_Missy.Case@FIRSTDATA.COM30_Tue, 2 Mar 2010 13:40:51 -0600487_utf-8 Jorg, We put our dsnrlst01 in a small read only code table bufferpool which holds about 25 or 30 tablespaces and indexes for our reference or code tables. I defined our buffer with 2500 pages and it probably gets somewhere in the range of 200 io's per week. We never have issues with our rlf. We also have < 50 rows in our RLF table as we group by Sybase gateway id and give overrides for our CA7 batch ids, etc, so almost every condition can be addressed with 30 or so rows. [...] 13566 256 19_Re: PAGE LATCH high9_Mike Bell21_mbell11a1@VERIZON.NET30_Tue, 2 Mar 2010 13:45:03 -0600336_iso-8859-1 If a table does not have any indexes then 1. every SQL will have to do a tablespace scan 2. every SQL will have to get a page latch for every page in the tablespace (segmented tablespace and uts will be limited to pages that have had data inserted).

The result means you will always have a high page latch count. [...] 13823 763 19_Re: PAGE LATCH high8_duam lee20_duam_lee@HOTMAIL.COM30_Tue, 2 Mar 2010 19:47:07 +0000322_Windows-1252

Hi Josh,





If there are no indexes on this table, then page latch would be the result of search for sapce info i.e freespace infor on each page while inserting. if this time hurts you, then you may consider insert at the end so that no page is latched due free space search. [...] 14587 102 28_Re: Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Tue, 2 Mar 2010 14:48:30 -0500584_ISO-8859-1 Also, is the purpose of DSNDB04 only to 'entertain' the users (in other words, users' database alone)? Or, is it also being used internally by DB2 for any other purpose.



TIA -Josh Wawzynzak





On Tue, Mar 2, 2010 at 2:27 PM, DB2 DBA wrote:

> Hello: > > DB2 V7 z/OS 1.4 > > I received a request from a user. The user is using a reporting tool and > can't specify database name explicitly. > The tool internally creates tables in the default database. He wanted to > know if it is OK to go ahead and let [...] 14690 209 19_Re: OSC successor ?13_David Simpson22_dsimpson@THEMISINC.COM30_Tue, 2 Mar 2010 13:54:42 -0600381_iso-8859-1 The ability to group statements into workloads was a major piece of functionality that was free with OSC and seems to be something you pay for in the Optim suite.

-----Original Message----- From: Martin Hubel Sent: Tuesday, March 02, 2010 1:37 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] OSC successor ? [...] 14900 315 28_Re: Significance of DSNDB04!14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 2 Mar 2010 14:56:48 -0500534_us-ascii Josh, I'm coming up empty with Google searches on DSNDB04 and ZPARM. All references I can find to a DB2 default database explicitly reference DSNDB04. So I'm pretty sure that "DSNDB04" is what you get, no choice.

--Phil Sevetson

P.S. does the tool have a setting for database? If not, do you have a catalog/change management tool such as BMC Change Manager? You can use tools like that to "move" the tables to the database you want them in (although this might make upgrades to your software problematic). [...] 15216 299 28_Re: DB2 Support Quality Poll12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM30_Tue, 2 Mar 2010 15:15:31 -0500478_us-ascii Questions ----------

1) DB2 platform (z/OS, LUW, etc.): z/OS



2) Maint/support contract for this product (yes/no): YES



3) Support rating (1=poor to 5=excellent, with 3=satisfactory): 5 Excellent



4) Comments on what should be improved (e.g. difficult to contact, sluggish responses, useless answers, code fixes take too long, etc.):

Overall response is a bit sluggish , but once they get going it's great.. [...] 15516 73 28_Re: Significance of DSNDB04!0_24_carol.sutfin@REGIONS.COM30_Tue, 2 Mar 2010 14:15:36 -0600374_UTF-8 Josh,

Most reporting tools have a way to designate a default Database somewhere in the configuration. If you can find that, why not build one specific to that tool.

That way you can also maintain the space allocations and even remove unused tables after a designated amount of time.

I have several "databases" like that in my DB2 subsystems. [...] 15590 179 28_Re: DB2 Support Quality Poll12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Tue, 2 Mar 2010 21:20:13 +0100480_iso-8859-1

Todd,

in times where politicans vote for themselves and bankers decide on their own rip-off I'd consider this only natural. ;-)

To be honest, I don't believe in unlimited impartiality (nor is it requested for this poll). Meaning: Of course you are welcome to share your opinion.



Peter

Date: Mon, 1 Mar 2010 17:11:25 -0600 From: toddburch@MAC.COM Subject: Re: [DB2-L] DB2 Support Quality Poll To: DB2-L@WWW.IDUGDB2-L.ORG [...] 15770 61 69_Re: Baltimore / Washington DB2 Users' Group March 10, 2010 Meeting!!!11_Mann, Darsh24_Darsh.Mann@SALLIEMAE.COM30_Tue, 2 Mar 2010 15:26:30 -0500450_utf-8 Hi Henry,. I am planning on attending the meeting and would like to pre-register. Who and where do I mail the check to? When does the check has to be mailed by? Thanks, --darsh

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Henry L Nalven Sent: Thursday, February 25, 2010 10:08 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Baltimore / Washington DB2 Users' Group March 10, 2010 Meeting!!! [...] 15832 269 28_Re: Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Tue, 2 Mar 2010 15:32:18 -0500381_windows-1252 Hello Phil:

Thanks for the reply.

Here, the 'problem' with the tool is it doesn't let you mention/choose database. In fact, the tables are created internally in the background. The only thing it lets you do is, pick the 3-part table name. DATABAS1.QUALFIER1.TABLENAM1.

No, it may sound strange but, we don't have catalog/change manager here. [...] 16102 227 28_Re: Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Tue, 2 Mar 2010 15:48:05 -0500597_windows-1252 Hello Carol:

You may be right. I shall take that route and see what I can do.

Would DB2 use DSNDB04 for any other reason? Or is it only a user database?





-Josh Wawzynzak

On Tue, Mar 2, 2010 at 3:15 PM, wrote:

> Josh, > > Most reporting tools have a way to designate a default Database somewhere > in the configuration. > If you can find that, why not build one specific to that tool. > > That way you can also maintain the space allocations and even remove unused > tables after a designated amount of [...] 16330 328 34_Re: set current package path usage15_Attuluri, Vidya27_Vidya.Attuluri@MARRIOTT.COM30_Tue, 2 Mar 2010 16:27:37 -0500514_us-ascii Paul,





No, you can use that in applications that run under a plan. We bound the same program into 2 different collections (with different qualifiers), and then we will switch between these 2 collections in the program using SET CURRENT PACKAGE PATH SQL statement and it works great.





Only difference I found between this (it is better) and SET CURRENT PACKAGESET is, the collection into which you want switch to need not be part of the PKLIST of the PLAN. [...] 16659 26 24_Re: DSNRLST01 Bufferpool10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 2 Mar 2010 21:39:55 +0000521_UTF-8 Missy,

Thanks, that's not a bad place for it since the table is indeed quite small and seldom updated.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * ** The most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 16686 26 19_Re: PAGE LATCH high10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 2 Mar 2010 19:34:02 +0000589_UTF-8 Jose,

Does your IRLM started task have the highest WLM dispatching priority (higher than the other DB2 tasks and CICS)? Are you CPU constrained when latching is an issue?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * ** The most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 16713 229 28_Re: Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Tue, 2 Mar 2010 17:06:34 -0500590_windows-1252 Hello Dave:

Ship it back? I can only wish I could do that :-)

Yes, this tool is designed to run on z/OS DB2 too.



BTW, thanks for your reply

-Josh Wawzynzak

On Tue, Mar 2, 2010 at 2:36 PM, Seibert, Dave wrote:

> Hello Josh. > > > > If this reporting tool is designed to run on z/OS DB2, I suggest you > consider putting it in the box and sending it back. > > In my experience it is completely unacceptable in most shops to allow > dynamic creation of user tables in the default database without [...] 16943 138 36_Re: Where Clause on a VARCHAR Column13_Terry Purcell18_tpurcel@US.IBM.COM30_Tue, 2 Mar 2010 22:09:48 +0000419_UTF-8 Vidya,

I suggest opening a PMR with IBM. DB2 development ran a quick test on current V8 maintenance level and cannot recreate your problem. Opening the PMR and sending the appropriate data will allow support to test your same maintenance level, your table definition, data etc.

Regards Terry Purcell

On Tue, 2 Mar 2010 15:15:47 +0000, Vidya Attuluri wrote: [...] 17082 39 64_Saving money and the planet with the most open system - System Z11_Dave Beulke19_dave@DAVEBEULKE.COM30_Tue, 2 Mar 2010 20:20:34 +0000508_UTF-8 I have a new post on DaveBeulke.com



Saving money and the planet with the most open system - System Z



It seems that last week’s blog struck a chord with many readers. Many people commented on how their management is increasingly out of touch with the mainframe. Also, comments also stated that the System Z environment is really processing almost all of the transactions in their company and how all the Windows platform systems continue to have scalability issues. [...] 17122 40 28_Re: DB2 Support Quality Poll13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Tue, 2 Mar 2010 14:36:14 -0800321_utf-8 As a sysprog, I have supported many different products and vendors, and I really appreciate IBM's long PE chains. It shows me they have a clue about what happened when. IBM software is no more prone to error than any other I've worked with, but their packaging is nearly rock solid, better than anyone else's. [...] 17163 33 28_Re: DB2 Support Quality Poll11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 3 Mar 2010 00:16:51 +0000336_- >I really appreciate IBM's long PE chains.

When I saw this, I hoped you were kidding!

We had VSAM/LINEAR/DB2 issues, to the point of SEV1. When it came to finger-pointing, IBM told us it was our fault for not being current with DFP.

You can't (unless recently) be current with DFP because oif the PE chains. [...] 17197 40 24_Index on expression - V911_Sameer Rana21_sameerdrana@GMAIL.COM30_Wed, 3 Mar 2010 02:16:15 +0000486_UTF-8 We are reviewing the new exciting features that got introduced with Version9 DB2 z/OS. One feature that I am particularly interested in is indexing on expressions. Has anybody had any experience with this?

Has anyone met with any success in improving performance for queries using these new types of indexes?

Also how can we determine which predicates in an application can make for likely candidates for such type of indexing ( aside from reviewing the code). [...] 17238 51 21_[OT] Chile earthquake15_Jorge Martelanz27_jorge_martelanz@HOTMAIL.COM30_Wed, 3 Mar 2010 02:29:14 +0000312_UTF-8 Dear friends

As all of you already know from the news, Chile suffered a violent earthquake on February 27th.

I have the fortune of being here with my family at that time and with the help of God none of us or our closest relatives and friends had any major problem or personal injuries. [...] 17290 51 25_Re: [OT] Chile earthquake11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 3 Mar 2010 03:33:27 +0000498_Windows-1252 While I feel sorry for them, I do NOT believe that this forum is appropriate to address that.

If we start veering off-topic like this, where do we draw the line?
------Original Message------
From: Jorge Martelanz
Sender: IDUG DB2-L
To: DB2 List
ReplyTo: DB2 List
Sent: Mar 2, 2010 21:29
Subject: [DB2-L] [OT] Chile earthquake

Dear friends

As all of you already know from the news, Chile suffered a violent earthquake
on February 27th. [...]105_1145070786-1267587199-cardhu_decombobulator_blackberry.rim.net-1487541994-@bda026.bisx.prod.on.blackberry 17342 23 21_DB2-L Upgrade to 16.05_Billy21_billysundar@YAHOO.COM30_Wed, 3 Mar 2010 03:42:48 +0000570_UTF-8 We have upgraded the software from Listserv version 15.5 to 16.0. If you encounter any issues, please contact listadmin@idug.org.
Cheers.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]53_4267601569160546.WA.billysundaryahoo.com@www.idug.org 17366 69 28_Re: Index on expression - V912_Roger Miller19_millerrl@US.IBM.COM30_Wed, 3 Mar 2010 05:41:00 +0000822_UTF-8 Willie Favero has an interesting blog on the subject and an article
http://it.toolbox.com/blogs/db2zos/avoiding-a-stage-2-predicate-index-on-expression-redo-29964
http://www.zjournal.com/index.cfm?section=article&aid=1161
http://www.zjournal.com/pdfIssue/pdfArticle/favero.zJ.JUNE-JULY08.pdf

SQL performance news
http://www.hiperformance-software.de/documents/DB2%209%20for%20zOS%20-%20SQL%20Performance%20News.pdf

Robert Catterall
http://www.catterallconsulting.com/2009/05/db2-9-for-zos-rx-for-database-design.html

What I hear from customers is that they only have a couple of uses for the index on expression, but
it saves an extra column, extra processing, and scans for some of those cases where there was no
way to avoid the work before this improvement arrived. [...]51_5247825598837204.WA.millerrlus.ibm.com@www.idug.org 17436 334 19_Re: PAGE LATCH high12_Jose Antonio17_jamorcillo@CAM.ES30_Wed, 3 Mar 2010 08:17:07 +0100650_iso-8859-1 Hi Mike!

But we only INSERT in this table, we don't run any SELECT statament run throught this table space!

Any ideas then?

Josh

-----Mensaje original-----
De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Mike Bell
Enviado el: martes, 02 de marzo de 2010 20:45
Para: DB2-L@WWW.IDUGDB2-L.ORG
Asunto: Re: [DB2-L] PAGE LATCH high

If a table does not have any indexes then
1. every SQL will have to do a tablespace scan
2. every SQL will have to get a page latch for every page in the tablespace
(segmented tablespace and uts will be limited to pages that have had data
[...]57_78E5EB2B7326D240BBB670236211F9D3D5E2AF@SRVMAIL3.redcam.es 17771 74 19_Re: PAGE LATCH high12_Jose Antonio17_jamorcillo@CAM.ES30_Wed, 3 Mar 2010 08:20:05 +0100558_iso-8859-1 Hello Jorg!

Our IRLM have the highest priority. Yesterday we had our system using almost 100% CPU all day

Jos

-----Mensaje original-----
De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Jorg Lueke
Enviado el: martes, 02 de marzo de 2010 20:34
Para: DB2-L@WWW.IDUGDB2-L.ORG
Asunto: Re: [DB2-L] PAGE LATCH high

Jose,

Does your IRLM started task have the highest WLM dispatching priority
(higher than the other DB2 tasks and CICS)? Are you CPU constrained
when latching is an issue? [...]57_78E5EB2B7326D240BBB670236211F9D3D5E2B0@SRVMAIL3.redcam.es 17846 188 45_Re: [OT] Chile earthquake and FAQ Reminder...20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM30_Wed, 3 Mar 2010 10:00:12 +0200710_us-ascii Hello List,

Jorge applied the list rules and put [OT] in front of his subject line,
nothing wrong.

This list is enough mature to draw the line. Admins are monitoring the
list and taking actions when necessary.
I remember many posts with [FLUFF] prefix.

Regards,
Cuneyt
DB2-L Volunteer

--------

Hello DB2-L Subscribers,

This posting is something we (the list owners) are sending out about
every couple of months. The purpose is to highlight information about
DB2-L and also remind subscribers about certain information. Some
information will be repeated to benefit new subscribers. We hope you
will find the information useful, [...]117_!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAdyet3dgRhUKaV5vgm3ghEsKAAAAQAAAABa04f+KX1kahIJsaBkyGCQEAAAAA@gmail.com 18035 81 27_Re: [OT^2] Chile earthquake10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 3 Mar 2010 09:12:04 +0100549_US-ASCII If you had at least a vague idea about what a earthquake 8.8 Richter
Moment Magnitude means you'd write these indifferent and insensible
words.Just to say, Probably if you had missed all you'd ask for help
everywhere as well.

This is NOT your personal list, there are administrators that can decide
what is appropriate or not, as it could be this post I'm just writing. If
you don't agree with the content of some posts simply ignore them , hit
'cancel' button and please don't miss another chance to shut up. [...]66_OFA563F1BA.CA14D3EB-ONC12576DB.002965EF-C12576DB.002CB6AA@cesve.it 18117 303 28_Re: Significance of DSNDB04!13_Michael Ebert18_mebert@AMADEUS.COM30_Wed, 3 Mar 2010 08:47:44 +0000397_ISO-8859-1 On the other hand, what do you gain by creating tables in database XYZABC
instead of DSNDB04? What's the advantage of having an extra, unused
database around? "Naming conventions" maybe? That's a guidance, don't let
it become a straitjacket. It seems everyone is positively afraid of using
DSNDB04... why? Just because it's "IBM-supplied"? Some food for thought
:-) [...]69_OF259B48A9.A3961A86-ON002576DB.00303076-C12576DB.00305104@amadeus.com 18421 243 25_Re: [OT] Chile earthquake13_Michael Ebert18_mebert@AMADEUS.COM30_Wed, 3 Mar 2010 08:52:15 +0000516_ISO-8859-1 Objection.

The attitude "post whatever you want, the admins will look after it" is
NOT helpful or right; they've got better things to do. When I joined up,
at least, the rules said "DB2-stuff ONLY - nothing else, however good the
cause", and I second that - precisely because this is not somebodys
personal list. In fact the "fluff" bit mentioned in another post is
sometimes getting a bit too thick for my taste already, especially when it
starts to creep into non-Fridays. [...]69_OF038D6EC7.E49C6824-ON002576DB.00306322-C12576DB.0030BB07@amadeus.com 18665 88 36_AW: [DB2-L] Index on expression - V935_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 3 Mar 2010 11:14:23 +0100766_iso-8859-1 Hi Sameer

We have used it in a few situations and as Roger already mentioned had great success with that feature.

Here is an example:

DECLARE CURSOR01 CURSOR FOR
SELECT USBD_NAME, USBD_REVOKE
FROM DB2.USER_BD
WHERE SUBSTR (USBD_NAME, 2, 6) = :H

Mit freundlichen Gren
Walter Janien

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Dsseldorf
mailto:walter.janissen@itergo.com

Vorsitzender des Aufsichtsrates: Jrgen Vetter
Geschftsfhrung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schn.
Sitz: Dsseldorf, Handelsregister: Amtsgericht Dsseldorf, HRB 37996 [...]43_DB2-L%201003031014324685.003A@IDUGDB2-L.ORG 18754 203 36_AW: [DB2-L] Significance of DSNDB04!35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 3 Mar 2010 11:21:43 +0100324_iso-8859-1 Hi

If you are in DB2 V9, there is still a database called DSNDB04, but if you don't specify a database, tablespaces get created using DSN00001, DSN00002 and so on. I think, there is a ZPARM, where you can limit the number of DSNnnnnn-databases. If this number is exhausted, a wrap around takes place. [...]43_DB2-L%201003031021529562.003C@IDUGDB2-L.ORG 18958 132 25_Re: [OT] Chile earthquake44_=?iso-8859-1?Q?RB_J=F3hannes_B._G=EDslason?=23_Johannes.Gislason@RB.IS30_Wed, 3 Mar 2010 10:42:16 -0000483_iso-8859-1 I think we should be open minded in our communications. I can't see any wrongdoing by using this forum to remind us that we can help others in need. The World is cruel enough.

Regards
Johannes Gislason
Development division
Icelandic Banks Data Centre
tel.+3545698877

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Ebert
Sent: 3. mars 2010 08:52
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [OT] Chile earthquake [...]57_8B9F431F5FEE5B4C87A7A2FEA1265BFA01FB98F2@stampur.rbank.is 19091 59 19_Re: PAGE LATCH high11_Mike Bracey22_mike_bracey@UK.IBM.COM30_Wed, 3 Mar 2010 11:01:32 +0000544_UTF-8 Hello José
Judging from the previous exchanges this is a write only read never table probably a log table. I am assuming there are multiple threads attempting to insert concurrently. DB2 first finds a home page, normally via an index but in this case will be by using the space map pages. Having found the home page then it will be used unless it is locked, quite likely in your case as all insert will be on the end, so the space search starts again. My suspicion is that the page latch contention is on the space map page. You [...]53_9954976526137073.WA.mikebraceyuk.ibm.com@www.idug.org 19151 41 51_migration of DB server SAP R/3 4.6 to SAP Netweaver24_fjpohlen-maillist@gmx.de24_fjpohlen-maillist@GMX.DE30_Wed, 3 Mar 2010 12:16:15 +0100590_ISO-8859-15 Hi listers,

I assume that there are some people in this list who use z/OS as DB
server for SAP. My customer plans the migration in the subject and I'm
looking for information on how much the dasd space may increase in
percent with this upgrade. The customer will not use unicode and no
additional applications. It will be a 1:1 migration of his ERP system.
Meanwhile I have found out that during migration a shadow database will
be built, so that I plan about three times the database space (twice the
db + increased log space + reserve) during [...]23_4B8E44FF.4030109@gmx.de 19193 62 46_Re: Experiences with "current client_applname"14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 3 Mar 2010 22:24:35 +1100471_ISO-8859-1 Problem with using client_applname is that you are trusting the client programs to be honest.

Perhaps a more secure way is to
- have a special owner id that has EXECUTE on the stored procedure. It also has whatever
other privileges that are necessary
- bind only "certain packages" using this owner id.

The binds of packages which don't have the authorised owner and which call the procedure
will fail with, from memory, a -551. [...]48_4B8EE1A3.5852.1103A317@jacampbell.acslink.net.au 19256 31 25_Re: [OT] Chile earthquake11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 3 Mar 2010 11:51:04 +0000424_- >In fact the "fluff" bit mentioned in another post is sometimes getting a bit too thick for my taste already, especially when it starts to creep into non-Fridays.

I disagree entirely with the "fluff" and "ot" stuff, and always have.
I may slip occasionally; nobody's perfect.

But, the whole Friday concept is a crock!
Not only does it slip into non-Fridays, but not everybody sees them on Friday. [...]104_1489999386-1267617056-cardhu_decombobulator_blackberry.rim.net-937687210-@bda026.bisx.prod.on.blackberry 19288 26 25_Re: [OT] Chile earthquake11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Wed, 3 Mar 2010 11:52:51 +0000270_- >I think we should be open minded in our communications. I can't see any wrongdoing by using this forum to remind us that we can help others in need. The World is cruel enough.

As I said in a previous post, once you open it up, where do you draw the line? [...]103_566128819-1267617165-cardhu_decombobulator_blackberry.rim.net-586566170-@bda026.bisx.prod.on.blackberry 19315 22 27_ADMIN [OT] Chile earthquake0_19_galambos@ROGERS.COM30_Wed, 3 Mar 2010 12:28:53 +0000521_- Consider this thread as CLOSED
Sent from my BlackBerry device on the Rogers Wireless Network

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]104_1788188103-1267619247-cardhu_decombobulator_blackberry.rim.net-398133836-@bda271.bisx.prod.on.blackberry 19338 72 25_Re: [OT] Chile earthquake44_=?iso-8859-1?Q?RB_J=F3hannes_B._G=EDslason?=23_Johannes.Gislason@RB.IS30_Wed, 3 Mar 2010 12:27:58 -0000801_iso-8859-1 Be open minded and skip off topic[OT]posts if you don't want to read them. Although this is a professional forum it has its rules as has been outlined in another post. These rules have not been broken.

The rules draw the line.

Regards
Johannes Gislason
Development division
Icelandic Banks Data Centre
tel.+3545698877

=================================================================
Reiknistofa bankanna gerir fyrirvara vi tlvupst. Hann er a finna vefsetri RB http://www.rb.is/fyrirvari
RB's e-mail disclaimer http://www.rb.is/disclaimer-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL
Sent: 3. mars 2010 11:53
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [OT] Chile earthquake [...]57_8B9F431F5FEE5B4C87A7A2FEA1265BFA01FB9926@stampur.rbank.is 19411 81 28_Re: Index on expression - V912_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 3 Mar 2010 05:56:16 -0800334_us-ascii I've used it for several different queries and have had reductions in CPU of over 90% by the usage. I reviewed carefully the queries and access paths individually and explored all types of various alternatives prior to using the expression indexes.

They're very good but there are caveats as explained elsewhere. [...]44_941834.13485.qm@web112111.mail.gq1.yahoo.com 19493 102 25_Re: [OT] Chile earthquake15_Gaston, Raymond17_GastonRay@ORU.COM30_Wed, 3 Mar 2010 08:58:56 -0500521_us-ascii Ted...

What's inappropriate to one can be quite appropriate to another. I
recall responding to a "September 11th" call for donations via this very
forum.

- Ray

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL
Sent: Tuesday, March 02, 2010 10:33 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [OT] Chile earthquake

While I feel sorry for them, I do NOT believe that this forum is
appropriate to address that. [...]63_0A69F3794ED5F842B1A75AEF1D59EC430858FD64@exchmbir.conedison.net 19596 243 34_AW: set current package path usage35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 3 Mar 2010 15:05:39 +0100362_iso-8859-1 Hi Paul

We are using this statement in our test environment all the time, before and after each SQL-statement. Since DB2 V8 we experience a huge CPU-comsumption for this statement, because we are an EBCDIC-shop, but the special register is UNICODE, so there is always a conversion taken place.

So you can use it, but not too often. [...]43_DB2-L%201003031405487769.0054@IDUGDB2-L.ORG 19840 87 28_Re: Significance of DSNDB04!10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 3 Mar 2010 15:12:20 +0100604_US-ASCII A good product should give possibility to decide where you want to create
the tables, leaving DSNDB04 as 'default'.

There's nothing wrong in DSNDB04 database but usually it's considered as
'no man's land' or a 'work' database in many shops so you can have a lot
of table inside (or very few) that no one drops and no one reorgs (for
instance it's excluded from databasas to reorg). Or on the contrary (as
happened in the past) some DBA can decide to 'clean' that database
dropping all tables, including tables used by your product. For a normal
database this is [...]66_OF4BB081F4.3B077F70-ONC12576DB.004CD061-C12576DB.004DB262@cesve.it 19928 100 28_Re: DB2 Support Quality Poll16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM30_Wed, 3 Mar 2010 08:57:30 -0600349_us-ascii I'm with Cathy on this one. I don't mind the long PE chains since SMP/E
handles them. I've supported multiple products on multiple platforms
(including Oracle). IBM support is much, much superior. If I open a
premium response PMR, I get a call back very quickly. I can also travel
up the food chain very fast if I need to. [...]70_B22003942F5A0C4DBF34DC9C6121BF9B0C4E82@A1DAL1SWPES22MB.ams.acs-inc.net 20029 58 25_Re: DB2-L Upgrade to 16.015_Sharon L Heller22_sheller@AESSUCCESS.ORG30_Wed, 3 Mar 2010 09:48:33 -0500437_iso-8859-1 You have a secure email message waiting for you from Sharon L Heller at AES/PHEAA with the subject: Re: [DB2-L] DB2-L Upgrade to 16.0.

How to Retrieve Your Message

To retrieve your message from Sharon L Heller with the subject: Re: [DB2-L] DB2-L Upgrade to 16.0, go to:
https://securemail.aessuccess.org/messenger/msg?x=d-32415818-BkMd18xxqPpeBFO6

This message will be available until 05/02/2010. [...]64_securemail.d-32415818-BkMd18xxqPpeBFO6@securemail.aessuccess.org 20088 378 28_Re: Significance of DSNDB04!12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK30_Wed, 3 Mar 2010 15:21:16 +0000389_iso-8859-1 The implicit database count is controlled the following:

ALTER SEQUENCE SYSIBM.DSNSEQ_IMPLICITDB MAXVALUE n;

Where n is the max number of databases, and it cannot be less than 1. Therefore... I haven't yet found a way of disabling this altogether, enforcing users to specify a named database in their DDL ??? (just in case we want to do that at some point !) [...]72_1454A0984F246445950CB759E249F50F4150F918B3@csis564.wlp.uk.winterthur.com 20467 205 28_Re: DB2 Support Quality Poll15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV30_Wed, 3 Mar 2010 09:21:51 -0600632_us-ascii Questions
----------

1) DB2 platform (z/OS, LUW, etc.): z/OS and LUW

2) Maint/support contract for this product (yes/no): YES

3) Support rating (1=poor to 5=excellent, with 3=satisfactory): 5 Excellent

4) Comments on what should be improved (e.g. difficult to contact, sluggish responses, useless answers, code fixes take too long, etc.):

On the LUW side they try to immediately put you to a technician if available (even if the problem is severity 3) whereas they are not able to do that for z/OS... I have to wait for someone to call back. I wish they could do more of that for [...]63_2DC7C68F7CB3A44581728B546466F35122F07D790F@CMS01.sas.arkgov.net 20673 495 36_AW: [DB2-L] Significance of DSNDB04!35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 3 Mar 2010 16:24:32 +0100689_iso-8859-1 Phil

I think, you can control that, by revoking any privilege on DSNDB04. Then nobody can create tables without specifying a database name.

Mit freundlichen Gren
Walter Janien

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Dsseldorf
Tel.: +49 211 477-2928
Fax: +49 211 477-2615
mailto:walter.janissen@itergo.com

Vorsitzender des Aufsichtsrates: Jrgen Vetter
Geschftsfhrung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schn.
Sitz: Dsseldorf, Handelsregister: Amtsgericht Dsseldorf, HRB 37996 [...]43_DB2-L%201003031524421907.005E@IDUGDB2-L.ORG 21169 632 28_Re: Significance of DSNDB04!14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 3 Mar 2010 10:37:29 -0500693_iso-8859-1 That's a DB2V9 feature, the original question referred to V7.

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of McLaren Phil
Sent: Wednesday, March 03, 2010 10:21 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Significance of DSNDB04!

The implicit database count is controlled the following:

ALTER SEQUENCE SYSIBM.DSNSEQ_IMPLICITDB MAXVALUE n;

Where n is the max number of databases, and it cannot be less than 1. Therefore... I haven't yet found a way of disabling this altogether, enforcing users to specify a named database in their DDL ??? (just in case we want to do that at some point !) [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033378CF61@MAIL02.fisalan.nycnet 21802 211 28_Re: Significance of DSNDB04!14_Amsden, John W19_John.Amsden@LFG.COM30_Wed, 3 Mar 2010 10:39:54 -0500515_iso-8859-1 In our shop we allow people to build a table using DSNDB04 even in production. However, we have issued a standard that
all tables in DSNDB04 in every subsystem are dropped every evening by a scheduled production job. Seem to work well as
long as people understand it.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Max Scarpa
Sent: Wednesday, March 03, 2010 9:12 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Significance of DSNDB04! [...]57_1B866F270C444C4985C3BD5CF62AA3F0075E8FC5@nh1emp02.jp.corp 22014 556 40_[ADMIN?] sendto address change for db2-l13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Wed, 3 Mar 2010 10:51:14 -0500411_utf-8 Good morning,

I had a couple problems with my email client this morning
(self-inflicted, or company-inflicted). A bit later I noticed the
automated rule I had set up which filed DB2-L posts away in a folder
also was not functioning. Being a careless logician, I guessed this was
related to the other problems. I wasted a little time (or more) trying
to diagnose & resolve this. [...]70_E814208E0983274198870632E8697D5B0E3B5067@nasa-dtw-ex001.nasa.cpwr.corp 22571 32 28_Re: DB2 Support Quality Poll10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Wed, 3 Mar 2010 15:56:58 +0000561_UTF-8 Cathy,

That's one interpretation thought not one I've heard from the sysprogs aound here stuck working on DB2 9 issues for months.
Having 900+ modules tied together so that a simpe Reorg sortsize calculation can't be fixed for months is to me a sign of
rather poor design. For us DB2 support really was a lot worse with DB2 9 than any previous version. It was never as good as BMC (at least BMC of a few years ago) but it was always satisfactory. But DB2 9 was not. Again, others are worse. CA still doesn't support index compression so [...]53_9265483818768135.WA.jorghluekebcbsmn.com@www.idug.org 22604 81 28_Re: DB2 Support Quality Poll13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Wed, 3 Mar 2010 08:07:05 -0800513_us-ascii Software quality has nothing to do with PE chains, quality is "does the thing work?" A PE chain merely alerts you to the fact that you are applying software with bugs, they know what some of the bugs are, they're not all fixed yet, so be informed. That give you the opportunity to track the ones that concern you the most. Would you rather NOT know? And yes, it is your fault if you wait for IBM to fix every last problem before applying maintenance. That's why they came up with the BYPASS clause. [...]64_927FE8790B320742927BCF9ADF7AE48A18ECD4EB9F@PDXMAIL.pacificorp.us 22686 22 28_Re: Index on expression - V911_Sameer Rana21_sameerdrana@GMAIL.COM30_Wed, 3 Mar 2010 16:18:41 +0000491_UTF-8 Thanks a lot Mr. Miller.
This information is very useful !

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]53_1808652778669098.WA.sameerdranagmail.com@www.idug.org 22709 447 25_Re: [OT] Chile earthquake11_Krnic, Ivan23_Ivan.Krnic@ALLSTATE.COM30_Wed, 3 Mar 2010 10:22:28 -0600589_US-ASCII Far from the eyes, far from the heart...
People always react differently when disaster hits them directly.
I believe a little compassion never hurts...

Ivan

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gaston,
Raymond
Sent: Wednesday, March 03, 2010 7:59 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [OT] Chile earthquake

Ted...

What's inappropriate to one can be quite appropriate to another. I
recall responding to a "September 11th" call for donations via this very
forum. [...]77_499EA82EB489B04D8728FE77EC02DD71068F0F6C@a0116-xpo0113-s.swdc.ad.allstate.com 23157 46 25_Re: [OT] Chile earthquake12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Wed, 3 Mar 2010 10:25:11 -0600477_US-ASCII Ray:

I was going to comment on the 9/11 memories, but thought better of it.

Let us just pray that those who object never need this kind of support.

Gerald Hodge
HLS Technologies, Inc.
www.hlstechnologies.com

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gaston, Raymond
Sent: Wednesday, March 03, 2010 7:59 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [OT] Chile earthquake [...]35_017401cabaee$19141610$4b3c4230$@com 23204 25 22_DB2 9 User Experiences10_Bill Brown21_db2_dba@BELLSOUTH.NET30_Wed, 3 Mar 2010 16:43:37 +0000726_UTF-8 I wanted to start a thread for folks to report their DB2 9 user experiences. I'm interested in performance improvements, new online capabilities, larger index page sizes, index compression, asymmetric index page split results, etc. Responses don't need to be limited to these topics. Just unload.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]52_9473178143849574.WA.db2dbabellsouth.net@www.idug.org 23230 209 28_Re: DB2 Support Quality Poll7_Ed Long19_rdhm99a@PRODIGY.NET30_Wed, 3 Mar 2010 08:47:08 -0800645_iso-8859-1 The following represents my opinion aloneandin no way represents any other entity or person's opinion. 1: DB2 Platform (z/OS Luw): Both. 2: Maintenance/support contract for this product: Yes. 3: Support Rating: 3. 4: See below. I find the long prereq chains - and the number of PE's - to be show stoppers, as in often effectively uninstallable. I also dislikesome of the'actions' that are assumed acceptable to demand of customers. I would rather have the long chains replaced by full module replacements - essentially a lot more superseding PTF's. The actions that require substantial alterations of sample or install jobs [...]43_392826.97090.qm@web80205.mail.mud.yahoo.com 23440 675 28_Re: Significance of DSNDB04!12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK30_Wed, 3 Mar 2010 16:56:27 +0000459_iso-8859-1 Hi Walter,

I believe I tried that, but because you can't set the MAXVALUE on SYSIBM.DSNSEQ_IMPLICITDB to zero, everything just went into DSN00001.
I'll see if I can test this shortly, just in case I missed something last time.

Phil

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walter Janien
Sent: 03 March 2010 15:25
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] AW: [DB2-L] Significance of DSNDB04! [...]72_1454A0984F246445950CB759E249F50F4150F9193C@csis564.wlp.uk.winterthur.com 24116 942 44_Re: [ADMIN?] sendto address change for db2-l18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM30_Wed, 3 Mar 2010 10:03:02 -0700551_us-ascii Good Morning Everybody,

Even I noticed that my automated e-mail rule is not working for this list. I saw that it started happening after the e-mail that Billy sent regarding upgrade. I thought I was the odd one out, seems like others are having issues similar to mine.

Satish

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Seibert, Dave
Sent: Wednesday, March 03, 2010 8:51 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] [ADMIN?] sendto address change for db2-l [...]55_D42E68651088914B9B327A4EEA8433AC8EDA7CA1@VM251.apsc.com 25059 230 40_Re: AW: [DB2-L] Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Wed, 3 Mar 2010 12:09:01 -0500633_ISO-8859-1 Hello Walter:

I just wonder, would you or can you think of any negative effect on DB2,
having DSNDB04 used heavily?

-Josh Wawzynzak

2010/3/3 Walter Janien

> Hi
>
> If you are in DB2 V9, there is still a database called DSNDB04, but if you
> don't specify a database, tablespaces get created using DSN00001, DSN00002
> and so on. I think, there is a ZPARM, where you can limit the number of
> DSNnnnnn-databases. If this number is exhausted, a wrap around takes place.
>
> And AFAIK, DSNDB04 is merely for user tables, I never noticed, [...]59_85726c9d1003030909j4e4773e3t8c87c3ebd200a79d@mail.gmail.com 25290 28 40_[ADMIN?] sendto address change for db2-l0_19_galambos@ROGERS.COM30_Wed, 3 Mar 2010 17:36:16 +0000680_- Thanks for bringing this up to our attention

We will get back to everyone as soon as we have more into.

P.S. As a note if you are reading this, the old address still works db2-l@www.idugdb2-l.org

mobile email sent from my blackberry.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]103_145888958-1267637691-cardhu_decombobulator_blackberry.rim.net-447040220-@bda271.bisx.prod.on.blackberry 25319 21 40_Re: AW: [DB2-L] Index on expression - V911_Sameer Rana21_sameerdrana@GMAIL.COM30_Wed, 3 Mar 2010 16:30:06 +0000546_UTF-8 Thanks Walter !

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L53_1435925483198226.WA.sameerdranagmail.com@www.idug.org 25341 76 36_Re: Where Clause on a VARCHAR Column14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Wed, 3 Mar 2010 18:42:48 +0100605_UTF-8 Vidya,

I would like to be informed - maybe off list -
how this problem gets solved in the end,
and what was the source of the problem.
Thank you.

Kind regards

Bernd

Terry Purcell schrieb:
> Vidya,
>
> I suggest opening a PMR with IBM. DB2 development ran a quick test on
> current V8 maintenance level and cannot recreate your problem. Opening the
> PMR and sending the appropriate data will allow support to test your same
> maintenance level, your table definition, data etc.
>
> Regards
> Terry Purcell
>
> On Tue, 2 Mar [...]28_4B8E9F98.7020509@t-online.de 25418 91 25_Re: DB2-L Upgrade to 16.012_Martin Hubel17_Martin@MHUBEL.COM30_Wed, 3 Mar 2010 12:45:11 -05000_43_DB2-L%201003031745203190.007F@IDUGDB2-L.ORG 25510 32 23_ADMIN earthquake thread0_19_galambos@ROGERS.COM30_Wed, 3 Mar 2010 18:00:50 +0000419_- AGAIN please refrain from posting any more to this thread.

The initial post was NOT contravening any policies of this listserv.

But this thread has drifted to far and should be terminated.

While we all have our own opinions, this is not where they should be voiced.

This should not be taken as my personnel judgement, but an impartial enforcement of the rules agreed by everyone here [...]104_1412216023-1267639165-cardhu_decombobulator_blackberry.rim.net-589372696-@bda271.bisx.prod.on.blackberry 25543 148 40_Re: AW: [DB2-L] Significance of DSNDB04!9_Mike Bell21_mbell11a1@VERIZON.NET30_Wed, 3 Mar 2010 12:31:27 -0600491_iso-8859-1 Other than the normal problem that any DDL locks the entire DBD - NO.

You can get some interesting deadlocks anytime there is a long running query
and a different user wants to create a new table.

Mike
HLS Technologies

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DB2 DBA
Sent: Wednesday, March 03, 2010 11:09 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] AW: [DB2-L] Significance of DSNDB04! [...]43_01CF251012394E9DAC7F42E00085C877@mikelaptop 25692 319 40_Re: AW: [DB2-L] Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Wed, 3 Mar 2010 13:37:06 -0500638_ISO-8859-1 Hello Mike:

Thank you.

In my case, I'm sure there is only one user in this Sub-System who's gonna
create these tables.

-Josh Wawzynzak

On Wed, Mar 3, 2010 at 1:31 PM, Mike Bell wrote:

> Other than the normal problem that any DDL locks the entire DBD - NO.
>
> You can get some interesting deadlocks anytime there is a long running
> query
> and a different user wants to create a new table.
>
> Mike
> HLS Technologies
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DB2 DBA
> Sent: [...]58_85726c9d1003031037w25045c90ha8a931d83463a02@mail.gmail.com 26012 21 28_Re: Index on expression - V911_Sameer Rana21_sameerdrana@GMAIL.COM30_Wed, 3 Mar 2010 19:10:29 +0000545_UTF-8 Thanks Myron !

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L53_3885611429247768.WA.sameerdranagmail.com@www.idug.org 26034 71 28_Re: DB2 Support Quality Poll13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Wed, 3 Mar 2010 11:22:55 -0800610_utf-8 Hi Jorg. I'm sorry you had a bad experience applying maintenance. I have found that when there are 900 modules tied together for a single fix, it's usually because of somewhat backlevel maintenance and often only one or a very small number of errors could be bypassed to allow your PTF to go on without 900 others. Try APPLY CHECK without the GROUPEXTEND parameter (but still bypassing holdsystem as usual), and you should get a manageable list of hold errors, then decide whether to bypass them. Decide what you're going to bypass, then do APPLY CHECK GROUPEXTEND BYPASS(HOLDERROR(errorid)) -- you [...]64_927FE8790B320742927BCF9ADF7AE48A18ECD4EFA9@PDXMAIL.pacificorp.us 26106 505 28_Re: Significance of DSNDB04!13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Wed, 3 Mar 2010 15:11:29 -0500507_us-ascii Problems tend to occur not in the use of DSNDB04 BUT in the continual creating and dropping of objects without any intervening MODIFY RECOVERY statements (who takes image copies of DSNDB04 let alone runs modify recovery on it???)

Do this and the size of the dbd will increase (and increase)

Or at least it used to!
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A5F0@MAILR004.mail.lan 26612 385 28_Re: Significance of DSNDB04!13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Wed, 3 Mar 2010 15:13:04 -0500723_iso-8859-1 Indeed

If you don't have CREATEIN on DSNDB04 then you cannot (so the doc says) get implicit object creation
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of McLaren Phil
Sent: 03 March 2010 16:56
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Significance of DSNDB04!

Hi Walter,

I believe I tried that, but because you can't set the MAXVALUE on SYSIBM.DSNSEQ_IMPLICITDB to zero, everything just went into DSN00001.
I'll see if I can test this shortly, just in case I missed something last time. [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A5F1@MAILR004.mail.lan 26998 672 28_Re: Significance of DSNDB04!14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 3 Mar 2010 15:59:50 -0500641_us-ascii Beg pardon? I thought dropping a tablespace (which should happen when you drop the table, if you've created the tablespace implicitly) cleaned up the DBD?

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Wednesday, March 03, 2010 3:11 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Significance of DSNDB04!

Problems tend to occur not in the use of DSNDB04 BUT in the continual creating and dropping of objects without any intervening MODIFY RECOVERY statements (who takes image copies of DSNDB04 let alone runs modify recovery on it???) [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033378CF70@MAIL02.fisalan.nycnet 27671 24 12_Tool Support10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Wed, 3 Mar 2010 21:34:29 +0000301_UTF-8 As we start using features in DB2 9 like index on expression and index expression we are finding that the CA tools do not support these features and they have no date yet as when they might. Does anyone out there have BMC/IBM tools (catalog and utilities) and do they work with DB2 9 z/os? [...]53_8269421211170909.WA.jorghluekebcbsmn.com@www.idug.org 27696 30 28_Re: DB2 Support Quality Poll10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Wed, 3 Mar 2010 21:37:52 +0000558_UTF-8 Hi Cathy,

We've had our sysprogs on both regular and the SAP side look at bypasses and the various ways around the issue. DB2 support's been on conference calls with people from development but there's always been something in the way to apply the fix. We don't run very far behind on maintenance 3-6 months typically. This issue should be fixed now we just need our sysprog to come back from vacation but the problem was first noticed in SAP a year ago. I do appreciate the concept of the PE chain but the number and types of modules that [...]53_7025778202104717.WA.jorghluekebcbsmn.com@www.idug.org 27727 180 28_Re: Significance of DSNDB04!9_Mike Bell21_mbell11a1@VERIZON.NET30_Wed, 3 Mar 2010 16:33:46 -0600541_US-ASCII Nope, and not since v2.3 or something when that ptf came out. Requires
modify recovery to remove entries from the DBD and LGRNG. The origional
problem was some one did a modify table, image copy, then REORG to populate
the fields, the reorg failed for some reason and they could not recover back
to the image copy because DB2 had removed the information for the old
version of the table when the reorg started. New rules - nothing removed
from DBD or LGRNG until last image copy removed with MODIFY RECOVERY. [...]43_D46FECA1E018488D9B9F8C8ADEE6396C@mikelaptop 27908 54 16_Re: Tool Support13_Bright, Randy20_Randy_Bright@BMC.COM30_Wed, 3 Mar 2010 15:59:14 -0700596_utf-8 The latest releases of the BMC DB2 Utilities have full support for DB2 V9. There are some specific features of DB2 V9 that are supported via calling DSNUTILB. These are features that were not widely adopted by our customers. For example with LoadPlus for DB2 and Reorg Plus for DB2 indexes defined as random or on expression will invoke DSNUTILB. We have plans in a future release to implement index on expression support natively in these two products for a limited set of expressions. Until adoption of random indexes becomes more widespread we do not have plans for native support. [...]69_476996CBBE9AF14285E09E63C370072A13CD7396C5@PHXCCRPRD01.adprod.bmc.com 27963 425 28_Re: Significance of DSNDB04!13_David Simpson22_dsimpson@THEMISINC.COM30_Wed, 3 Mar 2010 18:11:34 -0500615_iso-8859-1 But DROP TABLESPACE removes all references to the image copy, no?

It has been my experience that DROP TABLESPACE cures all your DBD woes. It could however cause other problems :)

______________________________________________________________________________
David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | dsimpson@themisinc.com
For more information about Themis, visit www.themisinc.com [...]67_7EC87535E7581C4C890F5BF1CF9A937401C96DCA@THEMISSRV1.themisinc.local 28389 31 27_ADMIN change of domain name0_19_galambos@ROGERS.COM30_Wed, 3 Mar 2010 23:38:36 +0000434_- As some of you may have noticed (especially those of you who have mail filters) the address of post that you received has slightly changed.

Instead of db2-l@www.idugdb2-l.org its

db2-l@idugdb2-l.org

Also note both addresses still work in sending to the listserv FOR NOW

Sorry for this, but this slipped through the cracks

We will try better next time
mobile email sent from my blackberry. [...]103_218862868-1267659431-cardhu_decombobulator_blackberry.rim.net-258115317-@bda271.bisx.prod.on.blackberry 28421 27 19_Re: PAGE LATCH high11_Mike Bracey22_mike_bracey@UK.IBM.COM30_Thu, 4 Mar 2010 00:06:43 +0000321_UTF-8 Hello again
Having just responded, I was reminded by a colleague that page latch contention can also occur when a page is in the process of being written to disk. What value are you using for DWQT and VDWQT? As mentioned before both too high and too low values can cause problems.
Regards
Mike Bracey [...]53_7295132260376249.WA.mikebraceyuk.ibm.com@www.idug.org 28449 85 32_Any users of COMPRESS_SPT01=YES?0_17_jtonchick@AOL.COM30_Thu, 4 Mar 2010 00:08:03 -0500430_us-ascii I'm in the middle of rolling out our latest RSU maintenance for DB2 V8 and included in the PTFs is the one adding the support for compressing DSNDB01.SPT01 (v8 UK50986, v9 UK50987). I have tested the compression of SPT01 and am very satisfied with the 76% reduction I achieved in a "sand box" subsystem. With this result, I hope to compress SPT01 in a large development subsystem that currently is using 3 datasets. [...]53_8CC896FCD704CDC-8D0C-9CEF@webmail-d047.sysops.aol.com 28535 305 44_SV: [DB2-L] Any users of COMPRESS_SPT01=YES?13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE30_Thu, 4 Mar 2010 08:03:31 +0100549_iso-8859-1 Yes, we have compressed SPT01 in several subsystems without any problems. We have seen page savings between 69 and 76 percent.
The largest SPT01 that we compressed consisted of 12 datasets, In the latter case we saw that the Image Copy CPU time was decreased from 56 seconds down to 22 seconds and the elapsed time decreased from 18 minutes down to 8 minutes, this is total times for the complete copy job of Cat & DIR.
Since we take 1 or 2 Image Copies of the DB2 catalog & directory each day we can save some space for Image [...]70_B0000573F0F67C438DC58043C06F4CAB49D3A9977C@FSPAS01EV011.fspa.myntet.se 28841 303 28_Re: Significance of DSNDB04!13_Michael Ebert18_mebert@AMADEUS.COM30_Thu, 4 Mar 2010 08:31:43 +0000591_ISO-8859-1 MODIFY RECOVERY will keep SYSCOPY and SYSLGRNX (and, I'm sure, the DBD as
well) in sync. So, if you remove an entry from SYSCOPY, entries in
SYSLGRNX that are no longer relevant will be removed along with it. A
special case is when you drop a TS: under certain circumstances DB2 won't
remove SYSLGRNX entries at the time (I think something to do with
locking), but only when the PSID is reused (by creating another TS in the
same DB). This is practical experience working intensively with SYSLGRNX
(I had a SAS program to read it for my "maintenance job [...]69_OF60129344.5DA9BD0D-ON002576DC.002E128F-C12576DC.002ED90B@amadeus.com 29145 76 28_Re: Significance of DSNDB04!10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 4 Mar 2010 10:11:40 +0100370_US-ASCII It's a known WAD, it's suggested to run MODIFY RECOVER .........AGE(*)
before dropping a TS so you've a complete cleanup of all cat/dir records.

I did some tests with DROP/CREATE tablespace in the past to try to
maintain the same xxIDs for TS/TB/IX when dropping/creating a TS (for
DSN1COPY use) and it came out xxIDs are (re)used starting [...]66_OFC85EBC8E.2241DFCB-ONC12576DC.0030C6E2-C12576DC.00322B9A@cesve.it 29222 49 16_Re: Tool Support13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Thu, 4 Mar 2010 10:16:57 +0100530_utf-8 Yes, and yes... ;o)

Semi-seriously, and possibly in [AD] mode, as you specifically mentioned index-on-expression our SQL Performance for DB2 Solution can let you model the potential benefit of adding an IOE (is that a patented abbreviation?) index and see if the cost estimate for the affected statement(s) reduces or not. Pretty useful to be able to see if a proposed [IOE] index would help without having to add it for real, rebind (if static SQL) and hope for the best. Some sites don't like that; weird, eh? [...]71_2ECBF1EB8D499348849093615F9901550147FAC53123@AMSCCRPRD01.adprod.bmc.com 29272 84 19_Re: PAGE LATCH high12_Jose Antonio17_jamorcillo@CAM.ES30_Thu, 4 Mar 2010 10:11:53 +0100421_us-ascii Hi Mike!

Thanks a lot for all your help! Values for DWQT and VDWQT are set by
default, we are thinking of using Buffer Pool Analyser to tune them

Thanks again!
Josh

-----Mensaje original-----
De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Mike Bracey
Enviado el: jueves, 04 de marzo de 2010 1:07
Para: DB2-L@IDUGDB2-L.ORG
Asunto: Re: [DB2-L] PAGE LATCH high [...]57_78E5EB2B7326D240BBB670236211F9D3D5E2BD@SRVMAIL3.redcam.es 29357 26 45_Re: QMF with RACF Security - Effects of Cache11_Michel Helg24_michel.helg@AXA-TECH.COM30_Thu, 4 Mar 2010 11:52:01 +0000556_UTF-8 Hi everybody, Phil

we take up Phil's advice and put it to IBM. I will post the outcome.

Thanks again
Michel

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]55_1675164235857308.WA.michel.helgaxatech.com@www.idug.org 29384 225 28_Re: Significance of DSNDB04!13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Thu, 4 Mar 2010 07:02:58 -0500355_iso-8859-1 And notice the comment "... last image copy removed with MODIFY RECOVERY"

If you don't HAVE any image copies, then you can MODIFY RECOVERY and you won't reclaim DBD bits & pieces

SYSLGRNX is even worse (for now)

Dropping a table space OR a data base does NOT clear out SYSLGRNX

Only a MODIFY RECOVERY does that [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A627@MAILR004.mail.lan 29610 271 39_Re: [SPAM] Re: Significance of DSNDB04!16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Thu, 4 Mar 2010 07:25:41 -0600506_iso-8859-1 Phil,
Did you mean "can't" not "can" in the statement below?
Dan
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Thursday, March 04, 2010 6:03 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [SPAM] Re: Significance of DSNDB04!

And notice the comment "... last image copy removed with MODIFY RECOVERY"

If you don't HAVE any image copies, then you can MODIFY RECOVERY and you
won't reclaim DBD bits & pieces [...]35_01d901cabb9e$302ef0d0$908cd270$@com 29882 284 39_Re: [SPAM] Re: Significance of DSNDB04!13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Thu, 4 Mar 2010 08:37:49 -0500763_iso-8859-1 Sorry - of course Dan is right (but then he knows I type faster than I can think!)

Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0)1298 872 148
+44 (0)7505 266 768
www.cogito.co.uk

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Daniel Luksetich
Sent: 04 March 2010 13:26
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [SPAM] Re: Significance of DSNDB04!

Phil,
Did you mean "can't" not "can" in the statement below?
Dan
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Thursday, March 04, 2010 6:03 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [SPAM] Re: Significance of DSNDB04! [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A63F@MAILR004.mail.lan 30167 88 16_Re: Tool Support12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 4 Mar 2010 05:50:43 -0800447_us-ascii Actually OSC does have the capability to model Indexes on Expressions. it's not necessarily the easiest to setup but it can be done. I did it with a couple of my expression indexes when I was attempting to figure out what to do.

Myron

________________________________
From: "Bell, Raymond"
To: DB2-L@IDUGDB2-L.ORG
Sent: Thu, March 4, 2010 4:16:57 AM
Subject: Re: [DB2-L] Tool Support [...]44_524886.11556.qm@web112114.mail.gq1.yahoo.com 30256 48 19_Re: PAGE LATCH high9_Andy Hunt21_andy_hunt@YAHOO.CO.UK30_Thu, 4 Mar 2010 14:02:06 +0000558_UTF-8 Hi Mike,
I'm just wondering about your recommendation of SEGSIZE=64. I would have thought a smaller SEGSIZE would mean more space maps and so less potential contention on the space map?

I’m also currently looking at a lock/latch wait issue with a ‘write only-never read’ log table. We are doing about 90 inserts/second at V8 and occasionally get a lock/latch bottleneck that backs the transactions up and causes CICS issues. Our table has no index, empty at start of day, ,is non-datasharing, using page locks and all in 1 extent. [...]52_6083117905684272.WA.andyhuntyahoo.co.uk@www.idug.org 30305 422 16_Re: Tool Support13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Thu, 4 Mar 2010 15:02:40 +0100345_us-ascii Ah. There you go, Raymond, as a colleague in the States is prone to say. If it involves the Virtual Index tables then yes, I can see how it might be 'challenging'. Needless to say we do have a simple implementation - a matter of typing E next to the column you're thinking of creating an IOE index on. But ta for the intel' Myron. [...]71_2ECBF1EB8D499348849093615F9901550147FAC5357D@AMSCCRPRD01.adprod.bmc.com 30728 37 36_Re: Any users of COMPRESS_SPT01=YES?0_29_Pat.Mcmanus@MUTUALOFOMAHA.COM30_Thu, 4 Mar 2010 08:04:20 -0600369_us-ascii I applied compression to SPT01 back in May 2009 when this was a usermod. We
were at V8 at the time and have since moved on to V9 NFM on all subsystems.
After I applied the usermod and did a reorg on SPT01 I realized around 70%
to 75% reduction across the board on all my subsystems. The largest SPT01
was right around 4gb. before compression. [...]75_OF4C25F173.28A3995B-ON862576DC.004D3196-862576DC.004D4D09@mutualofomaha.com 30766 25 29_DB2 messages on the OPERLOG ?11_Nenad Vidak21_nenad.vidak@GMAIL.COM30_Thu, 4 Mar 2010 14:29:01 +0000634_UTF-8 Hello,
is there a way to have only DB2 messages merged from different DB2 members displayed on the operlog ? Basically I would like to filter out all other messages except DB2 ones.
Regards, Nenad

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]53_4148836553146922.WA.nenad.vidakgmail.com@www.idug.org 30792 44 28_Re: DB2 Support Quality Poll12_Bob Jeandron21_bob.jeandron@USDA.GOV30_Thu, 4 Mar 2010 14:05:18 +0000554_UTF-8 IBM has the best support.
One morning I had a sev 1 prob in both DB2 z/os and Oracle. I contacted both vendors and opened a problem with each. Within a 1/2 hour, IBM called back to find out more information.....The responder went "down the hall" to ask one of the DB2 Developers what was going on and the issue was immediately resolved. Oracle did not call back for 3 days, fortunately we found the problem, but waited just to see how long Oracle would take to respond. One day I called Oracle World Wide Support the day after Thanksgiving [...]53_2371740634674684.WA.bob.jeandronusda.gov@www.idug.org 30837 587 39_Re: [SPAM] Re: Significance of DSNDB04!13_David Simpson22_dsimpson@THEMISINC.COM30_Thu, 4 Mar 2010 09:55:32 -0500682_iso-8859-1 Hmmm... I know about the SYSLGRNX problem, but SYSCOPY does get cleaned up on a DROP TABLESPACE and the DBD does get smaller (I just tested that). Is there some "bit" or "piece" of the DBD that doesn't go away on a DROP when SYSLGRNX wasn't cleaned up?

______________________________________________________________________________
David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | dsimpson@themisinc.com
For more information about Themis, visit www.themisinc.com [...]67_7EC87535E7581C4C890F5BF1CF9A937401C96DCB@THEMISSRV1.themisinc.local 31425 104 27_AW: [DB2-L] PAGE LATCH high35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Thu, 4 Mar 2010 16:26:40 +0100426_iso-8859-1 Hi Andy

AFAIK: segsize has no influence on what the spacemap controls. The number of pages controlled by the spacemap is only limited by the size of the spacemap.

TRACKMOD does not influence how freespace is maintained, but if the page was updated since the last copy. If you go for TRACKMOD NO, then only the elapsed time of incremental copies will increase (because it has to check each page). [...]43_DB2-L%201003041526500392.013C@IDUGDB2-L.ORG 31530 91 119_IBM still wants your feedback on the DB2 for z/OS Reference Summary, Diagnostic Quick Reference, and Installation Guide11_Judy Tobias18_jtobias@US.IBM.COM30_Thu, 4 Mar 2010 09:00:04 -0800515_US-ASCII Dear DB2-L members:

The IBM User Experience team is still looking for volunteers to give us
feedback on your usage of the DB2 for z/OS Reference Summary, DB2 for z/OS
Diagnostic Quick Reference, and DB2 for z/OS Installation Guide. The
feedback you provide can play an important role in improving our
documentation.

If you have not done so already, we would really appreciate your completing
the short survey at this URL:
https://www.ibm.com/survey/oid/wsb.dll/s/ag2a1 [...]68_OF1C31ECF1.CE2E6CC6-ON882576D2.0080299C-882576DC.005D6415@us.ibm.com 31622 45 38_Re: APPEND DATA TO A ROW WHILE LOADING11_Sameer Rana21_sameerdrana@GMAIL.COM30_Thu, 4 Mar 2010 17:04:44 +0000390_UTF-8 Assuming that you do not want to go through a programmatic effort in generating the load file that would include the appended values like Timestamp, #Userid , Defect ; the other option is to manipulate the records after each load job. So basically do a mass update of records that were just loaded with the desired values of TIMESTAMP, #USERID, DEFECT after loading the records. [...]53_3695656249403596.WA.sameerdranagmail.com@www.idug.org 31668 96 23_z/os v8 end-of-service?15_Chris Hoelscher21_choelscher@HUMANA.COM30_Thu, 4 Mar 2010 13:21:22 -0500543_US-ASCII i have been to the website and seen that there is no posted end-of-service
date for z/os V8.1 - but with V10 Beta announced, V10 GA cannot be far
away - and I do not want to be boxed into a corner. Our mgmt is not
wanting to install v9 because of the immediate license fee increase -but
with the lead time required to install/test and because of
business-mandated "freeze-out" periods, if i do not get V9 in house in the
next 2 months - i can not put it into production until jan 2011at the
earliest - and i [...]68_OF5324B0F9.F5D11A29-ON852576DC.0064225D-852576DC.0064D596@humana.com 31765 245 27_Re: z/os v8 end-of-service?16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU30_Fri, 5 Mar 2010 06:59:39 +0800411_us-ascii A Rule of Thumb used to be that when version 'y' went GA, then 'version 'y-2' would be announced as going EOS in ~1-1.5 years.

Although I guess it depends on the size of your thumb... :)

Greg

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Hoelscher
Sent: Friday, 5 March 2010 2:21 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] z/os v8 end-of-service? [...]69_8522673947DF7D4394C962BFE441CD2783A865@PER-EXCHMBX.win2k.iinet.net.au 32011 93 27_Re: z/os v8 end-of-service?10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 5 Mar 2010 09:50:47 +0100424_US-ASCII In some companies managers decided to use unsupported DB2 versions for a
while (for example we used V7 for almost a year after EOS, V6 for some
months and a CICS version for more than 3

years before closing MF), applying all PTF available at EOS and
considered to be useful for your businness (for instance if you don't use
LOB there's little chance to need a PTF for them) . Surprisingly I [...]66_OFDAD32DF4.AD2E5138-ONC12576DD.0029244B-C12576DD.003040F2@cesve.it 32105 121 51_IDUG 2010 Europe - 8-12 November in Vienna, Austria10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 5 Mar 2010 10:01:09 +0100647_US-ASCII IDUG 2010 Europe
8-12 November in Vienna, Austria
IDUG is proud to announce IDUG 2010 Europe, taking place 8-12 November
2010 at the Hilton Vienna Hotel in Vienna, Austria. The event will feature
the latest in DB2 technologies, networking opportunities and the technical
content you need to be efficient in your day-to-day activities.

IDUG 2010 Europe is not only the conference you need to attend, it's also
the opportunity to participate in the DB2 community. If you're a DB2
professional who would like to share your experience and knowledge with
DB2 peers, we invite you to participate in the IDUG [...]66_OFDD041EA8.19AEC0D9-ONC12576DD.003147EB-C12576DD.003133EB@cesve.it 32227 258 46_Re: lazydba.com; was: DB2 Support Quality Poll13_Michael Ebert18_mebert@AMADEUS.COM30_Fri, 5 Mar 2010 11:00:24 +0000548_ISO-8859-1 Hi Peter,

I've registered with lazydba.com. My initial impression after two days is
"doubtful". Responses (and responders) like what's coming from one "Edward
Ed" is exactly what the business world doesn't need, IMHO. I'll lurk some
more.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany

"Peter, Georg"
To
DB2-L@WWW.IDUGDB2-L.ORG
cc

bcc

Subject
[DB2-L] Antwort: [DB2-L] DB2 Support Quality Poll [...]69_OFBFFE1B1C.408E7D36-ON002576DD.003BC9D2-C12576DD.003C7546@amadeus.com 32486 486 67_Re: IDUG 2010 Europe - 8-12 November in Vienna, Austria - Why Not??13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 5 Mar 2010 07:50:29 -0500356_us-ascii I'm not going to make a habit of a weekly poll, but this announcement about IDUG Europe reminded me of something I have been meaning to do for ages

Within IDUG, we take great care to survey attendees to get their feedback about the conferences, but it has always been difficult to determine why some people attend whilst others do not [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A69B@MAILR004.mail.lan 32973 31 45_Re: QMF with RACF Security - Effects of Cache11_Michel Helg24_michel.helg@AXA-TECH.COM30_Fri, 5 Mar 2010 13:56:26 +0000317_UTF-8 Hi all

we have put the case to IBM and already got a reply. There is an PTF available (UK53071) which addresses the problem as described by us. However some dependent PTF's are not yet released, only by end of March.
We will apply these PTFs as soon as available and let you know of the results. [...]55_0760694865386968.WA.michel.helgaxatech.com@www.idug.org 33005 116 17_z/IS DB2 V8.8 NFM15_Chris Hoelscher21_choelscher@HUMANA.COM30_Fri, 5 Mar 2010 09:43:22 -0500580_US-ASCII good Friday to everyone

we are experiencing the following in our shop:

as previously created but never used partitions are inserted into for the
first time (known internally as the "active" partition, the partition has
no stats and not likely to have stats until the first weekend following
its first use. So for the remainder of the week after a new partition has
started to be used, without stats, the access scans and does not use the
index. Really how could it, the optimizer has now idea there's data in
that "active" partition. [...]68_OF14788C14.33F78127-ON852576DD.00502912-852576DD.0050E059@humana.com 33122 369 67_Re: IDUG 2010 Europe - 8-12 November in Vienna, Austria - Why Not??16_Christian Michel18_cmichel@DE.IBM.COM30_Fri, 5 Mar 2010 15:55:51 +0100637_ISO-8859-1 Hi Phil,

I am missing answer "I can't make it because I have private activities at
the same time" which is true for me this year, sigh :-( .

Mit freundlichen Gren / Kind regards
Christian Michel

Christian Michel
E-mail: cmichel@de.ibm.com
Phone (49)-7031-16-4293
DB2 for z/OS Utilities Development
Information Management Development Boeblingen, Germany

IBM Deutschland Research & Development GmbH
Vorsitzender des Aufsichtsrats: Martin Jetter
Geschftsfhrung: Dirk Wittkopp
Sitz der Gesellschaft: Bblingen / Registergericht: Amtsgericht Stuttgart,
HRB 243294 [...]68_OFF40BA376.C9B575B0-ONC12576DD.0051ABE9-C12576DD.005204F0@de.ibm.com 33492 304 21_Re: z/IS DB2 V8.8 NFM14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 5 Mar 2010 10:11:08 -0500452_us-ascii Chris:
At the risk of picking nits, do you mean z/OS V8.1? I've never heard of anything similar to what you wrote in title ;-)

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Hoelscher
Sent: Friday, March 05, 2010 9:43 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] z/IS DB2 V8.8 NFM

good Friday to everyone

we are experiencing the following in our shop: [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033378CF79@MAIL02.fisalan.nycnet 33797 345 21_Re: z/IS DB2 V8.8 NFM13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Fri, 5 Mar 2010 16:14:49 +0100680_us-ascii Hi Chris,

Is VOLATILE a parm that might be useful to you? Maybe worth a butcher's...

Cheers,

Raymond

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Hoelscher
Sent: 05 March 2010 14:43
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] z/IS DB2 V8.8 NFM

good Friday to everyone

we are experiencing the following in our shop:

as previously created but never used partitions are inserted into for the first time (known internally as the "active" partition, the partition has no stats and not likely to have stats until the first weekend following its first use. So for the remainder of the week after a [...]71_2ECBF1EB8D499348849093615F9901550147FAD01C26@AMSCCRPRD01.adprod.bmc.com 34143 78 21_Re: z/IS DB2 V8.8 NFM15_Chris Hoelscher21_choelscher@HUMANA.COM30_Fri, 5 Mar 2010 10:16:03 -0500517_US-ASCII yes - z/OS

dammit jim, i'm a dba, not a typist

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly

The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. [...]68_OFD4F31687.86FFD394-ON852576DD.0053CEA8-852576DD.0053DE58@humana.com 34222 180 21_Re: z/IS DB2 V8.8 NFM19_Jardine, Lawrence J19_JardineLJ@AETNA.COM30_Fri, 5 Mar 2010 10:17:32 -0500427_us-ascii You can alter the table to "volatile yes" which will favor index access. Or you can use SQL to update catalog statistics on the unused partitions (data and index).

Larry Jardine
Aetna
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Hoelscher
Sent: Friday, March 05, 2010 9:43 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] z/IS DB2 V8.8 NFM [...]70_C7DCA78FAF334147B2FD39A220A4C500019EC18283@HFDPMSGCMS02.aeth.aetna.com 34403 53 45_Re: QMF with RACF Security - Effects of Cache13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 5 Mar 2010 10:19:35 -0500554_utf-8 Hmm

I did a search on UK53071 and found PM05218 which says "ABND04E RC00C90101 DURING BIND WITH UK53070 (V8) / UK53071 (v9) APPLIED"

I think I'd check this out before applying UK53071 in any case (perhaps that's what’s meant by "dependent ptfs")

Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A6BC@MAILR004.mail.lan 34457 427 21_Re: z/IS DB2 V8.8 NFM13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 5 Mar 2010 10:31:04 -0500514_us-ascii I think I'd be inclined to "see the stats" with -1 and trick the optimiser into considering "stats are absent" access path choices rather than "partition is empty" when you have 0 for various stats

Seeding the stats with representative values is fraught with danger, unless you know your data intimately (which most of us don't)
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A6C2@MAILR004.mail.lan 34885 306 21_Re: z/IS DB2 V8.8 NFM14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 5 Mar 2010 10:38:10 -0500493_us-ascii Chris, to your concern: Have you tried defining the table with the VOLATILE keyword, and checking binds once that is set? The V8 Release Planning Guide (at least) says that DB2 should prefer to use indexes in all accesses if this keyword is set.
--Phil

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Hoelscher
Sent: Friday, March 05, 2010 9:43 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] z/IS DB2 V8.8 NFM [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033378CF7B@MAIL02.fisalan.nycnet 35192 98 21_Re: z/IS DB2 V8.8 NFM10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 5 Mar 2010 16:45:08 +0100628_US-ASCII Hi

I'm not sure if I understood your question well (I don't know too much DB2
8.8 for z/IS ;-))) ), but once DB2 used default statistics for access path
if no stats were available, so just to say (from administration manual):



Tables with default statistics for NPAGES (NPAGES =-1) are presumed to
have 501 pages. For such tables, DB2 will favor matching index access only
when NPGTHRSH is set above 501. Recommendation: Before you use NPGTHRSH,
be aware that in some cases, matching index access can be more costly than
a table space scan or nonmatching index access. [...]66_OF8A104A97.98C839D9-ONC12576DD.0054A422-C12576DD.0056307A@cesve.it 35291 25 55_Re: IDUG 2010 Europe - 8-12 November in Vienna, Austria10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Fri, 5 Mar 2010 15:52:23 +0000716_UTF-8 Vienna, Rome, I don't know how you Europeans focus on DB2 in such wonderful cities.
Although Tampa can make it hard as well.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_8408240347018069.WA.jorghluekebcbsmn.com@www.idug.org 35317 397 21_Re: z/IS DB2 V8.8 NFM17_Kniaz, Benjamin X26_benjamin.x.kniaz@CHASE.COM30_Fri, 5 Mar 2010 10:54:07 -0500593_utf-8 Chris,

NPGTHRSH zparm might do what your looking for.

From the V8 Admin Guide, page 767

Using a subsystem parameter to favor matching index access DB2 often does a table space scan or nonmatching index scan when the data access statistics indicate that a table is small, even though matching index access is possible. This is a problem if the table is small or empty when statistics are collected, but the table is large when it is queried. In that case, the statistics are not accurate and can lead DB2 to pick an inefficient access path. The best solution to [...]75_B24CECEFB74A044ABE7D6A4B7A655449080BE4776F@EMARC142VS01.exchad.jpmchase.net 35715 64 21_Re: z/IS DB2 V8.8 NFM10_Joe Geller21_joerg6666@HOTMAIL.COM30_Fri, 5 Mar 2010 16:06:42 +0000554_UTF-8 Max,
My interpretation of the manual is that NPGTHRSH affects the optimizer's choice if it is set to n <> 0 (which is the default). If you use the default of 0, then DB2 will do it's (or is it his/hers?) normal statistics based analysis. The default table statistics should give you matching index access in most cases.
n = -1 favors matching index access for all tables
n > 0 favors matching index access if NPAGES < n. The manual doesn't say what happens if NPAGES >= n, but again, my interpretation is that DB2 would do the normal [...]53_1748841928143978.WA.joerg6666hotmail.com@www.idug.org 35780 47 55_Re: IDUG 2010 Europe - 8-12 November in Vienna, Austria13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Fri, 5 Mar 2010 11:08:23 -0500624_utf-8 You mean Denver, Dallas, San Jose/SVL, Orlando, Las Vegas etc weren't somewhat distracting??

Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke
Sent: 05 March 2010 15:52
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] IDUG 2010 Europe - 8-12 November in Vienna, Austria [...]58_4440F5DA00E3F3459BBCB97431B91B660F26A6D1@MAILR004.mail.lan 35828 257 40_z/OS DB2 DBA Staffing Criteria/Standards19_Claypool, Alisa@EDD25_Alisa.Claypool@EDD.CA.GOV30_Fri, 5 Mar 2010 08:12:13 -0800575_us-ascii Good day to you all.

I've recently crossed over from the technical side to the management side. It is a difficult and painful transition, but I digress. I'm in the process of identifying our 'total' workload and what the staffing should be for baseline support. This is a DB2 z/OS V8 non data sharing (at this time) shop with both mainframe and distributed applications. There is no criteria defined in this shop and I need help to determine what the staffing level should be. I know this type of question has been posted in the past but I couldn't find [...]78_9F049831A018964597D84EF3A941F977227255BCD2@MDTSSWECCR19.rf01.itservices.ca.gov 36086 492 34_[OT] RE: [DB2-L] z/IS DB2 V8.8 NFM14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 5 Mar 2010 11:24:26 -0500432_us-ascii Raymond and my other DB2-L P-O-M (am I using that right?) friends,
What the heck does "Worth a butcher's" or "have a butcher's" mean, anyway? Worth trying? Worth a small try?

--Phil

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond
Sent: Friday, March 05, 2010 10:15 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] z/IS DB2 V8.8 NFM [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033378CF7C@MAIL02.fisalan.nycnet 36579 570 38_Re: [OT] RE: [DB2-L] z/IS DB2 V8.8 NFM13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Fri, 5 Mar 2010 17:29:23 +0100405_us-ascii Matey,

No matter how you view the definition of Pom (either an Australian or, more popularly/accurately (probably), a Brit) I am not a Prisoner of Mother England. Actually that's not true; I did get British citizenship awhile ago, but that's another story.

It's Cockney rhyming slang. Butcher's hook -> look. So the use of VOLATILE is worth a look. Easy when you know how, eh? [...]71_2ECBF1EB8D499348849093615F9901550147FAD01D35@AMSCCRPRD01.adprod.bmc.com 37150 587 38_Re: [OT] RE: [DB2-L] z/IS DB2 V8.8 NFM11_Mike Turner19_mike.turner@GMX.COM30_Fri, 5 Mar 2010 16:45:29 -0000529_iso-8859-1 Butcher's hook = look.

Regards
Mike Turner
Email: mike.turner@gmx.com
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk
Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44.
----- Original Message -----
From: Sevetson, Phil
Newsgroups: bit.listserv.db2-l
To: DB2-L@IDUGDB2-L.ORG
Sent: Friday, March 05, 2010 4:24 PM
Subject: [DB2-L] [OT] RE: [DB2-L] z/IS DB2 V8.8 NFM [...]44_6E85081AE01244CA99190F95D2C50D16@ToshibaA300 37738 731 38_Re: [OT] RE: [DB2-L] z/OS DB2 V8.8 NFM15_Mike Dransfield38_Michael.Dransfield@BARCLAYSCAPITAL.COM30_Fri, 5 Mar 2010 11:46:00 -0500347_us-ascii Phil,

Google is your friend.

Noun. A look. From the Cockney rhyming slang butcher's hook. E.g."Let's have a butchers at it before you put it back."

For another example from Cockney rhyming slang, apples = stairs from "apples & pears" e.g., "let's take the apples instead of the elevator" (lift for those in UK?) [...]76_1F3DCD8A1A1ADF4D99443C7A341695F6244EDD29@NYKPCMMGMB07.INTRANET.BARCAPINT.COM 38470 183 33_[JOB] DataStage Consultant Needed7_Kim May28_kim.may@THEFILLMOREGROUP.COM30_Fri, 5 Mar 2010 14:50:44 -0500910_US-ASCII I am looking for an experienced DataStage consultant to provide 4 weeks of
implementation support. Please contact me off list at
kim.may@thefillmoregroup.com if you are interested and qualified. Thanks!

Kim May, Vice President, Business Development

IBM Information Champion

The Fillmore Group, Inc.

(410) 465-6335 office

(443) 956-0288 mobile

www.thefillmoregroup.com

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, [...]45_4b9160af.0508d00a.7be4.fffff55c@mx.google.com 38654 151 21_Re: z/IS DB2 V8.8 NFM12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 5 Mar 2010 14:10:08 -0800372_us-ascii Two options: VOLATILE is one - force index usage if table has no rows (stats) but is likely to have a number of rows
2) Seed the stats using one of the other partition's stats.

Both work very well and each will work better than the other depending upon the type of queries, I've done both and are using both currently depending upon the situation. [...]44_902241.48117.qm@web112106.mail.gq1.yahoo.com 38806 464 21_Re: z/IS DB2 V8.8 NFM16_Daniel Luksetich18_danl@DB2EXPERT.COM30_Sat, 6 Mar 2010 07:15:07 -0600460_us-ascii Chris,

I always seed or fake the stats, but you can try making the table VOLATILE.
Some risk with that so test, test, test.

Dan

Daniel L Luksetich

IBM Information Champion

IBM Certified Database Administrator - DB2 9 for z/OS

IBM Certified System Administrator - DB2 9 for z/OS

IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database
Administration for UNIX, Windows, and OS/2 [...]35_038c01cabd2f$0b1db7d0$21592770$@com 39271 83 54_Re: DB2-L Digest - 6 Mar 2010 to 7 Mar 2010 (#2010-65)16_Sheryl M. Larsen18_smlsql@COMCAST.NET30_Sat, 6 Mar 2010 20:19:52 -0600613_utf-8 I lovee your new title! DB2-L automatic digest system wrote: >Chris, > >I always seed or fake the stats, but you can try making the table VOLATILE. >Some risk with that so test, test, test. > >Dan > > > >Daniel L Luksetich > >IBM Information Champion > >IBM Certified Database Administrator - DB2 9 for z/OS > >IBM Certified System Administrator - DB2 9 for z/OS > >IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database >Administration for UNIX, Windows, and OS/2 > >IBM Certified Solutions Expert - DB2 UDB V7.1 Family Application Development > >IBM Certified [...]56_uxve09qp1ygnau7kocn9eijb.1267928392133@email.android.com 39355 74 64_AUTO: James A Brogan is out of the office (returning 03/15/2010)14_James A Brogan18_jambrog@US.IBM.COM30_Sat, 6 Mar 2010 22:01:50 -0500424_US-ASCII I am out of the office until 03/15/2010.

I am out of the office 3/6-3/14 returning on 3/15 with no access to email
and voice messages ..... I will respond when I return. If this is an
emergency please contact my manager Sharon Brower at sbrower@us.ibm.com.

Note: This is an automated response to your message "DB2-L Digest - 6 Mar
2010 to 7 Mar 2010 (#2010-65)" sent on 3/6/10 20:00:01. [...]68_OF1C943295.8939EA13-ON852576DF.0010A616-852576DF.0010A616@us.ibm.com 39430 236 20_Dubuntu - It's free!22_Frank C. Fillmore, Jr.19_tfgpublic@GMAIL.COM30_Sun, 7 Mar 2010 14:21:24 -0500625_us-ascii Do you have Dubuntu? It's the all-in-one DB2 + Ubuntu Linux VMWare
"appliance". It's free! http://www.thefillmoregroup.com/blog/?p=291.

+-------------------------------------+-------------------------------------
--------+

| Frank C. Fillmore, Jr. | Office: 410.465.6335 Mobile:
410.963.0416 |

| The Fillmore Group, Inc. (TFG) | Facsimile: 888.828.4717
|

| 8501 LaSalle Road; Suite 318 | IBM Training: 800-TFG-RDBMs
(800.834.7326) |

| Towson, Maryland 21286 | URL: http://thefillmoregroup.com
|

| USA | Blog:
http://www.thefillmoregroup.com/blog | [...]35_002501cabe2b$62295eb0$267c1c10$@com 39667 105 85_DB2 z/OS SQL Procedures: What are you using for Source Code Management and Migration?15_Bernie O'Connor26_berniedb2loconnor@LIVE.COM30_Sun, 7 Mar 2010 17:57:26 -0500433_iso-8859-1 This is a DB2 for z/OS question.

We're using external SQL Procedures and COBOL Stored Procedures. Our Code Repository and Change Manager for both: SCLM. It works great, and the biggest challenge we have is getting people up to speed on ARCHDEFs.

We're going to DB2 9 NFM on April 25. We can continue the same SCLM process, with some modification. The question came up: What else are other people doing? [...]42_SNT108-W38E04B0DC103BCC34555892360@phx.gbl 39773 111 38_DB2 Support Quality Poll - the Results12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Sun, 7 Mar 2010 23:24:40 +0000501_UTF-8 Hi all,

as promised, these are the results of my poll on support quality for DB2.

The questions were:
- DB2 Platform
- Maint/Support contract yes / no
- Support rating (1=poor to 5=excellent with 3=satisfactory)
- Comments / ideas for improvement

Voting Results:

Platform
========
# of responses: 41
whereof LUW : 12
z/OS: 25
unspecified: 4

Maint/Support contract
======================
yes : 31
no : 0
unknown : 10 [...]55_9282041469799576.WA.petersuhnerhotmail.com@www.idug.org