DB2 for z/OS "Microdatabases"

Matthew Crowley

DB2 for z/OS "Microdatabases"
Does anyone know of and have experience with products that would create what I'll call "microdatabases" -- copies of tables and ideally populate them with a subset of data from the full tables? Ideally it could follow and account for foreign keys to know all the tables (and related data) that would be needed to create a logically consistent copy of the tables and subset of data.

We are in a DB2 for z/OS shop so we'd be interested in existence of and experience with products that would work on that platform.

Thanks,
Matt

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Philip Sevetson

Re: DB2 for z/OS "Microdatabases"
(in response to Matthew Crowley)
Matt, be prepared to be piled on -- I mean, solicited -- by vendors.
CA RC/Migrator,
Compuware Fileaid/RDX,
BMC has a product as I recall,
didn't Princeton Softech and their product (Move for DB2, again IIRC-"If I Recall Correctly") get acquired by IBM a few years ago?

Then, of course, there's always Materialized Query Tables in the base product to draw consistent subsets/joins of whatever you need.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Matt Crowley
Sent: Wednesday, February 02, 2011 10:27 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS "Microdatabases"

Does anyone know of and have experience with products that would create what I'll call "microdatabases" -- copies of tables and ideally populate them with a subset of data from the full tables? Ideally it could follow and account for foreign keys to know all the tables (and related data) that would be needed to create a logically consistent copy of the tables and subset of data.

We are in a DB2 for z/OS shop so we'd be interested in existence of and experience with products that would work on that platform.

Thanks,
Matt

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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