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

Jim McAlpine

Re: DB2 for z/OS - copying databases for development and test
(in response to Jim McAlpine)
James,

We are currently running the z/OS 1.4 Summer ADCD which allegedly has both the Admin Tool and the Object Comparison Tool.

Any idea what the dataset names would be called for these datasets.

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:

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

Jim McAlpine

[DB2-L] DB2 for z/OS - copying databases for development and test
It's OK, I've found them. Admin Tool - ADB, Object Comparison Tool - GOC.

Jim McAlpine

-----Original Message-----
From: Jim McAlpine
Sent: 08 December 2006 16:09
To: 'DB2 Database Discussion list at IDUG'
Subject: RE: [DB2-L] DB2 for z/OS - copying databases for development
and test


James,

We are currently running the z/OS 1.4 Summer ADCD which allegedly has both the Admin Tool and the Object Comparison Tool.

Any idea what the dataset names would be called for these datasets.

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:

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