Data Propagator Tablespaces Backups

Christine Keeling

Data Propagator Tablespaces Backups
Data Propagator is being used at this location and as the new DBA I
noticed that this product generated many tablespaces. I need to know if
all these tablespaces generated by this product need to backup? There is
over a 100 spaces generated with for databases PR01 AND DSNDB04.

The concern here is if we would lose any of these many spaces' information
the Data Propagator would not run causing the mill up-load of data to the
mainframe to stop.

I would greatly appreciate any information or sources to review, before we
start this hugh task

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

Frank Crissy

Re: Data Propagator Tablespaces Backups
(in response to Christine Keeling)
You can control the number of tablespaces and where they are created by
using the custom selection in replication center to tell the product
when it generates the DDL where the objects should go. You should also
create a separate database for all the replication control tables. Back
this database up just like you would any other production database. The
data contained in these tables are critical for replication to function
and not corrupt your target data.

Hope this helps


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Chris Keeling
Sent: Friday, December 15, 2006 7:12 AM
To: [login to unmask email]
Subject: [DB2-L] Data Propagator Tablespaces Backups


Data Propagator is being used at this location and as the new DBA I
noticed that this product generated many tablespaces. I need to know if
all these tablespaces generated by this product need to backup? There
is
over a 100 spaces generated with for databases PR01 AND DSNDB04.

The concern here is if we would lose any of these many spaces'
information
the Data Propagator would not run causing the mill up-load of data to
the
mainframe to stop.

I would greatly appreciate any information or sources to review, before
we
start this hugh task

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

Tim R Ohling

Re: Data Propagator Tablespaces Backups
(in response to Frank Crissy)
I'll second this and add that the backup and recovery of all platforms
(e.g. Source, middle tier Websphere Info Integrator / Replication
Edition if you have that, and target) need to be coordinated. We've had
a couple of "oops's" and the effort to recovery and re-sync everything
was "non-trivial". Part of that was because a manual refresh of the
targets is not an option for us due to the pseudo-warehouse
architecture.

Tim

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Crissy, Frank
Sent: Friday, December 15, 2006 5:39 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Data Propagator Tablespaces Backups

You can control the number of tablespaces and where they are created by
using the custom selection in replication center to tell the product
when it generates the DDL where the objects should go. You should also
create a separate database for all the replication control tables. Back
this database up just like you would any other production database. The
data contained in these tables are critical for replication to function
and not corrupt your target data.

Hope this helps


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Chris Keeling
Sent: Friday, December 15, 2006 7:12 AM
To: [login to unmask email]
Subject: [DB2-L] Data Propagator Tablespaces Backups


Data Propagator is being used at this location and as the new DBA I
noticed that this product generated many tablespaces. I need to know if
all these tablespaces generated by this product need to backup? There
is
over a 100 spaces generated with for databases PR01 AND DSNDB04.

The concern here is if we would lose any of these many spaces'
information
the Data Propagator would not run causing the mill up-load of data to
the
mainframe to stop.

I would greatly appreciate any information or sources to review, before
we
start this hugh task

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