[FLUFF] DB2 for z/OS "Microdatabases"

Raymond Bell

[FLUFF] DB2 for z/OS "Microdatabases"
<snip>'...be prepared to be... solicited by vendors...' </snip>

My knowledge of US law is slim at the best, but isn't that a Federal offence? ;o)

Rock on, Friday.


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: 02 February 2011 15:43
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS "Microdatabases"

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

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

Steen Rasmussen

Re: DB2 for z/OS "Microdatabases"
(in response to Raymond Bell)
I probably should put AD on the subject line, but since Mr. Phil Sevetson already mentioned the products, I just want to add a minor note.

If you want to copy RI-related (whether this is DB2 RI or user defined RI), you can look at CA RC/Extract, FileAid/RDX from Compuware - and like Phil mentioned - Princeton was acquired by IBM a few years ago and the product was renamed to Optim (there are more vendors out there).

If you don't care about RI - there are many more options to copy subset of data. If you're really on the hunt - it could be worthwhile to ask your preferred vendors what they can offer based on your requirements.

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Matt Crowley
Sent: Wednesday, February 02, 2011 9: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

Philip Sevetson

Re: [FLUFF] DB2 for z/OS "Microdatabases"
(in response to Steen Rasmussen)
Raymond: **THWAP** it's Wednesday.

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

<snip>'...be prepared to be... solicited by vendors...' </snip>

My knowledge of US law is slim at the best, but isn't that a Federal offence? ;o)

Rock on, Friday.


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: 02 February 2011 15:43
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS "Microdatabases"

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

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

Robert Galambos

Re: DB2 for z/OS "Microdatabases"
(in response to Philip Sevetson)
I 'resemble' this ;-)



The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Wednesday, February 02, 2011 10:43 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS "Microdatabases"

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

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