Best practices for databases being replicated

Lynne Flatley

Best practices for databases being replicated
Good morning!

I'm going to be responsible for maintaining both a small data mart and its
operational data store. Both are on DB2 V9 z/OS. I've worked in several
shops which used replication but I'm never been directly responsible for a
database using replication. We'll be using QREP. What are some of the
procedures/best practices used when maintaining a replicated database?

I know of two; when altering a replicated table to add a column, its
tablespace must be reorged immediately (or as soon as possible?), if the
tablespace is compressed, keepdictionary must be specified when doing the
reorg.

Can anyone else think of any others?

Thanks!

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Max Scarpa

Re: Best practices for databases being replicated
(in response to Lynne Flatley)
Hi Lynn

I found some articles in IBM Dw web sites, for instance:

http://www.ibm.com/developerworks/data/library/techarticle/dm-0709hamel/

I'm sure there are some presentation/papers somewhere but I've to dig a
little. I knew also some Db2-L are using it so probably thye'll provde
more 'hands-on' experience.

HTH

Max Scarpa
Cerified runner on Sunset Boulevard

'If you want to plow a field with 64 chickens instead of one mule, then
yes the unit cost per chicken is less but herding chickens becomes the new
frontier.'

From a discussion about UNIX and mainframe

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Lynne Flatley

Re: Best practices for databases being replicated
(in response to Max Scarpa)
That's a very good article. Thanks Max!

On Thu, Jan 20, 2011 at 9:15 AM, Max Scarpa <[login to unmask email]> wrote:

