DB2 for z/OS - copying databases for development and test

Jim McAlpine

DB2 for z/OS - copying databases for development and test
We have a Flex-ES system for z/OS development. The system includes 5 x DB2 Version 7 subsystems, each with 4 or 5 instances of our application for differing levels of support and development purposes. Each application development/support system has 2000+ tablespaces and each tablespace contains a single table. When a new system is required, it is typically built from scratch with just a base set of data and the data is then added to manually which is obviously time consuming. We would like to be able to copy an instance of our application and rename it and include all the DB2 objects so that the new system contains all the data from an existing system. Is there an "easy" way to accomplish this. For instance, if we have subsystem DB2A which contains application system TEST1, can we copy TEST1 and call it TEST2 either into DB2A or another subsystem DB2B.

Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856

CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com


This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst CedarOpenAccounts
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. CedarOpenAccounts grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.

CedarOpenAccounts is a trading name of Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products,
please visit our web site at http://www.cedaropenaccounts.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ray Williams

Re: DB2 for z/OS - copying databases for development and test
(in response to Jim McAlpine)
Do you have any tools, like CA's RC/Migrator? If so, then you can
"clone" systems very easily. One note though, if you have large amounts
of data in the tables you may want to use RC/Migrator to "clone" your
structure and use the UNLOAD/LOAD utility to move your data as it is
much faster. If the data is really big there are alternatives.



If you don't have a tool it becomes a little more challenging. You can
use SQL & Rexx to "clone" structure and use SQL & REXX to create
Unload/Load JCL. Another option is to use QMF to build everything.
Either one of these options requires significant work to set up
initially but can be used repeatedly. You might want to check "IDUG
CODE SOURCE" for these tools it will save you time.



Hope this helps





Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jim McAlpine
Sent: Tuesday, December 05, 2006 8:49 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS - copying databases for development and
test



We have a Flex-ES system for z/OS development. The system includes 5 x
DB2 Version 7 subsystems, each with 4 or 5 instances of our application
for differing levels of support and development purposes. Each
application development/support system has 2000+ tablespaces and each
tablespace contains a single table. When a new system is required, it
is typically built from scratch with just a base set of data and the
data is then added to manually which is obviously time consuming. We
would like to be able to copy an instance of our application and rename
it and include all the DB2 objects so that the new system contains all
the data from an existing system. Is there an "easy" way to accomplish
this. For instance, if we have subsystem DB2A which contains
application system TEST1, can we copy TEST1 and call it TEST2 either
into DB2A or another subsystem DB2B.

Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856

CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com

________________________________

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. Any unauthorised distribution or copying is strictly
prohibited. Whilst CedarOpenAccounts takes steps to prevent the
transmission of viruses via e-mail, we cannot guarantee that any email
or attachment is free from computer viruses and you are strongly advised
to undertake your own anti-virus precautions. CedarOpenAccounts grants
no warranties regarding performance, use or quality of any e-mail or
attachment and undertakes no liability for loss or damage, howsoever
caused.

CedarOpenAccounts is a trading name for Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products, please visit
our web site at http://www.cedaropenaccounts.com

________________________________



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steen Rasmussen

Re: DB2 for z/OS - copying databases for development and test
(in response to Ray Williams)


Thank you Ray - one additional note (I don't know if you are aware of
it). Instead of doing UNLOAD/LOAD - RC/Migrator has another option which
eliminates the need for unload/load. Use option M(erger) instead of
A(nalysis), and the VSAM datasets will be renamed or copied which really
will speed up the process.



Please feel free to contact me offline if you have additional questions
to the MERGER component.



Steen Rasmussen
CA
Senior Consultant DB2 tools

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

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

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Williams, Ray [WHQKO]
Sent: Tuesday, December 05, 2006 9:47 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development
and test



Do you have any tools, like CA's RC/Migrator? If so, then you can
"clone" systems very easily. One note though, if you have large amounts
of data in the tables you may want to use RC/Migrator to "clone" your
structure and use the UNLOAD/LOAD utility to move your data as it is
much faster. If the data is really big there are alternatives.



If you don't have a tool it becomes a little more challenging. You can
use SQL & Rexx to "clone" structure and use SQL & REXX to create
Unload/Load JCL. Another option is to use QMF to build everything.
Either one of these options requires significant work to set up
initially but can be used repeatedly. You might want to check "IDUG
CODE SOURCE" for these tools it will save you time.



Hope this helps





Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim McAlpine

Re: DB2 for z/OS - copying databases for development and test
(in response to Steen Rasmussen)
The only tools we have are the following which I know little about -

5655-L88 IBM DB2 Info Integ Replication V08.02.00 HAAW821

5655-L88 IBM DB2 Replication Common Library V08.02.00 HAAW820

5655-L88 IBM DB2 DataPropagator V08.02.00 HAAW822

We don't have large amounts of data, but do have 2000+ tablespaces per application instance.

I'll check IDUG.

Thanks

Jim McAlpine

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Williams, Ray [WHQKO]
Sent: 05 December 2006 15:47
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development and test



Do you have any tools, like CA's RC/Migrator? If so, then you can "clone" systems very easily. One note though, if you have large amounts of data in the tables you may want to use RC/Migrator to "clone" your structure and use the UNLOAD/LOAD utility to move your data as it is much faster. If the data is really big there are alternatives.



If you don't have a tool it becomes a little more challenging. You can use SQL & Rexx to "clone" structure and use SQL & REXX to create Unload/Load JCL. Another option is to use QMF to build everything. Either one of these options requires significant work to set up initially but can be used repeatedly. You might want to check "IDUG CODE SOURCE" for these tools it will save you time.



Hope this helps





Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359




This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst CedarOpenAccounts
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. CedarOpenAccounts grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.

CedarOpenAccounts is a trading name of Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products,
please visit our web site at http://www.cedaropenaccounts.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: DB2 for z/OS - copying databases for development and test
(in response to Jim McAlpine)
Jim,
You can do a unload/load and select all tables or only selected tables to
get the data to the other db2 system. View: _www.recoveryknowledge.com_
(http://www.recoveryknowledge.com/)

Ed.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jeff Frazier

Re: DB2 for z/OS - copying databases for development and test
(in response to DB2information@AOL.COM)
We use FDRFLASH and a product from Mainstar VCR(Volume Conflict Rename) to
clone our DB2 Peoplesoft subsystems. We have a clone coming up this week
to clone our HRPRD to HRPQA to test tax updates. It takes about 1 1/2
hours to do as we also take care of other setup for the new subsystem
within this job also.
HTH,
Jeff



"Williams, Ray [WHQKO]" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/05/2006 10:47 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] DB2 for z/OS - copying databases for development and test






Do you have any tools, like CA's RC/Migrator? If so, then you can "clone"
systems very easily. One note though, if you have large amounts of data
in the tables you may want to use RC/Migrator to "clone" your structure
and use the UNLOAD/LOAD utility to move your data as it is much faster. If
the data is really big there are alternatives.

If you don't have a tool it becomes a little more challenging. You can
use SQL & Rexx to "clone" structure and use SQL & REXX to create
Unload/Load JCL. Another option is to use QMF to build everything. Either
one of these options requires significant work to set up initially but can
be used repeatedly. You might want to check "IDUG CODE SOURCE" for these
tools it will save you time.

Hope this helps


Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Jim McAlpine
Sent: Tuesday, December 05, 2006 8:49 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS - copying databases for development and test

We have a Flex-ES system for z/OS development. The system includes 5 x
DB2 Version 7 subsystems, each with 4 or 5 instances of our application
for differing levels of support and development purposes. Each
application development/support system has 2000+ tablespaces and each
tablespace contains a single table. When a new system is required, it is
typically built from scratch with just a base set of data and the data is
then added to manually which is obviously time consuming. We would like
to be able to copy an instance of our application and rename it and
include all the DB2 objects so that the new system contains all the data
from an existing system. Is there an "easy" way to accomplish this. For
instance, if we have subsystem DB2A which contains application system
TEST1, can we copy TEST1 and call it TEST2 either into DB2A or another
subsystem DB2B.
Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856
CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Any unauthorised distribution or copying is strictly prohibited. Whilst
CedarOpenAccounts takes steps to prevent the transmission of viruses via
e-mail, we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your own
anti-virus precautions. CedarOpenAccounts grants no warranties regarding
performance, use or quality of any e-mail or attachment and undertakes no
liability for loss or damage, howsoever caused.
CedarOpenAccounts is a trading name for Cedar Software Ltd and
OpenAccounts Ltd.
For more information on CedarOpenAccounts and our products, please visit
our web site at http://www.cedaropenaccounts.com


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

Ray Williams

Re: DB2 for z/OS - copying databases for development and test
(in response to Jeff Frazier)
Thanks for the information, I wasn't aware of this option and will
investigate - It should save time letting RC/Migrator do the work rather
than me. I love automation!!!!



One question . . . is the MERGER component part of RC/Migrator or an
add-on component with a separate charge?



Thanks again





Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Rasmussen, Steen
Sent: Tuesday, December 05, 2006 9:59 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development
and test





Thank you Ray - one additional note (I don't know if you are aware of
it). Instead of doing UNLOAD/LOAD - RC/Migrator has another option which
eliminates the need for unload/load. Use option M(erger) instead of
A(nalysis), and the VSAM datasets will be renamed or copied which really
will speed up the process.



Please feel free to contact me offline if you have additional questions
to the MERGER component.



Steen Rasmussen
CA
Senior Consultant DB2 tools

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

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

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Ebert

Re: DB2 for z/OS - copying databases for development and test
(in response to Ray Williams)
You might want to check the "Homogeneous System Copy JCL" on the IDUG
Insider Code Place. This works together with a "snapshot" or "flash copy"
of the original DB2 subsystem.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




Jim McAlpine <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
[DB2-L] DB2 for z/OS - copying databases for development and test





Jim McAlpine <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
05-12-06 15:49


We have a Flex-ES system for z/OS development. The system includes 5 x
DB2 Version 7 subsystems, each with 4 or 5 instances of our application
for differing levels of support and development purposes. Each
application development/support system has 2000+ tablespaces and each
tablespace contains a single table. When a new system is required, it is
typically built from scratch with just a base set of data and the data is
then added to manually which is obviously time consuming. We would like
to be able to copy an instance of our application and rename it and
include all the DB2 objects so that the new system contains all the data
from an existing system. Is there an "easy" way to accomplish this. For
instance, if we have subsystem DB2A which contains application system
TEST1, can we copy TEST1 and call it TEST2 either into DB2A or another
subsystem DB2B.
Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856
CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim McAlpine

Re: DB2 for z/OS - copying databases for development and test
(in response to Michael Ebert)
Thanks, but we do not want to copy the whole DB2 subsystem, but just a complete application set of databases.

Jim McAlpine

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Michael Ebert
Sent: 05 December 2006 16:32
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development and test



You might want to check the "Homogeneous System Copy JCL" on the IDUG Insider Code Place. This works together with a "snapshot" or "flash copy" of the original DB2 subsystem.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




Jim McAlpine <[login to unmask email]>


To
[login to unmask email]

cc

bcc

Subject
[DB2-L] DB2 for z/OS - copying databases for development and test



Jim McAlpine <[login to unmask email]>

Please respond to DB2 Database Discussion list at IDUG <[login to unmask email]>


Sent by: DB2 Data Base Discussion List <[login to unmask email]>
05-12-06 15:49




We have a Flex-ES system for z/OS development. The system includes 5 x DB2 Version 7 subsystems, each with 4 or 5 instances of our application for differing levels of support and development purposes. Each application development/support system has 2000+ tablespaces and each tablespace contains a single table. When a new system is required, it is typically built from scratch with just a base set of data and the data is then added to manually which is obviously time consuming. We would like to be able to copy an instance of our application and rename it and include all the DB2 objects so that the new system contains all the data from an existing system. Is there an "easy" way to accomplish this. For instance, if we have subsystem DB2A which contains application system TEST1, can we copy TEST1 and call it TEST2 either into DB2A or another subsystem DB2B.

Jim McAlpine
Email: [login to unmask email]
Direct Dial: +44 (0)191 4827856


CedarOpenAccounts
PrismTech House
5th Avenue Business Park
Team Valley
Gateshead
Tyne and Wear
NE11 ONG
United Kingdom
Tel 0191 482 7900
Fax 0191 482 7901
www.cedaropenaccounts.com


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst CedarOpenAccounts
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. CedarOpenAccounts grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.

CedarOpenAccounts is a trading name of Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products,
please visit our web site at http://www.cedaropenaccounts.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steen Rasmussen

Re: DB2 for z/OS - copying databases for development and test
(in response to Jim McAlpine)
Hey Ray - it used to be a separate licensed feature, but with r11 and
r11.5 it's "free" as long as you have a license for RC/Migrator.



If you have further questions - please contact me off the list so we
don't spam the rest of the subscribers :-)



Steen Rasmussen
CA
Senior Consultant DB2 tools

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

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

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Williams, Ray [WHQKO]
Sent: Tuesday, December 05, 2006 10:16 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development
and test



Thanks for the information, I wasn't aware of this option and will
investigate - It should save time letting RC/Migrator do the work rather
than me. I love automation!!!!



One question . . . is the MERGER component part of RC/Migrator or an
add-on component with a separate charge?



Thanks again





Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: DB2 for z/OS - copying databases for development and test
(in response to Steen Rasmussen)
Are you running the ADCD package? If so, it comes with the DB2 Admin
Tool. V7.1 of the Admin Tool includes a basic migrate function - just use a
MIG line command against a database. Since Object Comparision is not
included with ADCD, you'll have to manually alter object names after
unloading your data.

James Campbell

On 5 Dec 2006 at 14:49, Jim McAlpine wrote:

>
> We have a Flex-ES system for z/OS development. The system includes 5 x DB2 Version 7
> subsystems, each with 4 or 5 instances of our application for differing levels of support and
> development purposes. Each application development/support system has 2000+ tablespaces
> and each tablespace contains a single table. When a new system is required, it is typically built
> from scratch with just a base set of data and the data is then added to manually which is
> obviously time consuming. We would like to be able to copy an instance of our application and
> rename it and include all the DB2 objects so that the new system contains all the data from an
> existing system. Is there an "easy" way to accomplish this. For instance, if we have subsystem
> DB2A which contains application system TEST1, can we copy TEST1 and call it TEST2 either
> into DB2A or another subsystem DB2B.
> Jim McAlpine
> Email: [login to unmask email]
> Direct Dial: +44 (0)191 4827856
> CedarOpenAccounts
> PrismTech House
> 5th Avenue Business Park
> Team Valley
> Gateshead
> Tyne and Wear
> NE11 ONG
> United Kingdom
> Tel 0191 482 7900
> Fax 0191 482 7901
> www.cedaropenaccounts.com
>
> This email and any files transmitted with it are confidential and intended solely for the use of the
> individual or entity to whom they are addressed. Any unauthorised distribution or copying is strictly
> prohibited. Whilst CedarOpenAccounts takes steps to prevent the transmission of viruses via e-mail, we
> cannot guarantee that any email or attachment is free from computer viruses and you are strongly
> advised to undertake your own anti-virus precautions. CedarOpenAccounts grants no warranties regarding
> performance, use or quality of any e-mail or attachment and undertakes no liability for loss or damage,
> howsoever caused.
> CedarOpenAccounts is a trading name for Cedar Software Ltd and OpenAccounts Ltd.
> For more information on CedarOpenAccounts and our products, please visit our web site at
> http://www.cedaropenaccounts.com
>
>
> --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list.
> To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-
> l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
> [login to unmask email] Find out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim McAlpine

Re: DB2 for z/OS - copying databases for development and test
(in response to James Campbell)
James, thanks for that. We are indeed running the ADCD so I'll check out the Admin Tool. Since I'm not a DBA, could you please elaborate on "manually alter object names after unloading your data".

Jim McAlpine

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of James Campbell
Sent: 06 December 2006 00:35
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development
and test


Are you running the ADCD package? If so, it comes with the DB2 Admin
Tool. V7.1 of the Admin Tool includes a basic migrate function - just use a
MIG line command against a database. Since Object Comparision is not
included with ADCD, you'll have to manually alter object names after
unloading your data.

James Campbell

On 5 Dec 2006 at 14:49, Jim McAlpine wrote:

>
> We have a Flex-ES system for z/OS development. The system includes 5 x DB2 Version 7
> subsystems, each with 4 or 5 instances of our application for differing levels of support and
> development purposes. Each application development/support system has 2000+ tablespaces
> and each tablespace contains a single table. When a new system is required, it is typically built
> from scratch with just a base set of data and the data is then added to manually which is
> obviously time consuming. We would like to be able to copy an instance of our application and
> rename it and include all the DB2 objects so that the new system contains all the data from an
> existing system. Is there an "easy" way to accomplish this. For instance, if we have subsystem
> DB2A which contains application system TEST1, can we copy TEST1 and call it TEST2 either
> into DB2A or another subsystem DB2B.
> Jim McAlpine
> Email: [login to unmask email]
> Direct Dial: +44 (0)191 4827856
> CedarOpenAccounts
> PrismTech House
> 5th Avenue Business Park
> Team Valley
> Gateshead
> Tyne and Wear
> NE11 ONG
> United Kingdom
> Tel 0191 482 7900
> Fax 0191 482 7901
> www.cedaropenaccounts.com
>
> This email and any files transmitted with it are confidential and intended solely for the use of the
> individual or entity to whom they are addressed. Any unauthorised distribution or copying is strictly
> prohibited. Whilst CedarOpenAccounts takes steps to prevent the transmission of viruses via e-mail, we
> cannot guarantee that any email or attachment is free from computer viruses and you are strongly
> advised to undertake your own anti-virus precautions. CedarOpenAccounts grants no warranties regarding
> performance, use or quality of any e-mail or attachment and undertakes no liability for loss or damage,
> howsoever caused.
> CedarOpenAccounts is a trading name for Cedar Software Ltd and OpenAccounts Ltd.
> For more information on CedarOpenAccounts and our products, please visit our web site at
> http://www.cedaropenaccounts.com
>
>
> --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list.
> To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-
> l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
> [login to unmask email] Find out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst CedarOpenAccounts
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. CedarOpenAccounts grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.

CedarOpenAccounts is a trading name of Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products,
please visit our web site at http://www.cedaropenaccounts.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: DB2 for z/OS - copying databases for development and test
(in response to Jim McAlpine)
The process generates an unload from, and reload into, TEST1 (or whatever database and
creator names you use). The Control statements to do the reload are generated during the
UNLOAD phase, and hence also reload into TEST1. So you'll need to ensure that you
change the reload control statements *after* the unload.

James Campbell

On 6 Dec 2006 at 9:23, Jim McAlpine wrote:

> James, thanks for that. We are indeed running the ADCD so I'll check out the Admin Tool. Since I'm not a DBA, could you please elaborate on "manually alter object names after unloading your data".
>
> Jim McAlpine
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of James Campbell
> Sent: 06 December 2006 00:35
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development
> and test
>
>
> Are you running the ADCD package? If so, it comes with the DB2 Admin
> Tool. V7.1 of the Admin Tool includes a basic migrate function - just use a
> MIG line command against a database. Since Object Comparision is not
> included with ADCD, you'll have to manually alter object names after
> unloading your data.
>
> James Campbell
>
> On 5 Dec 2006 at 14:49, Jim McAlpine wrote:
>
> >
> > We have a Flex-ES system for z/OS development. The system includes 5 x DB2 Version 7
> > subsystems, each with 4 or 5 instances of our application for differing levels of support and
> > development purposes. Each application development/support system has 2000+ tablespaces
> > and each tablespace contains a single table. When a new system is required, it is typically built
> > from scratch with just a base set of data and the data is then added to manually which is
> > obviously time consuming. We would like to be able to copy an instance of our application and
> > rename it and include all the DB2 objects so that the new system contains all the data from an
> > existing system. Is there an "easy" way to accomplish this. For instance, if we have subsystem
> > DB2A which contains application system TEST1, can we copy TEST1 and call it TEST2 either
> > into DB2A or another subsystem DB2B.
> > Jim McAlpine
> > Email: [login to unmask email]
> > Direct Dial: +44 (0)191 4827856
> > CedarOpenAccounts
> > PrismTech House
> > 5th Avenue Business Park
> > Team Valley
> > Gateshead
> > Tyne and Wear
> > NE11 ONG
> > United Kingdom
> > Tel 0191 482 7900
> > Fax 0191 482 7901
> > www.cedaropenaccounts.com
> >
> > This email and any files transmitted with it are confidential and intended solely for the use of the
> > individual or entity to whom they are addressed. Any unauthorised distribution or copying is strictly
> > prohibited. Whilst CedarOpenAccounts takes steps to prevent the transmission of viruses via e-mail, we
> > cannot guarantee that any email or attachment is free from computer viruses and you are strongly
> > advised to undertake your own anti-virus precautions. CedarOpenAccounts grants no warranties regarding
> > performance, use or quality of any e-mail or attachment and undertakes no liability for loss or damage,
> > howsoever caused.
> > CedarOpenAccounts is a trading name for Cedar Software Ltd and OpenAccounts Ltd.
> > For more information on CedarOpenAccounts and our products, please visit our web site at
> > http://www.cedaropenaccounts.com
> >
> >
> > --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list.
> > To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-
> > l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
> > http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
> > [login to unmask email] Find out the latest on IDUG conferences at
> > http://conferences.idug.org/index.cfm
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to
> whom they are addressed. Any unauthorised distribution or
> copying is strictly prohibited. Whilst CedarOpenAccounts
> takes steps to prevent the transmission of viruses via e-mail,
> we cannot guarantee that any email or attachment is free from
> computer viruses and you are strongly advised to undertake your
> own anti-virus precautions. CedarOpenAccounts grants no
> warranties regarding performance, use or quality of any e-mail
> or attachment and undertakes no liability for loss or damage,
> howsoever caused.
>
> CedarOpenAccounts is a trading name of Cedar Software Ltd and
> OpenAccounts Ltd.
>
> For more information on CedarOpenAccounts and our products,
> please visit our web site at http://www.cedaropenaccounts.com
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim McAlpine

Re: DB2 for z/OS - copying databases for development and test
(in response to James Campbell)
Excellent, thanks again.

Jim McAlpine

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of James Campbell
Sent: 07 December 2006 05:16
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS - copying databases for development
and test


The process generates an unload from, and reload into, TEST1 (or whatever database and
creator names you use). The Control statements to do the reload are generated during the
UNLOAD phase, and hence also reload into TEST1. So you'll need to ensure that you
change the reload control statements *after* the unload.

James Campbell

On 6 Dec 2006 at 9:23, Jim McAlpine wrote:

This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst CedarOpenAccounts
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. CedarOpenAccounts grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.

CedarOpenAccounts is a trading name of Cedar Software Ltd and
OpenAccounts Ltd.

For more information on CedarOpenAccounts and our products,
please visit our web site at http://www.cedaropenaccounts.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm