[Friday] "The things we do for DB2"

Phil Grainger

[Friday] "The things we do for DB2"
Or "Have a laugh at Phils expense"

I know that some of you really don't believe it when those of us lucky
enough to travel as part of our job tell you "It's really not that
exotic to fly around the world, you know"

Anyway, sometimes it really ISN'T so let me brighten up your Friday with
a sad tale of how things can go awry

Last weekend was the inaugural planning meeting for European IDUG 2008 -
held in Warsaw

Although I would normally avoid it like the plague, this time I was
forced to fly out of London Heathrow - last Thursday.... (the "Boeing
777 day"). Actually, I was rather surprised our flight left at all, so
being 4 hours late wasn't so bad.

Then I tried to get home again after the meeting.

First of all, our flight was delayed and then delayed a little further,
until around 10pm it was cancelled altogether. We were offered a hotel
room for the night, but the airline was shuttling people from the
airport to the hotel in blocks of 20 (small bus) - across the four
flights they cancelled, that amounted to around 400 people, so you can
do the maths and work out the queue length!

One sneaky cab ride later and I was in another queue to check in (behind
only around 80 people this time). Finally got to bet around 1am

Oh, and they wanted us BACK at the airport by 5am the next morning (I am
getting too old for missing my sleep).

So, back at Warsaw airport and checked in (again) for the flight,
through to the departure gate and as we were starting to board, they
discovered an unattended bag in the check-in area and evacuated the
airport - with around 50 people who should have been on our flight. Of
course, in Europe, if your BAG is on the plane but you AREN'T, then the
flight stays put. The airline decided that we'd wait for these people to
be un-evacuated and (90 minutes later) they rejoined us on the plane.

Ready to go?

Not a chance - still two more bags than people.

So all the bags off the plane and we each have to physically identify
our bags to be reloaded (and the suspect two taken away for
interrogation, I suppose)

FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
trip back to Heathrow

So you see - sometimes travelling in support of DB2 can be a real pain

I'm not after sympathy (I'd get none anyway, right?) but those of you
who DO travel a lot can rest safe in the knowledge that I've used up
quite a lot of our collective bad luck all in one go :)

Have a safe and quiet weekend everyone

Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bill Gannon
Sent: 23 January 2008 12:43
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

Good morning Phil,

Furthering on what James sent us - if you remove the /dsnsh0a2 portion
of the URL, you will find yourself in a very large Bookshelf repository
that has all the Softcopy documentation for DB2 z/OS from V2 through V9
just do a "Find on this Page" and specify dsn .... Happy reading !!


William B. Gannon
- IBM Certified Solutions Expert
- IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Wednesday, January 23, 2008 6:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

V2.3. The "a" makes me think this was the first softcopy set
http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0a2

James Campbell


On 22 Jan 2008 at 9:47, Grainger, Phil wrote:

> OK, follow-on question
>
> Does anyone have softcopies of any of the Version 2 SQL Reference
manuals (bookmanager format probably)??
>
> I'm trying to remember "all" of the new stuff that came in V2.1, 2.2
and 2.3 and my long-term memory is failing me badly (with all the stuff
IBM deliver these days, I have Gary Larssons "my brains full" moments
now)
>
> Thanks to everyone for their help
>
> Phil Grainger
> CA
>
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms
-----------------------------------------
Under Florida law, e-mail addresses are public records. If you do not
want your e-mail address released in response to a public records
request, do not send electronic mail to this entity.
Instead, contact this office by phone or in writing.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

[login to unmask email]

Re: [Friday] "The things we do for DB2"
(in response to Phil Grainger)
On Friday 25 January 2008 07:38:59 Grainger, Phil wrote:
> Or "Have a laugh at Phils expense"
>
> I know that some of you really don't believe it when those of us lucky
> enough to travel as part of our job tell you "It's really not that
> exotic to fly around the world, you know"
>
> Anyway, sometimes it really ISN'T so let me brighten up your Friday with
> a sad tale of how things can go awry
>
> Last weekend was the inaugural planning meeting for European IDUG 2008 -
> held in Warsaw
>
> Although I would normally avoid it like the plague, this time I was
> forced to fly out of London Heathrow - last Thursday.... (the "Boeing
> 777 day"). Actually, I was rather surprised our flight left at all, so
> being 4 hours late wasn't so bad.
>
> Then I tried to get home again after the meeting.
>
> First of all, our flight was delayed and then delayed a little further,
> until around 10pm it was cancelled altogether. We were offered a hotel
> room for the night, but the airline was shuttling people from the
> airport to the hotel in blocks of 20 (small bus) - across the four
> flights they cancelled, that amounted to around 400 people, so you can
> do the maths and work out the queue length!
>
> One sneaky cab ride later and I was in another queue to check in (behind
> only around 80 people this time). Finally got to bet around 1am
>
> Oh, and they wanted us BACK at the airport by 5am the next morning (I am
> getting too old for missing my sleep).
>
> So, back at Warsaw airport and checked in (again) for the flight,
> through to the departure gate and as we were starting to board, they
> discovered an unattended bag in the check-in area and evacuated the
> airport - with around 50 people who should have been on our flight. Of
> course, in Europe, if your BAG is on the plane but you AREN'T, then the
> flight stays put. The airline decided that we'd wait for these people to
> be un-evacuated and (90 minutes later) they rejoined us on the plane.
>
> Ready to go?
>
> Not a chance - still two more bags than people.
>
> So all the bags off the plane and we each have to physically identify
> our bags to be reloaded (and the suspect two taken away for
> interrogation, I suppose)
>
> FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
> trip back to Heathrow
>
> So you see - sometimes travelling in support of DB2 can be a real pain
>
> I'm not after sympathy (I'd get none anyway, right?) but those of you
> who DO travel a lot can rest safe in the knowledge that I've used up
> quite a lot of our collective bad luck all in one go :)
>
> Have a safe and quiet weekend everyone
>
> Phil Grainger
> CA
> Product Management Director
> Phone: +44 (0)1753 577 733
> Mobile: +44 (0)7970 125 752
> eMail: [login to unmask email]
>
> Ditton Park
> Riding Court Road
> Datchet
> Slough
> SL3 9LL
>
> CA plc a company registered in England and Wales under company
> registration number 1282495 with its registered office at the address
> set out above. VAT number 697904179.
>
>

Great Story - I think I'll stick with the 1-2 hour drive for my commute.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Richard Fazio

Re: [Friday] "The things we do for DB2"
(in response to dj53tx-udb@YAHOO.COM)
Well, I don't know about the planes, hotels the suspected "b"-word in
the un-attended bag, but what I heard right here LOUD AND CLEAR is a
great example of when to turn off sequential pre-fetch and/or adding I/O
parallelism.

The bus executing efficiently for the whole unit of work, however, by
creating a new stream of data (you) with a single I/O (cab) you achieved
superior I/O throughput at an overall higher cost, but in this case, the
user requirements for reduced response time.

Phil, nice job!
faz

p.s. Yes...it IS Friday
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Grainger, Phil
Sent: Friday, January 25, 2008 7:39 AM
To: [login to unmask email]
Subject: [DB2-L] [Friday] "The things we do for DB2"

Or "Have a laugh at Phils expense"

I know that some of you really don't believe it when those of us lucky
enough to travel as part of our job tell you "It's really not that
exotic to fly around the world, you know"

Anyway, sometimes it really ISN'T so let me brighten up your Friday with
a sad tale of how things can go awry

Last weekend was the inaugural planning meeting for European IDUG 2008 -
held in Warsaw

Although I would normally avoid it like the plague, this time I was
forced to fly out of London Heathrow - last Thursday.... (the "Boeing
777 day"). Actually, I was rather surprised our flight left at all, so
being 4 hours late wasn't so bad.

Then I tried to get home again after the meeting.

First of all, our flight was delayed and then delayed a little further,
until around 10pm it was cancelled altogether. We were offered a hotel
room for the night, but the airline was shuttling people from the
airport to the hotel in blocks of 20 (small bus) - across the four
flights they cancelled, that amounted to around 400 people, so you can
do the maths and work out the queue length!

One sneaky cab ride later and I was in another queue to check in (behind
only around 80 people this time). Finally got to bet around 1am

Oh, and they wanted us BACK at the airport by 5am the next morning (I am
getting too old for missing my sleep).

So, back at Warsaw airport and checked in (again) for the flight,
through to the departure gate and as we were starting to board, they
discovered an unattended bag in the check-in area and evacuated the
airport - with around 50 people who should have been on our flight. Of
course, in Europe, if your BAG is on the plane but you AREN'T, then the
flight stays put. The airline decided that we'd wait for these people to
be un-evacuated and (90 minutes later) they rejoined us on the plane.

Ready to go?

Not a chance - still two more bags than people.

So all the bags off the plane and we each have to physically identify
our bags to be reloaded (and the suspect two taken away for
interrogation, I suppose)

FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
trip back to Heathrow

So you see - sometimes travelling in support of DB2 can be a real pain

I'm not after sympathy (I'd get none anyway, right?) but those of you
who DO travel a lot can rest safe in the knowledge that I've used up
quite a lot of our collective bad luck all in one go :)

Have a safe and quiet weekend everyone

Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bill Gannon
Sent: 23 January 2008 12:43
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

Good morning Phil,

Furthering on what James sent us - if you remove the /dsnsh0a2 portion
of the URL, you will find yourself in a very large Bookshelf repository
that has all the Softcopy documentation for DB2 z/OS from V2 through V9
just do a "Find on this Page" and specify dsn .... Happy reading !!


William B. Gannon
- IBM Certified Solutions Expert
- IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Wednesday, January 23, 2008 6:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

V2.3. The "a" makes me think this was the first softcopy set
http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0a2

James Campbell


On 22 Jan 2008 at 9:47, Grainger, Phil wrote:

> OK, follow-on question
>
> Does anyone have softcopies of any of the Version 2 SQL Reference
manuals (bookmanager format probably)??
>
> I'm trying to remember "all" of the new stuff that came in V2.1, 2.2
and 2.3 and my long-term memory is failing me badly (with all the stuff
IBM deliver these days, I have Gary Larssons "my brains full" moments
now)
>
> Thanks to everyone for their help
>
> Phil Grainger
> CA
>
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms
-----------------------------------------
Under Florida law, e-mail addresses are public records. If you do not
want your e-mail address released in response to a public records
request, do not send electronic mail to this entity.
Instead, contact this office by phone or in writing.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

William Favero

Re: [Friday] "The things we do for DB2"
(in response to Richard Fazio)
You have my sympathy... been there, done that... too many times...

Willie

Grainger, Phil wrote:
> Or "Have a laugh at Phils expense"
>
> I know that some of you really don't believe it when those of us lucky
> enough to travel as part of our job tell you "It's really not that
> exotic to fly around the world, you know"
>
> Anyway, sometimes it really ISN'T so let me brighten up your Friday with
> a sad tale of how things can go awry
>
> Last weekend was the inaugural planning meeting for European IDUG 2008 -
> held in Warsaw
>
> Although I would normally avoid it like the plague, this time I was
> forced to fly out of London Heathrow - last Thursday.... (the "Boeing
> 777 day"). Actually, I was rather surprised our flight left at all, so
> being 4 hours late wasn't so bad.
>
> Then I tried to get home again after the meeting.
>
> First of all, our flight was delayed and then delayed a little further,
> until around 10pm it was cancelled altogether. We were offered a hotel
> room for the night, but the airline was shuttling people from the
> airport to the hotel in blocks of 20 (small bus) - across the four
> flights they cancelled, that amounted to around 400 people, so you can
> do the maths and work out the queue length!
>
> One sneaky cab ride later and I was in another queue to check in (behind
> only around 80 people this time). Finally got to bet around 1am
>
> Oh, and they wanted us BACK at the airport by 5am the next morning (I am
> getting too old for missing my sleep).
>
> So, back at Warsaw airport and checked in (again) for the flight,
> through to the departure gate and as we were starting to board, they
> discovered an unattended bag in the check-in area and evacuated the
> airport - with around 50 people who should have been on our flight. Of
> course, in Europe, if your BAG is on the plane but you AREN'T, then the
> flight stays put. The airline decided that we'd wait for these people to
> be un-evacuated and (90 minutes later) they rejoined us on the plane.
>
> Ready to go?
>
> Not a chance - still two more bags than people.
>
> So all the bags off the plane and we each have to physically identify
> our bags to be reloaded (and the suspect two taken away for
> interrogation, I suppose)
>
> FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
> trip back to Heathrow
>
> So you see - sometimes travelling in support of DB2 can be a real pain
>
> I'm not after sympathy (I'd get none anyway, right?) but those of you
> who DO travel a lot can rest safe in the knowledge that I've used up
> quite a lot of our collective bad luck all in one go :)
>
> Have a safe and quiet weekend everyone
>
> Phil Grainger
> CA
> Product Management Director
> Phone: +44 (0)1753 577 733
> Mobile: +44 (0)7970 125 752
> eMail: [login to unmask email]
>
> Ditton Park
> Riding Court Road
> Datchet
> Slough
> SL3 9LL
>
> CA plc a company registered in England and Wales under company
> registration number 1282495 with its registered office at the address
> set out above. VAT number 697904179.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Bill Gannon
> Sent: 23 January 2008 12:43
> To: [login to unmask email]
> Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2
>
> Good morning Phil,
>
> Furthering on what James sent us - if you remove the /dsnsh0a2 portion
> of the URL, you will find yourself in a very large Bookshelf repository
> that has all the Softcopy documentation for DB2 z/OS from V2 through V9
> just do a "Find on this Page" and specify dsn .... Happy reading !!
>
>
> William B. Gannon
> - IBM Certified Solutions Expert
> - IBM Certified Database Administrator
> DB2 Universal Database V8.1 for zOS
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of [login to unmask email]
> Sent: Wednesday, January 23, 2008 6:02 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2
>
> V2.3. The "a" makes me think this was the first softcopy set
> http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0a2
>
> James Campbell
>
>
> On 22 Jan 2008 at 9:47, Grainger, Phil wrote:
>
>
>> OK, follow-on question
>>
>> Does anyone have softcopies of any of the Version 2 SQL Reference
>>
> manuals (bookmanager format probably)??
>
>>
>> I'm trying to remember "all" of the new stuff that came in V2.1, 2.2
>>
> and 2.3 and my long-term memory is failing me badly (with all the stuff
> IBM deliver these days, I have Gary Larssons "my brains full" moments
> now)
>
>>
>> Thanks to everyone for their help
>>
>> Phil Grainger
>> CA
>>
>>
>>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and
> Code Place, see the latest IDUG conference information, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on Member Services at http://www.idug.org/lsms
> -----------------------------------------
> Under Florida law, e-mail addresses are public records. If you do not
> want your e-mail address released in response to a public records
> request, do not send electronic mail to this entity.
> Instead, contact this office by phone or in writing.
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and
> Code Place, see the latest IDUG conference information, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Gerald Hodge

Re: [Friday] "The things we do for DB2"
(in response to William Favero)
Phil:

Travel is not luck it is misfortune. Your trip sounds like a normal passage
from Houston to Chicago to catch a flight to the UK. I use Dallas or
Chicago as hubs because New York and Miami are competing to see who can be
the most dysfunctional. I do about 100K on American Airlines and 20K to 30K
on others within Europe each year. When coming into the UK from the
continent or Ireland, I try to use London City as the Immigration and
Customs staffs are used to dealing with business people. Of course, they
are now trying to close London City.

You do have my sympathy. Come by our booth at IDUG in Dallas and I'll buy
you a drink. Perhaps we could form a club. I am told that is what happens
when three or more Englishmen get together?

Gerald Hodge
HLS Technologies, Inc.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Grainger, Phil
Sent: Friday, January 25, 2008 7:39 AM
To: [login to unmask email]
Subject: [DB2-L] [Friday] "The things we do for DB2"

Or "Have a laugh at Phils expense"

I know that some of you really don't believe it when those of us lucky
enough to travel as part of our job tell you "It's really not that
exotic to fly around the world, you know"

Anyway, sometimes it really ISN'T so let me brighten up your Friday with
a sad tale of how things can go awry

Last weekend was the inaugural planning meeting for European IDUG 2008 -
held in Warsaw

Although I would normally avoid it like the plague, this time I was
forced to fly out of London Heathrow - last Thursday.... (the "Boeing
777 day"). Actually, I was rather surprised our flight left at all, so
being 4 hours late wasn't so bad.

Then I tried to get home again after the meeting.

First of all, our flight was delayed and then delayed a little further,
until around 10pm it was cancelled altogether. We were offered a hotel
room for the night, but the airline was shuttling people from the
airport to the hotel in blocks of 20 (small bus) - across the four
flights they cancelled, that amounted to around 400 people, so you can
do the maths and work out the queue length!

One sneaky cab ride later and I was in another queue to check in (behind
only around 80 people this time). Finally got to bet around 1am

Oh, and they wanted us BACK at the airport by 5am the next morning (I am
getting too old for missing my sleep).

So, back at Warsaw airport and checked in (again) for the flight,
through to the departure gate and as we were starting to board, they
discovered an unattended bag in the check-in area and evacuated the
airport - with around 50 people who should have been on our flight. Of
course, in Europe, if your BAG is on the plane but you AREN'T, then the
flight stays put. The airline decided that we'd wait for these people to
be un-evacuated and (90 minutes later) they rejoined us on the plane.

Ready to go?

Not a chance - still two more bags than people.

So all the bags off the plane and we each have to physically identify
our bags to be reloaded (and the suspect two taken away for
interrogation, I suppose)

FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
trip back to Heathrow

So you see - sometimes travelling in support of DB2 can be a real pain

I'm not after sympathy (I'd get none anyway, right?) but those of you
who DO travel a lot can rest safe in the knowledge that I've used up
quite a lot of our collective bad luck all in one go :)

