PLAN_TABLE evolvement

Steen Rasmussen

PLAN_TABLE evolvement
I am trying to find out when the EXPLAIN function was invented.

Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.

Looking into V2R3 I can see 30 columns.



Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got introduced
?



Steen Rasmussen
CA

Principal Technical Specialist DB2 tools

IBM Certified Database Associate -- DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS

Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)

Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]
< http://www.ca.com >


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< 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
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < 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

Mike Kalena

Re: PLAN_TABLE evolvement
(in response to Steen Rasmussen)
The IBM Admin Guide shows it had a 28 column format and 25 column
format:



http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh16/5.10.1.1?SH
ELF=&DT=20061206092512&CASE=



Hope this helps.





Michael Kalena
973-793-2133
[login to unmask email]



DB2 Info Page at BSC < http://whsysops1/db2/ >

(http://whsysops1/db2/ < http://whsysops1/db2/ > )



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Rasmussen, Steen
Sent: Thursday, January 24, 2008 5:59 PM
To: [login to unmask email]
Subject: [DB2-L] PLAN_TABLE evolvement



I am trying to find out when the EXPLAIN function was invented.

Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.

Looking into V2R3 I can see 30 columns.



Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got introduced
?



Steen Rasmussen
CA

Principal Technical Specialist DB2 tools

IBM Certified Database Associate -- DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS

Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)

Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]
< http://www.ca.com >


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< 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
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < 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 www.idug.org
< 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
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < 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: PLAN_TABLE evolvement
(in response to Mike Kalena)
EXPLAIN was introduced to DB2 almost at the beginning of DB2's life...
Version 1.2.......

Willie

Rasmussen, Steen wrote:
>
> I am trying to find out when the EXPLAIN function was invented.
>
> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>
> Looking into V2R3 I can see 30 columns.
>
>
>
> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
> introduced ?
>
>
>
> *Steen Rasmussen*
> CA
>
> Principal Technical Specialist DB2 tools
>
> IBM Certified Database Associate -- DB2 9 Fundamentals
>
> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>
> Tel : +1-630-505-6673 (US direct)
> Tel : +1-815-274-9589 (US mobile)
>
> Tel : +45-22 15 44 98 (Europe mobile)
> [login to unmask email]
> <mailto:[login to unmask email]> < http://www.ca.com >
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at _ www.idug.org
> < 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
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 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 _ www.idug.org
> < 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
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 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

Mike Bell

Re: PLAN_TABLE evolvement
(in response to William Favero)
Easy to tell, it has a column called timestamp that isn't in timestamp data
type. Timestamp data type showed up in 1.3 with all the other date and time
functions.

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Willie Favero
Sent: Thursday, January 24, 2008 5:33 PM
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

EXPLAIN was introduced to DB2 almost at the beginning of DB2's life...
Version 1.2.......

Willie

Rasmussen, Steen wrote:
>
> I am trying to find out when the EXPLAIN function was invented.
>
> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>
> Looking into V2R3 I can see 30 columns.
>
>
>
> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
> introduced ?
>
>
>
> *Steen Rasmussen*
> CA
>
> Principal Technical Specialist DB2 tools
>
> IBM Certified Database Associate -- DB2 9 Fundamentals
>
> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>
> Tel : +1-630-505-6673 (US direct)
> Tel : +1-815-274-9589 (US mobile)
>
> Tel : +45-22 15 44 98 (Europe mobile)
> [login to unmask email]
> <mailto:[login to unmask email]> < http://www.ca.com >
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at _ www.idug.org
> < 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
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 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 _ www.idug.org
> < 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
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 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

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: PLAN_TABLE evolvement
(in response to Mike Bell)
Hi Steen,
Seems like your going to have a nice DB2 trivia guide when your done :-)
Would make a nice trivial pursuit game edition.

Troy


Rasmussen, Steen wrote:
>
> I am trying to find out when the EXPLAIN function was invented.
>
> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>
> Looking into V2R3 I can see 30 columns.
>
>
>
> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
> introduced ?
>
>
>
> *Steen Rasmussen*
> CA
>
> Principal Technical Specialist DB2 tools
>
> IBM Certified Database Associate -- DB2 9 Fundamentals
>
> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>
> Tel : +1-630-505-6673 (US direct)
> Tel : +1-815-274-9589 (US mobile)
>
> Tel : +45-22 15 44 98 (Europe mobile)
> [login to unmask email]
> <mailto:[login to unmask email]> < http://www.ca.com >
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at _ www.idug.org
> < 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
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 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 _ www.idug.org
> < 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
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 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: PLAN_TABLE evolvement
(in response to Troy Coleman)
I think I have a set of DB2 trivia playing cards that a "vendor" gave
out many, many years ago.. Now if I could only find them....

Willie

Troy Coleman wrote:
> Hi Steen,
> Seems like your going to have a nice DB2 trivia guide when your done :-)
> Would make a nice trivial pursuit game edition.
>
> Troy
>
>
> Rasmussen, Steen wrote:
>>
>> I am trying to find out when the EXPLAIN function was invented.
>>
>> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>>
>> Looking into V2R3 I can see 30 columns.
>>
>>
>>
>> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
>> introduced ?
>>
>>
>>
>> *Steen Rasmussen*
>> CA
>>
>> Principal Technical Specialist DB2 tools
>>
>> IBM Certified Database Associate -- DB2 9 Fundamentals
>>
>> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>>
>> Tel : +1-630-505-6673 (US direct)
>> Tel : +1-815-274-9589 (US mobile)
>>
>> Tel : +45-22 15 44 98 (Europe mobile)
>> [login to unmask email]
>> <mailto:[login to unmask email]> < http://www.ca.com >
>>
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG.
>> DB2-L list archives, the FAQ, and delivery preferences are at _
>> www.idug.org < 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 <%20 http://www.idug.org/lsconf > _, and much more.
>> If you have not yet signed up for Basic Membership in IDUG, available
>> at no cost, click on _ Member Services <%20 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 _
>> www.idug.org < 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 <%20 http://www.idug.org/lsconf > _, and much more.
>> If you have not yet signed up for Basic Membership in IDUG, available
>> at no cost, click on _ Member Services <%20 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

Raymond Bell

Re: PLAN_TABLE evolvement
(in response to William Favero)
Willie, I might remember what you're talking about. Many, many moons
ago during my first 'gig' as a DB2 DBA in New Zealand, a vendor (one
near and dear to my heart if you catch my drift) handed out some
multi-guess DB2 trivia cards. You were supposed to get someone to
verify how many correct answers you got, send your results to 'The Best
Little Software House in Texas' and they'd send you a 'degree'. I've
still got tucked away in the darkest recesses of my CV my 'Batchelor of
DB2' degree from the 'University of BMC'. Don't know if it ever
encouraged anyone to hire me though. Still, it was fun.

Oh, hey, and it's Friday too. You'd never have guessed...

Cheers,


Raymond
PS. I don't have the cards unfortunately. Could probably make a
fortune selling them on eBay.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Willie Favero
Sent: 25 January 2008 04:43
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

I think I have a set of DB2 trivia playing cards that a "vendor" gave
out many, many years ago.. Now if I could only find them....

Willie

Troy Coleman wrote:
> Hi Steen,
> Seems like your going to have a nice DB2 trivia guide when your done
:-)
> Would make a nice trivial pursuit game edition.
>
> Troy
>
>
> Rasmussen, Steen wrote:
>>
>> I am trying to find out when the EXPLAIN function was invented.
>>
>> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>>
>> Looking into V2R3 I can see 30 columns.
>>
>>
>>
>> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
>> introduced ?
>>
>>
>>
>> *Steen Rasmussen*
>> CA
>>
>> Principal Technical Specialist DB2 tools
>>
>> IBM Certified Database Associate -- DB2 9 Fundamentals
>>
>> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>>
>> Tel : +1-630-505-6673 (US direct)
>> Tel : +1-815-274-9589 (US mobile)
>>
>> Tel : +45-22 15 44 98 (Europe mobile)
>> [login to unmask email]
>> <mailto:[login to unmask email]> < http://www.ca.com >
>>

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

Barbara Koenen

Re: PLAN_TABLE evolvement
(in response to Raymond Bell)
DB2 Pursuit. The deck is sitting in the back of my desk drawer.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bell, Raymond
Sent: Friday, January 25, 2008 2:21 AM
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

Willie, I might remember what you're talking about. Many, many moons
ago during my first 'gig' as a DB2 DBA in New Zealand, a vendor (one
near and dear to my heart if you catch my drift) handed out some
multi-guess DB2 trivia cards. You were supposed to get someone to
verify how many correct answers you got, send your results to 'The Best
Little Software House in Texas' and they'd send you a 'degree'. I've
still got tucked away in the darkest recesses of my CV my 'Batchelor of
DB2' degree from the 'University of BMC'. Don't know if it ever
encouraged anyone to hire me though. Still, it was fun.

Oh, hey, and it's Friday too. You'd never have guessed...

Cheers,


Raymond
PS. I don't have the cards unfortunately. Could probably make a
fortune selling them on eBay.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Willie Favero
Sent: 25 January 2008 04:43
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

I think I have a set of DB2 trivia playing cards that a "vendor" gave
out many, many years ago.. Now if I could only find them....

Willie

Troy Coleman wrote:
> Hi Steen,
> Seems like your going to have a nice DB2 trivia guide when your done
:-)
> Would make a nice trivial pursuit game edition.
>
> Troy
>
>
> Rasmussen, Steen wrote:
>>
>> I am trying to find out when the EXPLAIN function was invented.
>>
>> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>>
>> Looking into V2R3 I can see 30 columns.
>>
>>
>>
>> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
>> introduced ?
>>
>>
>>
>> *Steen Rasmussen*
>> CA
>>
>> Principal Technical Specialist DB2 tools
>>
>> IBM Certified Database Associate -- DB2 9 Fundamentals
>>
>> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>>
>> Tel : +1-630-505-6673 (US direct)
>> Tel : +1-815-274-9589 (US mobile)
>>
>> Tel : +45-22 15 44 98 (Europe mobile)
>> [login to unmask email]
>> <mailto:[login to unmask email]> < http://www.ca.com >
>>

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

Raymond Bell

Re: PLAN_TABLE evolvement
(in response to Barbara Koenen)
Bingo! That's the one! Might see if I can scan my diploma and post it
to the Code Place...

Cheers,


Raymond

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Barbara Koenen
Sent: 25 January 2008 12:28
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

DB2 Pursuit. The deck is sitting in the back of my desk drawer.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bell, Raymond
Sent: Friday, January 25, 2008 2:21 AM
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

Willie, I might remember what you're talking about. Many, many moons
ago during my first 'gig' as a DB2 DBA in New Zealand, a vendor (one
near and dear to my heart if you catch my drift) handed out some
multi-guess DB2 trivia cards. You were supposed to get someone to
verify how many correct answers you got, send your results to 'The Best
Little Software House in Texas' and they'd send you a 'degree'. I've
still got tucked away in the darkest recesses of my CV my 'Batchelor of
DB2' degree from the 'University of BMC'. Don't know if it ever
encouraged anyone to hire me though. Still, it was fun.

Oh, hey, and it's Friday too. You'd never have guessed...

Cheers,


Raymond
PS. I don't have the cards unfortunately. Could probably make a
fortune selling them on eBay.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Willie Favero
Sent: 25 January 2008 04:43
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

I think I have a set of DB2 trivia playing cards that a "vendor" gave
out many, many years ago.. Now if I could only find them....

Willie

Troy Coleman wrote:
> Hi Steen,
> Seems like your going to have a nice DB2 trivia guide when your done
:-)
> Would make a nice trivial pursuit game edition.
>
> Troy
>
>
> Rasmussen, Steen wrote:
>>
>> I am trying to find out when the EXPLAIN function was invented.
>>
>> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>>
>> Looking into V2R3 I can see 30 columns.
>>
>>
>>
>> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
>> introduced ?
>>
>>
>>
>> *Steen Rasmussen*
>> CA
>>
>> Principal Technical Specialist DB2 tools
>>
>> IBM Certified Database Associate -- DB2 9 Fundamentals
>>
>> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>>
>> Tel : +1-630-505-6673 (US direct)
>> Tel : +1-815-274-9589 (US mobile)
>>
>> Tel : +45-22 15 44 98 (Europe mobile)
>> [login to unmask email]
>> <mailto:[login to unmask email]> < http://www.ca.com >
>>

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

Steen Rasmussen

Re: PLAN_TABLE evolvement
(in response to Raymond Bell)
That would be so neat Willie (please share) - perhaps we all can team up
in Dallas for a Trivia game (and a couple of beers) :-)

Steen Rasmussen
CA
Principal Technical Specialist DB2 tools
IBM Certified Database Associate -- DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 DBA for z/OS
Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)
Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Willie Favero
Sent: Thursday, January 24, 2008 10:43 PM
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

I think I have a set of DB2 trivia playing cards that a "vendor" gave
out many, many years ago.. Now if I could only find them....

Willie

Troy Coleman wrote:
> Hi Steen,
> Seems like your going to have a nice DB2 trivia guide when your done
:-)
> Would make a nice trivial pursuit game edition.
>
> Troy
>
>
> Rasmussen, Steen wrote:
>>
>> I am trying to find out when the EXPLAIN function was invented.
>>
>> Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.
>>
>> Looking into V2R3 I can see 30 columns.
>>
>>
>>
>> Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got
>> introduced ?
>>
>>
>>
>> *Steen Rasmussen*
>> CA
>>
>> Principal Technical Specialist DB2 tools
>>
>> IBM Certified Database Associate -- DB2 9 Fundamentals
>>
>> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>>
>> Tel : +1-630-505-6673 (US direct)
>> Tel : +1-815-274-9589 (US mobile)
>>
>> Tel : +45-22 15 44 98 (Europe mobile)
>> [login to unmask email]
>> <mailto:[login to unmask email]> < http://www.ca.com >
>>
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG.
>> DB2-L list archives, the FAQ, and delivery preferences are at _
>> www.idug.org < 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 <%20 http://www.idug.org/lsconf > _, and much more.
>> If you have not yet signed up for Basic Membership in IDUG, available

>> at no cost, click on _ Member Services <%20 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 _
>> www.idug.org < 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 <%20 http://www.idug.org/lsconf > _, and much more.
>> If you have not yet signed up for Basic Membership in IDUG, available

>> at no cost, click on _ Member Services <%20 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

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

Mark Ediger

Re: PLAN_TABLE evolvement
(in response to Steen Rasmussen)
Hi Steen,

I can tell you that SQL/DS for DOS/VSE V1 had EXPLAIN in it in 1982.
That's when the company I worked for had just put in a production SQL/DS
application that buried the processor that was supposed to last another
18 months. EXPLAIN helped us tune the sql statements and lower the cpu
utilization. Then, in 1983, when we converted to MVS with the Early
Ship program of DB2 for MVS V1 we were alarmed to find EXPLAIN was not
available. Of course, neither was the EXEC SQL CONNECT statement so our
application plan was larger than the amount of real memory available.
EXPLAIN then was added in V1.2 as I recall, to our relief.

Mark Ediger



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Rasmussen, Steen
Sent: Thursday, January 24, 2008 4:59 PM
To: [login to unmask email]
Subject: [DB2-L] PLAN_TABLE evolvement

I am trying to find out when the EXPLAIN function was invented.

Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.

Looking into V2R3 I can see 30 columns.



Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got introduced
?



Steen Rasmussen
CA

Principal Technical Specialist DB2 tools

IBM Certified Database Associate -- DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS

Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)

Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]
< http://www.ca.com >


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< 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
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < 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 www.idug.org
< 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
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >
***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
****************************************************************************

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

Isaac Yassin

Re: PLAN_TABLE evolvement
(in response to Mark Ediger)
Hi Steen,



AFAIK it was on 1.2



Isaac Yassin

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Rasmussen, Steen
Sent: Friday, January 25, 2008 12:59 AM
To: [login to unmask email]
Subject: [DB2-L] PLAN_TABLE evolvement



I am trying to find out when the EXPLAIN function was invented.

Looking into my DB2 V1R1M0 DB2 reference Guide there was no explain.

Looking into V2R3 I can see 30 columns.



Any idea which DB2 version/release EXPLAIN and PLAN_TABLE got introduced ?



Steen Rasmussen
CA

Principal Technical Specialist DB2 tools

IBM Certified Database Associate -- DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS

Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)

Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]
< http://www.ca.com/ > cid:[login to unmask email]


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org < 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
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org < 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



_____

I am using the free version of SPAMfighter for private users.
It has removed 1952 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter < http://www.spamfighter.com/len > for free now!


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

Steen Rasmussen

Re: PLAN_TABLE evolvement
(in response to Isaac Yassin)
Thank you everybody for a load of great information - it was really
helpful.


Steen Rasmussen
CA
Principal Technical Specialist DB2 tools
IBM Certified Database Associate -- DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 DBA for z/OS
Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)
Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Ediger Mark - medige
Sent: Friday, January 25, 2008 9:20 AM
To: [login to unmask email]
Subject: Re: [DB2-L] PLAN_TABLE evolvement

Hi Steen,

I can tell you that SQL/DS for DOS/VSE V1 had EXPLAIN in it in 1982.
That's when the company I worked for had just put in a production SQL/DS
application that buried the processor that was supposed to last another
18 months. EXPLAIN helped us tune the sql statements and lower the cpu
utilization. Then, in 1983, when we converted to MVS with the Early
Ship program of DB2 for MVS V1 we were alarmed to find EXPLAIN was not
available. Of course, neither was the EXEC SQL CONNECT statement so our
application plan was larger than the amount of real memory available.
EXPLAIN then was added in V1.2 as I recall, to our relief.

Mark Ediger

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