Re: [z/OS V9] Default Behavior when no CLUSTER index exists?

Adam Baldwin

Re: [z/OS V9] Default Behavior when no CLUSTER index exists?
(in response to Roger Hecq)
...didn't the way that Reorg handles an implicit clustering index change once
before...back in V4 / V5 days?? I no longer have the manuals and my
memory isn't what it was. It's not even friday and I can't remember
wednesday.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Georg Peter

[DB2-L] [z/OS V9] Default Behavior when no CLUSTER index exists?
>> My memory isn't what it was. <<<

Adam, you are not alone ;-))

SCNR.

Cheers, G e o r g
----------------------------------------------------------------------

-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Adam Baldwin
Gesendet: Donnerstag, 5. November 2009 16:07
An: [login to unmask email]
Betreff: Re: [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index exists?


Didn't the way that reorg handles an implicit clustering index change once
before back in V4 / V5 days? My memory isn't what it was. It's not even friday
and I can't remember wednesday.

Cheers, Adam

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L


Abonnieren Sie unseren Infobrief und erfahren Sie regelmäßig die neuesten Nachrichten über unsere Lösungen, aktuellen Projekte und Entwicklungen. Melden sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief
_______________________________________________________________________________

Datenzentrale Baden-Württemberg, Anstalt des öffentlichen Rechts
Krailenshaldenstr. 44, 70469 Stuttgart
Telefon (0711) 8108-0, Telefax (0711) 8108-350
E-Mail [login to unmask email], Internet www.datenzentrale.de
Vorstand: Karl Tramer (Vors.) und Harald Schätzle, Vorsitzender des Verwaltungsrats: Gunter Czisch
USt-Id-Nr. DE147794223
_______________________________________________________________________________

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Roger Hecq

Re: [z/OS V9] Default Behavior when no CLUSTER index exists?
(in response to Georg Peter)
Interesting article on CNN re causes of sudden short term memory loss.

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

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Adam Baldwin
Sent: Thursday, November 05, 2009 10:07 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index
exists?

Didn't the way that reorg handles an implicit clustering index change
once before back in V4 / V5 days? My memory isn't what it was. It's not
even friday and I can't remember wednesday.

Cheers, Adam

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User
Groups, there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User
Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L
Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.


UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Bala

Re: [z/OS V9] Default Behavior when no CLUSTER index exists?
(in response to Adam Baldwin)
YES, the behaviour in discussion was implemented in v8. But, is this
available in CM or only in NFM ? Anybody has experience taking advantage of
this while in v8 CM itself ? we have got some hundreds of tables having
implicit clustering index and reorgs are not doing the re-ordering. SQLs are
suffering because of it. I don't have time to change those primary indexes
into clustering while in DB2 v8 CM.

Thanks!

On Thu, Nov 5, 2009 at 12:05 PM, Peter Backlund <[login to unmask email]>wrote:

> Actually, the change to reorg was implemented already in DB2 V8
>
> Peter
>
> Rasmussen, Steen wrote:
>
> Correct Rick – the first index defined becomes the clustering until an
> explicit one is created.
>
> What changed in DB2 V9 was, that reorg now honors this implicit created
> clustering – so data will be organized according to this one. In the past
> reorganizing a tablespace without an explicitly created clustering index –
> only freespace was reclaimed, the data remained in the same order.
>
>
>
> *Steen Rasmussen*
> CA
>
> Sr Engineering Services Architect
>
> IBM Certified Database Associate - DB2 9 Fundamentals
>
> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>
>
>
> *From:* IDUG DB2-L [mailto:[login to unmask email] <[login to unmask email]>] *On
> Behalf Of *Weaver, Rick
> *Sent:* Wednesday, November 04, 2009 4:43 PM
> *To:* [login to unmask email]
> *Subject:* Re: [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index
> exists?
>
>
>
> If memory serves, the first index defined becomes the clustering index if
> no index has CLUSTER defined.
>
>
>
> There, I just used index, cluster, and defined twice each in the same
> sentence and it's not even Friday.
>
>
>
> Rick Weaver
> Product Manager
> DB2 z/OS Solutions
> BMC Software
>
>
>
>
> ------------------------------
>
> *From:* IDUG DB2-L [mailto:[login to unmask email] <[login to unmask email]>] *On
> Behalf Of *Sevetson, Phil
> *Sent:* Wednesday, November 04, 2009 3:47 PM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index
> exists?
>
> I have a segmented tablespace in production. It has no index defined with
> CLUSTER. Can anyone point me to documentation of the behavior of an INSERT
> statement on this table? (My understanding is that the oldest, or lowest
> OBID, index will be used for clustering data in the event of a REORG; is
> this true for INSERT as well?)
>
>
>
> It looks like what I’m seeing with this case (three indexes; the first one
> created also has the lowest OBID), INSERT behavior seems to be
> at-end-of-table, but that could just be heap behavior and the keys are built
> and INSERTed in sequence. I could use advice, if anyone has it.
>
>
>
> --Phil
>
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>
> ------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.424 / Virus Database: 270.14.48/2479 - Release Date: 11/03/09 19:38:00
>
>
>
>
> --
>
> +-------------------------------+---------------------------------+
> | Peter G Backlund | Telephone: 08 - 38 69 08 |
> | Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554 |
> | Rasundavagen 94 | Country Code (Sweden): 46 |
> | S-169 57 SOLNA | Skype: BacklundDB2 |
> | Sweden | E-mail: [login to unmask email] |
> +-------------------------------+---------------------------------+
> | IBM Database GOLD Consultant |
> +-------------------------------+---------------------------------+
> | Working with DB2 since 1981 ... and forever! |
> +-----------------------------------------------------------------+
>
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Marianne Wainwright

Re: [z/OS V9] Default Behavior when no CLUSTER index exists?
(in response to Bala)
I am a bit surprised about your comment
"I don't have time to change those primary indexes into clustering while in
DB2 v8 CM.

It is just an "Alter Index Creator.Indexname CLUSTER" and you are there...

Peter



On Sun, Nov 22, 2009 at 10:50 AM, DB2sysprog <[login to unmask email]> wrote:

> YES, the behaviour in discussion was implemented in v8. But, is this
> available in CM or only in NFM ? Anybody has experience taking advantage of
> this while in v8 CM itself ? we have got some hundreds of tables having
> implicit clustering index and reorgs are not doing the re-ordering. SQLs are
> suffering because of it. I don't have time to change those primary indexes
> into clustering while in DB2 v8 CM.
>
> Thanks!
>
> On Thu, Nov 5, 2009 at 12:05 PM, Peter Backlund <[login to unmask email]>wrote:
>
>> Actually, the change to reorg was implemented already in DB2 V8
>>
>> Peter
>>
>> Rasmussen, Steen wrote:
>>
>> Correct Rick – the first index defined becomes the clustering until an
>> explicit one is created.
>>
>> What changed in DB2 V9 was, that reorg now honors this implicit created
>> clustering – so data will be organized according to this one. In the past
>> reorganizing a tablespace without an explicitly created clustering index –
>> only freespace was reclaimed, the data remained in the same order.
>>
>>
>>
>> *Steen Rasmussen*
>> CA
>>
>> Sr Engineering Services Architect
>>
>> IBM Certified Database Associate - DB2 9 Fundamentals
>>
>> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>>
>>
>>
>> *From:* IDUG DB2-L [mailto:[login to unmask email] <[login to unmask email]>] *On
>> Behalf Of *Weaver, Rick
>> *Sent:* Wednesday, November 04, 2009 4:43 PM
>> *To:* [login to unmask email]
>> *Subject:* Re: [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index
>> exists?
>>
>>
>>
>> If memory serves, the first index defined becomes the clustering index if
>> no index has CLUSTER defined.
>>
>>
>>
>> There, I just used index, cluster, and defined twice each in the same
>> sentence and it's not even Friday.
>>
>>
>>
>> Rick Weaver
>> Product Manager
>> DB2 z/OS Solutions
>> BMC Software
>>
>>
>>
>>
>> ------------------------------
>>
>> *From:* IDUG DB2-L [mailto:[login to unmask email] <[login to unmask email]>] *On
>> Behalf Of *Sevetson, Phil
>> *Sent:* Wednesday, November 04, 2009 3:47 PM
>> *To:* [login to unmask email]
>> *Subject:* [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index
>> exists?
>>
>> I have a segmented tablespace in production. It has no index defined with
>> CLUSTER. Can anyone point me to documentation of the behavior of an INSERT
>> statement on this table? (My understanding is that the oldest, or lowest
>> OBID, index will be used for clustering data in the event of a REORG; is
>> this true for INSERT as well?)
>>
>>
>>
>> It looks like what I’m seeing with this case (three indexes; the first one
>> created also has the lowest OBID), INSERT behavior seems to be
>> at-end-of-table, but that could just be heap behavior and the keys are built
>> and INSERTed in sequence. I could use advice, if anyone has it.
>>
>>
>>
>> --Phil
>>
>>
>> ------------------------------
>>
>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>
>>
>> ------------------------------
>>
>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>
>> ------------------------------
>>
>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>
>> ------------------------------
>>
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com
>> Version: 8.5.424 / Virus Database: 270.14.48/2479 - Release Date: 11/03/09 19:38:00
>>
>>
>>
>>
>> --
>>
>> +-------------------------------+---------------------------------+
>> | Peter G Backlund | Telephone: 08 - 38 69 08 |
>> | Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554 |
>> | Rasundavagen 94 | Country Code (Sweden): 46 |
>> | S-169 57 SOLNA | Skype: BacklundDB2 |
>> | Sweden | E-mail: [login to unmask email] |
>> +-------------------------------+---------------------------------+
>> | IBM Database GOLD Consultant |
>> +-------------------------------+---------------------------------+
>> | Working with DB2 since 1981 ... and forever! |
>> +-----------------------------------------------------------------+
>>
>>
>> ------------------------------
>>
>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>
>
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community! ] < http://www.idug.org/db2-north-america-conference/index.html >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>



--
Attend IDUG 2009, Europe -- 5-9 October in Rome, Italy
Learn more at http://www.idug.org

+-------------------------------+---------------------------------+
| Peter G Backlund | Telephone: 08 - 38 69 08
|
| Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554
|
| Rasundavagen 94 | Country Code (Sweden): 46
|
| S-169 57 SOLNA | Skype: BacklundDB2
|
| Sweden | E-mail: [login to unmask email] |
+-------------------------------+---------------------------------+
| IBM Database GOLD Consultant |
+-------------------------------+---------------------------------+
| Working with DB2 since 1981 ... and forever! |
+-----------------------------------------------------------------+

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Bala

Re: [z/OS V9] Default Behavior when no CLUSTER index exists?
(in response to Marianne Wainwright)
So, do I :-)

"It is just an "Alter Index Creator.Indexname CLUSTER" and you are there..."

Alter the Cluster is a v8 NFM feature. But, I found answer myself for my
original question. The reorg seems to use implicit clustering index while in
V8 CM itself. If that is wrong, someone please correct me.

thanks...

On Mon, Nov 23, 2009 at 2:50 AM, Peter Backlund <[login to unmask email]>wrote:

> I am a bit surprised about your comment
> "I don't have time to change those primary indexes into clustering while in
> DB2 v8 CM.
>
> It is just an "Alter Index Creator.Indexname CLUSTER" and you are there...
>
> Peter
>
>
>
>
> On Sun, Nov 22, 2009 at 10:50 AM, DB2sysprog <[login to unmask email]>wrote:
>
>> YES, the behaviour in discussion was implemented in v8. But, is this
>> available in CM or only in NFM ? Anybody has experience taking advantage of
>> this while in v8 CM itself ? we have got some hundreds of tables having
>> implicit clustering index and reorgs are not doing the re-ordering. SQLs are
>> suffering because of it. I don't have time to change those primary indexes
>> into clustering while in DB2 v8 CM.
>>
>> Thanks!
>>
>> On Thu, Nov 5, 2009 at 12:05 PM, Peter Backlund <[login to unmask email]>wrote:
>>
>>> Actually, the change to reorg was implemented already in DB2 V8
>>>
>>> Peter
>>>
>>> Rasmussen, Steen wrote:
>>>
>>> Correct Rick – the first index defined becomes the clustering until an
>>> explicit one is created.
>>>
>>> What changed in DB2 V9 was, that reorg now honors this implicit created
>>> clustering – so data will be organized according to this one. In the past
>>> reorganizing a tablespace without an explicitly created clustering index –
>>> only freespace was reclaimed, the data remained in the same order.
>>>
>>>
>>>
>>> *Steen Rasmussen*
>>> CA
>>>
>>> Sr Engineering Services Architect
>>>
>>> IBM Certified Database Associate - DB2 9 Fundamentals
>>>
>>> IBM Certified Database Administrator - DB2 9 DBA for z/OS
>>>
>>>
>>>
>>> *From:* IDUG DB2-L [mailto:[login to unmask email] <[login to unmask email]>] *On
>>> Behalf Of *Weaver, Rick
>>> *Sent:* Wednesday, November 04, 2009 4:43 PM
>>> *To:* [login to unmask email]
>>> *Subject:* Re: [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index
>>> exists?
>>>
>>>
>>>
>>> If memory serves, the first index defined becomes the clustering index if
>>> no index has CLUSTER defined.
>>>
>>>
>>>
>>> There, I just used index, cluster, and defined twice each in the same
>>> sentence and it's not even Friday.
>>>
>>>
>>>
>>> Rick Weaver
>>> Product Manager
>>> DB2 z/OS Solutions
>>> BMC Software
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> *From:* IDUG DB2-L [mailto:[login to unmask email] <[login to unmask email]>] *On
>>> Behalf Of *Sevetson, Phil
>>> *Sent:* Wednesday, November 04, 2009 3:47 PM
>>> *To:* [login to unmask email]
>>> *Subject:* [DB2-L] [z/OS V9] Default Behavior when no CLUSTER index
>>> exists?
>>>
>>> I have a segmented tablespace in production. It has no index defined
>>> with CLUSTER. Can anyone point me to documentation of the behavior of an
>>> INSERT statement on this table? (My understanding is that the oldest, or
>>> lowest OBID, index will be used for clustering data in the event of a REORG;
>>> is this true for INSERT as well?)
>>>
>>>
>>>
>>> It looks like what I’m seeing with this case (three indexes; the first
>>> one created also has the lowest OBID), INSERT behavior seems to be
>>> at-end-of-table, but that could just be heap behavior and the keys are built
>>> and INSERTed in sequence. I could use advice, if anyone has it.
>>>
>>>
>>>
>>> --Phil
>>>
>>>
>>> ------------------------------
>>>
>>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>>
>>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>>
>>>
>>> ------------------------------
>>>
>>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>>
>>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>>
>>> ------------------------------
>>>
>>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>>
>>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>>
>>> ------------------------------
>>>
>>>
>>>
>>>
>>> No virus found in this incoming message.
>>> Checked by AVG - www.avg.com
>>> Version: 8.5.424 / Virus Database: 270.14.48/2479 - Release Date: 11/03/09 19:38:00
>>>
>>>
>>>
>>>
>>> --
>>>
>>> +-------------------------------+---------------------------------+
>>> | Peter G Backlund | Telephone: 08 - 38 69 08 |
>>> | Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554 |
>>> | Rasundavagen 94 | Country Code (Sweden): 46 |
>>> | S-169 57 SOLNA | Skype: BacklundDB2 |
>>> | Sweden | E-mail: [login to unmask email] |
>>> +-------------------------------+---------------------------------+
>>> | IBM Database GOLD Consultant |
>>> +-------------------------------+---------------------------------+
>>> | Working with DB2 since 1981 ... and forever! |
>>> +-----------------------------------------------------------------+
>>>
>>>
>>> ------------------------------
>>>
>>> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>>>
>>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>>
>>
>>
>> ------------------------------
>>
>> [image: IDUG - The Worldwide DB2 User Community! ] < http://www.idug.org/db2-north-america-conference/index.html >
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
>> are not already an IDUG member, please register here. < http://www.idug.org/register >
>>
>
>
>
> --
> Attend IDUG 2009, Europe -- 5-9 October in Rome, Italy
> Learn more at http://www.idug.org
>
>
> +-------------------------------+---------------------------------+
> | Peter G Backlund | Telephone: 08 - 38 69 08
> |
> | Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554
> |
> | Rasundavagen 94 | Country Code (Sweden): 46
> |
> | S-169 57 SOLNA | Skype: BacklundDB2
> |
> | Sweden | E-mail:
> [login to unmask email] |
> +-------------------------------+---------------------------------+
> | IBM Database GOLD Consultant |
> +-------------------------------+---------------------------------+
> | Working with DB2 since 1981 ... and forever! |
> +-----------------------------------------------------------------+
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community! ] < http://www.idug.org/db2-north-america-conference/index.html >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L