Have a safe and quiet weekend everyone

Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bill Gannon
Sent: 23 January 2008 12:43
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

Good morning Phil,

Furthering on what James sent us - if you remove the /dsnsh0a2 portion
of the URL, you will find yourself in a very large Bookshelf repository
that has all the Softcopy documentation for DB2 z/OS from V2 through V9
just do a "Find on this Page" and specify dsn .... Happy reading !!


William B. Gannon
- IBM Certified Solutions Expert
- IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Wednesday, January 23, 2008 6:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

V2.3. The "a" makes me think this was the first softcopy set
http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0a2

James Campbell


On 22 Jan 2008 at 9:47, Grainger, Phil wrote:

> OK, follow-on question
>
> Does anyone have softcopies of any of the Version 2 SQL Reference
manuals (bookmanager format probably)??
>
> I'm trying to remember "all" of the new stuff that came in V2.1, 2.2
and 2.3 and my long-term memory is failing me badly (with all the stuff
IBM deliver these days, I have Gary Larssons "my brains full" moments
now)
>
> Thanks to everyone for their help
>
> Phil Grainger
> CA
>
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms
-----------------------------------------
Under Florida law, e-mail addresses are public records. If you do not
want your e-mail address released in response to a public records
request, do not send electronic mail to this entity.
Instead, contact this office by phone or in writing.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site, you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much more. If you
have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

William Favero

Re: [Friday] "The things we do for DB2"
(in response to Gerald Hodge)
Hey Gerry

We could make "DB2 Road Warrior" buttons for all of the club members.

BTW, I am no longer in the sales job at IBM. With SVL now doing data
warehouse. We'll need to talk in Dallas... LOL

Willie

Gerald Hodge wrote:
> Phil:
>
> Travel is not luck it is misfortune. Your trip sounds like a normal passage
> from Houston to Chicago to catch a flight to the UK. I use Dallas or
> Chicago as hubs because New York and Miami are competing to see who can be
> the most dysfunctional. I do about 100K on American Airlines and 20K to 30K
> on others within Europe each year. When coming into the UK from the
> continent or Ireland, I try to use London City as the Immigration and
> Customs staffs are used to dealing with business people. Of course, they
> are now trying to close London City.
>
> You do have my sympathy. Come by our booth at IDUG in Dallas and I'll buy
> you a drink. Perhaps we could form a club. I am told that is what happens
> when three or more Englishmen get together?
>
> Gerald Hodge
> HLS Technologies, Inc.
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
> Of Grainger, Phil
> Sent: Friday, January 25, 2008 7:39 AM
> To: [login to unmask email]
> Subject: [DB2-L] [Friday] "The things we do for DB2"
>
> Or "Have a laugh at Phils expense"
>
> I know that some of you really don't believe it when those of us lucky
> enough to travel as part of our job tell you "It's really not that
> exotic to fly around the world, you know"
>
> Anyway, sometimes it really ISN'T so let me brighten up your Friday with
> a sad tale of how things can go awry
>
> Last weekend was the inaugural planning meeting for European IDUG 2008 -
> held in Warsaw
>
> Although I would normally avoid it like the plague, this time I was
> forced to fly out of London Heathrow - last Thursday.... (the "Boeing
> 777 day"). Actually, I was rather surprised our flight left at all, so
> being 4 hours late wasn't so bad.
>
> Then I tried to get home again after the meeting.
>
> First of all, our flight was delayed and then delayed a little further,
> until around 10pm it was cancelled altogether. We were offered a hotel
> room for the night, but the airline was shuttling people from the
> airport to the hotel in blocks of 20 (small bus) - across the four
> flights they cancelled, that amounted to around 400 people, so you can
> do the maths and work out the queue length!
>
> One sneaky cab ride later and I was in another queue to check in (behind
> only around 80 people this time). Finally got to bet around 1am
>
> Oh, and they wanted us BACK at the airport by 5am the next morning (I am
> getting too old for missing my sleep).
>
> So, back at Warsaw airport and checked in (again) for the flight,
> through to the departure gate and as we were starting to board, they
> discovered an unattended bag in the check-in area and evacuated the
> airport - with around 50 people who should have been on our flight. Of
> course, in Europe, if your BAG is on the plane but you AREN'T, then the
> flight stays put. The airline decided that we'd wait for these people to
> be un-evacuated and (90 minutes later) they rejoined us on the plane.
>
> Ready to go?
>
> Not a chance - still two more bags than people.
>
> So all the bags off the plane and we each have to physically identify
> our bags to be reloaded (and the suspect two taken away for
> interrogation, I suppose)
>
> FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
> trip back to Heathrow
>
> So you see - sometimes travelling in support of DB2 can be a real pain
>
> I'm not after sympathy (I'd get none anyway, right?) but those of you
> who DO travel a lot can rest safe in the knowledge that I've used up
> quite a lot of our collective bad luck all in one go :)
>
> Have a safe and quiet weekend everyone
>
> Phil Grainger
> CA
> Product Management Director
> Phone: +44 (0)1753 577 733
> Mobile: +44 (0)7970 125 752
> eMail: [login to unmask email]
>
> Ditton Park
> Riding Court Road
> Datchet
> Slough
> SL3 9LL
>
> CA plc a company registered in England and Wales under company
> registration number 1282495 with its registered office at the address
> set out above. VAT number 697904179.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Bill Gannon
> Sent: 23 January 2008 12:43
> To: [login to unmask email]
> Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2
>
> Good morning Phil,
>
> Furthering on what James sent us - if you remove the /dsnsh0a2 portion
> of the URL, you will find yourself in a very large Bookshelf repository
> that has all the Softcopy documentation for DB2 z/OS from V2 through V9
> just do a "Find on this Page" and specify dsn .... Happy reading !!
>
>
> William B. Gannon
> - IBM Certified Solutions Expert
> - IBM Certified Database Administrator
> DB2 Universal Database V8.1 for zOS
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of [login to unmask email]
> Sent: Wednesday, January 23, 2008 6:02 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2
>
> V2.3. The "a" makes me think this was the first softcopy set
> http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0a2
>
> James Campbell
>
>
> On 22 Jan 2008 at 9:47, Grainger, Phil wrote:
>
>
>> OK, follow-on question
>>
>> Does anyone have softcopies of any of the Version 2 SQL Reference
>>
> manuals (bookmanager format probably)??
>
>>
>> I'm trying to remember "all" of the new stuff that came in V2.1, 2.2
>>
> and 2.3 and my long-term memory is failing me badly (with all the stuff
> IBM deliver these days, I have Gary Larssons "my brains full" moments
> now)
>
>>
>> Thanks to everyone for their help
>>
>> Phil Grainger
>> CA
>>
>>
>>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and
> Code Place, see the latest IDUG conference information, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on Member Services at http://www.idug.org/lsms
> -----------------------------------------
> Under Florida law, e-mail addresses are public records. If you do not
> want your e-mail address released in response to a public records
> request, do not send electronic mail to this entity.
> Instead, contact this office by phone or in writing.
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and
> Code Place, see the latest IDUG conference information, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
> archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site, you
> can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information, and much more. If you
> have not yet signed up for Basic Membership in IDUG, available at no cost,
> click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Rick Weaver