> Hi Lynn
>
> I found some articles in IBM Dw web sites, for instance:
>
> http://www.ibm.com/developerworks/data/library/techarticle/dm-0709hamel/
>
> I'm sure there are some presentation/papers somewhere but I've to dig a
> little. I knew also some Db2-L are using it so probably thye'll provde more
> 'hands-on' experience.
>
> HTH
>
> Max Scarpa
> Cerified runner on Sunset Boulevard
>
> 'If you want to plow a field with 64 chickens instead of one mule, then yes
> the unit cost per chicken is less but herding chickens becomes the new
> frontier.'
>
>
> From a discussion about UNIX and mainframe
> ------------------------------
>
> [image: Introducing IBM® DB2® 10 for z/OS ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >
>
> 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 * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Max Scarpa

Re: Best practices for databases being replicated
(in response to Lynne Flatley)
You're welcome. If you search deeper in that web site there are more
articles, the link I sent was only an example. I'll send more articles if
I'll find when in my presentation db.

I found it as we have Q-Rep in our soapbox but we don't used it, so I was
just curious to understand what it is.

HTH

Max Scarpa


> Sent by: IDUG DB2-L <[login to unmask email]>
>
> That's a very good article. Thanks Max!

> On Thu, Jan 20, 2011 at 9:15 AM, Max Scarpa <[login to unmask email]> wrote:
> Hi Lynn
>
> I found some articles in IBM Dw web sites, for instance:
>
> http://www.ibm.com/developerworks/data/library/techarticle/dm-0709hamel/

>
> I'm sure there are some presentation/papers somewhere but I've to
> dig a little. I knew also some Db2-L are using it so probably
> thye'll provde more 'hands-on' experience.
>
> HTH
>
> Max Scarpa
> Cerified runner on Sunset Boulevard
>
> 'If you want to plow a field with 64 chickens instead of one mule,
> then yes the unit cost per chicken is less but herding chickens
> becomes the new frontier.'
>
>
> From a discussion about UNIX and mainframe

>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.
>
>

> [image removed]
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Lynne Flatley

Re: Best practices for databases being replicated
(in response to Max Scarpa)
Also, I'm wondering if I should 'suggest' or make the strong case for not
having RI on the target tables (RI does exist on the source tables). Because
the replication is asynchronous, a child table's row could potentially
arrive before the parent table's row and if there were RI in the database,
the child insert would fail?


On Thu, Jan 20, 2011 at 9:27 AM, Max Scarpa <[login to unmask email]> wrote:

> You're welcome. If you search deeper in that web site there are more
> articles, the link I sent was only an example. I'll send more articles if
> I'll find when in my presentation db.
>
> I found it as we have Q-Rep in our soapbox but we don't used it, so I was
> just curious to understand what it is.
>
> HTH
>
> Max Scarpa
>
>
> > Sent by: IDUG DB2-L <[login to unmask email]>
> >
> > That's a very good article. Thanks Max!
>
> > On Thu, Jan 20, 2011 at 9:15 AM, Max Scarpa <[login to unmask email]> wrote:
> > Hi Lynn
> >
> > I found some articles in IBM Dw web sites, for instance:
> >
> > http://www.ibm.com/developerworks/data/library/techarticle/dm-0709hamel/
> >
> > I'm sure there are some presentation/papers somewhere but I've to
> > dig a little. I knew also some Db2-L are using it so probably
> > thye'll provde more 'hands-on' experience.
> >
> > HTH
> >
> > Max Scarpa
> > Cerified runner on Sunset Boulevard
> >
> > 'If you want to plow a field with 64 chickens instead of one mule,
> > then yes the unit cost per chicken is less but herding chickens
> > becomes the new frontier.'
> >
> >
> > From a discussion about UNIX and mainframe
>
> >
> > The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> > you are not already an IDUG member, please register here.
>
> >
> >
>
> > [image removed]
> > The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> > you are not already an IDUG member, please register here.
> ------------------------------
>
> [image: Introducing IBM® DB2® 10 for z/OS ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >
>
> 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 * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Max Scarpa

Re: Best practices for databases being replicated
(in response to Lynne Flatley)
I found also:

Zero Downtime Upgrades Using Q-REP at Constant Contact, Inc. by Dan
Berry, Sankar Padhi IOD 2010
Making Data More Highly Available at American Express by Rick Molera,
Art Bullock IOD 2010

Max Scarpa

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Raymond Bell

Re: Best practices for databases being replicated
(in response to Max Scarpa)
Don't wonder about it; it's definitely a good idea - to NOT have RI on the target tables. The relationships have already been validated/enforced in the source system - why do it in the target as well?

More practically, you'll save a little MIPS by not having DB2 re-check the RI at the target, plus make the replication process easier (and easier to restart) without it.

Cheers,


Raymond

________________________________________
Raymond Bell
Senior Software Consultant
BMC Software

Phone: +44 (0) 1784 478 558
Mobile: +44 (0) 7894 608 214
Fax: +44 (0) 1784 478 753

Assurance House
Vicarage Road, Egham
Surrey TW20 9JY, United Kingdom

From: Lynne Flatley [mailto:[login to unmask email]
Sent: Thursday, January 20, 2011 08:56 AM
To: [login to unmask email] <[login to unmask email]>
Subject: Re: [DB2-L] Best practices for databases being replicated

Also, I'm wondering if I should 'suggest' or make the strong case for not having RI on the target tables (RI does exist on the source tables). Because the replication is asynchronous, a child table's row could potentially arrive before the parent table's row and if there were RI in the database, the child insert would fail?


On Thu, Jan 20, 2011 at 9:27 AM, Max Scarpa <[login to unmask email]<mailto:[login to unmask email]>> wrote:
You're welcome. If you search deeper in that web site there are more articles, the link I sent was only an example. I'll send more articles if I'll find when in my presentation db.

I found it as we have Q-Rep in our soapbox but we don't used it, so I was just curious to understand what it is.

HTH

Max Scarpa


> Sent by: IDUG DB2-L <[login to unmask email]<mailto:[login to unmask email]>>
>
> That's a very good article. Thanks Max!

> On Thu, Jan 20, 2011 at 9:15 AM, Max Scarpa <[login to unmask email]<mailto:[login to unmask email]>> wrote:
> Hi Lynn
>
> I found some articles in IBM Dw web sites, for instance:
>
> http://www.ibm.com/developerworks/data/library/techarticle/dm-0709hamel/
>
> I'm sure there are some presentation/papers somewhere but I've to
> dig a little. I knew also some Db2-L are using it so probably
> thye'll provde more 'hands-on' experience.
>
> HTH
>
> Max Scarpa
> Cerified runner on Sunset Boulevard
>
> 'If you want to plow a field with 64 chickens instead of one mule,
> then yes the unit cost per chicken is less but herding chickens
> becomes the new frontier.'
>
>
> From a discussion about UNIX and mainframe

>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.

>
>

> [image removed]
> 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-01.ibm.com/software/data/db2/zos/db2-10/ >

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 >


________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

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 * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Lockwood Lyon

Re: Best practices for databases being replicated
(in response to Raymond Bell)
Lynne,

There are several things you need to configure differently in your target tables, depending on their intended use.

Among these are RI (usually left OFF), columns with the IDENTITY attribute (usually REMOVED), triggers (usually REMOVED). Sometimes there are lots of index changes -- some are REMOVED (ex. you no longer require an index to enforce PK or uniqueness, since this is (supposedly) guaranteed in the target system), some changed, some re-configured vis-a-vis CLUSTER, etc. for performance, and so forth.

Another ODS-to-DW issue involves time-series data, purging, and partitioning. You may have segmented TS in ODS, but partitioned in DW (by date, region, etc.) due to analytic requirements and needs to purge old data (perhaps by partition rotation).

Yet another issue involves backup and recovery in the target system. Do you use ICs, or use replication to re-sync problem tables?

HTH

- Lock Lyon
Fifth Third Bancorp



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Thursday, January 20, 2011 10:09 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Best practices for databases being replicated

Don't wonder about it; it's definitely a good idea - to NOT have RI on the target tables. The relationships have already been validated/enforced in the source system - why do it in the target as well?

More practically, you'll save a little MIPS by not having DB2 re-check the RI at the target, plus make the replication process easier (and easier to restart) without it.

Cheers,


Raymond

________________________________________
Raymond Bell
Senior Software Consultant
BMC Software

Phone: +44 (0) 1784 478 558
Mobile: +44 (0) 7894 608 214
Fax: +44 (0) 1784 478 753

Assurance House
Vicarage Road, Egham
Surrey TW20 9JY, United Kingdom
 
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Thursday, January 20, 2011 08:56 AM
To: [login to unmask email] <[login to unmask email]>
Subject: Re: [DB2-L] Best practices for databases being replicated
 
Also, I'm wondering if I should 'suggest' or make the strong case for not having RI on the target tables (RI does exist on the source tables). Because the replication is asynchronous, a child table's row could potentially arrive before the parent table's row and if there were RI in the database, the child insert would fail?


This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Kim May

Re: Best practices for databases being replicated
(in response to Lockwood Lyon)
Lynne,



Have you taken training? We are scheduled to deliver the IBM Q Rep training
class, CE243, starting February 14th in Baltimore. The course covers Q Rep
- concepts, implementation concerns, monitoring and modification. The full
course outline and registration information is on the IBM website -
www.ibm.com/training



I know training is (too often) considered a luxury these days, but I hope
you will consider it. Q Replication is fairly complicated and typically
isn't implemented unless the data really needs to be replicated.so it needs
to work.



Kim May

The Fillmore Group



From: IDUG DB2-L [mailto:[login to unmask email] on Behalf Of Lynne Flatley
Sent: Thursday, January 20, 2011 9:03 AM
To: [login to unmask email]
Subject: [DB2-L] Best practices for databases being replicated



Good morning!

I'm going to be responsible for maintaining both a small data mart and its
operational data store. Both are on DB2 V9 z/OS. I've worked in several
shops which used replication but I'm never been directly responsible for a
database using replication. We'll be using QREP. What are some of the
procedures/best practices used when maintaining a replicated database?

I know of two; when altering a replicated table to add a column, its
tablespace must be reorged immediately (or as soon as possible?), if the
tablespace is compressed, keepdictionary must be specified when doing the
reorg.

Can anyone else think of any others?

Thanks!



_____

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ > Introducing IBMR DB2R
10 for z/OS

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 * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Lynne Flatley

Re: Best practices for databases being replicated
(in response to Kim May)
Wow, lots of things to think about...

Regarding your question, do you use ICs or use replication to re-sync
problem tables, we're only at the the planning stage right now. Supposedly,
it's going to be a small Data Mart, under 40GB so if/when a problem with a
specific table, I think we would just unload the source table and load to
the target table. They will be on different DB2 subsystems.

I am a contractor at this company and they do not have DRDA set up between
subsystems (unfortunately). Is this something they will need for replication
using QREP?

On Thu, Jan 20, 2011 at 10:42 AM, Lyon, Lockwood <[login to unmask email]>wrote:

> Lynne,
>
> There are several things you need to configure differently in your target
> tables, depending on their intended use.
>
> Among these are RI (usually left OFF), columns with the IDENTITY attribute
> (usually REMOVED), triggers (usually REMOVED). Sometimes there are lots of
> index changes -- some are REMOVED (ex. you no longer require an index to
> enforce PK or uniqueness, since this is (supposedly) guaranteed in the
> target system), some changed, some re-configured vis-a-vis CLUSTER, etc. for
> performance, and so forth.
>
> Another ODS-to-DW issue involves time-series data, purging, and
> partitioning. You may have segmented TS in ODS, but partitioned in DW (by
> date, region, etc.) due to analytic requirements and needs to purge old data
> (perhaps by partition rotation).
>
> Yet another issue involves backup and recovery in the target system. Do
> you use ICs, or use replication to re-sync problem tables?
>
> HTH
>
> - Lock Lyon
> Fifth Third Bancorp
>
>
>
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
> Sent: Thursday, January 20, 2011 10:09 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] Best practices for databases being replicated
>
> Don't wonder about it; it's definitely a good idea - to NOT have RI on the
> target tables. The relationships have already been validated/enforced in the
> source system - why do it in the target as well?
>
> More practically, you'll save a little MIPS by not having DB2 re-check the
> RI at the target, plus make the replication process easier (and easier to
> restart) without it.
>
> Cheers,
>
>
> Raymond
>
> ________________________________________
> Raymond Bell
> Senior Software Consultant
> BMC Software
>
> Phone: +44 (0) 1784 478 558
> Mobile: +44 (0) 7894 608 214
> Fax: +44 (0) 1784 478 753
>
> Assurance House
> Vicarage Road, Egham
> Surrey TW20 9JY, United Kingdom
>
> From: Lynne Flatley [mailto:[login to unmask email]
> Sent: Thursday, January 20, 2011 08:56 AM
> To: [login to unmask email] <[login to unmask email]>
> Subject: Re: [DB2-L] Best practices for databases being replicated
>
> Also, I'm wondering if I should 'suggest' or make the strong case for not
> having RI on the target tables (RI does exist on the source tables). Because
> the replication is asynchronous, a child table's row could potentially
> arrive before the parent table's row and if there were RI in the database,
> the child insert would fail?
>
>
> This e-mail transmission contains information that is confidential and may
> be privileged. It is intended only for the addressee(s) named above. If
> you receive this e-mail in error, please do not read, copy or disseminate it
> in any manner. If you are not the intended recipient, any disclosure,
> copying, distribution or use of the contents of this information is
> prohibited. Please reply to the message immediately by informing the sender
> that the message was misdirected. After replying, please erase it from your
> computer system. Your assistance in correcting this error is appreciated.
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> _____________________________________________________________________
> http://www.IDUG.org/mentor
> Mentoring should be a rewarding experience for everyone...
> IDUG is offering up to 80% off when you both come to the conference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Lynne Flatley

Re: Best practices for databases being replicated
(in response to Lynne Flatley)
Thanks Kim! I had seen your ad for the class. It looks very interesting but
as I just mentioned above, I'm a contractor here with my client and 2/14
happens to be the day we're supposed to be implementing this in our test
environment... :-)

On Thu, Jan 20, 2011 at 10:54 AM, Kimberly May <[login to unmask email]
> wrote:

> Lynne,
>
>
>
> Have you taken training? We are scheduled to deliver the IBM Q Rep
> training class, CE243, starting February 14th in Baltimore. The course
> covers Q Rep – concepts, implementation concerns, monitoring and
> modification. The full course outline and registration information is on
> the IBM website – www.ibm.com/training
>
>
>
> I know training is (too often) considered a luxury these days, but I hope
> you will consider it. Q Replication is fairly complicated and typically
> isn’t implemented unless the data really needs to be replicated…so it needs
> to work.
>
>
>
> Kim May
>
> The Fillmore Group
>
>
>
> *From:* IDUG DB2-L [mailto:[login to unmask email] *on Behalf Of *Lynne
> Flatley
> *Sent:* Thursday, January 20, 2011 9:03 AM
>
> *To:* [login to unmask email]
> *Subject:* [DB2-L] Best practices for databases being replicated
>
>
>
> Good morning!
>
> I'm going to be responsible for maintaining both a small data mart and its
> operational data store. Both are on DB2 V9 z/OS. I've worked in several
> shops which used replication but I'm never been directly responsible for a
> database using replication. We'll be using QREP. What are some of the
> procedures/best practices used when maintaining a replicated database?
>
> I know of two; when altering a replicated table to add a column, its
> tablespace must be reorged immediately (or as soon as possible?), if the
> tablespace is compressed, keepdictionary must be specified when doing the
> reorg.
>
> Can anyone else think of any others?
>
> Thanks!
>
> ------------------------------
>
> [image: Introducing IBM® DB2® 10 for z/OS ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >
>
> 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: Introducing IBM® DB2® 10 for z/OS ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >
>
> 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 * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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