db2 fast data copy tools

Zhang Ming

db2 fast data copy tools
Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.




_____________________________________________________________________

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

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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 Thome

Re: db2 fast data copy tools
(in response to Zhang Ming)
Hi Zhang,
its for free
load from remote cursor
by defining for example the destination server as a federated server and then
create server / wrapper / nicknames / user mapping
Greeting
Georg
On 05-Feb-2010 02:06, Zhang Ming wrote:
Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.
 



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



-- IBM certified Database Administrator Application Developer / SAP Development IEE S.A. IT department / Development Team zone industrielle L-6468 Echternach tel. 00352/27712810 fax 00352/27713810 www.iee.lu / [login to unmask email] This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.

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

Philip Sevetson

Re: db2 fast data copy tools
(in response to Georg Thome)
George, in my shop cursor loads work really well for small tables, and really slow - much slower than unloading to a flatfile and loading to the target - for large tables.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Georg Thomé
Sent: Friday, February 05, 2010 3:24 AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Hi Zhang,
its for free
load from remote cursor
by defining for example the destination server as a federated server and then
create server / wrapper / nicknames / user mapping
Greeting
Georg
On 05-Feb-2010 02:06, Zhang Ming wrote:
Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.


________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >




--

IBM certified Database Administrator

Application Developer / SAP Development

IEE S.A.

IT department / Development Team

zone industrielle

L-6468 Echternach

tel. 00352/27712810

fax 00352/27713810

www.iee.lu < http://www.iee.lu > / [login to unmask email]<mailto:[login to unmask email]>



This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Philip Sevetson

Re: db2 fast data copy tools
(in response to Philip Sevetson)
Zhang,
I have a couple of links for you, and you should talk to the CA, BMC, and IBM vendor reps for your company as well, about their fast unload/load tools.
http://www.esaigroup.com/products/bcv5.htm
http://www.mainstar.com/busissue/75d2005/


________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools

Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.



________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Peter Suhner

Re: db2 fast data copy tools
(in response to Philip Sevetson)

Zhang, Georg,

Federation and the respective terms (wrapper/server/user mappings/nicknames) are the DB2 LUW view. These types of objects do not exist for DB2 z/OS.

Nevertheless you can interconnect disparate DB2 z/OS subsystems via DDF (Distributed Data Facility), which is a separate Started Task and will make your DB2 accessible from outside via a TCP/IP listener. This will allow you to directly execute SQL on a remote LPAR and as far as you have specified your requirements, I would chime in with Georg and recommend load/insert from a remote cursor.


Regards,
Peter

_______________________
Peter Suhner
[login to unmask email]

Date: Fri, 5 Feb 2010 09:24:03 +0100
From: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools
To: [login to unmask email]









Hi Zhang,

its for free

load from remote cursor

by defining for example the destination server as a federated server
and then

create server / wrapper / nicknames / user mapping

Greeting

Georg

On 05-Feb-2010 02:06, Zhang Ming wrote:



Dear db2 lister,
we are a large data testing center,need copy data between
different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy
process
does anyone know any db2 tools which can be used to copy data
fast
1. target db2 table sometimes need to be added(adding data to
existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.








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







--
IBM certified Database Administrator
Application Developer / SAP Development
IEE S.A.
IT department / Development Team
zone industrielle
L-6468 Echternach
tel. 00352/27712810
fax 00352/27713810
www.iee.lu / [login to unmask email]

This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.








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


_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
https://signup.live.com/signup.aspx?id=60969
_____________________________________________________________________

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

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Rick Weaver

Re: db2 fast data copy tools
(in response to Peter Suhner)
Zhang, going from Segmented to Partitioned in DB2 V8 is going to be harder than a volume or dataset level copy/restore process. You will have to have a Partitioning Key on the target site, and it may be that your current Segmented source does not have a handy key to drive that.

Now if you were in DB2 9 you might (might) be able to go from Segmented to Partition By Growth but that would require some research.

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 9:37 AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Zhang,
I have a couple of links for you, and you should talk to the CA, BMC, and IBM vendor reps for your company as well, about their fast unload/load tools.
http://www.esaigroup.com/products/bcv5.htm
http://www.mainstar.com/busissue/75d2005/


________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools

Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.



________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Philip Sevetson

Re: db2 fast data copy tools
(in response to Rick Weaver)
Rick, my take on what Zhang was talking about was that the subject was moving data quickly between subsystems. You might want to point his salesrep towards a demo of BMC UNLOAD PLUS for DB2 and BMC LOADPLUS for DB2.

--Phil

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 12:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Zhang, going from Segmented to Partitioned in DB2 V8 is going to be harder than a volume or dataset level copy/restore process. You will have to have a Partitioning Key on the target site, and it may be that your current Segmented source does not have a handy key to drive that.

Now if you were in DB2 9 you might (might) be able to go from Segmented to Partition By Growth but that would require some research.

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 9:37 AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Zhang,
I have a couple of links for you, and you should talk to the CA, BMC, and IBM vendor reps for your company as well, about their fast unload/load tools.
http://www.esaigroup.com/products/bcv5.htm
http://www.mainstar.com/busissue/75d2005/


________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools

Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.



________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Rick Weaver

Re: db2 fast data copy tools
(in response to Philip Sevetson)
What a wonderful idea!

Zhang, where are you located and I'll get someone to contact you off list. You can email me at [login to unmask email]<mailto:[login to unmask email]>.

For the CA and IBM folks on the list, no money changed hands between me and Phil. But I hope he makes it to IDUG or IOD this year ;-)

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 1:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Rick, my take on what Zhang was talking about was that the subject was moving data quickly between subsystems. You might want to point his salesrep towards a demo of BMC UNLOAD PLUS for DB2 and BMC LOADPLUS for DB2.

--Phil

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 12:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Zhang, going from Segmented to Partitioned in DB2 V8 is going to be harder than a volume or dataset level copy/restore process. You will have to have a Partitioning Key on the target site, and it may be that your current Segmented source does not have a handy key to drive that.

Now if you were in DB2 9 you might (might) be able to go from Segmented to Partition By Growth but that would require some research.

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 9:37 AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Zhang,
I have a couple of links for you, and you should talk to the CA, BMC, and IBM vendor reps for your company as well, about their fast unload/load tools.
http://www.esaigroup.com/products/bcv5.htm
http://www.mainstar.com/busissue/75d2005/


________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools

Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.



________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Philip Sevetson

Re: db2 fast data copy tools
(in response to Rick Weaver)
If the IBM and CA folks aren't following up on this - I recommended that Zhang get in touch with them - then that would be their failure :-)

However, Rick, I won't be at IDUG or IOD - I'm an hourly paid consultant for a government entity and such are notoriously reluctant to pay for "consultants" to go on "junkets" - I'd have to lose a week of billable time and pay my own way. Raise a glass for me :-)

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 2:28 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

What a wonderful idea!

Zhang, where are you located and I'll get someone to contact you off list. You can email me at [login to unmask email]<mailto:[login to unmask email]>.

For the CA and IBM folks on the list, no money changed hands between me and Phil. But I hope he makes it to IDUG or IOD this year ;-)

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 1:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Rick, my take on what Zhang was talking about was that the subject was moving data quickly between subsystems. You might want to point his salesrep towards a demo of BMC UNLOAD PLUS for DB2 and BMC LOADPLUS for DB2.

--Phil

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 12:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Zhang, going from Segmented to Partitioned in DB2 V8 is going to be harder than a volume or dataset level copy/restore process. You will have to have a Partitioning Key on the target site, and it may be that your current Segmented source does not have a handy key to drive that.

Now if you were in DB2 9 you might (might) be able to go from Segmented to Partition By Growth but that would require some research.

Rick Weaver
DB2 z/OS Product Manager
BMC Software

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 9:37 AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools

Zhang,
I have a couple of links for you, and you should talk to the CA, BMC, and IBM vendor reps for your company as well, about their fast unload/load tools.
http://www.esaigroup.com/products/bcv5.htm
http://www.mainstar.com/busissue/75d2005/


________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools

Dear db2 lister,
we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.
we need to buy some tools to easy and enhance our db2 data copy process
does anyone know any db2 tools which can be used to copy data fast
1. target db2 table sometimes need to be added(adding data to existing target table)
2. copy data from segment tablespace to partition tablespace.
Thanks.



________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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 >

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < 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/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Steen Rasmussen

Re: db2 fast data copy tools
(in response to Philip Sevetson)
Zhang - there are a couple of possible solutions from CA. Which one is the most suitable depends on the objects, what kind of outage and HW in place. Please feel free to contact me off the list and I can give you a call to discuss. I will be out of office the next week, but will respond asap.

Steen Rasmussen
CA
Steen

________________________________

From: IDUG DB2-L <[login to unmask email]>
To: [login to unmask email] <[login to unmask email]>
Sent: Fri Feb 05 15:06:58 2010
Subject: Re: [DB2-L] db2 fast data copy tools



If the IBM and CA folks aren’t following up on this – I recommended that Zhang get in touch with them – then that would be their failure :-)



However, Rick, I won’t be at IDUG or IOD – I’m an hourly paid consultant for a government entity and such are notoriously reluctant to pay for “consultants” to go on “junkets” – I’d have to lose a week of billable time and pay my own way. Raise a glass for me :-)



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 2:28 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



What a wonderful idea!



Zhang, where are you located and I’ll get someone to contact you off list. You can email me at [login to unmask email]



For the CA and IBM folks on the list, no money changed hands between me and Phil. But I hope he makes it to IDUG or IOD this year ;-)



Rick Weaver

DB2 z/OS Product Manager

BMC Software



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 1:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



Rick, my take on what Zhang was talking about was that the subject was moving data quickly between subsystems. You might want to point his salesrep towards a demo of BMC UNLOAD PLUS for DB2 and BMC LOADPLUS for DB2.



--Phil



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 12:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



Zhang, going from Segmented to Partitioned in DB2 V8 is going to be harder than a volume or dataset level copy/restore process. You will have to have a Partitioning Key on the target site, and it may be that your current Segmented source does not have a handy key to drive that.



Now if you were in DB2 9 you might (might) be able to go from Segmented to Partition By Growth but that would require some research.



Rick Weaver

DB2 z/OS Product Manager

BMC Software



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, February 05, 2010 9:37 AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



Zhang,

I have a couple of links for you, and you should talk to the CA, BMC, and IBM vendor reps for your company as well, about their fast unload/load tools.

http://www.esaigroup.com/products/bcv5.htm

http://www.mainstar.com/busissue/75d2005/





________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools



Dear db2 lister,

we are a large data testing center,need copy data between different lpars under z/os 1.9 and db2 v8.

we need to buy some tools to easy and enhance our db2 data copy process

does anyone know any db2 tools which can be used to copy data fast

1. target db2 table sometimes need to be added(adding data to existing target table)

2. copy data from segment tablespace to partition tablespace.

Thanks.







________________________________

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

Aurora Dell'Anno

Re: db2 fast data copy tools
(in response to Steen Rasmussen)
Zhang Ming,

there are a number of vendors that offer Data copy and migration tools
for the purposes that you mention and data warehousing - if you may be
interested in hearing more about our tools (CA), please feel free to
contact me offline, or call your local friendly CA Rep to come and visit
you.


Thanks.


Aurora


Aurora Emanuela Dell'Anno
CA
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
[login to unmask email]
<mailto:[login to unmask email]>
http://www.ca.com/


P please don't print this e-mail unless you really need to!









________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools



Dear db2 lister,

we are a large data testing center,need copy data between different
lpars under z/os 1.9 and db2 v8.

we need to buy some tools to easy and enhance our db2 data copy process

does anyone know any db2 tools which can be used to copy data fast

1. target db2 table sometimes need to be added(adding data to existing
target table)

2. copy data from segment tablespace to partition tablespace.

Thanks.






________________________________

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/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Aurora Dell'Anno

Re: db2 fast data copy tools
(in response to Aurora Dell'Anno)
we certain ARE following this, guys, and I thank you for mentioning CA
among the competitors in your first email :-)

I'll put a CA DB2 9 Catalog tables poster in the post for you if you
want ;-)


Thanks.


Aurora


Aurora Emanuela Dell'Anno
CA
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
[login to unmask email]
<mailto:[login to unmask email]>
http://www.ca.com/


P please don't print this e-mail unless you really need to!





________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: 05 February 2010 20:07
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



If the IBM and CA folks aren't following up on this - I recommended that
Zhang get in touch with them - then that would be their failure :-)



However, Rick, I won't be at IDUG or IOD - I'm an hourly paid consultant
for a government entity and such are notoriously reluctant to pay for
"consultants" to go on "junkets" - I'd have to lose a week of billable
time and pay my own way. Raise a glass for me :-)



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 2:28 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



What a wonderful idea!



Zhang, where are you located and I'll get someone to contact you off
list. You can email me at [login to unmask email]



For the CA and IBM folks on the list, no money changed hands between me
and Phil. But I hope he makes it to IDUG or IOD this year ;-)



Rick Weaver

DB2 z/OS Product Manager

BMC Software



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Friday, February 05, 2010 1:06 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



Rick, my take on what Zhang was talking about was that the subject was
moving data quickly between subsystems. You might want to point his
salesrep towards a demo of BMC UNLOAD PLUS for DB2 and BMC LOADPLUS for
DB2.



--Phil



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Weaver, Rick
Sent: Friday, February 05, 2010 12:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



Zhang, going from Segmented to Partitioned in DB2 V8 is going to be
harder than a volume or dataset level copy/restore process. You will
have to have a Partitioning Key on the target site, and it may be that
your current Segmented source does not have a handy key to drive that.



Now if you were in DB2 9 you might (might) be able to go from Segmented
to Partition By Growth but that would require some research.



Rick Weaver

DB2 z/OS Product Manager

BMC Software



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Friday, February 05, 2010 9:37 AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy tools



Zhang,

I have a couple of links for you, and you should talk to the CA, BMC,
and IBM vendor reps for your company as well, about their fast
unload/load tools.

http://www.esaigroup.com/products/bcv5.htm

http://www.mainstar.com/busissue/75d2005/





________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy tools



Dear db2 lister,

we are a large data testing center,need copy data between different
lpars under z/os 1.9 and db2 v8.

we need to buy some tools to easy and enhance our db2 data copy process

does anyone know any db2 tools which can be used to copy data fast

1. target db2 table sometimes need to be added(adding data to existing
target table)

2. copy data from segment tablespace to partition tablespace.

Thanks.







________________________________

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 - 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 - 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 - 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 - 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 - 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/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Edward Long

Re: db2 fast data copy tools
(in response to Aurora Dell'Anno)
At our most recent New England DB2 User's group planning session, we tentatively settled on this very topic for our September Tools Fair.
Given the combination of escalated testing demands, SOX, data warehousing and DR, data copy or data movement generally remains a potent cost and process challenge.
Any vendors who have products that lower cost, improve the process, or generally make life easier for DBA's tasked with moving large amounts of data, who would like to reach most every DB2 shop in New England and beyond, please contact me at [login to unmask email]
More to come.

Edward Long




________________________________
From: "Dell'Anno, Aurora" <[login to unmask email]>
To: [login to unmask email]
Sent: Sat, February 6, 2010 11:42:02 AM
Subject: Re: [DB2-L] db2 fast data copy tools


we certain ARE following this, guys, and I thank you for
mentioning CA among the competitors in your first email :-)

I'll put a CA DB2 9 Catalog tables poster in the post for
you if you want
;-)

Thanks.

Aurora

Aurora Emanuela
Dell'Anno
CA
Sr.
Engineering Services Architect
Tel: +44 (0)1753 577
733
Mobile: +44 (0)7768 235 339
[login to unmask email]

http://www.ca.com/

P please
don't print this e-mail unless you really need to!




________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: 05 February 2010
20:07
To: [login to unmask email]
Subject: Re: [DB2-L] db2
fast data copy tools


If the IBM and CA folks
aren’t following up on this – I recommended that Zhang get in touch with them –
then that would be their failure :-)

However, Rick, I won’t
be at IDUG or IOD – I’m an hourly paid consultant for a government entity and
such are notoriously reluctant to pay for “consultants” to go on “junkets” – I’d
have to lose a week of billable time and pay my own way. Raise a glass for
me :-)


________________________________

From:IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Weaver, Rick
Sent: Friday, February 05, 2010 2:28
PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools

What a wonderful
idea!

Zhang, where are
you located and I’ll get someone to contact you off list. You can email me at [login to unmask email]

For the CA and IBM
folks on the list, no money changed hands between me and Phil. But I hope he
makes it to IDUG or IOD this year ;-)

Rick
Weaver
DB2 z/OS Product
Manager
BMC
Software

From:IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Sevetson, Phil
Sent: Friday, February 05, 2010 1:06
PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools

Rick, my take on what
Zhang was talking about was that the subject was moving data quickly between
subsystems. You might want to point his salesrep towards a demo of BMC
UNLOAD PLUS for DB2 and BMC LOADPLUS for DB2.

--Phil


________________________________

From:IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Weaver, Rick
Sent: Friday, February 05, 2010 12:17
PM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools

Zhang, going from
Segmented to Partitioned in DB2 V8 is going to be harder than a volume or
dataset level copy/restore process. You will have to have a Partitioning Key on
the target site, and it may be that your current Segmented source does not have
a handy key to drive that.

Now if you were in
DB2 9 you might (might) be able to go from Segmented to Partition By Growth but
that would require some research.

Rick
Weaver
DB2 z/OS Product
Manager
BMC
Software

From:IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Sevetson, Phil
Sent: Friday, February 05, 2010 9:37
AM
To: [login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools

Zhang,
I have a couple of
links for you, and you should talk to the CA, BMC, and IBM vendor reps for your
company as well, about their fast unload/load
tools.
http://www.esaigroup.com/products/bcv5.htm
http://www.mainstar.com/busissue/75d2005/



________________________________

From:IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Zhang Ming
Sent: Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy
tools

Dear db2 lister,
we are a large data testing center,need copy data
between different lpars under z/os 1.9 and db2
v8.
we need to buy some tools to easy and enhance our db2
data copy process
does anyone know any db2 tools which can be used to copy
data fast
1. target db2 table sometimes need to be added(adding
data to existing target table)
2. copy data from segment tablespace to partition
tablespace.
Thanks.




________________________________

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.


________________________________

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

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

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 * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Ram Nagasuri

Re: db2 fast data copy tools
(in response to Edward Long)
Hello Aurora,

I had poster of DB2 UDB LUW 8.2 but unable to get the latest version.
Is there a way that we can get the latest one (V9.7)?

Thank you,
-Ram


--- On Sat, 2/6/10, Dell'Anno, Aurora <[login to unmask email]> wrote:

From: Dell'Anno, Aurora <[login to unmask email]>
Subject: Re: [DB2-L] db2 fast data copy tools
To: [login to unmask email]
Date: Saturday, February 6, 2010, 11:42 AM








we certain ARE following this, guys, and I thank you for
mentioning CA among the competitors in your first email :-)
 
I'll put a CA DB2 9 Catalog tables poster in the post for
you if you want
;-)

Thanks.
 
Aurora



Aurora Emanuela
Dell'Anno
CA
Sr.
Engineering Services Architect
Tel:      +44 (0)1753 577
733
Mobile:  +44 (0)7768 235 339
[login to unmask email]

http://www.ca.com/
 
P please
don't print this e-mail unless you really need to!




 



From: IDUG DB2-L [mailto:[login to unmask email]
On Behalf Of Sevetson, Phil
Sent: 05 February 2010
20:07
To: [login to unmask email]
Subject: Re: [DB2-L] db2
fast data copy tools




If the IBM and CA folks
aren’t following up on this – I recommended that Zhang get in touch with them –
then that would be their failure :-) 
 
However, Rick, I won’t
be at IDUG or IOD – I’m an hourly paid consultant for a government entity and
such are notoriously reluctant to pay for “consultants” to go on “junkets” – I’d
have to lose a week of billable time and pay my own way.  Raise a glass for
me :-)
 




From: IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Weaver, Rick
Sent: Friday, February 05, 2010 2:28
PM
To:
[login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools
 
What a wonderful
idea!
 
Zhang, where are
you located and I’ll get someone to contact you off list. You can email me at [login to unmask email]

 
For the CA and IBM
folks on the list, no money changed hands between me and Phil. But I hope he
makes it to IDUG or IOD this year ;-)
 

Rick
Weaver
DB2 z/OS Product
Manager
BMC
Software
 


From: IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Sevetson, Phil
Sent: Friday, February 05, 2010 1:06
PM
To:
[login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools
 
Rick, my take on what
Zhang was talking about was that the subject was moving data quickly between
subsystems.  You might want to point his salesrep towards a demo of BMC
UNLOAD PLUS for DB2 and BMC LOADPLUS for DB2.
 
--Phil
 




From: IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Weaver, Rick
Sent: Friday, February 05, 2010 12:17
PM
To:
[login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools
 
Zhang, going from
Segmented to Partitioned in DB2 V8 is going to be harder than a volume or
dataset level copy/restore process. You will have to have a Partitioning Key on
the target site, and it may be that your current Segmented source does not have
a handy key to drive that.
 
Now if you were in
DB2 9 you might (might) be able to go from Segmented to Partition By Growth but
that would require some research.
 

Rick
Weaver
DB2 z/OS Product
Manager
BMC
Software
 


From: IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Sevetson, Phil
Sent: Friday, February 05, 2010 9:37
AM
To:
[login to unmask email]
Subject: Re: [DB2-L] db2 fast data copy
tools
 
Zhang,
I have a couple of
links for you, and you should talk to the CA, BMC, and IBM vendor reps for your
company as well, about their fast unload/load
tools.
http://www.esaigroup.com/products/bcv5.htm
http://www.mainstar.com/busissue/75d2005/
 
 




From: IDUG
DB2-L [mailto:[login to unmask email] On Behalf
Of Zhang Ming
Sent:
Thursday, February 04, 2010 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] db2 fast data copy
tools
 


Dear db2 lister,

we are a large data testing center,need copy data
between different lpars under z/os 1.9 and db2
v8.

we need to buy some tools to easy and enhance our db2
data copy process

does anyone know any db2 tools which can be used to copy
data fast

1. target db2 table sometimes need to be added(adding
data to existing target table)

2. copy data from segment tablespace to partition
tablespace.

Thanks.

 
 
 




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.

 




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.





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.





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 * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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