Re: [Friday] "The things we do for DB2"
(in response to William Favero)
I've been trying to hold back but just can't help myself. As Barney Bell
says, it's Friday!

Below are sanitized excerpts from an email chain I had with my
international travel coordinator a year or so ago. She was initially
skeptical, but by the end of the chain she was telling me to write a
book.

Start at the bottom (above Gerald's note) and work up.

Or don't.

Happy travels!!!!!!

Rick Weaver
DB2 z/OS Product Manager
BMC Software
==================

Another SC was flying nnn home to Houston and had to emergency land in
New Orleans. When you emergency land, they leave you out on the tarmac
and you have to walk across the runway to wherever they want you to go.
There's an airline employee standing out there to point you in the right
direction. In this case a 'red coat'. So she walked up to the red coat
and said 'I was in the plane that just emergency landed, where do I go?'
And the red coat said 'which one?'. Nnn had two emergency landings at
the same airport within minutes of each other.
Don't fly them much either.
==================

I've still got the flight ticket stub - nn4127, July 9 ORD - SBN. Don't
have the year on the stub but it must have been around 1994 to 1996.


Honest. Flight out of O'Hare bound for South Bend. One of the little
prop jobs, rear load door. Wouldn't seat on the ground, took several
tries. Even though it was a small plane, we had 2 flight attendants. The
one in the back was a trainee. I didn't see what happened, I was in row
2, but I speculate that shortly after take off (I'm talking like only a
minute or two - we were probably less than 1000 feet up), she noticed
the door rattling and got up to make sure it was locked ... and it came
off in her hands!!! All I heard was a whoosh, and she started screaming
'help me help me'. The supposedly senior attendant at the front of the
plane (across the aisle from me) got up and circled around three times,
then picked up the radio and contacted the pilot. There was only a
curtain between him and the passengers, and we all heard him yell 'I
KNOW!!!'. Then he turned steeply around (door side down!!) and went back
to O'Hare. I didn't get to South Bend until about 6am (by BUS!) and the
NTSB impounded our luggage (this was in about 1996 - WAY before 9/11
security concerns). My luggage showed up at 7:30am, and I made my 8am
call to a bank in a suit instead of jeans and t-shirt.
You can't make this stuff up.
==================

Did I tell you about the time the door came off of my airplane after
takeoff? Almost lost a flight attendant with that one. She broke an arm
and 3 guys had to go back and reel her in. took 4 days to find the door
(fell into a creek in a suburban neighborhood. Good thing it didn't land
on a house). That was the LAST time I ever flew nnn - they treated us
like dogs once we got back down.

======================
It'll be my first time. Last time I was in Asia (Shanghai), my cab got
broadsided. Both cars destroyed, my traveling partner broke a shoulder
in two places. I saw the other car coming and literally leapt across the
cab - I think I was airborne when he hit us and the cab just spun around
underneath me. I didn't even get bruised, and even made it to the
customer site in time to do my pitch.
Now that's taking one for the team!!
=======================

Hong Kong is one of my favorite cities. The lights at night at the
harbor are so beautiful...

===================

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Gerald Hodge
Sent: Friday, January 25, 2008 9:52 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [Friday] "The things we do for DB2"

Phil:

Travel is not luck it is misfortune. Your trip sounds like a normal
passage
from Houston to Chicago to catch a flight to the UK. I use Dallas or
Chicago as hubs because New York and Miami are competing to see who can
be
the most dysfunctional. I do about 100K on American Airlines and 20K to
30K
on others within Europe each year. When coming into the UK from the
continent or Ireland, I try to use London City as the Immigration and
Customs staffs are used to dealing with business people. Of course,
they
are now trying to close London City.

You do have my sympathy. Come by our booth at IDUG in Dallas and I'll
buy
you a drink. Perhaps we could form a club. I am told that is what
happens
when three or more Englishmen get together?

Gerald Hodge
HLS Technologies, Inc.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf
Of Grainger, Phil
Sent: Friday, January 25, 2008 7:39 AM
To: [login to unmask email]
Subject: [DB2-L] [Friday] "The things we do for DB2"

Or "Have a laugh at Phils expense"

I know that some of you really don't believe it when those of us lucky
enough to travel as part of our job tell you "It's really not that
exotic to fly around the world, you know"

Anyway, sometimes it really ISN'T so let me brighten up your Friday with
a sad tale of how things can go awry

Last weekend was the inaugural planning meeting for European IDUG 2008 -
held in Warsaw

Although I would normally avoid it like the plague, this time I was
forced to fly out of London Heathrow - last Thursday.... (the "Boeing
777 day"). Actually, I was rather surprised our flight left at all, so
being 4 hours late wasn't so bad.

Then I tried to get home again after the meeting.

First of all, our flight was delayed and then delayed a little further,
until around 10pm it was cancelled altogether. We were offered a hotel
room for the night, but the airline was shuttling people from the
airport to the hotel in blocks of 20 (small bus) - across the four
flights they cancelled, that amounted to around 400 people, so you can
do the maths and work out the queue length!

One sneaky cab ride later and I was in another queue to check in (behind
only around 80 people this time). Finally got to bet around 1am

Oh, and they wanted us BACK at the airport by 5am the next morning (I am
getting too old for missing my sleep).

So, back at Warsaw airport and checked in (again) for the flight,
through to the departure gate and as we were starting to board, they
discovered an unattended bag in the check-in area and evacuated the
airport - with around 50 people who should have been on our flight. Of
course, in Europe, if your BAG is on the plane but you AREN'T, then the
flight stays put. The airline decided that we'd wait for these people to
be un-evacuated and (90 minutes later) they rejoined us on the plane.

Ready to go?

Not a chance - still two more bags than people.

So all the bags off the plane and we each have to physically identify
our bags to be reloaded (and the suspect two taken away for
interrogation, I suppose)

FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
trip back to Heathrow

So you see - sometimes travelling in support of DB2 can be a real pain

I'm not after sympathy (I'd get none anyway, right?) but those of you
who DO travel a lot can rest safe in the knowledge that I've used up
quite a lot of our collective bad luck all in one go :)

Have a safe and quiet weekend everyone

Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bill Gannon
Sent: 23 January 2008 12:43
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

Good morning Phil,

Furthering on what James sent us - if you remove the /dsnsh0a2 portion
of the URL, you will find yourself in a very large Bookshelf repository
that has all the Softcopy documentation for DB2 z/OS from V2 through V9
just do a "Find on this Page" and specify dsn .... Happy reading !!


William B. Gannon
- IBM Certified Solutions Expert
- IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Wednesday, January 23, 2008 6:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2

V2.3. The "a" makes me think this was the first softcopy set
http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0a2

James Campbell


On 22 Jan 2008 at 9:47, Grainger, Phil wrote:

> OK, follow-on question
>
> Does anyone have softcopies of any of the Version 2 SQL Reference
manuals (bookmanager format probably)??
>
> I'm trying to remember "all" of the new stuff that came in V2.1, 2.2
and 2.3 and my long-term memory is failing me badly (with all the stuff
IBM deliver these days, I have Gary Larssons "my brains full" moments
now)
>
> Thanks to everyone for their help
>
> Phil Grainger
> CA
>
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms
-----------------------------------------
Under Florida law, e-mail addresses are public records. If you do not
want your e-mail address released in response to a public records
request, do not send electronic mail to this entity.
Instead, contact this office by phone or in writing.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list
archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much more. If
you
have not yet signed up for Basic Membership in IDUG, available at no
cost,
click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

William Favero

Re: [Friday] "The things we do for DB2"
(in response to Rick Weaver)
I was still working with when you had the door come off.... quite the
topic of discussion around the coffee pot... the luggage part sucks.
We had all the tires blow out on a similar aircraft with that same
airline landing in St Louis. It took them over an hour to get the
handful of us off the plane. I do have to say the pilot made a
terrific landing that day.... he kept the plane on the runway....

It's definitely Friday.. LOL

Willie


Weaver, Rick wrote:
> I've been trying to hold back but just can't help myself. As Barney Bell
> says, it's Friday!
>
> Below are sanitized excerpts from an email chain I had with my
> international travel coordinator a year or so ago. She was initially
> skeptical, but by the end of the chain she was telling me to write a
> book.
>
> Start at the bottom (above Gerald's note) and work up.
>
> Or don't.
>
> Happy travels!!!!!!
>
> Rick Weaver
> DB2 z/OS Product Manager
> BMC Software
> ==================
>
> Another SC was flying nnn home to Houston and had to emergency land in
> New Orleans. When you emergency land, they leave you out on the tarmac
> and you have to walk across the runway to wherever they want you to go.
> There's an airline employee standing out there to point you in the right
> direction. In this case a 'red coat'. So she walked up to the red coat
> and said 'I was in the plane that just emergency landed, where do I go?'
> And the red coat said 'which one?'. Nnn had two emergency landings at
> the same airport within minutes of each other.
> Don't fly them much either.
> ==================
>
> I've still got the flight ticket stub - nn4127, July 9 ORD - SBN. Don't
> have the year on the stub but it must have been around 1994 to 1996.
>
>
> Honest. Flight out of O'Hare bound for South Bend. One of the little
> prop jobs, rear load door. Wouldn't seat on the ground, took several
> tries. Even though it was a small plane, we had 2 flight attendants. The
> one in the back was a trainee. I didn't see what happened, I was in row
> 2, but I speculate that shortly after take off (I'm talking like only a
> minute or two - we were probably less than 1000 feet up), she noticed
> the door rattling and got up to make sure it was locked ... and it came
> off in her hands!!! All I heard was a whoosh, and she started screaming
> 'help me help me'. The supposedly senior attendant at the front of the
> plane (across the aisle from me) got up and circled around three times,
> then picked up the radio and contacted the pilot. There was only a
> curtain between him and the passengers, and we all heard him yell 'I
> KNOW!!!'. Then he turned steeply around (door side down!!) and went back
> to O'Hare. I didn't get to South Bend until about 6am (by BUS!) and the
> NTSB impounded our luggage (this was in about 1996 - WAY before 9/11
> security concerns). My luggage showed up at 7:30am, and I made my 8am
> call to a bank in a suit instead of jeans and t-shirt.
> You can't make this stuff up.
> ==================
>
> Did I tell you about the time the door came off of my airplane after
> takeoff? Almost lost a flight attendant with that one. She broke an arm
> and 3 guys had to go back and reel her in. took 4 days to find the door
> (fell into a creek in a suburban neighborhood. Good thing it didn't land
> on a house). That was the LAST time I ever flew nnn - they treated us
> like dogs once we got back down.
>
> ======================
> It'll be my first time. Last time I was in Asia (Shanghai), my cab got
> broadsided. Both cars destroyed, my traveling partner broke a shoulder
> in two places. I saw the other car coming and literally leapt across the
> cab - I think I was airborne when he hit us and the cab just spun around
> underneath me. I didn't even get bruised, and even made it to the
> customer site in time to do my pitch.
> Now that's taking one for the team!!
> =======================
>
> Hong Kong is one of my favorite cities. The lights at night at the
> harbor are so beautiful...
>
> ===================
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Gerald Hodge
> Sent: Friday, January 25, 2008 9:52 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [Friday] "The things we do for DB2"
>
> Phil:
>
> Travel is not luck it is misfortune. Your trip sounds like a normal
> passage
> from Houston to Chicago to catch a flight to the UK. I use Dallas or
> Chicago as hubs because New York and Miami are competing to see who can
> be
> the most dysfunctional. I do about 100K on American Airlines and 20K to
> 30K
> on others within Europe each year. When coming into the UK from the
> continent or Ireland, I try to use London City as the Immigration and
> Customs staffs are used to dealing with business people. Of course,
> they
> are now trying to close London City.
>
> You do have my sympathy. Come by our booth at IDUG in Dallas and I'll
> buy
> you a drink. Perhaps we could form a club. I am told that is what
> happens
> when three or more Englishmen get together?
>
> Gerald Hodge
> HLS Technologies, Inc.
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf
> Of Grainger, Phil
> Sent: Friday, January 25, 2008 7:39 AM
> To: [login to unmask email]
> Subject: [DB2-L] [Friday] "The things we do for DB2"
>
> Or "Have a laugh at Phils expense"
>
> I know that some of you really don't believe it when those of us lucky
> enough to travel as part of our job tell you "It's really not that
> exotic to fly around the world, you know"
>
> Anyway, sometimes it really ISN'T so let me brighten up your Friday with
> a sad tale of how things can go awry
>
> Last weekend was the inaugural planning meeting for European IDUG 2008 -
> held in Warsaw
>
> Although I would normally avoid it like the plague, this time I was
> forced to fly out of London Heathrow - last Thursday.... (the "Boeing
> 777 day"). Actually, I was rather surprised our flight left at all, so
> being 4 hours late wasn't so bad.
>
> Then I tried to get home again after the meeting.
>
> First of all, our flight was delayed and then delayed a little further,
> until around 10pm it was cancelled altogether. We were offered a hotel
> room for the night, but the airline was shuttling people from the
> airport to the hotel in blocks of 20 (small bus) - across the four
> flights they cancelled, that amounted to around 400 people, so you can
> do the maths and work out the queue length!
>
> One sneaky cab ride later and I was in another queue to check in (behind
> only around 80 people this time). Finally got to bet around 1am
>
> Oh, and they wanted us BACK at the airport by 5am the next morning (I am
> getting too old for missing my sleep).
>
> So, back at Warsaw airport and checked in (again) for the flight,
> through to the departure gate and as we were starting to board, they
> discovered an unattended bag in the check-in area and evacuated the
> airport - with around 50 people who should have been on our flight. Of
> course, in Europe, if your BAG is on the plane but you AREN'T, then the
> flight stays put. The airline decided that we'd wait for these people to
> be un-evacuated and (90 minutes later) they rejoined us on the plane.
>
> Ready to go?
>
> Not a chance - still two more bags than people.
>
> So all the bags off the plane and we each have to physically identify
> our bags to be reloaded (and the suspect two taken away for
> interrogation, I suppose)
>
> FINALLY, our 8.05pm flight left at 9.30am for a (luckily) uneventful
> trip back to Heathrow
>
> So you see - sometimes travelling in support of DB2 can be a real pain
>
> I'm not after sympathy (I'd get none anyway, right?) but those of you
> who DO travel a lot can rest safe in the knowledge that I've used up
> quite a lot of our collective bad luck all in one go :)
>
> Have a safe and quiet weekend everyone
>
> Phil Grainger
> CA
> Product Management Director
> Phone: +44 (0)1753 577 733
> Mobile: +44 (0)7970 125 752
> eMail: [login to unmask email]
>
> Ditton Park
> Riding Court Road
> Datchet
> Slough
> SL3 9LL
>
> CA plc a company registered in England and Wales under company
> registration number 1282495 with its registered office at the address
> set out above. VAT number 697904179.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Bill Gannon
> Sent: 23 January 2008 12:43
> To: [login to unmask email]
> Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2
>
> Good morning Phil,
>
> Furthering on what James sent us - if you remove the /dsnsh0a2 portion
> of the URL, you will find yourself in a very large Bookshelf repository
> that has all the Softcopy documentation for DB2 z/OS from V2 through V9
> just do a "Find on this Page" and specify dsn .... Happy reading !!
>
>
> William B. Gannon
> - IBM Certified Solutions Expert
> - IBM Certified Database Administrator
> DB2 Universal Database V8.1 for zOS
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of [login to unmask email]
> Sent: Wednesday, January 23, 2008 6:02 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [z/OS] GA dates of old(er) versions of DB2
>
> V2.3. The "a" makes me think this was the first softcopy set
> http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0a2
>
> James Campbell
>
>
> On 22 Jan 2008 at 9:47, Grainger, Phil wrote:
>
>
>> OK, follow-on question
>>
>> Does anyone have softcopies of any of the Version 2 SQL Reference
>>
> manuals (bookmanager format probably)??
>
>>
>> I'm trying to remember "all" of the new stuff that came in V2.1, 2.2
>>
> and 2.3 and my long-term memory is failing me badly (with all the stuff
> IBM deliver these days, I have Gary Larssons "my brains full" moments
> now)
>
>>
>> Thanks to everyone for their help
>>
>> Phil Grainger
>> CA
>>
>>
>>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and
> Code Place, see the latest IDUG conference information, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on Member Services at http://www.idug.org/lsms
> -----------------------------------------
> Under Florida law, e-mail addresses are public records. If you do not
> want your e-mail address released in response to a public records
> request, do not send electronic mail to this entity.
> Instead, contact this office by phone or in writing.
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and
> Code Place, see the latest IDUG conference information, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list
> archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you
> can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information, and much more. If
> you
> have not yet signed up for Basic Membership in IDUG, available at no
> cost,
> click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and
> Code Place, see the latest IDUG conference information, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Gerald Hodge

Re: [Friday] "The things we do for DB2"
(in response to William Favero)
Willie:

We can definitely talk in Dallas, and the drink offer is extended to you.
We are at the back behind BMC and next to the refreshments. "Road Warrior"
sounds too Mel Gibson for me, but I am sure we can come up with something.

"Vive la mort, vive la guerre, vive le sacré mercenaire!"

Gerald Hodge
HLS Technologies, Inc.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Willie Favero
Sent: Friday, January 25, 2008 10:34 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [Friday] "The things we do for DB2"

Hey Gerry

We could make "DB2 Road Warrior" buttons for all of the club members.

BTW, I am no longer in the sales job at IBM. With SVL now doing data
warehouse. We'll need to talk in Dallas... LOL

Willie

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

William Favero

Re: [Friday] "The things we do for DB2"
(in response to Gerald Hodge)
We are a bit like "mercenaries" sometimes.... LOL

Willie

Gerald Hodge wrote:
> Willie:
>
> We can definitely talk in Dallas, and the drink offer is extended to you.
> We are at the back behind BMC and next to the refreshments. "Road Warrior"
> sounds too Mel Gibson for me, but I am sure we can come up with something.
>
> "Vive la mort, vive la guerre, vive le sacré mercenaire!"
>
> Gerald Hodge
> HLS Technologies, Inc.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
> Of Willie Favero
> Sent: Friday, January 25, 2008 10:34 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [Friday] "The things we do for DB2"
>
> Hey Gerry
>
> We could make "DB2 Road Warrior" buttons for all of the club members.
>
> BTW, I am no longer in the sales job at IBM. With SVL now doing data
> warehouse. We'll need to talk in Dallas... LOL
>
> Willie
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Troy Coleman

Re: [Friday] "The things we do for DB2"
(in response to William Favero)
Hi Gerald,
Need a Klingon name... :-)

Troy

Gerald Hodge wrote:
> Willie:
>
> We can definitely talk in Dallas, and the drink offer is extended to you.
> We are at the back behind BMC and next to the refreshments. "Road Warrior"
> sounds too Mel Gibson for me, but I am sure we can come up with something.
>
> "Vive la mort, vive la guerre, vive le sacré mercenaire!"
>
> Gerald Hodge
> HLS Technologies, Inc.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
> Of Willie Favero
> Sent: Friday, January 25, 2008 10:34 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [Friday] "The things we do for DB2"
>
> Hey Gerry
>
> We could make "DB2 Road Warrior" buttons for all of the club members.
>
> BTW, I am no longer in the sales job at IBM. With SVL now doing data
> warehouse. We'll need to talk in Dallas... LOL
>
> Willie
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Gerald Hodge

Re: [Friday] "The things we do for DB2"
(in response to Troy Coleman)
Klingon is so last century, Troy. But I'll ask our internal Klingon expert.
Churchill said that German was an excuse for spitting on others during
discourse. Since I anticipate Germen members, I believe that obviates the
need for Klingon.

GSH

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Troy Coleman
Sent: Friday, January 25, 2008 2:00 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Friday] "The things we do for DB2"

Hi Gerald,
Need a Klingon name... :-)

Troy

Gerald Hodge wrote:
> Willie:
>
> We can definitely talk in Dallas, and the drink offer is extended to you.
> We are at the back behind BMC and next to the refreshments. "Road Warrior"
> sounds too Mel Gibson for me, but I am sure we can come up with something.

>
> "Vive la mort, vive la guerre, vive le sacré mercenaire!"
>
> Gerald Hodge
> HLS Technologies, Inc.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
> Of Willie Favero
> Sent: Friday, January 25, 2008 10:34 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [Friday] "The things we do for DB2"
>
> Hey Gerry
>
> We could make "DB2 Road Warrior" buttons for all of the club members.
>
> BTW, I am no longer in the sales job at IBM. With SVL now doing data
> warehouse. We'll need to talk in Dallas... LOL
>
> Willie
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site, you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much more. If you
have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services at http://www.idug.org/lsms
>
>
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site, you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much more. If you
have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Troy Coleman

Re: [Friday] "The things we do for DB2"
(in response to Gerald Hodge)
LOL... I figured you would come up with something good :-)


Gerald Hodge wrote:
> Klingon is so last century, Troy. But I'll ask our internal Klingon expert.
> Churchill said that German was an excuse for spitting on others during
> discourse. Since I anticipate Germen members, I believe that obviates the
> need for Klingon.
>
> GSH
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
> Of Troy Coleman
> Sent: Friday, January 25, 2008 2:00 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] [Friday] "The things we do for DB2"
>
> Hi Gerald,
> Need a Klingon name... :-)
>
> Troy
>
> Gerald Hodge wrote:
>
>> Willie:
>>
>> We can definitely talk in Dallas, and the drink offer is extended to you.
>> We are at the back behind BMC and next to the refreshments. "Road Warrior"
>> sounds too Mel Gibson for me, but I am sure we can come up with something.
>>
>
>
>> "Vive la mort, vive la guerre, vive le sacré mercenaire!"
>>
>> Gerald Hodge
>> HLS Technologies, Inc.
>>
>>
>>
>> -----Original Message-----
>> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
>> Of Willie Favero
>> Sent: Friday, January 25, 2008 10:34 AM
>> To: [login to unmask email]
>> Subject: Re: [DB2-L] [Friday] "The things we do for DB2"
>>
>> Hey Gerry
>>
>> We could make "DB2 Road Warrior" buttons for all of the club members.
>>
>> BTW, I am no longer in the sales job at IBM. With SVL now doing data
>> warehouse. We'll need to talk in Dallas... LOL
>>
>> Willie
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
>>
> list archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site, you
> can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information, and much more. If you
> have not yet signed up for Basic Membership in IDUG, available at no cost,
> click on Member Services at http://www.idug.org/lsms
>
>>
>>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
> archives, the FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site, you
> can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information, and much more. If you
> have not yet signed up for Basic Membership in IDUG, available at no cost,
> click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms