Re: DB2 VSE to DB2 os/390 V5 conversion

Inc. The Fillmore Group

Re: DB2 VSE to DB2 os/390 V5 conversion
(in response to Chris Cronrath)
Chris,
This doesn't exactly address your question, but I do have a suggestion. Instead of unloading and reloading
your data from DB2 for VSE to DB2 for OS/390, it would be easier and faster to establish a DRDA connection
between the two databases. That way you could run a process on OS/390 that would directly read the VSE
database without having to go to an intermediate flat file.

Frank


On Wed, 29 Dec 1999 09:21:29 -0500, Chris Cronrath wrote:

>We are in the middle of a conversion from DB2 on a VSE to DB2 on the OS/390. One of our tasks is to ensure
that old database backups can be restored to DB2 OS/390. Backups made on VSE in the SQL/DS format have been
successfully restored used the LOAD option FORMAT SQL/DS.
>
>We have found no documentation on how to restore DB2 VSE backups using the data restore feature of VSE or DBS
Utility. Does anyone have any ideas how we might restore this data to DB2 OS/390 without first restoring it
to DB2/VSE and then backing it up in SQL/DS format.
>
>Thank You
>
>Chris A Cronrath
>Systems Programmer/DB2 Systems Programmer/DB2 DBA
>New Enterprise Stone and Lime Co., Inc.
>
>
> DB2-L webpage at
http://www.ryci.com/db2-l. The owners of the list can

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



Chris Cronrath

DB2 VSE to DB2 os/390 V5 conversion
We are in the middle of a conversion from DB2 on a VSE to DB2 on the OS/390. One of our tasks is to ensure that old database backups can be restored to DB2 OS/390. Backups made on VSE in the SQL/DS format have been successfully restored used the LOAD option FORMAT SQL/DS.

We have found no documentation on how to restore DB2 VSE backups using the data restore feature of VSE or DBS Utility. Does anyone have any ideas how we might restore this data to DB2 OS/390 without first restoring it to DB2/VSE and then backing it up in SQL/DS format.

Thank You

Chris A Cronrath
Systems Programmer/DB2 Systems Programmer/DB2 DBA
New Enterprise Stone and Lime Co., Inc.