VSAM KSDS conversion to DB2 V7.1 for z/OS

Doug Prather

VSAM KSDS conversion to DB2 V7.1 for z/OS
I was wondering if anyone knew of a utility to convert VSAM KSDS datasets
to DB2. Any help would be appreciated.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Mark Granger

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Doug Prather)
Doug,

See http://www.2bdb2.com .

2BDB2/VSAM has the option to run as a Transparency so that existing
VSAM calls are directed to DB2.

I think the Data Conversion Utilities are able to be Licensed
separately if you don't want the Transparency.

All the contact details are available there or e-mail me direct and
I'll send your details on.

Mark Granger


----- Original Message -----
From: "Prather, Doug, ISD" <[login to unmask email]>
Date: Wednesday, December 10, 2003 1:14 pm
Subject: VSAM KSDS conversion to DB2 V7.1 for z/OS

> I was wondering if anyone knew of a utility to convert VSAM KSDS
> datasetsto DB2. Any help would be appreciated.
>
> -------------------------------------------------------------------
> --------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives
> and home page at http://www.idugdb2-l.or From that page select
> "Join or Leave the list". If you will be out of the office, send
> the SET DB2-L NO MAIL command to [login to unmask email] The
> IDUG List Admins can be reached at [login to unmask email]
> l.org. Find out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm

---------------------------------------------------------------------
Waiting for that important email, but not in the office!
Get SMS alerts: http://www.mbox.com.au/smsservice.html

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Philip Sevetson

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Mark Granger)
REPRO to a flat file, followed by a DB2 LOAD statement. Unless you're
talking about taking the file COPYLIBs and making DDL out of them?

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]






"Prather, Doug, ISD" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/10/2003 12:14 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: VSAM KSDS conversion to DB2 V7.1 for z/OS


I was wondering if anyone knew of a utility to convert VSAM KSDS datasets
to DB2. Any help would be appreciated.

---------------------------------------------------------------------------------
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". If you will be out of
the office, send the SET DB2-L NO MAIL command to
[login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Phil Grainger

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Philip Sevetson)
Be aware that if you just convert an application from VSAM to DB2 and DON'T re-engineer to take advantage of DB2, or take advantage of SQL your performance is likely to be worse than it was with VSAM....

As an aside, why ARE you converting??

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Prather, Doug, ISD
Sent: Wednesday, December 10, 2003 5:15 PM
To: [login to unmask email]
Subject: VSAM KSDS conversion to DB2 V7.1 for z/OS


I was wondering if anyone knew of a utility to convert VSAM KSDS datasets
to DB2. Any help would be appreciated.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Doug Prather

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Phil Grainger)
Thanks Phil,
We have an app that wants to convert their VSAM / CICS up to DB2 for
more management. We will be doing data modeling. The best approach
I've seen so far is to do a repro unload and then selectively load the
data columns to the modeled DB2 Database. I was just interested if
there was any utility to convert from VSAM to DB2.



Doug Prather
4101 Wiseman
San Antonio, TX 78251
210-543-6742


-----Original Message-----
From: Grainger, Phil [mailto:[login to unmask email]
Sent: Wednesday, December 10, 2003 12:08 PM
To: [login to unmask email]
Subject: Re: VSAM KSDS conversion to DB2 V7.1 for z/OS

Be aware that if you just convert an application from VSAM to DB2 and
DON'T re-engineer to take advantage of DB2, or take advantage of SQL
your performance is likely to be worse than it was with VSAM....

As an aside, why ARE you converting??

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Prather, Doug, ISD
Sent: Wednesday, December 10, 2003 5:15 PM
To: [login to unmask email]
Subject: VSAM KSDS conversion to DB2 V7.1 for z/OS


I was wondering if anyone knew of a utility to convert VSAM KSDS
datasets
to DB2. Any help would be appreciated.

------------------------------------------------------------------------
---------
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". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] 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


*** NOTICE: The source of this e-mail is from the Internet or from a
source outside of World Savings. ***



*****************************************************************************
If you are not the intended recipient of this e-mail, please notify
the sender immediately. The contents of this e-mail do not amend
any existing disclosures or agreements unless expressly stated.
*****************************************************************************

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Phil Grainger

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Doug Prather)
Doug,

CA has a product called InfoRefiner that allows mapping of non-DB2 mainframe data sources and then controls the extraction, conversion, aggregation and loading into DB2 tables

If you need more information, drop me a line off-list, tell me geographically where you are located, and I will get a technician to call you.

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Prather, Doug, ISD
Sent: Wednesday, December 10, 2003 7:24 PM
To: [login to unmask email]
Subject: Re: VSAM KSDS conversion to DB2 V7.1 for z/OS


Thanks Phil,
We have an app that wants to convert their VSAM / CICS up to DB2 for
more management. We will be doing data modeling. The best approach
I've seen so far is to do a repro unload and then selectively load the
data columns to the modeled DB2 Database. I was just interested if
there was any utility to convert from VSAM to DB2.



Doug Prather
4101 Wiseman
San Antonio, TX 78251
210-543-6742


-----Original Message-----
From: Grainger, Phil [mailto:[login to unmask email]
Sent: Wednesday, December 10, 2003 12:08 PM
To: [login to unmask email]
Subject: Re: VSAM KSDS conversion to DB2 V7.1 for z/OS

Be aware that if you just convert an application from VSAM to DB2 and
DON'T re-engineer to take advantage of DB2, or take advantage of SQL
your performance is likely to be worse than it was with VSAM....

As an aside, why ARE you converting??

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Prather, Doug, ISD
Sent: Wednesday, December 10, 2003 5:15 PM
To: [login to unmask email]
Subject: VSAM KSDS conversion to DB2 V7.1 for z/OS


I was wondering if anyone knew of a utility to convert VSAM KSDS
datasets
to DB2. Any help would be appreciated.

------------------------------------------------------------------------
---------
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". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] 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


*** NOTICE: The source of this e-mail is from the Internet or from a
source outside of World Savings. ***



*****************************************************************************
If you are not the intended recipient of this e-mail, please notify
the sender immediately. The contents of this e-mail do not amend
any existing disclosures or agreements unless expressly stated.
*****************************************************************************

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Inc. The Fillmore Group

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Phil Grainger)

Something else to think about on the VSAM KSDS conversion: there are IBM and third-party products which will help you to migrate the data from VSAM to
DB2, but enable application programs to continue to run unmodified. The products use a layer of indirection which intercepts the VSAM I/O call and
translates it into native DB2 SQL. Collectively we call these products "VSAM Transparency".

You can fully normalize the data to take best advantage of a relational database without having to compromise the data model. Why not just change or
rewrite the program? Well, most shops have *lots* of programs and *lots* of VSAM files. If one file is accessed by dozens - if not hundreds - of CICS, batch,
and utility programs and you convert the VSAM files to DB2 all of those programs need to be changed at the same time. On the other hand, with VSAM
Transparency, you focus on the core transaction and nightly batch programs while the weekly, monthly, yearly, and on-demand applications run without
having to be changed or even tested. You can shorten your migration effort by a couple of orders of magnitude.

I have presented on VSAM Transparency at users group meetings and we have a few client engagements underway. If you are interested in more details,
please let me know.

Good luck,
Frank


On Wed, 10 Dec 2003 13:23:53 -0600, Prather, Doug, ISD wrote:

>Thanks Phil,
>We have an app that wants to convert their VSAM / CICS up to DB2 for
>more management. We will be doing data modeling. The best approach
>I've seen so far is to do a repro unload and then selectively load the
>data columns to the modeled DB2 Database. I was just interested if
>there was any utility to convert from VSAM to DB2.
>
>
>
>Doug Prather
>4101 Wiseman
>San Antonio, TX 78251
>210-543-6742
>
>
>-----Original Message-----
>From: Grainger, Phil [mailto:[login to unmask email]
>Sent: Wednesday, December 10, 2003 12:08 PM
>To: [login to unmask email]
>Subject: Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
>
>Be aware that if you just convert an application from VSAM to DB2 and
>DON'T re-engineer to take advantage of DB2, or take advantage of SQL
>your performance is likely to be worse than it was with VSAM....
>
>As an aside, why ARE you converting??
>
>Phil Grainger
>Computer Associates
>Product Manager, DB2
>Tel: +44 (0)161 928 9334
>Fax: +44 (0)161 941 3775
>Mobile: +44 (0)7970 125 752
>[login to unmask email]
>
>
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Prather, Doug, ISD
>Sent: Wednesday, December 10, 2003 5:15 PM
>To: [login to unmask email]
>Subject: VSAM KSDS conversion to DB2 V7.1 for z/OS
>
>
>I was wondering if anyone knew of a utility to convert VSAM KSDS
>datasets
>to DB2. Any help would be appreciated.
>
>------------------------------------------------------------------------
>---------
>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". If you will be out of the office,
>send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office,
>send the SET DB2-L NO MAIL command to [login to unmask email] 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
>
>
>*** NOTICE: The source of this e-mail is from the Internet or from a
>source outside of World Savings. ***
>
>
>
>*****************************************************************************
>If you are not the intended recipient of this e-mail, please notify
>the sender immediately. The contents of this e-mail do not amend
>any existing disclosures or agreements unless expressly stated.
>*****************************************************************************
>
>---------------------------------------------------------------------------------
>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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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 C. Fillmore, Jr. | Voice/Fax: 410.465.6335 |
| The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-RDBMs |
| 3213-A Corporate Court | E-mail: [login to unmask email] |
| Ellicott City, Maryland 21042-2247 | URL: http://www.thefillmoregroup.com |
| USA | |
+-------------------------------------+--------------------------------------+
| DB2 Family, Oracle, Client/Server, Distributed Database |
| "Relational Database Solutions"(sm) |
+----------------------------------------------------------------------------+


---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Martin Packer

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Inc. The Fillmore Group)
I don't see why you couldn't run a DFSORT COPY from VSAM to Sequential and
then load into DB2.

(Of course you could do much more with this DFSORT COPY step, including any
necessary transformations.)

Cheers, Martin

Martin Packer, MBCS Martin Packer/UK/IBM
020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile
07802-245584)

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Aurora Dellanno

Re: VSAM KSDS conversion to DB2 V7.1 for z/OS
(in response to Martin Packer)
Doug,

I remember a product called Convert by Forecross (maybe www.forecross.com ?)
that did just that.

Then there was something called... DBMS Migrator from Blue Phoenix
Technologies (no guesses on the web address here).

These were all examined by my team during a project for VSE/VSAM migration
to DB2. We did it some other way due to that VSE keyword, with the help of a
wonderful Redbook called "How to Get to DB2 from VSE/VSAM Using DB2 VSAM
Transparency for VSE/ESA", which I just looked for on the Redbooks website
at
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg244931.html?
Open

Of course, Striva had a very neat product that avoided you doing all that
conversion work, but I don't know what they're doing these days apart from
having been bought out by Informatica.

HTH.

ciao!

Aurora Emanuela Dell'Anno
Database Analyst
Data Services Group - Bank of America
tel. 66192
ext. 0208 760 6192
[login to unmask email]

* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER

no trees were killed in sending this message. However, a large number of
electrons were seriously inconvenienced :-)



-----Original Message-----
From: Prather, Doug, ISD [mailto:[login to unmask email]
Sent: 10 December 2003 17:15
To: [login to unmask email]
Subject: VSAM KSDS conversion to DB2 V7.1 for z/OS


I was wondering if anyone knew of a utility to convert VSAM KSDS datasets
to DB2. Any help would be appreciated.

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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

Notice to recipient:
The information in this internet e-mail and any attachments is confidential
and may be privileged. It is intended solely for the addressee. If you are
not the intended addressee please notify the sender immediately by
telephone. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful.
When addressed to external clients any opinions or advice contained in this
internet e-mail are subject to the terms and conditions expressed in any
applicable governing terms of business or client engagement letter issued by
the pertinent Bank of America group entity.
If this email originates from the U.K. please note that Bank of America,
N.A., London Branch, Banc of America Securities Limited and Banc of America
Futures Incorporated are regulated by the Financial Services Authority.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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