1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2009, week 4 2 27 14_Re: History OT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 22 May 2009 00:33:40 +0000358_- >Grace is my hero. >I want to grow up and be just like her and have a boat named after me.

Or, just the place where the cards come out of the sorter?

- Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 30 93 14_Re: History OT23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 21 May 2009 20:44:42 -0400369_iso-8859-1 They used to say - that 2**64 - in kernels of corn, would cover the earth with a couple of inches.



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 [...] 124 212 14_Re: History OT12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Thu, 21 May 2009 20:56:32 -0400469_us-ascii Actually, I was privileged to be on the same plane with ADM. Grace Hopper on a flight out of Washington National in the early 80's. Where I went to school they couldn't afford a mainframe so it was System 34 and did assembler on a Z80 processor...I used to give my students a test on the Hollerith code but most days now nobody has heard of it. I did do some 360 work on an old computer my reseve unit used for years.....Not quite over the hill yet....PG [...] 337 276 51_Re: Submitting batch job from DB2 Stroed Procedure?14_Wayne Driscoll18_wdrisco@US.IBM.COM31_Thu, 21 May 2009 20:17:43 -0500494_US-ASCII The issue has nothing to do with authorization. The issue is that in the REXX SP address space, the TSO environment is invoked using TSO/E service IKJTSOEV, which does not support the SUBMIT command. In addition, I believe that once an address space invokes IKJTSOEV, that address space can not dynaically allocate an internal reader. Also, once the TSO/E environment is established under IKJTSOEV, there is no way to delete the environment, other than address space termination. [...] 614 32 14_Re: History OT30_edward.krisiewicz@jpmorgan.com30_edward.krisiewicz@JPMORGAN.COM31_Fri, 22 May 2009 01:42:51 +0000740_windows-1252 http://www.developerdotstar.com/community/node/25



..a picture published by Popular Mechanics in 1954 of what they thought "home" computers would look like in 50 years, which is 2004.

Unfortunately, it's a hoax. But still amuzing. Another gem:

http://archive.computerhistory.org/resources/text/NCR/NCR.325.1960.1026462 03.pdf

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 647 396 22_AW: [DB2-L] History OT35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Fri, 22 May 2009 08:22:11 +0200881_iso-8859-1 Hi folks,

even at the risk of someone having said so before, here in Germany you might get some beer, as BIT is short for a common brand of beer (not my favourite one, though). (C'mon, it's Friday, after all)

Regards

Ruediger

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. Vorstand: Rolf-Peter Hoenen (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Christian Hofer, Dr. [...] 1044 168 51_Re: Submitting batch job from DB2 Stroed Procedure?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Fri, 22 May 2009 06:41:02 +0000654_ISO-8859-1 Hello,

thank you for the problem analysis. Is there a way to overcome this?

I'm going to try with internal reader queuing a simple IEBGENER batch job that would then submit a real job ....

Regards, Nenad

On Thu, 21 May 2009 20:17:43 -0500, Wayne Driscoll wrote:

>The issue has nothing to do with authorization. The issue is that in the >REXX SP address space, the TSO environment is invoked using TSO/E service >IKJTSOEV, which does not support the SUBMIT command. In addition, I >believe that once an address space invokes IKJTSOEV, that address space >can not dynaically allocate [...] 1213 387 14_Re: History OT13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 22 May 2009 09:35:56 +0200557_iso-8859-1 I was thinking épées at dawn myself. And wondering if reading a hex had anything to do with Tarot cards. Hmmm... maybe the mists aren't clearing after all.





First 'real' IT job, if this counts, was 2 weeks' work experience as an 18-year-old converting scripts of some sort from a PDP 11/70 to something suitable for Vax/VMS. I think. Got real friendly with the 'gold' key. If it wasn't Vi it was a close precursor. Faster to edit files than ISPF, but man, what a steep learning curve. It's all been paged out long ago. [...] 1601 241 14_Re: History OT12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 22 May 2009 10:46:39 +0300640_utf-8 Hi,

No - it should be "High Noon" duel

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Thursday, May 21, 2009 10:10 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT

"duel floppy drives"??

At dawn, no doubt

Sorry Wayne - couldn't resist

Luckily Friday is looming

Phil G

________________________________

From: DB2 Data Base Discussion List on behalf of Campbell, Wayne Sent: Thu 21/05/2009 19:38 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 1843 37 81_AUTO: Steve C Norris/Nationwide/NWIE is out of the office. (returning 05/27/2009)0_22_NORRISS@NATIONWIDE.COM31_Fri, 22 May 2009 04:06:25 -0400411_US-ASCII I am out of the office until 05/27/2009.

I am on vacation. Please contact Naga at 9-0890 if you need assistance.

Thanks

Steve







Note: This is an automated response to your message "DB2-L Digest - 21 May 2009 to 22 May 2009 (#2009-151)" sent on 5/21/2009 9:00:11 PM.

This is the only notification you will receive while this person is away. [...] 1881 22 14_Re: History OT12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Fri, 22 May 2009 08:09:43 +0000651_windows-1252 ...nostalgia just isn't what it used to be....

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG North America 2008 Attendee Testimonial- "The round table SIGs I attended were great. The IBM presenters were very helpful and professional." _____________________________________________________________________ 1904 24 14_Re: History OT12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Fri, 22 May 2009 08:39:51 +0000517_windows-1252 ...not mainframe, not even PC... but I remember struggling with a Reverse Polish HP calculator... I'm glad that one has gone away.

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 1929 374 14_Re: History OT13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 22 May 2009 03:47:21 -0500547_ISO-8859-1 Raymond,

I remember writing code for a PDP 11 when I was in college.

Willie

Bell, Raymond wrote: > > I was thinking épées at dawn myself. And wondering if reading a hex > had anything to do with Tarot cards. Hmmm... maybe the mists aren't > clearing after all. > > > > First 'real' IT job, if this counts, was 2 weeks' work experience as > an 18-year-old converting scripts of some sort from a PDP 11/70 to > something suitable for Vax/VMS. I think. Got real friendly with the > 'gold' key. If it wasn't Vi it [...] 2304 234 51_Re: Submitting batch job from DB2 Stroed Procedure?11_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Fri, 22 May 2009 09:00:01 +0000672_windows-1250 This is how I solved the problem:

1. In the WLM start procedure added :

//SBMITJCL DD SYSOUT=(,INTRDR)

2. The DB2 SP now looks like this:

/* REXX */ OUT.1="//SUBJCL01 JOB ,CLASS=I,MSGCLASS=X " OUT.2="//*******************************************" OUT.3="//* SUBMIT A JOB TO JES INTERNAL READER FOR EXECUTION * " OUT.4="//*******************************************" OUT.5="//SUBMIT EXEC PGM=IEBGENER " OUT.6="//SYSUT1 DD DISP=SHR,DSN=JCL.PDS(JCLMEM) " OUT.7="//SYSUT2 DD SYSOUT=(B,INTRDR) " OUT.8="//SYSPRINT DD SYSOUT=* " OUT.9="//SYSIN DD DUMMY " OUT.10="/* " OUT.11="/*EOF " "EXECIO * DISKW SBMITJCL (STEM OUT. FINIS" EXIT [...] 2539 28 14_Re: History OT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 22 May 2009 09:45:23 +0000578_- >...nostalgia just isn't what it used to be....

Meaning: "The 'Good Old Days' aren't as good as the 'Good Old Days' were in the 'Good Old Days'". (8-{]}

- Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 2568 594 51_Re: Submitting batch job from DB2 Stroed Procedure?14_Wayne Driscoll18_wdrisco@US.IBM.COM31_Fri, 22 May 2009 06:16:28 -0500329_US-ASCII No need to use the 2 step approach to submit the real job. The issue is that the internal reader needs to be allocated in the JCL (something that years ago was risky, because JES internal readers could be a limited resource). Once the internal reader is allocated, you can write any jobstream you would like to it. [...] 3163 508 14_Re: History OT0_19_mike.holmans@BT.COM31_Fri, 22 May 2009 13:12:41 +0100363_iso-8859-1 While at college in the late 70s, I did office temp work in the vacations. I got a one-day assignment to go and pick up a passport for the UK MD of Commodore, which had just brought out the PET. They asked me to come back the next day to help them stuff envelopes for a mailing, and five weeks later I was acting Service Manager for Commodore UK. [...] 3672 247 14_Re: History OT14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 22 May 2009 13:16:58 +0100341_iso-8859-1 Wow, the ICL2900 - from when "we" had a computer industry

That was probably the first machine I worked on too - complete with punch cards.....

Still, I'm grateful to this thread for making my (very) impending 50th birthday seem less of a disaster

Happy Memorial Weekend to all the US folks

Phil G [...] 3920 70 74_db2 nse search using contains problem after migration of db2 v8.1 --> v9.511_Honza Novak22_kacerr@ZLUTAZIMNICE.CZ31_Fri, 22 May 2009 14:14:00 +0200343_ISO-8859-1 Hello, this is my first post to the list, i hope i won't sound stupid with my question.

We migrated database from v8 to v 9.5, and when we were in it we migrated from 32bit to 64bit. Everything seems to work fine except NSE, which has problems when querying for anything else than primary key of fulltext indexed table. [...] 3991 169 14_Re: History OT10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 22 May 2009 08:56:01 -0400462_us-ascii My first computer job was as a student operator on a 7094 in the summer of my sophomore year. It wasn't loosely coupled, but the lead operator definitely was!

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

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of George Toolan Sent: Thursday, May 21, 2009 4:57 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 4161 295 22_AW: [DB2-L] History OT35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Fri, 22 May 2009 14:58:57 +0200923_iso-8859-1 Phil,

stay consoled. As probably lots of other listers will confirm, there's life after 50; I'm not certain about many things but that one I'm sure of !

Best regards

Ruediger 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. Vorstand: Rolf-Peter Hoenen (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Dr. Christian Hofer, Dr. Wolfgang Weiler. ============================================================= [...] 4457 30 14_Re: History OT12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Fri, 22 May 2009 13:01:00 +0000273_windows-1252 I kid you not but in my first IT job I worked with someone whose clame to fame in the company was searching for the header record on a tape by trying to hold it up to the light like old home movie film.

Cut my teeth programming COBOL on DEC/VAX... [...] 4488 31 8_OT - DB214_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Fri, 22 May 2009 08:08:17 -0500459_us-ascii Did you all know that you can say "SELECT *" from any table and get ALL the columns back WITHOUT having to code each column name.

Wow! Those folks at IBM think of EVERYTHING!

This is still a DB2 forum...yes?

Thought I'd start the ball rolling about something DB2ish :) faz

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 4520 67 12_Re: OT - DB214_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 22 May 2009 14:13:09 +0100313_iso-8859-1 Actually faz, that is not strictly true any more

If you have HIDDEN columns in the table they are NOT brought back by a SELECT * even though you CAN specify them by column name if you really DO want them returned

Nothing like a bit of pedantry to knock your ball into the gutter eh? [...] 4588 132 96_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] AVOID PREPAREs by exploiting the local statement cache13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Fri, 22 May 2009 08:23:15 -0500572_us-ascii One question to consider would be if you want your distributed threads to go inactive after a commit point. If you do, then you don't want to use KEEPDYNAMIC, so I wouldn't bother attempting to keep a prepare past a commit point. Setting that aside for a minute, there can definitely be value in limiting the number of prepares that you issue (even when using global caching - a PREPARE pulled from the cache is still more expensive than the one you never issue). Assuming that inactive thread support is a requirement, I would look at how many prepares you [...] 4721 194 12_Re: OT - DB213_Michael Ebert18_mebert@AMADEUS.COM31_Fri, 22 May 2009 13:47:01 +0000625_ISO-8859-1 One thing I've often sorely missed was a "SELECT *-{a,b,c}" which would return all columns _except_ a, b, and c...

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







"Fazio, Richard" To DB2-L@WWW.IDUGDB2-L.ORG cc

bcc

Subject [DB2-L] OT - DB2









"Fazio, Richard" Please respond to : DB2 Database Discussion list at IDUG Sent by: DB2 Data Base Discussion List 22-05-09 15:08 [...] 4916 290 30_RUNSTATS INLINE STATISTICS SQL9_Ali, Omar25_Omar.Ali@CITYOFBOSTON.GOV31_Fri, 22 May 2009 09:46:55 -0400429_us-ascii Hi Group,

Just was wondering if anyone has RUNSTATS with INLINE STATISTICS JCL they are willing to share

Someone mention to me by using the inline stats you can call up a Stor. Procedure that will prime temp instance (for Peoplesoft environment) to allow online to run faster

I'm not sure if I'm saying this correctly but its something to that effect any suggestion comments will be gratefully [...] 5207 502 12_Re: OT - DB215_Gaston, Raymond17_GastonRay@ORU.COM31_Fri, 22 May 2009 09:52:26 -0400530_iso-8859-1 Dr. Ebert... I've often suggested that and was always laughed at! Your email is a welcome reinforcement.





- Ray Gaston

- DBA/ConEd





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Ebert Sent: Friday, May 22, 2009 9:47 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] OT - DB2







One thing I've often sorely missed was a "SELECT *-{a,b,c}" which would return all columns _except_ a, b, and c... [...] 5710 259 29_Re: History OT -- Adm. Hopper14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 22 May 2009 09:54:30 -0400491_us-ascii I went to computer school at a local tech school in Minnesota in the 70's. One of my teachers had some kind of clout, enough that I got to see Adm. Hopper speak, twice. She used to hand out nanoseconds -- bits of coated electrical wire about 11" long, representing the distance electricity would travel in a nanosecond. She carried a microsecond around for a while -- 1,000 nanoseconds, or 11,000 inches. It made quite a respectable bundle, especially compared to nanoseconds. [...] 5970 127 22_Re: History OT -- 2^6414_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 22 May 2009 09:57:52 -0400297_us-ascii Well, it's about 2*10^19 kernels, so I wouldn't be _that_ surprised to hear it.

Wasn't that the reward the boy was supposed to have claimed from the king in some fable? 1 grain of rice on the first square of a checkerboard, two on the second, four on the third, and so forth? [...] 6098 179 12_Re: OT - DB214_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Fri, 22 May 2009 09:10:37 -0500434_us-ascii Yeah those were the days ! Now even that has changed, SELECT * may not give you all the columns. Sorry faz just couldn't resist.









"Fazio, Richard" Sent by: "DB2 Data Base Discussion List" 05/22/2009 08:08 AM Please respond to "DB2 Database Discussion list at IDUG"



To DB2-L@WWW.IDUGDB2-L.ORG cc [...] 6278 120 12_Re: OT - DB29_Sam Baugh24_Sam.Baugh@MOTION-IND.COM31_Fri, 22 May 2009 09:18:04 -0500469_us-ascii Too bad the HIDDEN column is not updateable. Could have fun frustrating programmers.

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan Sent: Friday, May 22, 2009 9:11 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] OT - DB2



Yeah those were the days ! Now even that has changed, SELECT * may not give you all the columns. Sorry faz just couldn't resist. [...] 6399 90 22_Re: History OT -- 2^6414_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Fri, 22 May 2009 09:20:44 -0500419_us-ascii Close enough - number of grains for that prize come out to be (2^64 - 1 ).











Well, it's about 2*10^19 kernels, so I wouldn't be _that_ surprised to hear it.

Wasn't that the reward the boy was supposed to have claimed from the king in some fable? 1 grain of rice on the first square of a checkerboard, two on the second, four on the third, and so forth? [...] 6490 204 22_Re: History OT -- 2^6423_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 22 May 2009 10:36:29 -0400475_iso-8859-1 Yes, I believe it was the checkerboard prize from a king. Good memory....



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 [...] 6695 299 12_Re: OT - DB223_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 22 May 2009 10:40:03 -0400422_iso-8859-1 Frustrating programmers - the Alter statement in old Cobol programs in the 60's. The compiler (PruBol) was limited to a 16K procedure division.





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 [...] 6995 55 35_Social Networking for DB2 in the UK14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 22 May 2009 16:30:49 +0100404_iso-8859-1 Just a quick note to all the UK based DB2-ers out there

I have set up a community group at Linked In (UK DB2 User Community)

Head on to http://www.linkedin.com/groups?gid=1967941 to join us - we're looking forward to "seeing" you

Please note though that this IS supposed to be for UK-based folks ONLY, so if you are from elsewhere, apologies, but this is not for you [...] 7051 340 26_Re: AW: [DB2-L] History OT20_Govan, Hal (RET-DAY)29_Harold.Govan@REEDELSEVIER.COM31_Fri, 22 May 2009 12:15:13 -0400569_iso-8859-1 Here's a "ray of sunshine" for you "youngsters"... there's even life after 60. :-)

Unfortunately, until the stock markets recover, retirement will have to wait. :-(



Hal Govan Senior Database Administrator Reed Elsevier - Technology Services harold.govan@reedelsevier.com Phone: (937) 865-7820



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kurtz, Rüdiger Sent: Friday, May 22, 2009 8:59 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] AW: [DB2-L] History OT [...] 7392 31 29_Re: History OT -- Adm. Hopper11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 22 May 2009 16:51:51 +0000452_- >She used to hand out nanoseconds -- bits of coated electrical wire about 11" long, representing the distance electricity would travel in a nanosecond.

That came from her original presentation to Congress during the COBOL project in the 1950's.

Also, I think you got the length slightly wrong. Light travels 30 millimetres in a nanosecond which at 2.54 millimetres/inch is 11.81 inches. I believe she used 1ft in the presentation. [...] 7424 62 39_Re: Social Networking for DB2 in the UK15_Chris Hoelscher21_choelscher@HUMANA.COM31_Fri, 22 May 2009 13:08:20 -0400481_US-ASCII --> Please note though that this IS supposed to be for UK-based folks ONLY, so if you are from elsewhere, apologies, but this is not for you



I guess this rules out Louisville fans .....

The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. [...] 7487 353 18_Re: DBM1 cpu usage19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Fri, 22 May 2009 15:19:11 -0500498_us-ascii Hi LSH,

If you look in SYS1.PARMLIB(SMFPRFM00) and you see DDCONS(YES) and DETAIL ... that that may be your problem. See DDCONS informational APAR II07124 (very old but still critical).

With those SMF exits on for started tasks it can explain:

* unexplained DBM1 cpu activity * and/or "weird" delays in DB2 thread accounting time for (very high "other db2 time"; or very high max "sych i/o" times or very high max "async i/o" times measured in a minute or more). [...] 7841 293 18_Re: DBM1 cpu usage13_Laila hosaini19_lshosaini@YAHOO.COM31_Fri, 22 May 2009 21:54:35 -0700567_iso-8859-1 Hi Richard

There was no DDCONS ,in SMFPRM00 member....

bye.



--- On Sat, 5/23/09, Humphris,Richard P. wrote:



From: Humphris,Richard P. Subject: Re: [DB2-L] DBM1 cpu usage To: DB2-L@WWW.IDUGDB2-L.ORG Date: Saturday, May 23, 2009, 12:49 AM





Hi LSH,

If you look in SYS1.PARMLIB(SMFPRFM00) and you see DDCONS(YES) and DETAIL ... that that may be your problem. See DDCONS informational APAR II07124 (very old but still critical). [...] 8135 63 29_Re: History OT -- Adm. Hopper12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 23 May 2009 11:58:55 +0300450_utf-8 2.54 centimeters = 1 inch

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL Sent: Friday, May 22, 2009 7:52 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT -- Adm. Hopper

>She used to hand out nanoseconds -- bits of coated electrical wire about 11" long, representing the distance electricity would travel in a nanosecond. [...] 8199 56 29_Re: History OT -- Adm. Hopper11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Sat, 23 May 2009 09:02:55 +0000364_utf-8 You're correct. In a hurry and got the units wrong. And, aside from that a nanosecond is still 11.8 inches (rounded to 1ft). - Too busy driving to stop for gas!

-----Original Message----- From: Isaac Yassin

Date: Sat, 23 May 2009 11:58:55 To: Subject: Re: [DB2-L] History OT -- Adm. Hopper [...] 8256 112 29_Re: History OT -- Adm. Hopper12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 23 May 2009 12:48:38 +0300418_utf-8 Hi,

I did not pay attention as well

300 millimeters = 30 centimeters = 0.3 meter = 1 nanosecond at SoL And it is still 11.81 inches :-)

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL Sent: Saturday, May 23, 2009 12:03 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT -- Adm. Hopper [...] 8369 575 18_Re: DBM1 cpu usage15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Sat, 23 May 2009 08:11:58 -0400680_us-ascii Since SMF parms can be changed, you might want to do a double check by issuing from the console (or SDSF LOG)





D SMF,O





This will show you exactly what is currently running.





Lizette



















Hi Richard





There was no DDCONS ,in SMFPRM00 member....





bye.





Hi LSH,





If you look in SYS1.PARMLIB(SMFPRFM00) and you see DDCONS(YES) and DETAIL ... that that may be your problem. See DDCONS informational APAR II07124 (very old but still critical). [...] 8945 82 36_Lance D Ziegler is Out of the Office16_Lance D Ziegler125_Lance.D.Ziegler1@AEXP.COM31_Sat, 23 May 2009 18:11:02 -0700308_us-ascii I will be out of the office starting 05/23/2009 and will not return until 06/01/2009.

I will respond to your message when I return to the office on 01-JUN. I will not be available during the US primeshift, but I am reachable by cell phone and will review emails in the US evening hours. [...] 9028 310 51_Re: Submitting batch job from DB2 Stroed Procedure?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Mon, 25 May 2009 06:51:11 +0000718_ISO-8859-1 I tried to make a more "generic" SP by pulling the actual JCL out ...

On Fri, 22 May 2009 06:16:28 -0500, Wayne Driscoll wrote:

>No need to use the 2 step approach to submit the real job. The issue is >that the internal reader needs to be allocated in the JCL (something that >years ago was risky, because JES internal readers could be a limited >resource). Once the internal reader is allocated, you can write any >jobstream you would like to it. > >=============================================== >Wayne Driscoll >OMEGAMON DB2 L3 Support/Development >wdrisco(AT)us.ibm.com >=============================================== > > > >Nenad Vidak [...] 9339 419 18_Re: DBM1 cpu usage13_Laila hosaini19_lshosaini@YAHOO.COM31_Mon, 25 May 2009 03:15:24 -0700470_iso-8859-1 Dear Lizette

thanks a lot L.S.H

--- On Sat, 5/23/09, Lizette Koehler wrote:



From: Lizette Koehler Subject: Re: [DB2-L] DBM1 cpu usage To: DB2-L@WWW.IDUGDB2-L.ORG Date: Saturday, May 23, 2009, 4:41 PM















Since SMF parms can be changed, you might want to do a double check by issuing from the console (or SDSF LOG) [...] 9759 298 18_Re: DBM1 cpu usage13_Laila hosaini19_lshosaini@YAHOO.COM31_Mon, 25 May 2009 03:23:42 -0700649_iso-8859-1

Hi Dear Richard

I Couldn't understarnd DDCONS(yes) EFFECT on DBM1,COULD YOU PLEASE EXPLAIN MORE OR INTRODUCE A SIMPLE BOOK. Thanks In Adavnce. L.S.H

--- On Sat, 5/23/09, Humphris,Richard P. wrote:



From: Humphris,Richard P. Subject: Re: [DB2-L] DBM1 cpu usage To: DB2-L@WWW.IDUGDB2-L.ORG Date: Saturday, May 23, 2009, 12:49 AM





Hi LSH,

If you look in SYS1.PARMLIB(SMFPRFM00) and you see DDCONS(YES) and DETAIL ... that that may be your problem. See DDCONS informational APAR II07124 (very old but still critical). [...] 10058 592 18_Re: DBM1 cpu usage15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Mon, 25 May 2009 10:11:58 -0400381_us-ascii LSH -





Could you provide the output from a D SMF,O command? Then we could see what is setup in SMF.





When DBM1 is running 60-70% - how long is that time? Is it for seconds, minutes, hours? What is running in DB2 at the time of this spike? What are you using to determine this spike? - SDSF DA Screen? Or a monitoring tool? [...] 10651 404 18_Re: DBM1 cpu usage13_Laila hosaini19_lshosaini@YAHOO.COM31_Mon, 25 May 2009 21:42:39 -0700591_utf-8

Hi Dear Lizette  several secounds DBM1 cpu utilization is high , I saw it IN SDSF;DA. There is several Java applications conect to our DB2. There is no SMS dasd. my monitoring tool is OMEGAMOON,accourding to ACCOUNTING reports LOTS OF TIME APPLICATIONS are SUSPEND more than 60%,and CLASS 3 SUSPENSIONS are too high ,I/O rate is the most, I knew preftech in some tablespaces is too high, I alter them and THEN reorg them..... prefetch became less ,but these 2-3 tablespace done about 90% I/O in our DATABASE... Another point is this:some threads use 80-90% OF CPU in a [...] 11056 835 18_Re: DBM1 cpu usage23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 26 May 2009 09:47:15 -0400403_UTF-8 Laila,

The type of IO is determined by your design, catalog statistics, and sql coding. Thye CPU cost for Prefetch IO is charged to the DBM1 address space. Synch IO is charged to the application address space.

Class3 IO suspension - is this Synch IO or Other IO?

If there is a lot of Synch IO suspend time, as a % of the elapsed time, you need to tune your buffer pools. [...] 11892 35 51_Re: Submitting batch job from DB2 Stroed Procedure?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 27 May 2009 10:52:41 +0000467_ISO-8859-1 Peter Schwarcz asked me to post a link to http://www-01.ibm.com/support/docview.wss?uid=isg1II13698 which contains further links to details about a number of DB2 supplied stored procedures to submit jobs, check status, retrieve output etc.

James Campbell

On Mon, 25 May 2009 06:51:11 +0000, Nenad Vidak wrote:

>I tried to make a more "generic" SP by pulling the actual JCL out ... > [...] 11928 126 25_Development batch testing13_Laine, Rogers22_rlaine@WHITNEYBANK.COM31_Wed, 27 May 2009 08:27:42 -0500530_us-ascii We have two DB2 V8 subsystems, one for Test the other for Production jobs.

We are developing a batch Static Cobol program to read millions of rows from an image table each month. In order to test this new program from the Test subsystem we would like to read the rows from the Production image table so we do not need to build the image table on Test. I know we can copy the table from Prod to Test but the application has embedded file names in this table that we do not want to change. The program we would [...] 12055 80 14_Re: History OT10_Roger Hecq18_Roger.Hecq@UBS.COM31_Wed, 27 May 2009 09:47:54 -0400524_US-ASCII When I first started working, I had to opportunity to work with some 'unit record' operators who regularly astounded us with their feats and intellect, but none of them could match this feat. This takes the cake in my book.

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

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Adam Baldwin Sent: Friday, May 22, 2009 9:01 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 12136 250 29_DB2 UDB LUW v8.2 Cloning a DB15_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 27 May 2009 09:50:31 -0400304_US-ASCII I have been asked to clone a database from a Production server to an Acceptance server on a weekly basis. I would like to reduce and hopefully eliminate any manual intervention for this cloning process. Has anyone does this kind of process and would you be willing to share the procedures? [...] 12387 242 36_Data Studio Developer Debugger Error15_Fox, Gregory W.22_GWFOX@ARKBLUECROSS.COM31_Wed, 27 May 2009 11:07:21 -0500668_us-ascii When attempting to execute the debugger within the Data Studio Developer for a native SQL stored procedure on z/OS I get the following error:





"Session Manager is not available. To change Session Manager settings, see the DB2 Debugger Stored Procedure preference page."





I have started the Session Manager locally on my computer by executing the db2dbgm.bat file in a cmd window. I have selected the "Use already running session manager" option in the preference page, and the IP address and port number returned by db2dbgm.bat have been entered as well. Is there some other setting which needs to be modified [...] 12630 300 29_Re: Development batch testing0_22_sally.mir@WACHOVIA.COM31_Wed, 27 May 2009 12:30:53 -0400485_US-ASCII

So you're saying that you want to run the program in your test environment, and access the table in your prod environment, right?

This would require a DDF connection between the two subsystems. You could create an alias for the prod table on your test subsystem, and bind your package on both subsystems. Then include both packages in your plan. Whenever you access the table via the alias, you will actually be getting the data from the production table. [...] 12931 236 33_Re: DB2 UDB LUW v8.2 Cloning a DB12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 27 May 2009 09:45:32 -0700365_iso-8859-1 Try this: The first 2 steps are "one-time". Assume dbs are named prod and dev, and that you only want to refresh the data. And that the table definitions are the same.

1.Catalog the prod database on the dev box 2.Set up a directory on the dev box named "exportdir"



From the dev box....set up a cron job that does the following [...] 13168 268 33_Re: DB2 UDB LUW v8.2 Cloning a DB12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Wed, 27 May 2009 13:12:17 -0400448_US-ASCII Can't we all just get along. :) I don't know how long all the exporting and loading takes(guess depends on amount of data) but we clone an entire DB2 Z/Os Peoplesoft subsystem in about an hour from prod to test .





tim malamphy Sent by: DB2 Data Base Discussion List 05/27/2009 12:44 PM Please respond to DB2 Database Discussion list at IDUG [...] 13437 17 33_Re: DB2 UDB LUW v8.2 Cloning a DB11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 27 May 2009 17:19:07 +0000349_Windows-1252 > Now aren't all you mainframe only guys envious as to how easy this is?

Cheap shot! And, an incorrect one.

Remember that DB2 started on the mainframe. And, the mainframe has better reliability and can run at close to 100% without impacting response. Whereas, I've seen squatty boxes considered running 'hot' at 20%. [...] 13455 405 33_Re: DB2 UDB LUW v8.2 Cloning a DB0_34_ravi.khandelwal@THOMSONREUTERS.COM31_Wed, 27 May 2009 12:58:45 -0500400_us-ascii If it's possible on your acceptance server, create the db2 filesystems with the exact name/path as you have in your production server, then you can just run a simple restore/rollforward (automate it using a script) without having to do all the restore-redirect containers stuff. If keeping the filesystem/directory names is not an option, you can also consider creating symbolic links. [...] 13861 166 29_Re: Development batch testing13_Laine, Rogers22_rlaine@WHITNEYBANK.COM31_Wed, 27 May 2009 14:09:06 -0500584_us-ascii Sally,

This is exactly what we are trying to do.

We currently have DDF connections for each subsystem, so would this be enought?

The batch program would just call the alias name to read the production table.

Where can I find more information regarding this process.

Rogers

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of sally.mir@WACHOVIA.COM Sent: Wednesday, May 27, 2009 11:31 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Development batch testing [...] 14028 43 45_DB2 UDB LUW v8.2 - freeing up container space13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Wed, 27 May 2009 19:11:04 +0000371_windows-1252 All,

I am fairly new to DB2 LUW, and I am trying to find a way to free up space consumed by tablespace containers for a few tables.

I ran some tests using classic REORG and INPLACE REORG, both of which reduced the number of pages in the table. However the physical space consumed by the tablespace containers was not reduced by the REORG. [...] 14072 91 49_Re: DB2 UDB LUW v8.2 - freeing up container space12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Wed, 27 May 2009 15:22:16 -0400858_us-ascii Sure, try "REDUCE".....PG





Phil Gunning IBM Data Champion www.gunningts.com Twitter:@db2luw See us at IDUG Europe, 5-9 Oct, 2009 Rome, Italy Database Industry Analyst DB2 Consulting, Books on DB2, Outsourcing, Education, Remote Support http://it.toolbox.com/blogs/db2-for-luw DB2 9.7 Early Access Program -- http://www-01.ibm.com/software/data/db2/technology-sandbox/ Direct +1.610.451.5801 Toll Free 888.241.1070 pgunning@gunningts.com IBM Business Partner IBM Authorized Reseller This message (including attachments, header and footer details) contains confidential information intended for a specific individual or individuals and purpose(s), and is protected by law. If you are not the intended recipient, you should delete this message and any attachments.Any disclosure, copying, or distribution of this message, or [...] 14164 25 49_Re: DB2 UDB LUW v8.2 - freeing up container space12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Wed, 27 May 2009 22:09:56 +0000758_ISO-8859-1 ...REDUCE is an ALTER TABLESPACE option allowing you to shrink your DMS container(s) - but not below the high watermark.

Peter

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 14190 145 72_ATTENTION -- LAST MINUTE ALERT. DB2 Security Webinar, Thurs. 9:30 AM CDT14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 27 May 2009 19:29:25 -0400356_us-ascii Sorry, folks, I got behind on my email. Rebecca Bond asked me to post this for y'all. She's a senior (and experienced and very freakin' good) UDB DBA, author of the "DB2 9 Security" book from IBM Press, and she's giving a Webinar Thursday AM (That's tomorrow to me, but "today" by the time most of you read it). This is the link to register: [...] 14336 28 29_Re: Development batch testing12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 28 May 2009 07:20:09 +0000595_windows-1252 Take a look at chapter 20 of the Application Programming and SQL Guide. It's the chapter called "Planning to access distributed data". You should find all of the informatoin that you need.

Cheers, Adam

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 14365 182 56_z/Journal (February - March and April - May 2009 issues)10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Thu, 28 May 2009 03:46:30 -0400531_Windows-1252





Hi DB2 user,





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

Last update on Monday, May 25th 2009



Articles from February - March and April - May 2009 issues of z/Journal are available online:





- Canonical Database Architecture and DB2 Performance … Really? by Susan Lawson and Dan Luksetich





- Not Sure Who You Are? Ask DB2 by Susan Lawson and Dan Luksetich [...] 14548 28 49_Re: DB2 UDB LUW v8.2 - freeing up container space13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Thu, 28 May 2009 16:50:11 +0000719_windows-1252 Peter / Phil

thanks for your assitance RESIZE / REDUCE is exactly what I needed.

regards

Jack

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG North America 2008 Attendee Testimonial- "The round table SIGs I attended were great. The IBM presenters were very helpful and professional." _____________________________________________________________________