DB2/ZOS to DB2/UDB (UNIX)

Tony Moore

DB2/ZOS to DB2/UDB (UNIX)
Hi Listers,
I'm 99.9% sure of the answer here, but as I'm a few releases behind on
DB2... and a Z/OS Dinosaur to boot, thought I'd throw it out to be
thorough....

I'm looking at getting DB2/ZOS table data mirrored to DB2/UDB tables. As
far as I know, my only options are...

1. Periodic Unload - FTP - Load jobs
2. Initial Unload-FTP-Load and then periodically capture and transmit
DB2/ZOS log activity and replicate update activity on the DB2/UDB tables.
3. Periodic SELECT * from DB2/ZOS tables, through DB2/Connect and then
either INSERTs or LOADs of that data into the DB2/UDB tables... either
through a homemade application or the DB2/UDB export/import commands.
4. Some third party software that automates one or more of the three
options above.

Without looking for salesreps to start knocking, are those still the only
viable options these days?

I've been specifically asked if it's possible to do something like
Flashcopy of the underlying VSAM datasets and use the copy with DB2/UDB
(Mainframe and UNIX box shares the same DS9000 Storage), but told them,
although I don't know much about UDB, I'm pretty sure that DB2/UDB would
not be able to use a Linear VSAM dataset.. not to mention the old internal
object id issue from days gone by.

Thanks,

Tony Moore
DB2 Mainframe Dinosaur

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Daniel Luksetich

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Tony Moore)
Right-o on not being able to internally move the data.

Additional options:
Export/Import on the LUW side.
If you have IBM utilites then you can use cross-loader (not 100% sure
here, I know you can go LUW to z/OS but not sure about the other way)

Cheers,
Dan
On Wed, 3 Nov 2010 16:46:07 -0400, Tony <[login to unmask email]> wrote:
> Hi Listers,
> I'm 99.9% sure of the answer here, but as I'm a few releases behind on
> DB2... and a Z/OS Dinosaur to boot, thought I'd throw it out to be
> thorough....
>
> I'm looking at getting DB2/ZOS table data mirrored to DB2/UDB tables. As

> far as I know, my only options are...
>
> 1. Periodic Unload - FTP - Load jobs
> 2. Initial Unload-FTP-Load and then periodically capture and transmit
> DB2/ZOS log activity and replicate update activity on the DB2/UDB
tables.
> 3. Periodic SELECT * from DB2/ZOS tables, through DB2/Connect and then
> either INSERTs or LOADs of that data into the DB2/UDB tables... either
> through a homemade application or the DB2/UDB export/import
commands.
> 4. Some third party software that automates one or more of the three
> options above.
>
> Without looking for salesreps to start knocking, are those still the
only
> viable options these days?
>
> I've been specifically asked if it's possible to do something like
> Flashcopy of the underlying VSAM datasets and use the copy with DB2/UDB
> (Mainframe and UNIX box shares the same DS9000 Storage), but told them,
> although I don't know much about UDB, I'm pretty sure that DB2/UDB would

> not be able to use a Linear VSAM dataset.. not to mention the old
internal
> object id issue from days gone by.
>
> Thanks,
>
> Tony Moore
> DB2 Mainframe Dinosaur
>
> _____________________________________________________________________
> * IDUG EMEA * Vienna, Austria * 8-12 November 2010 *
http://IDUG.ORG/EMEA
> *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is
> the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Byron Pierce

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Daniel Luksetich)
Hi Tony,

Not sure for what purpose you need a 'copy' of the z/OS data in UDB, or how
that copy will be used, but perhaps federating the table in UDB would solve
your problem. With that, all updates (insert/delete, data changes) will be
captured (not dataprop) through the federated copy in UDB. I did it for a
project not that long ago... quite simple actually.

Just a thought.

Byron C. Pierce
Prudential Retirement Technology
Database Services - DBA Operate Team
280 Trumbull Street - H18C
Hartford, CT 06103-3509
Work: 860.534.4222
Fax: 860.534.3135



Tony
<[login to unmask email]
-USA.COM> To
[login to unmask email]
Sent by: IDUG cc
DB2-L
<[login to unmask email] Subject
ORG> [DB2-L] DB2/ZOS to DB2/UDB (UNIX)



Wed 11/03/2010
04:46 PM


Please respond to
IDUG DB2-L
<[login to unmask email]
ORG>





Hi Listers,
I'm 99.9% sure of the answer here, but as I'm a few releases behind on
DB2... and a Z/OS Dinosaur to boot, thought I'd throw it out to be
thorough....

I'm looking at getting DB2/ZOS table data mirrored to DB2/UDB tables. As
far as I know, my only options are...

1. Periodic Unload - FTP - Load jobs
2. Initial Unload-FTP-Load and then periodically capture and transmit
DB2/ZOS log activity and replicate update activity on the DB2/UDB tables.
3. Periodic SELECT * from DB2/ZOS tables, through DB2/Connect and then
either INSERTs or LOADs of that data into the DB2/UDB tables... either
through a homemade application or the DB2/UDB export/import commands.
4. Some third party software that automates one or more of the three
options above.

Without looking for salesreps to start knocking, are those still the only
viable options these days?

I've been specifically asked if it's possible to do something like
Flashcopy of the underlying VSAM datasets and use the copy with DB2/UDB
(Mainframe and UNIX box shares the same DS9000 Storage), but told them,
although I don't know much about UDB, I'm pretty sure that DB2/UDB would
not be able to use a Linear VSAM dataset.. not to mention the old internal
object id issue from days gone by.

Thanks,

Tony Moore
DB2 Mainframe Dinosaur

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA
*
* Your only source for independent, unbiased, and trusted DB2
information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

(See attached file: C.htm)












_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Anand Jayachandran

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Byron Pierce)
Using Informatica to copy data between z/OS and UNIX would be simple and
beneficial



[login to unmask email] wrote on 11/03/2010 13:46:07:

> Hi Listers,
> I'm 99.9% sure of the answer here, but as I'm a few releases behind
> on DB2... and a Z/OS Dinosaur to boot, thought I'd throw it out to
> be thorough....
>
> I'm looking at getting DB2/ZOS table data mirrored to DB2/UDB
> tables. As far as I know, my only options are...
>
> 1. Periodic Unload - FTP - Load jobs
> 2. Initial Unload-FTP-Load and then periodically capture and
> transmit DB2/ZOS log activity and replicate update activity on the
> DB2/UDB tables.
> 3. Periodic SELECT * from DB2/ZOS tables, through DB2/Connect and
> then either INSERTs or LOADs of that data into the DB2/UDB
tables...either
> through a homemade application or the DB2/UDB export/import
commands.
> 4. Some third party software that automates one or more of the three
> options above.
>
> Without looking for salesreps to start knocking, are those still the
> only viable options these days?
>
> I've been specifically asked if it's possible to do something like
> Flashcopy of the underlying VSAM datasets and use the copy with
> DB2/UDB (Mainframe and UNIX box shares the same DS9000 Storage), but
> told them, although I don't know much about UDB, I'm pretty sure
> that DB2/UDB would not be able to use a Linear VSAM dataset.. not to
> mention the old internal object id issue from days gone by.
>
> Thanks,
>
> Tony Moore
> DB2 Mainframe Dinosaur
>

> [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.

If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation.
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Gregory Palgrave

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Anand Jayachandran)
Another possible option is to use DB2 replication from z/OS to LUW. I've used it on LUW systems, but I'm not quite sure what is needed on a real (i.e. z/OS) DB2 system to make it happen.

This may help: https://www.ibm.com/developerworks/mydeveloperworks/blogs/a82063fa-aecf-4716-81a4-8d33425a8735/entry/what_you_need_to_use_sql_replication_between_db2_z_os_and_db2_luw2?lang=en


Cheers

Greg
(former DB2 Mainframe Dinosaur, now 'Little DB2'-herder )


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Tony
Sent: Thursday, 4 November 2010 4:46 AM
To: [login to unmask email]
Subject: [DB2-L] DB2/ZOS to DB2/UDB (UNIX)

Hi Listers,
I'm 99.9% sure of the answer here, but as I'm a few releases behind on DB2... and a Z/OS Dinosaur to boot, thought I'd throw it out to be thorough....

I'm looking at getting DB2/ZOS table data mirrored to DB2/UDB tables. As far as I know, my only options are...

1. Periodic Unload - FTP - Load jobs
2. Initial Unload-FTP-Load and then periodically capture and transmit DB2/ZOS log activity and replicate update activity on the DB2/UDB tables.
3. Periodic SELECT * from DB2/ZOS tables, through DB2/Connect and then either INSERTs or LOADs of that data into the DB2/UDB tables... either
through a homemade application or the DB2/UDB export/import commands.
4. Some third party software that automates one or more of the three options above.

Without looking for salesreps to start knocking, are those still the only viable options these days?

I've been specifically asked if it's possible to do something like Flashcopy of the underlying VSAM datasets and use the copy with DB2/UDB (Mainframe and UNIX box shares the same DS9000 Storage), but told them, although I don't know much about UDB, I'm pretty sure that DB2/UDB would not be able to use a Linear VSAM dataset.. not to mention the old internal object id issue from days gone by.

Thanks,

Tony Moore
DB2 Mainframe Dinosaur

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Myron Miller

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Gregory Palgrave)
Why not also use the cross-system data loader? That's free.



________________________________
From: Gregory Palgrave <[login to unmask email]>
To: [login to unmask email]
Sent: Thu, November 4, 2010 12:20:16 AM
Subject: Re: [DB2-L] DB2/ZOS to DB2/UDB (UNIX)


Another possible option is to use DB2 replication from z/OS to LUW. I've used it
on LUW systems, but I'm not quite sure what is needed on a real (i.e. z/OS) DB2
system to make it happen.

This may help:
https://www.ibm.com/developerworks/mydeveloperworks/blogs/a82063fa-aecf-4716-81a4-8d33425a8735/entry/what_you_need_to_use_sql_replication_between_db2_z_os_and_db2_luw2?lang=en



Cheers

Greg
(former DB2 Mainframe Dinosaur, now 'Little DB2'-herder )


From:IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Tony
Sent: Thursday, 4 November 2010 4:46 AM
To: [login to unmask email]
Subject: [DB2-L] DB2/ZOS to DB2/UDB (UNIX)

Hi Listers,
I'm 99.9% sure of the answer here, but as I'm a few releases behind on DB2...
and a Z/OS Dinosaur to boot, thought I'd throw it out to be thorough....


I'm looking at getting DB2/ZOS table data mirrored to DB2/UDB tables. As far as
I know, my only options are...


1. Periodic Unload - FTP - Load jobs
2. Initial Unload-FTP-Load and then periodically capture and transmit DB2/ZOS
log activity and replicate update activity on the DB2/UDB tables.

3. Periodic SELECT * from DB2/ZOS tables, through DB2/Connect and then either
INSERTs or LOADs of that data into the DB2/UDB tables... either

through a homemade application or the DB2/UDB export/import commands.
4. Some third party software that automates one or more of the three options
above.


Without looking for salesreps to start knocking, are those still the only viable
options these days?


I've been specifically asked if it's possible to do something like Flashcopy of
the underlying VSAM datasets and use the copy with DB2/UDB (Mainframe and UNIX
box shares the same DS9000 Storage), but told them, although I don't know much
about UDB, I'm pretty sure that DB2/UDB would not be able to use a Linear VSAM
dataset.. not to mention the old internal object id issue from days gone by.


Thanks,

Tony Moore
DB2 Mainframe Dinosaur
________________________________

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 *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Tony Moore

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Myron Miller)
Thanks everyone for the suggestions... and the education!

I get asked this same question on an average of once every two to three
years, so I'm sure I'll be looking back at it again later down the road.

Thanks again!

Tony Moore D.M.D
(DB2 Mainframe Dinosaur)





From: Myron Miller <[login to unmask email]>
To: [login to unmask email]
Date: 11/04/2010 09:10 AM
Subject: Re: [DB2-L] DB2/ZOS to DB2/UDB (UNIX)
Sent by: IDUG DB2-L <[login to unmask email]>



Why not also use the cross-system data loader? That's free.

From: Gregory Palgrave <[login to unmask email]>
To: [login to unmask email]
Sent: Thu, November 4, 2010 12:20:16 AM
Subject: Re: [DB2-L] DB2/ZOS to DB2/UDB (UNIX)

Another possible option is to use DB2 replication from z/OS to LUW. I've
used it on LUW systems, but I'm not quite sure what is needed on a real
(i.e. z/OS) DB2 system to make it happen.

This may help:
https://www.ibm.com/developerworks/mydeveloperworks/blogs/a82063fa-aecf-4716-81a4-8d33425a8735/entry/what_you_need_to_use_sql_replication_between_db2_z_os_and_db2_luw2?lang=en


Cheers

Greg
(former DB2 Mainframe Dinosaur, now 'Little DB2'-herder )


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Tony
Sent: Thursday, 4 November 2010 4:46 AM
To: [login to unmask email]
Subject: [DB2-L] DB2/ZOS to DB2/UDB (UNIX)

Hi Listers,
I'm 99.9% sure of the answer here, but as I'm a few releases behind on
DB2... and a Z/OS Dinosaur to boot, thought I'd throw it out to be
thorough....

I'm looking at getting DB2/ZOS table data mirrored to DB2/UDB tables. As
far as I know, my only options are...

1. Periodic Unload - FTP - Load jobs
2. Initial Unload-FTP-Load and then periodically capture and transmit
DB2/ZOS log activity and replicate update activity on the DB2/UDB tables.
3. Periodic SELECT * from DB2/ZOS tables, through DB2/Connect and then
either INSERTs or LOADs of that data into the DB2/UDB tables... either
through a homemade application or the DB2/UDB export/import commands.
4. Some third party software that automates one or more of the three
options above.

Without looking for salesreps to start knocking, are those still the only
viable options these days?

I've been specifically asked if it's possible to do something like
Flashcopy of the underlying VSAM datasets and use the copy with DB2/UDB
(Mainframe and UNIX box shares the same DS9000 Storage), but told them,
although I don't know much about UDB, I'm pretty sure that DB2/UDB would
not be able to use a Linear VSAM dataset.. not to mention the old internal
object id issue from days gone by.

Thanks,

Tony Moore
DB2 Mainframe Dinosaur



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



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 EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Peter Suhner

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Tony Moore)
Byron, Tony,

just to clarify this point: Federation will actually *not* replicate the data of the source system (DB2 z/OS in this case) to the target system (LUW in this case). Meaning that with Federation, you don't have a permanent copy of the source data, but you transparently connect to and work on the source database. This might be worth knowing if you start modifying data through federation or if you have performance issues.

With Federation, you actually create so called "nicknames". You can think of these objects like of a "façade" which occurs to be a DB2 table on LUW - even though it's not. Instead, through the nickname, you actually connect (via other federation objects like "Server" and "Wrapper" definitions) directly to the original data source. Thus the term "Federation": you actually interconnect disparate data sources. And you can use them as you are used to work on real tables: Do all the SQL DML stuff you are used to (including joins with real local tables, etc.). DB2 will delegate the remote part of the work to the remote system and join the result sets locally. Quite sophisticated stuff behind the scenes.

For Tony's purpose (occasional replication from z/OS to LUW), you could use Federation as follows:
- Create the necessary federation objects (Wrapper, Server, User Mappings, Nicknames) on your target LUW instance
- Create the local target table (if not yet existing). You can even code "create table xy like my.nickname" - very comfy!
- Define a cursor for select * (or whatever - simply any cursor definition) from the nickname
- Load from cursor to the target table

The good things with this approach:
- Very simple, very easy to implement
- Load from cursor is extremely fast!
- With Federation, you cannot only interconnect DB2 z/OS and LUW, but many more DBMSs (Oracle, SQL Server, Informix, etc.) plus even Non-Relational data sources.

The bad things:
- AFAIK, Federation does not come for free. Maybe you can directly interconnect DB2 z/OS and LUW (because the DRDA Wrapper comes with DB2 LUW), but for any interconnection with 3rd party products, there's additional license cost. I think, IBM calls this product then "Websphere Information Integrator" or so, but the technology is actually identical to DB2 Federation.

Regards,
Peter

_________________________
peter suhner
ch-8200 schaffhausen
[login to unmask email]

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

William Gannon

Re: DB2/ZOS to DB2/UDB (UNIX)
(in response to Peter Suhner)
Funny thing is I just gave a presentation on this very subject at the 2010 IDUG conference. The link to my presentation follows



http://www.idug.org/component/option,com_presentation/lang,en/presentation,E01/



Hope you can find it useful !





William B. Gannon

- IBM Certified Database Administrator

DB2 9 for Linux, Unix and Windows

- IBM Certified Solutions Expert

- IBM Certified Database Administrator

DB2 Universal Database V8.1 for zOS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Peter Suhner
Sent: Friday, November 05, 2010 1:56 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2/ZOS to DB2/UDB (UNIX)



Byron, Tony,



just to clarify this point: Federation will actually *not* replicate the data of the source system (DB2 z/OS in this case) to the target system (LUW in this case). Meaning that with Federation, you don't have a permanent copy of the source data, but you transparently connect to and work on the source database. This might be worth knowing if you start modifying data through federation or if you have performance issues.



With Federation, you actually create so called "nicknames". You can think of these objects like of a "façade" which occurs to be a DB2 table on LUW - even though it's not. Instead, through the nickname, you actually connect (via other federation objects like "Server" and "Wrapper" definitions) directly to the original data source. Thus the term "Federation": you actually interconnect disparate data sources. And you can use them as you are used to work on real tables: Do all the SQL DML stuff you are used to (including joins with real local tables, etc.). DB2 will delegate the remote part of the work to the remote system and join the result sets locally. Quite sophisticated stuff behind the scenes.



For Tony's purpose (occasional replication from z/OS to LUW), you could use Federation as follows:

- Create the necessary federation objects (Wrapper, Server, User Mappings, Nicknames) on your target LUW instance

- Create the local target table (if not yet existing). You can even code "create table xy like my.nickname" - very comfy!

- Define a cursor for select * (or whatever - simply any cursor definition) from the nickname

- Load from cursor to the target table



The good things with this approach:

- Very simple, very easy to implement

- Load from cursor is extremely fast!

- With Federation, you cannot only interconnect DB2 z/OS and LUW, but many more DBMSs (Oracle, SQL Server, Informix, etc.) plus even Non-Relational data sources.



The bad things:

- AFAIK, Federation does not come for free. Maybe you can directly interconnect DB2 z/OS and LUW (because the DRDA Wrapper comes with DB2 LUW), but for any interconnection with 3rd party products, there's additional license cost. I think, IBM calls this product then "Websphere Information Integrator" or so, but the technology is actually identical to DB2 Federation.



Regards,

Peter



_________________________

peter suhner

ch-8200 schaffhausen

[login to unmask email]



_____________________________________________________________________

* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *

* Your only source for independent, unbiased, and trusted DB2 information. *

_____________________________________________________________________

http://www.IDUG.org/mentor

How can you expand your staff or do succession planning in this economy?

Mentoring is a proven, economical, way to train the next generation of DB2 Users!

_____________________________________________________________________



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 *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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