1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2010, week 4 2 40 12_DASD Wastage4_Anil21_alisha_kale@YAHOO.COM31_Mon, 22 Feb 2010 03:22:35 +0000516_UTF-8 Hi All,

I have a storage group wherein there are multiple volumes with free space ranging from 10 cyl to about 70 cyl. Since there are about 100+ volumes in the storage group, the free space amounts to about 5000 cylinders. Our MGEXTSZ zparm is set to NO. By changing MGEXTSZ to YES, would it help use the free space in .these volumes more effectively ? Is there anything else to watch out for after we set MGEXTSZ to YES. Any other alternatives to effectively using the DASD in the storage group. [...] 43 26 16_Re: DASD Wastage11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 22 Feb 2010 05:28:41 +0000303_- >Since there are about 100+ volumes in the storage group, the free space amounts to about 5000 cylinders.

5000 cylinders works out to 4.25 GB. At today's prices, that's about $20 (US) over three years.

With all due respect, I think that's a nit. - Too busy driving to stop for gas! [...] 70 54 51_Re: SV: [DB2-L] DB2 failed and restart failed RESTP10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 22 Feb 2010 08:39:51 +0100652_US-ASCII Hi Hanne

Strange, DEFER(object) was made to avoid CRC restart in some cases. Infact It's since so looonnggg tine I didn't use CRC restart. Anyway happy skiing, here in Dolomites there's a lot of snow :-)

Max



_____________________________________________________________________

* 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 _____________________________________________________________________ [...] 125 434 28_DB2 for z/OS Library History10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 22 Feb 2010 04:07:03 -0500580_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, February 15th 2010





Here are several DB2 for z/OS manuals from Version 2.3 to Version 9, available on IBM Library Server Library website:





All manuals are available in HTML format and for downloading in BookManager format. PDF files are available starting with Version 5. You can browse BookManager files with free IBM Sofcopy Reader tool available for Windows and Linux. [...] 560 65 16_Re: DASD Wastage13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 22 Feb 2010 05:00:23 -0500372_iso-8859-1 And isn't free space (within reason) a GOOD thing?

Unless your data is not growing AT ALL, it is good practice to have somewhere for it to grow into

I used to work with around 10% free space per volume

Paying for "unused space" is much better than the panic that hits when something fails to extend (always at the most awkward moment) [...] 626 46 16_Re: DASD Wastage4_Anil21_alisha_kale@YAHOO.COM31_Mon, 22 Feb 2010 12:24:08 +0000557_UTF-8 Good Point Phil !

I guess I was in rush to send out that note. I need to clarify more.

I have a bunch of DASD which have enough space to fit in the application new inserts/load. However, there are several other DASD in the storage group that have very small chunks of space available. And that would most likely give you a small extent on each of these volumes. Which in turn exposes you to some "extents issues". Or may be these small chunks would never be used because there are volumes having larger number of free cylinders. So [...] 673 79 20_LUW: TSA and Windows37_=?Windows-1252?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Mon, 22 Feb 2010 13:29:52 +0100361_Windows-1252 Hi folks,

I'm posting this on behalf of a colleague of mine:

Has anyone ever successfully implemented HADR-functionality via TSA on WINDOWS ?

We seem not to be able to succeed.

And yes, a simple "YES" or "NO" as an answer might not be the answer my colleague hopes for ;-)

Best regards and thanks in advance [...] 753 37 16_Re: DASD Wastage11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 22 Feb 2010 13:07:42 +0000330_- >So I was looking at more effective ultiization of these volumes such that I reduce the exposure of having too many extents of a db2 datasets.

And, what exposure(s) do you expect? There have been so many changes to both the hardware and software, that people are not aware of. There are few, if any exposures, left. [...] 791 224 16_Re: DASD Wastage35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Mon, 22 Feb 2010 09:44:46 -0500427_iso-8859-1 Letting someone else worry about it.... that why I still see mediocre to poor dasd performance in many of the DB2 systems I analyze.

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 www.responsivesystems.com [...] 1016 96 27_Re: [SPAM] Re: DASD Wastage16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Mon, 22 Feb 2010 08:46:03 -0600521_UTF-8 Interesting that you first message mentioned the autonomic MGEXTSZ install parameter. As far as I know DB2 is aware of the data, but not the DASD so it is probably not aware of the holes on some of the logical DASD devices. If I'm wrong on this someone please let me know. SMS may be more aware when the datasets and extents are allocated, and as I'm sure you know will reduce the extent size if it will fit on the DASD. As Phil said having the free space is a good thing. You're not wasting your DASD you are [...] 1113 33 11_LUW Classes12_Bob Jeandron21_bob.jeandron@USDA.GOV31_Mon, 22 Feb 2010 16:31:25 +0000351_UTF-8 Been working with DB2 for z/os and Oracle on Unix, but need class on how to install/admin DB2 on Linux, Unix and Windows.

Have looked at the IBM classes....Would like an admin workshop for experienced DBAs/SYSADMs that includes an install.

Any other capable companies out there that have provided you with valuable education? [...] 1147 33 16_Re: DASD Wastage11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 22 Feb 2010 16:35:43 +0000343_- >Letting someone else worry about it....

Since it's the storage admins job, yes, let them worry about it. If your storage admin is not doing their job, you have two options: 1. Review education needs. 2. Review exit strategies.

>that why I still see mediocre to poor dasd performance in many of the DB2 systems I analyze. [...] 1181 95 23_DB2 PROGRAM WORKING SET25_Miguel Del Valle Martinez24_mdelvalle@EVERTECINC.COM31_Mon, 22 Feb 2010 12:43:04 -0400711_UTF-8 Does anybody knows if the working set of DB2/SQL program is charge to DB2 or the program in question. Regards MIGUEL





----------------------------------------- CONFIDENTIALITY NOTE: This email communication and its attachments contain information that are proprietary and confidential to EVERTEC, INC., its affiliates or its clients. They may not be disclosed, distributed, used, copied or modified in any way without EVERTEC, Inc.’s authorization. If you are not the intended recipient of this email, you are not an authorized person. Please delete it and notify the sender immediately. EVERTEC, Inc. and its affiliates do not assume any liability for damages resulting from [...] 1277 71 15_Re: LUW Classes0_24_carol.sutfin@REGIONS.COM31_Mon, 22 Feb 2010 11:04:42 -0600649_US-ASCII IBM had just a course like this.

Titled something like - administration for "Experienced Relational DBAs"

I took it several years back.

Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com





From: Bob Jeandron

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

Date: 02/22/2010 10:48 AM

Subject: [DB2-L] LUW Classes

Sent by: IDUG DB2-L











Been working with DB2 for z/os and Oracle on Unix, but need class on how to install/admin DB2 on Linux, Unix and Windows. [...] 1349 38 65_DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.13_Walter Eachus15_walt@LEHMAN.COM31_Mon, 22 Feb 2010 17:31:02 +0000426_UTF-8 Our Mainframe is being shutdown and the firm wants to keep the imagecopies for historical purposes but they do not want to keep around a DB2 subsystem or its associated software.

They are keeping a very, very basic mainframe for this purpose.

They want a utility to read the imagecopy and the output being a dataset that the data can be read with the "naked" eye ( e.g. DECIMAL is now ZONED DECIMAL). [...] 1388 87 16_Re: DASD Wastage12_Kirk Hampton37_kirk.hampton@ENERGYFUTUREHOLDINGS.COM31_Mon, 22 Feb 2010 11:36:47 -0600532_us-ascii Let's get a grip now, Anil never said in the first post whether he was using a DB2 STOGROUP or an SMS storage group, so we don't really know whether this is A DBA's job or a storage admin's job.

Either way, 10 to 70 CYLs free is only about 2% free space, assuming these are 3390-3 volumes. That's pretty full. I would not be worrying about the most efficient way to use up those last few cylinders, I would be reorging some of the heavier insert tablespaces to try and move them off of the very full volumes to [...] 1476 27 16_Re: DASD Wastage11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 22 Feb 2010 17:53:51 +0000413_- >Anil never said in the first post whether he was using a DB2 STOGROUP or an SMS storage group, so we don't really know whether this is A DBA's job or a storage admin's job.

I assumed that Anil was a DBA, since the original post mentioned a ZPARM option. Also, worrying about 4.25 GB is something an application oriented individual (DBA) worries about, rather than a tech-support type (Stor Admin). [...] 1504 83 69_Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 22 Feb 2010 12:06:12 -0600474_US-ASCII

Not that I know of - I have heard of people trying to extract data from image copies and it seems like the only soulution is to build a DB2 subsystem, create a clone table, and use DSN1COPY to put the data back.

It would be a lot easier to either 1. unload the data in mainframe format and keep copybooks for each table Or 2. unload the data in character format using DSNTIAUL and a SQL statement that converts every internal format to display. [...] 1588 89 69_Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.15_Chris Hoelscher21_choelscher@HUMANA.COM31_Mon, 22 Feb 2010 13:15:26 -0500382_US-ASCII They want a utility to read the imagecopy and the output being a dataset that the data can be read with the "naked" eye ( e.g. DECIMAL is now ZONED DECIMAL). --------------------------------------------



would not an unload from an imagecopy do the trick ?

Chris Hoelscher IDMS/DB2 Database Architect Humana Inc 502-476-2538 choelscher@humana.com [...] 1678 68 69_Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 22 Feb 2010 13:11:58 -0500602_us-ascii Sounds like you need to run a lot of UNLOADs, Walt. DB2 UNLOAD will take imagecopy datasets as input, but it requires the presence of the catalog and a working DB2 system.

I don't think it's _possible_ for a program to read an imagecopy, without a lot of information that's normally present in the DB2 Catalog and Directory. You need column definitions, DBID/OBID/PSID information, and of course the compression dictionary if your datasets are compressed (You could wind up with an incremental copy but no compression dictionary, and thus have no way to interpret the data at all) [...] 1747 72 16_Re: DASD Wastage14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 22 Feb 2010 13:16:26 -0500354_us-ascii Ted,

You're making a lot of assumptions there. I've been a DBA at shops where the DB2 sysprog was also the z/OS Sysadmin, and didn't have _time_ to be the DB2 storage admin as well. DBAs are sometimes expected to do this job; in a sufficiently small shop, many roles get switched around depending on team needs and individual gifts. [...] 1820 268 69_Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 22 Feb 2010 13:27:09 -0500386_us-ascii I think the best for that would be to specify "DELIMITED" in the unload. That way you get CSV format.

________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Hoelscher Sent: Monday, February 22, 2010 1:15 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem. [...] 2089 48 69_Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.13_Bright, Randy20_Randy_Bright@BMC.COM31_Mon, 22 Feb 2010 11:39:23 -0700539_utf-8 Unload Plus for DB2 from BMC Software will read an Image Copy and output a sequential dataset. It does require a DB2 subsystem to be available, but the table does not have to be defined to the DB2 subsystem, you just have to supply the correct DDL for the table to Unload Plus and it will read the Image Copy and output a sequential dataset in the format you want. This does not fit all your requirements, but I don't know of an existing utility that will read an Image Copy, dissect the rows and output a sequential dataset if [...] 2138 39 16_Re: DASD Wastage11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 22 Feb 2010 19:07:28 +0000321_- >You're making a lot of assumptions there.

I don't think so. The primary point was that 4.25 GB was not worth worrying about. This is being blown out of proportion.

>I've been a DBA at shops where the DB2 sysprog was also the z/OS Sysadmin, and didn't have_time_ to be the DB2 storage admin as well. [...] 2178 405 69_Re: DB2 z/OS 8 CM - Using DB2 Imagecopies outside of a DB2 Subsystem.16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Mon, 22 Feb 2010 14:37:54 -0500345_US-ASCII I can see Randy already replied with the BMC solution J

CA Fast Unload can unload from an image copy even though the table doesn't exist. You just need to supply the TABLE DDL, and you can then use all the different output formats you want.





Steen Rasmussen CA

Sr Engineering Services Architect [...] 2584 35 34_APPEND DATA TO A ROW WHILE LOADING9_Raj Ghose17_raj.ghose@RBC.COM31_Mon, 22 Feb 2010 20:29:14 +0000303_UTF-8 Hi List, I would like to append data (constant value at the end) to every row in the load file during load time. There are multiple load files and each has a different record length. Please note that this procedure is not a one time solution. It has to be used many times during the project. [...] 2620 35 38_Re: APPEND DATA TO A ROW WHILE LOADING13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 22 Feb 2010 15:36:12 -0500474_utf-8 Where do these load files come from?

The simplest solution might be to add the constant to the files when they are created

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 Raj Ghose Sent: 22 February 2010 20:29 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] APPEND DATA TO A ROW WHILE LOADING [...] 2656 182 38_Re: APPEND DATA TO A ROW WHILE LOADING15_Andrew Lawinger17_alawinger@MMM.COM31_Mon, 22 Feb 2010 14:46:10 -0600299_US-ASCII Assuming that you are adding a value that is going to be put into a column in the tables, rather than something that is getting appended to a column that is already in the load file... Rather than updating the load files, maybe you could define those columns as not null with default. [...] 2839 80 38_Re: APPEND DATA TO A ROW WHILE LOADING14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 22 Feb 2010 15:46:23 -0500512_iso-8859-1 Raj,

1) What Phil G. said -- simplest is to create the record with the value already populated 2) Application programs, one for each data source. REXX or EASYTRIEVE (if you have it) if the files are small; COBOL or C if they're large.

--Phil Sevetson

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger Sent: Monday, February 22, 2010 3:36 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] APPEND DATA TO A ROW WHILE LOADING [...] 2920 58 51_Re: SV: [DB2-L] DB2 failed and restart failed RESTP18_Sandra Lakenburger27_sandra.lakenburger@USDA.GOV31_Mon, 22 Feb 2010 21:03:16 +0000337_UTF-8 Hanne,

PM08125 was recently created for the DSNX230I message not being issued consistently when a subsystem is started in maint mode. I've got subsystems where one day when they are started in maint mode this message is issued referencing DBD01 and at other times it isn't. The response I got in my PMR I had open was: [...] 2979 117 38_Re: APPEND DATA TO A ROW WHILE LOADING13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 22 Feb 2010 16:04:49 -0500429_iso-8859-1 OR (and I can't believe this just occurred to me)

Change the columns you are "loading" the constant value into so that they have a user defined default of what you want

Then, put the default value back to what it was before you did the load

ASSUMING this doesn't cause problems if you have concurrent insert activity expecting a particular default OTHER than the one YOU want from your loads [...] 3097 75 67_=?UTF-8?Q?=D7=AA=D7=A9=D7=95=D7=91=D7=94=3A_?= [DB2-L] DASD Wastage14_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Mon, 22 Feb 2010 23:07:58 +0200351_UTF-8 Anil,

We keep our SMS storage pools for DB2 page data sets at least 20% free. It was our management decision and, in this specific case, I agree ( sometimes, even management knows to make right decisions !!). Not to satisfy a new ALLOC request from DB2 is much more serious in our 24*7 environment than have spare unused DASD space. [...] 3173 178 27_[Job Ad] DB2 for LUW Boston7_Kim May28_kim.may@THEFILLMOREGROUP.COM31_Mon, 22 Feb 2010 21:04:20 -0500384_us-ascii I am trying to staff two temporary contract positions in the Boston area - both are for DB2 for LUW DBA's. The positions are for multiple months - one is for 6 months and the other is for 9 months. Both require someone local to the Boston area, and both require U.S. citizenship. If you are interested please contact me off-list at kim.may@thefillmoregroup.com. Thanks. [...] 3352 1431 38_Re: IMMEDWRITE YES Performance problem12_Jose Antonio17_jamorcillo@CAM.ES31_Tue, 23 Feb 2010 08:16:47 +0100805_iso-8859-1 Thanks Robert!





We have found transaction that spawns the problematic dependent transaction and we have BIND it with IMMEDWRITE(YES) with good

results.





Thanks again





José









__________________________ José A Morcillo Valenciano Tfno.: +34 965 90 51 43 747-Producción Informática

Administración DB2 Oracle



__________________________









________________________________

De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Robert Catterall Enviado el: lunes, 15 de febrero de 2010 5:01 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: Re: [DB2-L] IMMEDWRITE YES Performance problem [...] 4784 39 16_Re: DASD Wastage12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Tue, 23 Feb 2010 07:34:49 +0000516_UTF-8 Anil - you posted this with subjet "DASD Wastage". Do you really have DASD wastage? It doesn't sound like it. Re "effectively using the DASD in the storage group" - it looks as if the volumes in this storage group are being effectively used.

Do you have specific problems? Are you experiency poor I/O performance against these volumes? I agree with Joel that DASD performance is still an issue but if you haven't got problems then you can let DB2 and your storage management system do their thing. [...] 4824 72 41_QMF with RACF Security - Effects of Cache11_Michel Helg24_michel.helg@AXA-TECH.COM31_Tue, 23 Feb 2010 11:13:08 +0000396_UTF-8 Hi all

we observe the following:

User A has RACF rights on Table T User B has not

A saved query exists in QMF:

User B executes query – fails (obvious)

User A executes query – runs ok (obvious) User B executes query directly afterwards – runs ok (should fail !!!)

User B makes a slight change to the query (comments out a line) – fails [...] 4897 20 33_Defaults for EXCEPT and INTERSECT13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 23 Feb 2010 06:32:32 -0500389_utf-8 I'm sure I know the answer to this, but I can't find it documented anywhere

The default for the UNION operator is UNION DISTINCT (ie, remove duplicates)

That's because historically there was no such thing as UNION ALL - we just had UNION

I feel sure that DISTINCT is also the default for INTERSECT and EXCEPT, but I can't find that fact documented anywhere [...] 4918 64 45_Re: QMF with RACF Security - Effects of Cache13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 23 Feb 2010 06:36:47 -0500442_utf-8 Michael

I'd do one last thing, if you can

Change you test scenario to be

User B executes query – fails (obvious)

User A executes query – runs ok (obvious) User B executes query directly afterwards – runs ok (should fail !!!)

Run RUNSTATS UPDATE NONE REPORT NO on the table (invalidates the SQL in the dynamic statement cache) User B executes query directly after the RUNSTATS has completed [...] 4983 167 45_Re: QMF with RACF Security - Effects of Cache14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Tue, 23 Feb 2010 06:33:34 -0600497_UTF-8 if I could throw out a suggestion as well. If you are looking to isolate an issue with RACF and the stmt cache, recreate with dsntep2 or spufi. QMF is its own ecosystem and it just adds to the complexity of your issue. Reduce the variables.

Good luck, Faz

----- Original Message ----- From: IDUG DB2-L To: DB2-L@www.idugdb2-l.org Sent: Tue Feb 23 05:36:47 2010 Subject: Re: [DB2-L] QMF with RACF Security - Effects of Cache [...] 5151 210 45_Re: QMF with RACF Security - Effects of Cache11_Roy Boxwell16_R.Boxwell@SEG.DE31_Tue, 23 Feb 2010 13:38:54 +0100660_UTF-8 Possibly quite right...it could even be a "Works as designed" I am afraid. Here is the docu

Bypass of the access control authorization routine

In the following situations, the access control authorization routine is not called to check authorization: v The authorization ID that DB2 uses to determine access has installation SYSADM or installation SYSOPR authority (where installation SYSOPR authority is sufficient to authorize the request). This authorization check is made strictly within DB2. For example, if the execute privilege is being checked on a package, DB2 performs the check on the plan owner that this package is in. If [...] 5362 121 37_AW: Defaults for EXCEPT and INTERSECT37_=?Windows-1252?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Tue, 23 Feb 2010 14:02:25 +01001334_Windows-1252 Phil,

If I'm interpreting the following chart correctly, then DISTINCT should be the default for except, intersect and union:



>>-+-subselect----+---------------------------------------------> '-(fullselect)-'

.---------------------------------------------------. V | >----+-----------------------------------------------+-+--------> | .-DISTINCT-. | '-+-UNION-----+--+----------+--+-subselect----+-' +-EXCEPT----+ '-ALL------' '-(fullselect)-' '-INTERSECT-'

>--+-----------------+--+--------------------+----------------->< '-order-by-clause-' '-fetch-first-clause-'



I was looking it up via http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp with UNION, EXCEPT and INTERSECT as Search-items.

Hth

Ruediger

Rüdiger Kurtz Abteilung Informatik Betrieb

HUK-COBURG Bahnhofsplatz 96444 Coburg Telefon: 09561 96-44147 Telefax: 09561 96-44104 E-Mail: Ruediger.Kurtz@huk-coburg.de Internet: www.huk.de ===================================================================== HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021 Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg Vorsitzender des Aufsichtsrats: Werner Strohmayr. [...] 5484 94 37_Re: Defaults for EXCEPT and INTERSECT14_Peter Backlund21_BacklundDB2@TELIA.COM31_Tue, 23 Feb 2010 14:38:54 +0100 5579 162 37_Re: Defaults for EXCEPT and INTERSECT13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 23 Feb 2010 08:49:26 -0500453_iso-8859-1 AHA

Indeed, when I read the bit about reading IBMs syntax diagrams, it says

" If an optional item appears above the main path, that item has no effect on the execution of the statement and is used only for readability."

Which is another way of saying "this is the default behaviour"

Thanks

Phil Grainger Cogito Ltd. phil.grainger@cogito.co.uk +44 (0) 1298 872 148 +44 (0) 7505 266 768 www.cogito.co.uk [...] 5742 1175 38_Re: IMMEDWRITE YES Performance problem16_Robert Catterall21_rfcatterall@GMAIL.COM31_Tue, 23 Feb 2010 08:59:55 -0500397_windows-1252 That's good news, Jose. You have achieved positive results by making smart use of this bind option (as others have pointed out, programs -- particularly batch programs -- that perform lots of data-change operations per commit are usually not a good match for IMMEDWRITE(YES)).

Robert



On Tue, Feb 23, 2010 at 2:16 AM, Jose Antonio wrote: [...] 6918 50 45_Re: QMF with RACF Security - Effects of Cache10_Joe Geller21_joerg6666@HOTMAIL.COM31_Tue, 23 Feb 2010 14:00:39 +0000382_UTF-8 You didn't indicate whether User A was directly granted access to the table or if you are using secondary authids (i.e. RACF groups). If there is a bug, that might make a difference in determining where the problem lies (DB2 or RACF). Also bear in mind that the user does not have RACF rights to the table, he/she (or the RACF group) has DB2 rights granted to the table. [...] 6969 308 51_Re: SV: [DB2-L] DB2 failed and restart failed RESTP16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM31_Tue, 23 Feb 2010 08:33:52 -0600568_us-ascii I'm a little late to the game here (behind on my reading). We've had an SAP monitoring program that has caused this same problem since it never commits. If we catch it before DB2 is shutdown, we cancel the thread with the nobackout parameter, because we don't care about the data the thread is updating. On one occasion, however, DB2 was shutdown, and when it came back up, it wanted to rollback farther than we had archive logs available. In this instance, we made sure all the other workload was quiesced, we updated the zparms with DEFER ALL, and put [...] 7278 121 27_Re: DB2 PROGRAM WORKING SET14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Tue, 23 Feb 2010 16:20:45 +0000539_UTF-8 You do not state the platform (z/os?) or what you mean by working set.

I am going to assume z/os.

By working set I assume you mean amout of central storage actually allocated to an active thread.

In most configurations this storage is not not made visable to actual accounting systems.

Many environments consider there OLTP environments to be the primary consummer of DB2 related resources. CICS, IMS, DB2 distributed, and stored procedures all use schemes to share the same storage with many users. [...] 7400 44 31_When are log records compressed10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Tue, 23 Feb 2010 16:22:32 +0000597_UTF-8 If a tablespace is defined with Compress Yes but th comperssion dictionary has not been built can the log records be compressed? This excerpt from the admin guide implies no, without the dictionary there will be no compression in the log

"Log records can contain compressed data if a table contains compressed data. For example, if the data in a DB2 row are compressed, all data logged because of changes to that row (resulting from inserts, updates and deletes) are compressed. If logged, the record prefix is not compressed, but all of the data in the record are in compressed [...] 7445 66 35_Re: When are log records compressed13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 23 Feb 2010 10:37:51 -0600583_UTF-8 No data compression takes place to log records or data rows IF the dictionary has not been created. Even with COMPRESS YES, a dictionary must be created to actually get compression. LOAD or REORG must also be run to create the dictionary.

Willie

Jorg Lueke wrote: > If a tablespace is defined with Compress Yes but th comperssion dictionary > has not been built can the log records be compressed? This excerpt from > the admin guide implies no, without the dictionary there will be no > compression in the log > > "Log records can contain compressed data if [...] 7512 21 27_Re: DB2 PROGRAM WORKING SET15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Tue, 23 Feb 2010 10:41:45 -0600321_utf-8 Each address space is charged for the memory it uses. If to process a SQL request your address space has to get some memory, that gets charged to you. If DB2 has to get memory to do what it has to do, that gets charged to the DB2 address space, be that MSTR or IRLM or whatever address space needs the memory. [...] 7534 43 35_Re: When are log records compressed13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Tue, 23 Feb 2010 10:50:41 -0600459_utf-8 In a nutshell, the row data in the log will appear exactly as it is on the tablespace at the time the log record was written. So, if it's not compressed on the space, it will not be compressed on the log.

Regards, Ken

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke Sent: Tuesday, February 23, 2010 10:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] When are log records compressed [...] 7578 67 35_Re: When are log records compressed14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 23 Feb 2010 11:55:39 -0500607_us-ascii Jorg: Let me ask this clarifying question: "If there is no compression dictionary, how would the rows be compressed?" --Phil

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke Sent: Tuesday, February 23, 2010 11:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] When are log records compressed

If a tablespace is defined with Compress Yes but th comperssion dictionary has not been built can the log records be compressed? This excerpt from the admin guide implies no, without the dictionary there will be no compression in the log [...] 7646 55 38_Re: APPEND DATA TO A ROW WHILE LOADING9_Raj Ghose17_raj.ghose@RBC.COM31_Tue, 23 Feb 2010 16:54:44 +0000420_UTF-8 Hi All, First of all thanks to all who presented their ideas. It is much appreciated. I would just like to clarify myself further.

1. These application system tables are in a locked-in database with no access to the application. The only purpose for these tables is to control data changes and use this data too replicate into other environments like DEV/PROD systems so that we have no discrepancies. [...] 7702 132 35_Re: When are log records compressed10_Joe Geller21_joerg6666@HOTMAIL.COM31_Tue, 23 Feb 2010 18:10:14 +0000481_UTF-8 "Reading compressed data requires access to the dictionary that was in use when the data was compressed"

In planning to read the log, you need to consider the above. If a table is reorged/load replaced without Keepdictionary, there will be a new dictionary built.

If you are using a Log Analyzer product (from IBM or any of the other vendors), you should verify if they can handle this situation. Another option, according to The DB2 Administration Guide: [...] 7835 42 16_Re: DASD Wastage4_Anil21_alisha_kale@YAHOO.COM31_Tue, 23 Feb 2010 18:14:15 +0000551_UTF-8 Thanks Adam.

I have run into situations wherein I get 00D70025 errors on a db2 dataset even when there is plenty of space in the storage group. I have been told that for a particular tablespace/index, db2 (z/os) will not come back to a volume if that volume already has an extent on it. for example, there is a tablespace ts1 which has 5 extents on volumes v1,v2,v3,v4,v5 respectively. lets say you did bunch of drops on v1 and got lot of space now. but ts1 will not allocate extents on v1 because it already has an extent there and [...] 7878 68 16_Re: DASD Wastage9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 23 Feb 2010 13:27:53 -0600399_us-ascii That is a VSAM issue and yes, you are correct - once you have allocated the next volume, you will never take another extent on any of the previous volumes. Actually, I believe it is true for all z/os datasets but you don't normally have updates over time to non-database files. One of the basic rules of space management is to identify multi-volume datasets and manage them carefully. [...] 7947 33 19_COBOL UDF Examples?16_Daniel B. Wilson29_daniel.wilson@TRS.STATE.TX.US31_Tue, 23 Feb 2010 21:26:48 +0000720_UTF-8 Does anyone have a simple example of a COBOL user defined function? I need to write a simple UDF that takes a single CHAR(9) value, does a table look up and returns a CHAR(1). The only examples I've been finding are Assembler or C.

Thanks, Daniel

_____________________________________________________________________

* 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 [...] 7981 27 23_Re: COBOL UDF Examples?16_Daniel B. Wilson29_daniel.wilson@TRS.STATE.TX.US31_Tue, 23 Feb 2010 21:29:30 +0000631_UTF-8 I should add, this is for DB2 v9 z/OS.

Thanks, Daniel

_____________________________________________________________________

* 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! _____________________________________________________________________ [...] 8009 63 23_Re: COBOL UDF Examples?16_Daniel B. Wilson29_daniel.wilson@TRS.STATE.TX.US31_Tue, 23 Feb 2010 21:31:59 +0000650_UTF-8 Sorry, I should add that this is for DB2 v9 z/OS.

Thanks, Daniel

On Tue, 23 Feb 2010 21:26:48 +0000, Daniel B. Wilson wrote:

>Does anyone have a simple example of a COBOL user defined function? I >need to write a simple UDF that takes a single CHAR(9) value, does a table >look up and returns a CHAR(1). The only examples I've been finding are >Assembler or C. > >Thanks, >Daniel > >_________________________________________________________ ____________ > >* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * >* If you are going to attend only one conference [...] 8073 35 23_Re: COBOL UDF Examples?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 23 Feb 2010 17:08:10 -0500475_utf-8 How big is the lookup table?

I'm wondering if you could do this with a CASE statement without even writing an external program.....

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 B. Wilson Sent: 23 February 2010 21:27 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] COBOL UDF Examples? [...] 8109 40 16_Re: DASD Wastage11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 24 Feb 2010 00:28:10 +0000367_- >That is a VSAM issue and yes, you are correct - once you have allocated the next volume, you will never take another extent on any of the previous volumes.

That is a DFP issue; not VSAM.

>Actually, I believe it is true for all z/os datasets

Yes, it is.



>but you don't normally have updates over time to non-database files. [...] 8150 53 16_Re: DASD Wastage4_Anil21_alisha_kale@YAHOO.COM31_Wed, 24 Feb 2010 07:00:52 +0000565_UTF-8 Hi Ted,

The issues are the recent surge of "00D70025 errors" I get during our REORGs. It drives me nuts when I see free cylinders in the storage groups. But still getting 00D70025. First, I ruled out the fact that its not related to max volumes in the storage group. Its not reached max extents (number of extents). So I presumed it may something to do with so many of these volumes that have just small chunks of space available. could it be that its the sliding secondary extent that is causing the problem. Which made me consider zparm MGEXTSZ [...] 8204 53 35_Re: When are log records compressed10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Feb 2010 08:35:59 +0100814_US-ASCII Data Compression can be view as data 'filtered' by a digital filter: If there's no filter, the data remain unchanged so if there's no dictionary there's no way to use z/OS instructions to comp/decomp DB2 data

Max Scarpa Certified DB2 for CDC Cyber sysprog

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * _____________________________________________________________________ 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 the conference! _____________________________________________________________________ [...] 8258 60 16_Re: DASD Wastage11_Mike Bracey22_mike_bracey@UK.IBM.COM31_Wed, 24 Feb 2010 11:39:47 +0000570_UTF-8 Hello Anil I will try and answer your original question which concerned the use of MGEXTSZ. The effect of MGEXTSZ is explained in the SQL reference manual in the notes section of CREATE TABLESPACE. The default in V8 is NO but that changes to YES in V9. The zparm only applies when you have specified SECQTY>0. NO means that the SECQTY value is always used; YES means that the DB2 calculated value will be used if it is greater than the supplied SECQTY. Sliding secondary quantity was introduced to try and avoid running out of extents before hitting the data [...] 8319 25 42_Slightly Off Topic - Is DB2 "He" or "She"?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 24 Feb 2010 07:00:24 -0500408_utf-8 I'm just working my way through the draft presentations for IDUG North America and realised that I am guilty (when carried away) of referring to DB2 as "he" - as in "If DB2 detects a write error when running with single active logs, he will abend"

I was pulled up last year at a user group for referring to a piece of software as a "he" so I was sort of wondering what other people thought [...] 8345 58 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Feb 2010 13:18:33 +0100829_US-ASCII IT is only a piece of software (so I use 'it') but sometimes it behaves as a capricious lady, expecially at 2.00 a.m. when there's no way to start 'her' :-). AND I stop here.....:-)))))

Max Scarpa

Certified 2.00 a.m. DB2 awakener Certified Strike-slip DB2 sysprog

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * _____________________________________________________________________ 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 the conference! _____________________________________________________________________ [...] 8404 150 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Wed, 24 Feb 2010 06:36:10 -0600344_iso-8859-1 Phil,

Great question that demands something better than a collection of email replies.

Why not create a poll? We can publicize it here and on our LinkedIn groups.

BTW - definitely a "she". Creative, inspirational, responsive, creator of a huge industry... A "he" would build V.9 and go out for pizza :) Faz [...] 8555 267 33_DB2 Storage Group/Volume Question13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM31_Wed, 24 Feb 2010 07:54:40 -0500512_us-ascii







I am supporting a DB2 V7 environment for a customer.





In reviewing the storage groups/volumes I ran into this situation and am somewhat confused.





The DB2 datasets reside on spindles with a prefix of DBT* (000-019).





But when executing the query of SYSVOLUMES none of the above spindles are displayed.

In fact a review of the spindles that were displayed none of the volumes physically exist. [...] 8823 17 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 24 Feb 2010 13:00:57 +0000437_Windows-1252 > Great question that demands something better than a collection of email replies.

>Why not create a poll? We can publicize it here and on our LinkedIn groups.

Didn't you read Phil's entire post:

QUOTE:



>So as not to take up too much bandwidth here (and it's not Friday yet after all) I've hosted a poll on the subject at http://www.graingerdatabasesolutions.com/html/fun_polls.html [...] 8841 56 37_Re: DB2 Storage Group/Volume Question10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Feb 2010 14:47:13 +0100786_US-ASCII Just a curiosity:

If you execute a LISTCAT on one of DB2 VSAM datasets in that environment and belonging to that DB2 (where you execute the query) what volumes are displayed ? DBTxxx or something else ?

Ma Scarpa



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * _____________________________________________________________________ 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 the conference! _____________________________________________________________________ [...] 8898 52 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?15_Gaston, Raymond17_GastonRay@ORU.COM31_Wed, 24 Feb 2010 08:51:52 -0500528_iso-8859-1 How about "IT" !!?

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger Sent: Wednesday, February 24, 2010 7:00 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?

I'm just working my way through the draft presentations for IDUG North America and realised that I am guilty (when carried away) of referring to DB2 as "he" - as in "If DB2 detects a write error when running with single active logs, he will abend" [...] 8951 116 30_Re: [SPAM] COBOL UDF Examples?16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Wed, 24 Feb 2010 08:01:33 -0600336_UTF-8 All you really need is the parm setup and DDL. Everything else I've done is for customers and protected so I can't share. Don't forget to use the SQLSTATE output for error handling. I agree in that this might be better handled with A SQL scalar function. Plenty of examples on my web site, http://www.db2expert.com for free. [...] 9068 270 37_Re: DB2 Storage Group/Volume Question13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM31_Wed, 24 Feb 2010 09:12:29 -0500637_us-ascii It comes back with DBT012.

As one person pointed out it's probably in the ACS routines.

SO I need to look into that area.

Thanks,

Bob

________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Max Scarpa Sent: Wednesday, February 24, 2010 8:47 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Storage Group/Volume Question



Just a curiosity:

If you execute a LISTCAT on one of DB2 VSAM datasets in that environment and belonging to that DB2 (where you execute the query) what volumes are displayed ? DBTxxx or something else ? [...] 9339 87 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?20_Bruzdzinski, Michael27_Michael.Bruzdzinski@SSA.GOV31_Wed, 24 Feb 2010 09:24:32 -0500682_iso-8859-1 No, "IT" conjures up images from a Stephen King novel...hhmmm on second though the image of a clown that terrorizes may be appropriate!

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

The maxim is "qui tacet consentire." The maxim of the law is "Silence gives consent." - the character of Sir Thomas More in A Man for All Seasons by Robert Bolt -----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gaston, Raymond Sent: Wednesday, February 24, 2010 8:52 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 9427 62 37_Re: DB2 Storage Group/Volume Question10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Feb 2010 15:38:16 +0100799_US-ASCII I asked it to be sure that's it's ACS routine.

Probably somewhere there's a rule on datasets names (don't think about type) or subsystem that intercept any request coming from that DB2. If you are authorized you can use SMS dataset allocations simulation to check it .

Max Scarpa







_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * _____________________________________________________________________ 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 the conference! [...] 9490 91 49_Accesspath influenced by # of reached threshold's9_Cor Brink26_c.brink@BELASTINGDIENST.NL31_Wed, 24 Feb 2010 15:35:20 +0100349_us-ascii

Hi list,

We had some accesspath problems for dynamic sql at a given time. From our investigations it seems that during that period there were a lot of (VDWQT and also some DWQT) reached tresholds, due to other running processes. Does optimizer notice this, when creating the accesspath? Looking forward to your answers. [...] 9582 50 32_Join DB2 for z/OS LinkedIn Group14_Surekha Parekh20_surekha21@UK.IBM.COM31_Wed, 24 Feb 2010 13:56:56 +0000295_UTF-8 Dear DB2 Interested Party

I would like to let you know that we have just created a new subgroup for DB2 10 for z/OS in LinkedIn. This is part of our DB2 for z/OS - What's On Group - so if you work with DB2 for z/OS, want to stay ahead of the game please join our groups today. [...] 9633 201 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Wed, 24 Feb 2010 09:22:00 -0600418_us-ascii You can get away with "it" while using English but the question has to be faced some day - in French you only have "il" or "elle" to choose from. Francophones please correct me if I got it wrong.

Khalid









"Gaston, Raymond" Sent by: IDUG DB2-L 02/24/2010 07:57 AM Please respond to IDUG DB2-L [...] 9835 184 53_Re: Accesspath influenced by # of reached threshold's11_Mike Turner19_mike.turner@GMX.COM31_Wed, 24 Feb 2010 15:31:13 -0000582_iso-8859-1 Hi Cor

I am sure that the Optimizer does not notice VDWQT or DWQT threshold hits.

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: Cor Brink Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, February 24, 2010 2:35 PM Subject: [DB2-L] Accesspath influenced by # of reached threshold's [...] 10020 459 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Wed, 24 Feb 2010 09:35:56 -0600514_us-ascii Das De Be Zwei?

Rick Weaver DB2 z/OS Product Manager BMC Software

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan Sent: Wednesday, February 24, 2010 9:22 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?



You can get away with "it" while using English but the question has to be faced some day - in French you only have "il" or "elle" to choose from. Francophones please correct me if I got it wrong. [...] 10480 350 67_Betr: Re: [DB2-L] Accesspath influenced by # of reached threshold's9_Cor Brink26_c.brink@BELASTINGDIENST.NL31_Wed, 24 Feb 2010 16:49:57 +01002218_us-ascii





Thanks for your answer, Mike. I also couldn't imagine that this could be a reason, so our investigation continues...

Regards, Cor Brink, B/Cict EX-MIG, Quintax BPA A167 Laan v Westenenk 555 7334 DT Apeldoorn (055) 5282968, (06) 18608535, C.Brink@Belastingdienst.nl



|------------> | Van: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Mike Turner | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Aan: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |DB2-L@WWW.IDUGDB2-L.ORG | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Datum: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |24-02-2010 16:34 | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Onderwerp: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Re: [DB2-L] Accesspath influenced by # of reached threshold's | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Verzonden | | door: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |IDUG DB2-L | >--------------------------------------------------------------------------------------------------------------------------------------------------| [...] 10831 159 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?0_25_scott.taylor@AUTOZONE.COM31_Wed, 24 Feb 2010 09:56:08 -0600357_US-ASCII How about stating which address space is affected, since DB2 is made up of more than one piece. I figure you typically present to audiences more technical in nature, so instead of saying "he", you could say (modifying your example): "If DB2 detects a write error when running with single active logs, the db2 master address space will abend." [...] 10991 328 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Roger Hecq18_Roger.Hecq@UBS.COM31_Wed, 24 Feb 2010 10:58:25 -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. [...] 11320 159 23_Re: COBOL UDF Examples?11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 24 Feb 2010 10:00:58 -0600509_iso-8859-1

Daniel,





Check out the SP redbook SG24-7604 (or the original SG24-7083). They contain a sample COBOL UDF for salary validation (something simple like what you need) called EMPAUDTU.





You will find all required info (DDL, COBOL, JCL etc) in the addmat section.





Your comment about C and Assembler is true in general and I have tried over the years to provide COBOL examples for the general public. It is getting better. [...] 11480 82 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?16_Mark Labby - AES21_mlabby@AESSUCCESS.ORG31_Wed, 24 Feb 2010 11:10:19 -0500 11563 451 71_Re: Betr: Re: [DB2-L] Accesspath influenced by # of reached threshold's11_Mike Turner19_mike.turner@GMX.COM31_Wed, 24 Feb 2010 16:19:02 -0000493_iso-8859-1 Cor

There are a couple of cases I can think of where the access path can be modified after Optimization. The first is for parallel tasks and results in the number of parallel tasks being reduced or the prefetch quantity being reduced. This can be caused by contention in a buffer pool caused by other work. The second affects RID processing and can cause fallback to a tablespace scan, but this is not affected by other work, only by the number of RIDs being processed. [...] 12015 40 50_Any word on the dates or location for IDUG Europe?12_Martin Hubel17_Martin@MHUBEL.COM31_Wed, 24 Feb 2010 11:33:37 -0500 12056 141 71_Re: Betr: Re: [DB2-L] Accesspath influenced by # of reached threshold's12_Martin Hubel17_Martin@MHUBEL.COM31_Wed, 24 Feb 2010 11:37:49 -0500 12198 42 50_Reminding management of the advantages of System Z11_Dave Beulke19_dave@DAVEBEULKE.COM31_Wed, 24 Feb 2010 16:43:51 +0000646_UTF-8 I have a new post on my blog,

Reminding management of the advantages of System Z

Within the recent IBM Z Summit road show, there were several presentations detailing the mainframe platform advantages over UNIX and Windows platforms such as the lowest total cost of ownership, the best availability and unparalleled scalability. These presentations cut through the rumors with detailed facts and figures of the different platform configurations. Download these presentations and distribute them to your management for a little reminder why the mainframe continues to be the best platform for your enterprise applications. [...] 12241 22 20_A Test Please ignore10_Ed. Benoit29_db2tech@RECOVERYKNOWLEDGE.COM31_Wed, 24 Feb 2010 08:52:16 -0800586_us-ascii Test to see if I get the email Ed.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * _____________________________________________________________________ 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 the conference! _____________________________________________________________________ [...] 12264 230 53_Re: Accesspath influenced by # of reached threshold's35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 24 Feb 2010 12:02:55 -0500390_iso-8859-1 I have never heard of the optimizer considering these thresholds, and they are usually momentary issues.

You want to see high hits of vdwqt to keep a trickle write going and this avoids huge bursts of writes when DB2 takes a checkpoint. Correspondingly, the number of DWQT hits should be low to zero. Managing these thresholds properly avoids hitting spth, and dmth. [...] 12495 437 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?20_ARCHER, MARY-ELLEN H17_MARCHER@SCANA.COM31_Wed, 24 Feb 2010 12:35:01 -0500360_us-ascii I would say if it abends it's a HE. If it runs successfully, it is a SHE.

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Labby - AES Sent: Wednesday, February 24, 2010 11:10 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?



I have always referred to DB2 as she. [...] 12933 51 24_Re: A Test Please ignore15_Gaston, Raymond17_GastonRay@ORU.COM31_Wed, 24 Feb 2010 12:37:05 -0500360_us-ascii Ed... This happened to me a couple of weeks ago. I had to get my "network people" to take "IDUG.org" of our spam list.

- Ray

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ed. Benoit Sent: Wednesday, February 24, 2010 11:52 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] A Test Please ignore [...] 12985 201 54_Re: Any word on the dates or location for IDUG Europe?35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 24 Feb 2010 13:08:09 -0500462_iso-8859-1 The word is .... momentarily...

We're all waiting....



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

Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...] 13187 83 54_Re: Any word on the dates or location for IDUG Europe?12_Martin Hubel17_Martin@MHUBEL.COM31_Wed, 24 Feb 2010 13:39:18 -0500 13271 318 54_Re: Any word on the dates or location for IDUG Europe?35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 24 Feb 2010 14:24:24 -0500393_iso-8859-1 Maybe Andorra? I haven't been there yet.

Anyplace I can get a direct flight, and I'll be happy. I hate connections.



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 [...] 13590 60 47_[AD] DB2 Recovery Resources Needed for Recovery10_Ed. Benoit29_db2tech@RECOVERYKNOWLEDGE.COM31_Wed, 24 Feb 2010 12:32:26 -0800592_utf-8 Do you have access to the DB2 resources needed to recover your DB2 data at your finger tips? The DB2 DBA and DB2 System organizations need to know what resources are available to recover DB2 data. Just as important, where are these resources. Also, will the same software that Identify these resources also automate the recovery process at the Local Site as well as the DR site.  The  Health Check Interface forDB2will interface with the GENDB2 Software product or run standalone.  The Health Check product will produce reports online and batch that will supply both the DB2 [...] 13651 129 87_Re: DB2 LUW Oracle in for Tougher Sailing against IBM (re: Sun deal) -- Link to article10_Fred Edgar18_fredgarx@YAHOO.COM31_Wed, 24 Feb 2010 14:21:49 -0800323_utf-8 I apologize for being late to the party, but an enlightening thing to do once in awhile is to search Monster for things like: "DB2 DBA" , "oracle DBA", "SQL Server DBA". The number of hits you get back pretty well tells the story.  Fred

--- On Wed, 2/17/10, Phil Gunning wrote: [...] 13781 139 87_Re: DB2 LUW Oracle in for Tougher Sailing against IBM (re: Sun deal) -- Link to article12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Wed, 24 Feb 2010 23:01:57 +0000530_utf-8 Well not sure what the point is, but people are making good livings specializing in DB2 for LUW. DB2 LUW is not new to the party having hit the mainstream db market over 13 years ago, and longer if you include parallel edition, and I have done many Oracle, mainframe and MySQL conversions to DB2 LUW and not one has gone back to the original database. Maybe it is in the eye of the beholder type of thing. Bottom line: there are plenty of DB2 LUW jobs out there. Not to say other dbs don't have strong presence but DB2 [...] 13921 54 54_Re: Reminding management of the advantages of System Z13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 24 Feb 2010 16:16:07 -0800442_utf-8 > Download these presentations and distribute them to your management

Dave, do you have links to "these presentations" on your web site? I couldn't find them.

Thanks, Cathy

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave Beulke Sent: Wednesday, February 24, 2010 8:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Reminding management of the advantages of System Z [...] 13976 423 14_ADMIN: upgrade16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 24 Feb 2010 21:53:28 -0500556_utf-8 This Friday we will try once again to upgrade the listserv software





This will mean that for a short time starting Friday night (22:00 EST) or 3:00 sat GMT





For status email to db2lstatus@gmail.com





This will only looks once though

















Robert Galambos CIPP/C CIPP/IT

Compuware Senior Technical Specialist

IBM Certified Database Associate

IBM Certified DB2 9 for z/OS Database Administration [...] 14400 36 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 25 Feb 2010 07:10:53 +0000324_UTF-8 Hi Phil.

Here in Spain DB2 is a he - despite being known as Debbie Dos it's "el DB2".

I still don't know why, but then I don't know why a table is she and an index he....

And don't even start me off re utilities! Trying to sort out the boys and the girls in the utility suite is a nightmare. [...] 14437 475 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 25 Feb 2010 04:04:26 -0500402_us-ascii Well

Given that Db2 is either all UP or all DOWN, it rarely matters which address space abends - if one goes they usually all do (I'm hedging my bets as I think DDF could abend without bringing down the rest of DB2, but not 100% sure) Phil Grainger Cogito Ltd. phil.grainger@cogito.co.uk +44 (0) 1298 872 148 +44 (0) 7505 266 768 www.cogito.co.uk [...] 14913 537 85_Betr: Re: [DB2-L] Betr: Re: [DB2-L] Accesspath influenced by # of reached threshold's9_Cor Brink26_c.brink@BELASTINGDIENST.NL31_Thu, 25 Feb 2010 10:40:15 +0100686_us-ascii





Hi Martin,

To be more concrete, there were two running SQL-scripts who suffered. Operations killed the tasks, before we could do some (performance-) monitoring, or even look at the running thing. Normally the two updates needs approximately minutes to run and do not cause hitting thresholds. There were no DMT-hits. Explain now gives the right accesspath, within the same environment (stats, bufferpool-defenitions, ..). I agree hitting VDWQT/DWQT cause slowdowns. We noticed other threads using the same bufferpool's are running as expected, keeping in mind that they suffer a bit from DWQT. The killed tasks where consuming a lot of CPU, [...] 15451 65 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 25 Feb 2010 11:17:40 +0100562_UTF-8 I would say if it abends it’s a HE. If it runs successfully, it is a SHE.

Mhhh I'm sorry but DB2 remembers 'she' when :

- Every -911 error ('she' has nothing to dress) - Every 00D70014 ('she' has no space in her wardrobe) - Every 00D70008 (she says she's becoming 'large' and it's CICS' fault) - Every 00C90096 (she says needs more shoes) - Every +100 rc ('she' found no money in your pocket) - Every 'LOCK...IN EXCLUSIVE MODE' ('she' says 'Why don't we marry ?') - Every DSNB536I ('she' says 'Honey, your credit card is [...] 15517 115 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Mick P Graley16_mgraley2@CSC.COM31_Thu, 25 Feb 2010 12:02:04 +0000523_UTF-8 Well I was interested in this so I did a little test. I expected to be able to ABEND the DIST, WLM and SPAS address spaces without upsetting the MSTR, DBM1 and IRLM. We all know of course ABENDing the IRLM is a sure fire way of killing the sub-system. I canned the WLM1 address space, it died and another one started and replaced it - could still execute stored procs through it. I canned the SPAS address space, it died and stayed dead - didn't try to run a proc through it though. This surprised me - I canned [...] 15633 36 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Meir Zohar19_zmeyer@BEZEQINT.NET31_Thu, 25 Feb 2010 14:54:09 +0200313_us-ascii Not so. SPAS can crash and leave the other address spaces hanging ... Anyway, since the English language provides for a gender neutral - "it" - shouldn't DB2 be an "it" ? That way "it" could be just like an American infant, especially when it (DB2)starts to cry and and you can't figure out why :-) [...] 15670 61 22_Bounce DB2 every day ?9_DB2DBAzOS21_bala.db2dba@GMAIL.COM31_Thu, 25 Feb 2010 18:56:34 +0530400_ISO-8859-1 Dear list,

One of my clients has the DR strategy that goes like this.. Bring down DB2 every night after business is over, take a flash copy of the entire z/OS image and bring up DB2. And, continue to run batch for few hours. There is no DB2 copy (even) for online environment and just weekly copy. We keep archive logs long enough to cover up for any recovery during the week. [...] 15732 233 54_AW: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 25 Feb 2010 14:36:02 +0100552_iso-8859-1 And now all together ;-))

Well she's all you'd ever want, She's the kind they'd like to flaunt and take to dinner. Well she always knows her place. She's got style, she's got grace, She's a winner. She's a Lady. Whoa whoa whoa, She's a Lady. Talkin' about that little lady, and the lady is mine. Well she's never in the way Always something nice to say, Oh what a blessing. I can leave her on her own Knowing she's okay alone, and there's no messing. She's a lady. Whoa, whoa, whoa. She's a lady. Talkin' about that little lady, [...] 15966 85 26_Re: Bounce DB2 every day ?10_Joe Geller21_joerg6666@HOTMAIL.COM31_Thu, 25 Feb 2010 13:47:59 +0000565_UTF-8 My shop has been doing the same (stopping DB2 to do flash copies), but does do Image Copies as well. However, there is no need to bounce DB2 and we are going to stop that practice.

The flash copies need the bufferpools to be flushed to dasd (i.e. the updated pages need to be written to the tablespaces/indexes). But that can be accomplished by issuing -set log suspend (and then -set log resume after the flash copies are completed). The log suspend will prevent any DB2 update activity until the log resume. That should not be a problem for you [...] 16052 78 45_Re: QMF with RACF Security - Effects of Cache11_Michel Helg24_michel.helg@AXA-TECH.COM31_Thu, 25 Feb 2010 14:12:23 +0000368_UTF-8 Hi guys

thanks for your joint thought efforts ! I went ahead as Phil suggested and tried to pinpoint the source of the error by conducting the following test:

First I reduced the query to just select from one table only (the one with differing access authority of the users within their profiles). Then we ran the following tests in sequence: [...] 16131 343 26_Re: Bounce DB2 every day ?13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM31_Thu, 25 Feb 2010 09:23:56 -0500428_us-ascii I did this at one site AT THEIR REQUEST. It was slowly being phased out and we removed all 3rd party s/w including the recovery s/w. So they wanted a backup process in place.

So all image copies were completed, cat/dir completed. DB2 came down. Then a backup of the production logs, bsds, and subsystem files was taken. Using ADRU* utility. Then DB2 was brought back up, I had it set up in a batch process. [...] 16475 343 89_Re: Betr: Re: [DB2-L] Betr: Re: [DB2-L] Accesspath influenced by # of reached threshold's10_Joe Geller21_joerg6666@HOTMAIL.COM31_Thu, 25 Feb 2010 13:51:39 +0000287_UTF-8 Does your access path use list prefetch? If so, check your performance monitor reports to see if there were any ridpool failures. That would cause DB2 to switch to a tablespace scan and could be the cause of high getpages even with what "should" have been a good access path. [...] 16819 22 23_Re: COBOL UDF Examples?12_Scott Hodgin19_shodgin@SCFBINS.COM31_Thu, 25 Feb 2010 13:51:26 +0000454_UTF-8 Daniel, i emailed an example to you off list.

_____________________________________________________________________

* 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 most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 16842 57 45_Re: QMF with RACF Security - Effects of Cache13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 25 Feb 2010 09:53:28 -0500506_utf-8 If I were you, I'd be calling IBM

This feels like a security exposure, either in configuration (no idea where though) or due to a bug

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 Michel Helg Sent: 25 February 2010 14:12 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] QMF with RACF Security - Effects of Cache [...] 16900 650 41_[AD] Java for DBA's - New Training Course14_John Caccavale18_jcac@THEMISINC.COM31_Thu, 25 Feb 2010 14:55:32 +0000 17551 93 65_Baltimore / Washington DB2 Users' Group March 10, 2010 Meeting!!!14_Henry L Nalven25_henry.nalven@MARRIOTT.COM31_Thu, 25 Feb 2010 15:07:56 +0000609_UTF-8 HEADS UP!!! SHERYL LARSEN IS COMING TO TOWN!!

The Baltimore/Washington DB2 Users' Group Special DB2 Course Offering - Wednesday, March 10, 2010 presenting...

SHERYL LARSEN International DB2 Consultant

BWDB2UG z/OS Educational Session

Sheryl Larsen

When?

Wednesday, March 10, 2010, 9:00AM-3:30PM (registration at 8:30)

Where?

Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730- 3900

Meeting Fees: Pre-registered: $250 (lunch and break refreshments included) At-the-door: $350 (lunch and break refreshments included) [...] 17645 230 54_Re: Reminding management of the advantages of System Z15_Andrew Lawinger17_alawinger@MMM.COM31_Thu, 25 Feb 2010 09:12:24 -0600363_US-ASCII Cathy, Dave sent this to me off the message board due to a post I put on his blog

http://www-01.ibm.com/software/os/systemz/summit/index.html?S_TACT=109AX10W&S_CMP Either my expectations of what he was offering as a presentation is incorrect or I am looking in the wrong place on this site. See if you can find what you are looking for. Andy [...] 17876 195 26_Re: Bounce DB2 every day ?7_Ed Long19_rdhm99a@PRODIGY.NET31_Thu, 25 Feb 2010 07:25:56 -0800615_iso-8859-1 In the red world these are called 'cold' backup strategies and are quite common. By the standards of DB2 for z with all the tracker site and high performance backup techniques available they quaintly resemble cave paintings. Like those paintings, this design endures because it is very reliable and easy to execute. Yes, you might lose some transactions (between backup and point of failure); but you have a known starting point that makes the contingency plan simple; i.e., just replay yesterday please. I might almost say to the original poster, if there is no availability penalty why not do it. [...] 18072 180 58_Re: AW: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?7_Ed Long19_rdhm99a@PRODIGY.NET31_Thu, 25 Feb 2010 07:27:26 -0800597_utf-8 Can we get Tom Jones at the next IDUG?  Edward Long ________________________________ From: "Peter, Georg" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thu, February 25, 2010 8:36:02 AM Subject: [DB2-L] AW: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? And now all together ;-)) Well she's all you'd ever want, She's the kind they'd like to flaunt and take to dinner. Well she always knows her place. She's got style, she's got grace, She's a winner. She's a Lady. Whoa whoa whoa, She's a Lady. Talkin' about that little lady, and the lady is mine. Well she's never in the [...] 18253 24 35_Re: When are log records compressed10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 25 Feb 2010 15:36:23 +0000555_UTF-8 Thanks to all. We have a vendor tool issue and I just needed to verify that log records aren't compressed (or uncompressed) without the dictionary

_____________________________________________________________________

* 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 most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 18278 159 34_SV: [DB2-L] Bounce DB2 every day ?13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Thu, 25 Feb 2010 16:44:52 +0100383_us-ascii An we can't understand why DB2 on z/os looses the competition with other platforms? Ask the management in this shops an I bet that they will say DB2 z/os has do be down every day.

I have been in many discussions and to get people to understand the difference between someone has decided to take down DB2 each day, and DB2 has to bounce every day is a challenge. [...] 18438 34 35_Re: When are log records compressed13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Thu, 25 Feb 2010 08:47:30 -0700299_utf-8 For what it's worth... if you have specific log ranges (RBAs or LRSNs) of records you want to look at for confirmation, you can use DSN1LOGP to print them. There's a bit on every DM record that indicates if it is compressed or not, and DSN1LOGP actually indicates that in its formatting. [...] 18473 86 111_IBM wants your feedback on the DB2 for z/OS Quick Reference, Diagnostic Quick Reference, and Installation Guide11_Judy Tobias18_jtobias@US.IBM.COM31_Thu, 25 Feb 2010 08:14:05 -0800345_US-ASCII



Dear DB2-L members:

The IBM User Experience team is looking for volunteers to give us feedback on your usage of the DB2 for z/OS Quick Reference, 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. [...] 18560 29 35_Re: When are log records compressed12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Thu, 25 Feb 2010 10:41:34 -0600428_utf-8 Jorg, if the vendor tool is mine (BMC Log Master for DB2) please contact me directly at rick_weaver@bmc.com.

Regards,

Rick Weaver DB2 z/OS Product Manager BMC Software



-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke Sent: Thursday, February 25, 2010 9:36 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] When are log records compressed [...] 18590 645 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Thu, 25 Feb 2010 10:46:17 -0600304_iso-8859-1 This one cuts both ways:

My daddy left home when I was three And he didn't leave much to ma and me Just this old guitar and an empty bottle of booze. Now, I don't blame him cause he run and hid But the meanest thing that he ever did Was before he left, he went and named me "Sue." [...] 19236 234 115_Re: IBM wants your feedback on the DB2 for z/OS Quick Reference, Diagnostic Quick Reference, and Installation Guide14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 25 Feb 2010 12:00:26 -0500418_us-ascii [plaintively] I'd be happy to use 'em if someone would give me the link or send me a copy...

________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Judy Tobias Sent: Thursday, February 25, 2010 11:14 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IBM wants your feedback on the DB2 for z/OS Quick Reference, Diagnostic Quick Reference, and Installation Guide [...] 19471 80 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 25 Feb 2010 18:03:02 -0000694_iso-8859-1 Phil,

It's definitely a HE: resource consuming and forever memory hungry.





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!













-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger Sent: 24 February 2010 12:00 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 19552 326 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 25 Feb 2010 18:03:03 -0000644_us-ascii In Italian also it's a boy...





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!







________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan Sent: 24 February 2010 15:22 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 19879 554 54_Re: Reminding management of the advantages of System Z13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Thu, 25 Feb 2010 10:34:28 -0800655_us-ascii Thanks, Andy. That must have been what he was referring to.

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Andrew Lawinger Sent: Thursday, February 25, 2010 7:12 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Reminding management of the advantages of System Z



Cathy, Dave sent this to me off the message board due to a post I put on his blog http://www-01.ibm.com/software/os/systemz/summit/index.html?S_TACT=109AX10W&S_CMP Either my expectations of what he was offering as a presentation is incorrect or I am looking in the wrong place on this site. See if you can find what you are looking for. Andy [...] 20434 296 26_Re: Bounce DB2 every day ?16_Proctor, William25_William.Proctor@TGSLC.ORG31_Thu, 25 Feb 2010 12:47:09 -0600434_us-ascii I'm having a problem understanding why ya'll are taking DB2 down to get these flash copies. We use FDR and Shadow Image daily for all of our DR/System backups and outside of the log suspend for 2 minutes a day our DB2 systems are never down. The Shadow copies are taken to DR and it is a fairly easy procedure to Bring our systems up. We are not doing point in time Dr's at the moment but that is a management decision. [...] 20731 158 26_Re: Bounce DB2 every day ?12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Thu, 25 Feb 2010 13:56:23 -0500719_UTF-8 Same for us. No reason to shut DB2's down to backup. Been doing DB2 and flashcopy for years now. Jeff





"Proctor, William" Sent by: IDUG DB2-L 02/25/2010 01:48 PM Please respond to IDUG DB2-L



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

Subject Re: [DB2-L] Bounce DB2 every day ?











I’m having a problem understanding why ya’ll are taking DB2 down to get these flash copies. We use FDR and Shadow Image daily for all of our DR/System backups and outside of the log suspend for 2 minutes a day our DB2 systems are never down. The Shadow copies are taken to [...] 20890 118 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Thu, 25 Feb 2010 14:16:55 -0500516_iso-8859-1 Since DB2 came out with Online Schema Changes and AREO*, DB2 became a SHE. It's just like when my wife advises me to clean up the garage. When I get that advise, I get the picture and I intend to clean up the garage at some point in time when it's CONVENIENT for me. The problem is - when she advises me to clean up she really means NOW and not when it's convenient for me. Just like when DB2 issues the ADVISORY REORG status - you better do it sooner rather than later in order not to be penalized. [...] 21009 46 35_Re: When are log records compressed16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Thu, 25 Feb 2010 14:19:12 -0500441_UTF-8 Sorry about a little advert here, but I am doing a technical presentation about the DB2 LOG March 23, moderated by Troy Coleman. You can sign up from the CA events page ca.com/events, or you can contact me off the list for a direct link to the registration.

Steen Rasmussen CA Sr Engineering Services Architect IBM Certified Database Associate - DB2 9 Fundamentals IBM Certified Database Administrator - DB2 9 DBA for z/OS [...] 21056 114 26_Re: Bounce DB2 every day ?12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 25 Feb 2010 11:53:36 -0800309_us-ascii But it was my understanding that set log suspend does not flush the bufferpools. They stay exactly as they were. It just suspends all update activity. But whatever that is in the bufferpools is still in the pools and not written to the logs. Maybe I'm wrong, but that's the way it worked in V8. [...] 21171 82 35_Re: When are log records compressed14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 25 Feb 2010 14:57:30 -0500363_us-ascii Steen, it's a free webcast, not advertising. Publish it here, and some of us will sign up (I'm doing so as I write)

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rasmussen, Steen Sent: Thursday, February 25, 2010 2:19 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] When are log records compressed [...] 21254 176 26_Re: Bounce DB2 every day ?10_Joe Geller21_joerg6666@HOTMAIL.COM31_Thu, 25 Feb 2010 20:49:34 +0000681_UTF-8 I wasn't careful with my wording. The bufferpool contents remain the same. What happens is: (from the manual)

"DB2 externalizes unwritten log buffers, takes a system checkpoint (in non- data-sharing environments), updates the BSDS with the high-written RBA, and then suspends the update activity.

When to suspend logging: Specify SET LOG SUSPEND before making a remote copy of the entire database and logs for a system-level, point-in-time recovery or disaster recovery. You can make remote copies with peer-to- peer remote recovery (PPRC) and FlashCopy®. Suspending logging to make a remote copy of the database lets you avoid quiescing update activity. [...] 21431 383 58_Re: AW: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 25 Feb 2010 21:14:33 -0000757_iso-8859-1 Hr. Peter,

SHAGGY????????????????????????????????

Honestly, thank your appropriate divinity it's practically Friday.....





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!







________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter, Georg Sent: 25 February 2010 13:36 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] AW: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 21815 203 26_Re: Bounce DB2 every day ?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 25 Feb 2010 21:16:37 -0000517_us-ascii Mr/Mrs/Ms DB2DBAzOS (he, she or it? no offence meant ;-),

if you CAN, take advantage of it, nice, clean RECOVERTO points every day, full IC, what is the problem?





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! [...] 22019 137 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?0_24_carol.sutfin@REGIONS.COM31_Thu, 25 Feb 2010 15:17:20 -0600776_ISO-8859-1 and won't take out the garbage or cut the grass.

Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com





From: "Dell'Anno, Aurora"

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

Date: 02/25/2010 12:57 PM

Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?

Sent by: IDUG DB2-L











Phil,

It's definitely a HE: resource consuming and forever memory hungry.





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 [...] 22157 758 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 25 Feb 2010 21:18:01 -0000653_iso-8859-1 Now, Johnny Cash, that's CLASS.... :-D





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!







________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Weaver, Rick Sent: 25 February 2010 16:46 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 22916 77 42_Slightly Off Topic - Is DB2 "He" or "She"?13_Jose de Bedos20_josedebedos@LIVE.COM31_Thu, 25 Feb 2010 18:26:29 -0300697_iso-8859-1



I asked Stephen King.

He said "DB2 is IT".





José





_________________________________________________________________ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. https://signup.live.com/signup.aspx?id=60969 _____________________________________________________________________

* 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 most DB2 technical sessions of any conference ** Access IBM experts and developers _____________________________________________________________________ [...] 22994 518 26_Re: Bounce DB2 every day ?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Thu, 25 Feb 2010 13:48:22 -0800531_us-ascii Actually, there is a down side to cycling DB2 every day. When DB2 comes down, you will get message

IEF352I ADDRESS SPACE UNAVAILABLE

for the MSTR, DBM1, IRLM, and DIST address spaces. This means your RSVNONR reserve will be reduced by 4 each time you cycle DB2. When that value is exhausted, you will start reducing the address spaces available for MAXUSERS, and will have to IPL to reclaim them. You will find your limits in SYS1.PARMLIB(IEASYSxx). When you reach 95% of RSVNONR, you will get message: [...] 23513 345 26_Re: Bounce DB2 every day ?14_Leblanc, Fritz27_fritz.leblanc@SALLIEMAE.COM31_Thu, 25 Feb 2010 16:59:57 -0500531_us-ascii I've been watching this thread and I'm curious about your statement "Is it good to bring down production DB2 every day ? Because of that I do not see batch jobs getting any benefit out of bufferpools, EDMs etc.".

You then bring DB2 back up, and I assume that your batch is accessing DB2 resources. If that's the case, then the only thing your losing (for the batch jobs) is the pages that would have already been in the buffers, which may not even be the same pages that your batch applications are accessing. [...] 23859 384 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?7_Ed Long19_rdhm99a@PRODIGY.NET31_Thu, 25 Feb 2010 14:05:38 -0800737_utf-8 Given how much revenue DB2 drives both for IBM and the rest of us, CASH is king! Edward Long ________________________________ From: "Dell'Anno, Aurora" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thu, February 25, 2010 4:18:01 PM Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? Nachricht Now, Johnny Cash, that's CLASS.... :-D 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! ________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Weaver, Rick Sent: 25 February 2010 16:46 [...] 24244 164 35_Why this happens when using BP32Kn?13_Jose de Bedos20_josedebedos@LIVE.COM31_Thu, 25 Feb 2010 21:43:25 -0300465_iso-8859-1



Hi,





I've found that, when creating a TS in BP32Kn, the allocated VSAM has more space than what I asked for.

The DDLs I run have this pattern:





CREATE TABLESPACE TESTnK IN DBxxxxx USING STOGROUP xxxxx PRIQTY 69120 SECQTY 8640 --> Priqty: 96 cyls (3390) Secqty: 12 cyls (3390) ........

BUFFERPOOL BP?5





where n in TESTnK takes the values 4, 8, 16 and 32 [...] 24409 34 11_REORP issue9_SrinivasG21_SRINIVASG@INFOSYS.COM31_Fri, 26 Feb 2010 10:09:32 +0530338_us-ascii 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? [...] 24444 486 74_IBM Data in Action Virtual Event led by Sal Vella -See below if interested12_Phil Gunning19_pkgunning@GMAIL.COM31_Fri, 26 Feb 2010 02:05:48 -0500463_us-ascii Event Abstract





Long Abstract:

Join us March 3 at 11 a.m. EST for the Data in Action Virtual Conference to hear from technology leaders, clients and business partners about today's enterprise data management challenges and how leveraging IBM's data management portfolio can deliver better business outcomes, at lower cost, while providing capabilities that scale across enterprise applications, databases and platforms. [...] 24931 32 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?11_Dave Harvey17_db2dave@GMAIL.COM31_Fri, 26 Feb 2010 11:19:17 +0000310_UTF-8 Roger inspired me to join in but I'm afraid that when I clicked the link I needed to add an extra clause: 'Is DB2 "He" or "She" and cannot spell the word "Definitely"'.

To reply "IT" would be unkind to computer spell-checkers. I am not prepared to disclose my answer in case she is watching! [...] 24964 25 53_Re: Accesspath influenced by # of reached threshold's15_Patrick Bossman25_patrick.bossman@GMAIL.COM31_Fri, 26 Feb 2010 11:49:50 +0000513_UTF-8 The optimizer does not consider this.

Patrick Bossman DB2 for z/OS Query Optimization

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * ** The best DB2 technical sessions in the world ** NEW - IBM hands-on labs -> no additional charge _____________________________________________________________________ [...] 24990 41 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 26 Feb 2010 08:41:21 -0500315_utf-8 Just a quick update

We're not (quite) to 100 votes yet, but whereas early voters were definitely going for "it", the current votes look like this:

Definitely a "he" 23% DB2 is a "she" 17% I think DB2 is an "it" 31% To me, it's just "DB2" 24% This question has never even occurred to me! 5% [...] 25032 168 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?0_18_RENUSHARMA@AOL.COM29_Fri, 26 Feb 2010 11:00:15 EST520_US-ASCII Definitely SHE and decked up with diamonds and Gold.

Renu Sharma





In a message dated 2/26/2010 8:48:33 A.M. Eastern Standard Time, phil.grainger@COGITO.CO.UK writes:

Just a quick update

We're not (quite) to 100 votes yet, but whereas early voters were definitely going for "it", the current votes look like this:

Definitely a "he" 23% DB2 is a "she" 17% I think DB2 is an "it" 31% To me, it's just "DB2" 24% This question has never even occurred to me! 5% [...] 25201 209 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?7_DB2 DBA21_the.db2.dba@GMAIL.COM31_Fri, 26 Feb 2010 11:40:16 -0500337_ISO-8859-1 WITH DUE RESPECT TO ALL WONDERFUL WOMEN IN THIS WORLD

I agree, it has to be a 'SHE'. Your life is good, when she IS happy (up and running). But, when SHE ISN'T(when DB2 is down), your life is a HELL... SHE won't give you any proper reason... You must spend sleepless nights to understand what actually went wrong. [...] 25411 61 15_Re: REORP issue14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 26 Feb 2010 11:56:32 -0500480_us-ascii Srinivas, One of the things IBM may do, if you open an ETR with them, is give you the REPAIR statement which isn't documented but does take the tablespace out of REORP. (Warning; this will probably not fix whatever is causing your LEVELID problem.)

--Phil

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of SrinivasG Sent: Thursday, February 25, 2010 11:40 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] REORP issue [...] 25473 68 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Fri, 26 Feb 2010 10:41:48 -0800571_utf-8 In English, the neutral gender would ordinarily be appropriate for an object like a computer program. However, there is a longstanding tradition of referring to countries, cities, or ships as "she". Now, I don't think of DB2 as a country, but neither do I think of it as an object, as it seems to have quite a bit more personality than your average toaster. In the case of a generic individual (such as a "student" or a "doctor", or, as in this case, a computer program), the masculine personal pronoun is appropriate. Therefore, I feel I am quite proper when [...] 25542 58 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Joe Geller21_joerg6666@HOTMAIL.COM31_Fri, 26 Feb 2010 18:52:40 +0000334_UTF-8 On the whole, I don't find a significant difference between male and female DB2 DBAs, so I think that gender neutral seems more appropriate. However, I agree with Cathy that DB2 does have much more personality than your generic "it". So, I usually refer to DB2 as DB2 with an occasional it thrown in when I need a pronoun. [...] 25601 124 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 26 Feb 2010 11:51:06 -0800302_us-ascii Being a child of the 60's, a fan of the Adam's Family, and folliclly envious, I have always referred to DB2 -and IMS before it - as "IT". Often prefixed with a gerund (as in X#&~ing DB2) or suffixed with a verb (it crapped out). On a particularly bad day "X#&~ing DB2 crapped out again". [...] 25726 75 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?9_Sam Baugh24_Sam.Baugh@MOTION-IND.COM31_Fri, 26 Feb 2010 13:54:18 -0600392_utf-8 Or to steal from an old Saturday Night Live skit, just call it "Pat" (could be a guy, may be a girl, we just don't know). Definitely Friday.

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Taddei, Cathy Sent: Friday, February 26, 2010 12:42 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 25802 95 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 26 Feb 2010 15:01:15 -0500375_US-ASCII Is someone willing to to try to communicate with Ted Codd?

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

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joe Geller Sent: Friday, February 26, 2010 1:53 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 25898 22 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?14_Bruce Lightsey25_Bruce.Lightsey@ITS.MS.GOV31_Fri, 26 Feb 2010 14:05:34 -0600581_US-ASCII Since computers and their programs and OSs work better for me with lots of cussing - and women never, ever respond well to cussing - DB2 is obviously a "he".

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * * Your only source for independent, unbiased, and trusted DB2 information. * ** The best DB2 technical sessions in the world ** NEW - IBM hands-on labs -> no additional charge _____________________________________________________________________ [...] 25921 105 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 26 Feb 2010 15:06:10 -0500512_iso-8859-1 The number of bored people in here... is truly alarming.



--Phil Sevetson



-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger Sent: Friday, February 26, 2010 5:41 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?

Just a quick update

We're not (quite) to 100 votes yet, but whereas early voters were definitely going for "it", the current votes look like this: [...] 26027 27 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 26 Feb 2010 20:06:56 +0000337_- >Therefore, I feel I am quite proper when I say "he started spitting out messages " or "he just won't stay up".

(8-{]}

When I was a student at the University of Waterloo in the 1970's, we always anthropomorphised computers & programmes. We always referred to them as 'he'.

- Too busy driving to stop for gas! [...] 26055 66 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?14_Peter Schwarcz23_schwarcz@BIGPOND.NET.AU31_Sat, 27 Feb 2010 08:03:39 +1100556_US-ASCII Hello Friday people,

Over time I have referred to different parts of DB2 as he or she, depending on the author of the different components.

Now since Roger M, has been the public face of db2, why not refer is the beast as Roger

Regards Peter S









-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL Sent: Saturday, 27 February 2010 7:07 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 26122 163 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Fri, 26 Feb 2010 13:40:08 -0800368_iso-8859-1 Hey, we're not bored. We each made a sacrifice of our companies' time to help Phil prepare his presentation. I'm sure the next time any of us need help, Phil will be ready to reciprocate, and our companies will reap the benefit. Additionally, there may be many other people out there who had the same question, who have benefited from this discussion. [...] 26286 179 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 26 Feb 2010 16:47:23 -0500447_iso-8859-1 And it's Friday (and nearly 10pm where I am, so what am I still doing in eMail :( )

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 Taddei, Cathy Sent: 26 February 2010 21:40 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 26466 230 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 26 Feb 2010 17:25:53 -0500413_iso-8859-1 You should be taking the dog for a walk to the Pub, so that he can see his friends.



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

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger Sent: Friday, February 26, 2010 4:47 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? [...] 26697 205 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Fri, 26 Feb 2010 15:27:29 -0700458_iso-8859-1 Not sure but I'm betting there is vino nearby.

Rick Weaver DB2 z/OS Product Manager BMC Software



-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger Sent: Friday, February 26, 2010 3:47 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"?

And it's Friday (and nearly 10pm where I am, so what am I still doing in eMail :( ) [...] 26903 179 39_Re: Why this happens when using BP32Kn?13_Jose de Bedos20_josedebedos@LIVE.COM31_Fri, 26 Feb 2010 19:29:54 -0300434_Windows-1252

Thanks to all. I've found why.





Jose





Date: Thu, 25 Feb 2010 21:43:25 -0300 From: josedebedos@LIVE.COM Subject: [DB2-L] Why this happens when using BP32Kn? To: DB2-L@WWW.IDUGDB2-L.ORG







Hi,

I've found that, when creating a TS in BP32Kn, the allocated VSAM has more space than what I asked for. The DDLs I run have this pattern: [...] 27083 437 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?3_Ray22_ray_in_doubt@YAHOO.COM31_Fri, 26 Feb 2010 14:40:08 -0800442_iso-8859-1 Since DB2 is Daddy's (IBM) Boy too (2)... it is a "He"

Cheers, Ray

--- On Fri, 2/26/10, Roger Hecq wrote:



From: Roger Hecq Subject: Re: [DB2-L] Slightly Off Topic - Is DB2 "He" or "She"? To: DB2-L@WWW.IDUGDB2-L.ORG Date: Friday, February 26, 2010, 5:25 PM



You should be taking the dog for a walk to the Pub, so that he can see his friends. [...] 27521 110 87_Re: DB2 LUW Oracle in for Tougher Sailing against IBM (re: Sun deal) -- Link to article10_Fred Edgar18_fredgarx@YAHOO.COM31_Fri, 26 Feb 2010 15:15:40 -0800535_iso-8859-1 Just trying to point out that there seem to be 10 Oracle or SQL Server jobs for every DB2 job, whether z/OS or LUW. DB2 is a great DBMS, but that doesn't mean it will stick around. IBM is not that great at marketing. Ten years from now, I believe there's a good chance that DB2 will no longer be huge in the DB space. Not because it's inferior--just the Beta/VHS and OS/2/Windows phenomenon. IBM is going to have to fight, or go the way of Informix. I know Informix is still around, but it's extremely rare that I hear [...] 27632 327 26_Re: Bounce DB2 every day ?9_DB2DBAzOS21_bala.db2dba@GMAIL.COM31_Sat, 27 Feb 2010 09:45:11 +0530608_windows-1252 Thanks to everyone who responded. I have taken valuable inputs.

Especially to Fritz, We've gone to use Webservices recently against our DB2 Production. Trade offs between legacy batch and the 'always demanding' web services application made me think of this topic. Dynamic SQL cache was enabled that showed good results in our TEST (lying on the same z/OS image) that is not bounced daily (but weekly) but, in production the response suffered. We were not successful in getting the response within expected turn-around. TEST and PROD systems are alike (structure, data, statistics). [...] 27960 140 34_IDUG 2010 Europe Planning Underway20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM31_Sat, 27 Feb 2010 11:39:35 +0200384_US-ASCII



Dear IDUG Members,

As you know, IDUG Europe has been the cornerstone for DB2 professionals to meet with hundreds of their counterparts at other organizations to build their skill sets, optimize their investments, increase system performance and up-time, lower costs, and create efficiencies to remain successful and competitive in their business. [...] 28101 933 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Sat, 27 Feb 2010 16:20:07 -0500407_iso-8859-1 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

To follow up, I dropped a note to Don Haderle - here's the gist of his reply

"For the linguists, database is feminine gender in romantic languages (la base di data,la base de données, ...) and Germanic (Die Datenbank). [...] 29035 1176 46_Re: Slightly Off Topic - Is DB2 "He" or "She"?15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Sun, 28 Feb 2010 15:07:56 -0500454_iso-8859-1 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"? [...]