Move data from one DB2 database to another DB2 database 
Author Message
 Move data from one DB2 database to another DB2 database
Here's my dilemma, I have two DB2 v7 databases and I would like to
move data from one database (db1) to the other database (db2) without
using import/export files. Is this possible?

My current work around is creating a federated server, points to db1,
on db2 but I cannot use a SELECT INTO statement to move data. So, I
create a stored proc on db2 to retrieve information into a cursor and
then single insert each record into db1. Is there a better way to do
this?

Suggestions would be helpful!



Mon, 18 Jul 2005 05:16:01 GMT
 Move data from one DB2 database to another DB2 database

Quote:

> Here's my dilemma, I have two DB2 v7 databases and I would like to
> move data from one database (db1) to the other database (db2) without
> using import/export files. Is this possible?

> My current work around is creating a federated server, points to db1,
> on db2 but I cannot use a SELECT INTO statement to move data. So, I
> create a stored proc on db2 to retrieve information into a cursor and
> then single insert each record into db1. Is there a better way to do
> this?

> Suggestions would be helpful!

Taking a backup and restoring this to the
new database ?

db2 "backup db <dbname> to /tmp"
db2 "restore db <dbname> from /tmp into <new_dbname>"

Best regards

Eric
--
IT-Consulting Herber
WWW:   http://www.herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************



Mon, 18 Jul 2005 04:28:40 GMT
 Move data from one DB2 database to another DB2 database
   Here's a rad idea... no idea if it would work...

   What about on the receiving doing a LOAD from a Named Pipe, the other end
of that pipe having been originated from some application connected to (and
spewing data from) the original DB?
--
Larry Menard
IBM Workstation Database (DB2) Performance Team
Defender of Geese and of All Things Natural


Quote:
> Here's my dilemma, I have two DB2 v7 databases and I would like to
> move data from one database (db1) to the other database (db2) without
> using import/export files. Is this possible?

> My current work around is creating a federated server, points to db1,
> on db2 but I cannot use a SELECT INTO statement to move data. So, I
> create a stored proc on db2 to retrieve information into a cursor and
> then single insert each record into db1. Is there a better way to do
> this?

> Suggestions would be helpful!



Mon, 18 Jul 2005 05:42:17 GMT
 Move data from one DB2 database to another DB2 database
Only useful if the databases reside on the same platform (NT to NT) and the
same filesystems are used for your tablespaces - otherwise you need to do a
redirected restore...

HTH
Mike


Quote:

> > Here's my dilemma, I have two DB2 v7 databases and I would like to
> > move data from one database (db1) to the other database (db2) without
> > using import/export files. Is this possible?

> > My current work around is creating a federated server, points to db1,
> > on db2 but I cannot use a SELECT INTO statement to move data. So, I
> > create a stored proc on db2 to retrieve information into a cursor and
> > then single insert each record into db1. Is there a better way to do
> > this?

> > Suggestions would be helpful!

> Taking a backup and restoring this to the
> new database ?

> db2 "backup db <dbname> to /tmp"
> db2 "restore db <dbname> from /tmp into <new_dbname>"

> Best regards

> Eric
> --
> IT-Consulting Herber
> WWW:   http://www.herber-consulting.de

> ***********************************************
> Download the IFMX Database-Monitor for free at:
> http://www.herber-consulting.de/BusyBee
> ***********************************************



Mon, 18 Jul 2005 09:09:33 GMT
 Move data from one DB2 database to another DB2 database
This is not correct. Backup/Restore does allow
crossplatform support, at least between HP and SUN.

And NT, what is NT ? (at least not a reliable databaseserver
platform...)

Best regards

Eric
--
IT-Consulting Herber
WWW:   http://www.herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************

Quote:

> Only useful if the databases reside on the same platform (NT to NT) and the
> same filesystems are used for your tablespaces - otherwise you need to do a
> redirected restore...

> HTH
> Mike




>>>Here's my dilemma, I have two DB2 v7 databases and I would like to
>>>move data from one database (db1) to the other database (db2) without
>>>using import/export files. Is this possible?

>>>My current work around is creating a federated server, points to db1,
>>>on db2 but I cannot use a SELECT INTO statement to move data. So, I
>>>create a stored proc on db2 to retrieve information into a cursor and
>>>then single insert each record into db1. Is there a better way to do
>>>this?

>>>Suggestions would be helpful!

>>Taking a backup and restoring this to the
>>new database ?

>>db2 "backup db <dbname> to /tmp"
>>db2 "restore db <dbname> from /tmp into <new_dbname>"

>>Best regards

>>Eric
>>--
>>IT-Consulting Herber
>>WWW:   http://www.herber-consulting.de

>>***********************************************
>>Download the IFMX Database-Monitor for free at:
>>http://www.herber-consulting.de/BusyBee
>>***********************************************



Mon, 18 Jul 2005 14:47:16 GMT
 Move data from one DB2 database to another DB2 database

Quote:

> Here's a rad idea... no idea if it would work...

>    What about on the receiving doing a LOAD from a Named Pipe, the other end
> of that pipe having been originated from some application connected to (and
> spewing data from) the original DB?
> --
> Larry Menard
> IBM Workstation Database (DB2) Performance Team
> Defender of Geese and of All Things Natural



> > Here's my dilemma, I have two DB2 v7 databases and I would like to
> > move data from one database (db1) to the other database (db2) without
> > using import/export files. Is this possible?

> > My current work around is creating a federated server, points to db1,
> > on db2 but I cannot use a SELECT INTO statement to move data. So, I
> > create a stored proc on db2 to retrieve information into a cursor and
> > then single insert each record into db1. Is there a better way to do
> > this?

> > Suggestions would be helpful!

Can you give me an example on how it would work?


Tue, 19 Jul 2005 11:43:38 GMT
 Move data from one DB2 database to another DB2 database

Quote:

> This is not correct. Backup/Restore does allow
> crossplatform support, at least between HP and SUN.

> And NT, what is NT ? (at least not a reliable databaseserver
> platform...)

> Best regards

> Eric
> --
> IT-Consulting Herber
> WWW:   http://www.herber-consulting.de

> ***********************************************
> Download the IFMX Database-Monitor for free at:
> http://www.herber-consulting.de/BusyBee
> ***********************************************


> > Only useful if the databases reside on the same platform (NT to NT) and the
> > same filesystems are used for your tablespaces - otherwise you need to do a
> > redirected restore...

> > HTH
> > Mike




> >>>Here's my dilemma, I have two DB2 v7 databases and I would like to
> >>>move data from one database (db1) to the other database (db2) without
> >>>using import/export files. Is this possible?

> >>>My current work around is creating a federated server, points to db1,
> >>>on db2 but I cannot use a SELECT INTO statement to move data. So, I
> >>>create a stored proc on db2 to retrieve information into a cursor and
> >>>then single insert each record into db1. Is there a better way to do
> >>>this?

> >>>Suggestions would be helpful!

> >>Taking a backup and restoring this to the
> >>new database ?

> >>db2 "backup db <dbname> to /tmp"
> >>db2 "restore db <dbname> from /tmp into <new_dbname>"

> >>Best regards

> >>Eric
> >>--
> >>IT-Consulting Herber
> >>WWW:   http://www.herber-consulting.de

> >>***********************************************
> >>Download the IFMX Database-Monitor for free at:
> >>http://www.herber-consulting.de/BusyBee
> >>***********************************************

I am running on IBM AIX 5L.


Tue, 19 Jul 2005 11:44:57 GMT
 Move data from one DB2 database to another DB2 database
   Not a very complete example, I'm afraid, but at least a partial one.

   In various TPC-C kits I've seen a utility called "dbgen", which generates
rows of data and writes them either to STDOUT or to a named pipe.  Check out
the TPC website (http://www.tpc.org), you might find the source there.  It
wouldn't be hard to modify it so that it does a SELECT * from your table
instead of just generating random data.  It shouldn't even be too hard to
code from scratch.  The C APIs are "CreateNamedPipe", "ConnectNamedPipe",
and "DisconnectNamedPipe".

  On the receiving end (the destination database), do a "db2 load from
\\.\pipe\pipename ..."
--
Larry Menard
IBM Workstation Database (DB2) Performance Team
Defender of Geese and of All Things Natural



Quote:
> > Here's a rad idea... no idea if it would work...

> >    What about on the receiving doing a LOAD from a Named Pipe, the other
end
> > of that pipe having been originated from some application connected to
(and
> > spewing data from) the original DB?
> > --
> > Larry Menard
> > IBM Workstation Database (DB2) Performance Team
> > Defender of Geese and of All Things Natural



> > > Here's my dilemma, I have two DB2 v7 databases and I would like to
> > > move data from one database (db1) to the other database (db2) without
> > > using import/export files. Is this possible?

> > > My current work around is creating a federated server, points to db1,
> > > on db2 but I cannot use a SELECT INTO statement to move data. So, I
> > > create a stored proc on db2 to retrieve information into a cursor and
> > > then single insert each record into db1. Is there a better way to do
> > > this?

> > > Suggestions would be helpful!

> Can you give me an example on how it would work?



Tue, 19 Jul 2005 22:56:36 GMT
 Move data from one DB2 database to another DB2 database

:)This is not correct. Backup/Restore does allow
:)crossplatform support, at least between HP and SUN.

  Noo, it does not allow cross platform back/restore. I have tried to backup
  database on AIX and restore it on HP. I was told by IBM that it is not
  supported in V7. I will be supported in V8.

:)
:)And NT, what is NT ? (at least not a reliable databaseserver
:)platform...)
:)
:)Best regards
:)
:)Eric
:)--
:)IT-Consulting Herber
:)WWW:   http://www.herber-consulting.de

:)
:)***********************************************
:)Download the IFMX Database-Monitor for free at:
:)http://www.herber-consulting.de/BusyBee
:)***********************************************
:)
:)> Only useful if the databases reside on the same platform (NT to NT) and the
:)> same filesystems are used for your tablespaces - otherwise you need to do a
:)> redirected restore...
:)>
:)> HTH
:)> Mike
:)>


:)>
:)>>
:)>>>Here's my dilemma, I have two DB2 v7 databases and I would like to
:)>>>move data from one database (db1) to the other database (db2) without
:)>>>using import/export files. Is this possible?
:)>>>
:)>>>My current work around is creating a federated server, points to db1,
:)>>>on db2 but I cannot use a SELECT INTO statement to move data. So, I
:)>>>create a stored proc on db2 to retrieve information into a cursor and
:)>>>then single insert each record into db1. Is there a better way to do
:)>>>this?
:)>>>
:)>>>Suggestions would be helpful!
:)>>
:)>>Taking a backup and restoring this to the
:)>>new database ?
:)>>
:)>>db2 "backup db <dbname> to /tmp"
:)>>db2 "restore db <dbname> from /tmp into <new_dbname>"
:)>>
:)>>Best regards
:)>>
:)>>Eric
:)>>--
:)>>IT-Consulting Herber
:)>>WWW:   http://www.herber-consulting.de

:)>>
:)>>***********************************************
:)>>Download the IFMX Database-Monitor for free at:
:)>>http://www.herber-consulting.de/BusyBee
:)>>***********************************************
:)>>
:)>
:)>
:)>
:)
:)
:)

--
Hemant Shah                           /"\  ASCII ribbon campaign

                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.          
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.



Tue, 19 Jul 2005 23:42:22 GMT
 Move data from one DB2 database to another DB2 database

:)   Here's a rad idea... no idea if it would work...
:)
:)   What about on the receiving doing a LOAD from a Named Pipe, the other end
:)of that pipe having been originated from some application connected to (and

      I have tried this many times, and it works.
      1) Create a pipe using mknod command.
      2) Use the pipe as backup device on one database.
      3) Use the pipr as restore device on another database.

      This will only work if both the databases are on the same system.

:)spewing data from) the original DB?
:)--
:)Larry Menard
:)IBM Workstation Database (DB2) Performance Team
:)Defender of Geese and of All Things Natural
:)
:)

:)> Here's my dilemma, I have two DB2 v7 databases and I would like to
:)> move data from one database (db1) to the other database (db2) without
:)> using import/export files. Is this possible?
:)>
:)> My current work around is creating a federated server, points to db1,
:)> on db2 but I cannot use a SELECT INTO statement to move data. So, I
:)> create a stored proc on db2 to retrieve information into a cursor and
:)> then single insert each record into db1. Is there a better way to do
:)> this?
:)>
:)> Suggestions would be helpful!
:)
:)

--
Hemant Shah                           /"\  ASCII ribbon campaign

                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.          
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.



Tue, 19 Jul 2005 23:45:22 GMT
 Move data from one DB2 database to another DB2 database
In V7.x we do in fact support backup and restore between Solaris and HP-UX.

--
Bob Harbus
Consulting I/T Specialist - IBM Software Services for Data Management - IBM Toronto Lab
IBM Certified Database Associate - DB2 Universal Database V8.1 Family
IBM Certified Database Administrator- DB2 Universal Database V8.1 for Linux, UNIX, and Windows

Quote:


> :)This is not correct. Backup/Restore does allow
> :)crossplatform support, at least between HP and SUN.

>   Noo, it does not allow cross platform back/restore. I have tried to backup
>   database on AIX and restore it on HP. I was told by IBM that it is not
>   supported in V7. I will be supported in V8.

> :)
> :)And NT, what is NT ? (at least not a reliable databaseserver
> :)platform...)
> :)
> :)Best regards
> :)
> :)Eric
> :)--
> :)IT-Consulting Herber
> :)WWW:   http://www.herber-consulting.de

> :)
> :)***********************************************
> :)Download the IFMX Database-Monitor for free at:
> :)http://www.herber-consulting.de/BusyBee
> :)***********************************************
> :)

> :)> Only useful if the databases reside on the same platform (NT to NT) and the
> :)> same filesystems are used for your tablespaces - otherwise you need to do a
> :)> redirected restore...
> :)>
> :)> HTH
> :)> Mike
> :)>


> :)>

> :)>>
> :)>>>Here's my dilemma, I have two DB2 v7 databases and I would like to
> :)>>>move data from one database (db1) to the other database (db2) without
> :)>>>using import/export files. Is this possible?
> :)>>>
> :)>>>My current work around is creating a federated server, points to db1,
> :)>>>on db2 but I cannot use a SELECT INTO statement to move data. So, I
> :)>>>create a stored proc on db2 to retrieve information into a cursor and
> :)>>>then single insert each record into db1. Is there a better way to do
> :)>>>this?
> :)>>>
> :)>>>Suggestions would be helpful!
> :)>>
> :)>>Taking a backup and restoring this to the
> :)>>new database ?
> :)>>
> :)>>db2 "backup db <dbname> to /tmp"
> :)>>db2 "restore db <dbname> from /tmp into <new_dbname>"
> :)>>
> :)>>Best regards
> :)>>
> :)>>Eric
> :)>>--
> :)>>IT-Consulting Herber
> :)>>WWW:   http://www.herber-consulting.de

> :)>>
> :)>>***********************************************
> :)>>Download the IFMX Database-Monitor for free at:
> :)>>http://www.herber-consulting.de/BusyBee
> :)>>***********************************************
> :)>>
> :)>
> :)>
> :)>
> :)
> :)
> :)

> --
> Hemant Shah                           /"\  ASCII ribbon campaign

>                                        X     against HTML mail
> TO REPLY, REMOVE NoJunkMail           / \      and postings
> FROM MY E-MAIL ADDRESS.
> -----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
> I haven't lost my mind,                Above opinions are mine only.
> it's backed up on tape somewhere.      Others can have their own.



Tue, 19 Jul 2005 23:55:46 GMT
 Move data from one DB2 database to another DB2 database

:)In V7.x we do in fact support backup and restore between Solaris and HP-UX.
:)

  I find it strange that you support Solaris and HP-UX but not AIX.

:)
:)--
:)Bob Harbus
:)Consulting I/T Specialist - IBM Software Services for Data Management - IBM Toronto Lab
:)IBM Certified Database Associate - DB2 Universal Database V8.1 Family
:)IBM Certified Database Administrator- DB2 Universal Database V8.1 for Linux, UNIX, and Windows
:)
:)

:)> :)This is not correct. Backup/Restore does allow
:)> :)crossplatform support, at least between HP and SUN.
:)>
:)>   Noo, it does not allow cross platform back/restore. I have tried to backup
:)>   database on AIX and restore it on HP. I was told by IBM that it is not
:)>   supported in V7. I will be supported in V8.
:)>
:)> :)
:)> :)And NT, what is NT ? (at least not a reliable databaseserver
:)> :)platform...)
:)> :)
:)> :)Best regards
:)> :)
:)> :)Eric
:)> :)--
:)> :)IT-Consulting Herber
:)> :)WWW:   http://www.herber-consulting.de

:)> :)
:)> :)***********************************************
:)> :)Download the IFMX Database-Monitor for free at:
:)> :)http://www.herber-consulting.de/BusyBee
:)> :)***********************************************
:)> :)
:)> :)> Only useful if the databases reside on the same platform (NT to NT) and the
:)> :)> same filesystems are used for your tablespaces - otherwise you need to do a
:)> :)> redirected restore...
:)> :)>
:)> :)> HTH
:)> :)> Mike
:)> :)>


:)> :)>
:)> :)>>
:)> :)>>>Here's my dilemma, I have two DB2 v7 databases and I would like to
:)> :)>>>move data from one database (db1) to the other database (db2) without
:)> :)>>>using import/export files. Is this possible?
:)> :)>>>
:)> :)>>>My current work around is creating a federated server, points to db1,
:)> :)>>>on db2 but I cannot use a SELECT INTO statement to move data. So, I
:)> :)>>>create a stored proc on db2 to retrieve information into a cursor and
:)> :)>>>then single insert each record into db1. Is there a better way to do
:)> :)>>>this?
:)> :)>>>
:)> :)>>>Suggestions would be helpful!
:)> :)>>
:)> :)>>Taking a backup and restoring this to the
:)> :)>>new database ?
:)> :)>>
:)> :)>>db2 "backup db <dbname> to /tmp"
:)> :)>>db2 "restore db <dbname> from /tmp into <new_dbname>"
:)> :)>>
:)> :)>>Best regards
:)> :)>>
:)> :)>>Eric
:)> :)>>--
:)> :)>>IT-Consulting Herber
:)> :)>>WWW:   http://www.herber-consulting.de

:)> :)>>
:)> :)>>***********************************************
:)> :)>>Download the IFMX Database-Monitor for free at:
:)> :)>>http://www.herber-consulting.de/BusyBee
:)> :)>>***********************************************
:)> :)>>
:)> :)>
:)> :)>
:)> :)>
:)> :)
:)> :)
:)> :)
:)>
:)> --
:)> Hemant Shah                           /"\  ASCII ribbon campaign

:)>                                        X     against HTML mail
:)> TO REPLY, REMOVE NoJunkMail           / \      and postings
:)> FROM MY E-MAIL ADDRESS.
:)> -----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
:)> I haven't lost my mind,                Above opinions are mine only.
:)> it's backed up on tape somewhere.      Others can have their own.
:)
:)
:)

--
Hemant Shah                           /"\  ASCII ribbon campaign

                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.          
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.



Wed, 20 Jul 2005 01:55:07 GMT
 Move data from one DB2 database to another DB2 database
Cross-platform backup/restore amongst AIX, Solaris and HP is available in v8.

We started with Solaris and HP in v7 because the page formats were identical.

Quote:


> :)In V7.x we do in fact support backup and restore between Solaris and HP-UX.
> :)

>   I find it strange that you support Solaris and HP-UX but not AIX.

> :)
> :)--
> :)Bob Harbus
> :)Consulting I/T Specialist - IBM Software Services for Data Management - IBM Toronto Lab
> :)IBM Certified Database Associate - DB2 Universal Database V8.1 Family
> :)IBM Certified Database Administrator- DB2 Universal Database V8.1 for Linux, UNIX, and Windows
> :)

> :)

> :)> :)This is not correct. Backup/Restore does allow
> :)> :)crossplatform support, at least between HP and SUN.
> :)>
> :)>   Noo, it does not allow cross platform back/restore. I have tried to backup
> :)>   database on AIX and restore it on HP. I was told by IBM that it is not
> :)>   supported in V7. I will be supported in V8.
> :)>
> :)> :)
> :)> :)And NT, what is NT ? (at least not a reliable databaseserver
> :)> :)platform...)
> :)> :)
> :)> :)Best regards
> :)> :)
> :)> :)Eric
> :)> :)--
> :)> :)IT-Consulting Herber
> :)> :)WWW:   http://www.herber-consulting.de

> :)> :)
> :)> :)***********************************************
> :)> :)Download the IFMX Database-Monitor for free at:
> :)> :)http://www.herber-consulting.de/BusyBee
> :)> :)***********************************************
> :)> :)

> :)> :)> Only useful if the databases reside on the same platform (NT to NT) and the
> :)> :)> same filesystems are used for your tablespaces - otherwise you need to do a
> :)> :)> redirected restore...
> :)> :)>
> :)> :)> HTH
> :)> :)> Mike
> :)> :)>


> :)> :)>

> :)> :)>>
> :)> :)>>>Here's my dilemma, I have two DB2 v7 databases and I would like to
> :)> :)>>>move data from one database (db1) to the other database (db2) without
> :)> :)>>>using import/export files. Is this possible?
> :)> :)>>>
> :)> :)>>>My current work around is creating a federated server, points to db1,
> :)> :)>>>on db2 but I cannot use a SELECT INTO statement to move data. So, I
> :)> :)>>>create a stored proc on db2 to retrieve information into a cursor and
> :)> :)>>>then single insert each record into db1. Is there a better way to do
> :)> :)>>>this?
> :)> :)>>>
> :)> :)>>>Suggestions would be helpful!
> :)> :)>>
> :)> :)>>Taking a backup and restoring this to the
> :)> :)>>new database ?
> :)> :)>>
> :)> :)>>db2 "backup db <dbname> to /tmp"
> :)> :)>>db2 "restore db <dbname> from /tmp into <new_dbname>"
> :)> :)>>
> :)> :)>>Best regards
> :)> :)>>
> :)> :)>>Eric
> :)> :)>>--
> :)> :)>>IT-Consulting Herber
> :)> :)>>WWW:   http://www.herber-consulting.de

> :)> :)>>
> :)> :)>>***********************************************
> :)> :)>>Download the IFMX Database-Monitor for free at:
> :)> :)>>http://www.herber-consulting.de/BusyBee
> :)> :)>>***********************************************
> :)> :)>>
> :)> :)>
> :)> :)>
> :)> :)>
> :)> :)
> :)> :)
> :)> :)
> :)>
> :)> --
> :)> Hemant Shah                           /"\  ASCII ribbon campaign

> :)>                                        X     against HTML mail
> :)> TO REPLY, REMOVE NoJunkMail           / \      and postings
> :)> FROM MY E-MAIL ADDRESS.
> :)> -----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
> :)> I haven't lost my mind,                Above opinions are mine only.
> :)> it's backed up on tape somewhere.      Others can have their own.
> :)
> :)
> :)

> --
> Hemant Shah                           /"\  ASCII ribbon campaign

>                                        X     against HTML mail
> TO REPLY, REMOVE NoJunkMail           / \      and postings
> FROM MY E-MAIL ADDRESS.
> -----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
> I haven't lost my mind,                Above opinions are mine only.
> it's backed up on tape somewhere.      Others can have their own.



Wed, 20 Jul 2005 06:11:10 GMT
 Move data from one DB2 database to another DB2 database

Quote:


> :)   Here's a rad idea... no idea if it would work...
> :)
> :)   What about on the receiving doing a LOAD from a Named Pipe, the other end
> :)of that pipe having been originated from some application connected to (and

>       I have tried this many times, and it works.
>       1) Create a pipe using mknod command.
>       2) Use the pipe as backup device on one database.
>       3) Use the pipr as restore device on another database.

>       This will only work if both the databases are on the same system.

Too bad that backup/restore don't also work with TCP/IP sockets, isn't
it ?

--
Richard D. Latham  




Thu, 21 Jul 2005 06:48:50 GMT
 
 [ 14 post ] 

 Relevant Pages 

1. desire to move data from OS 390 DB2 to AS/400 DB2 using DTS

2. Need advice on moving data between DB2 mainframe and DB2 Unix

3. Dynamically moving data from Sql Server database to Oracle/DB2

4. Moving SQL database to AS400 DB2 database

5. Move data from one database to another database

6. move data from one database to another database

7. Distributed DB2 - Oracle/Oracle - Oracle/DB2 - DB2/DB2

8. Moving from a DB2 V2 certification to a DB2 UDB V5 certification

9. Sacramento, Calif - Database Specialist with SQL, DRDA, DB2 +DB2/2

10. Sacramento, Calif - Database Specialist with SQL, DRDA, DB2 +DB2/2

11. DBD::DB2-Linux-client connect to AS/400-DB2-database

12. How hard is it to move External stored procedures between databases (DB2,Oracle,Sql Server, etc)


 
Powered by phpBB® Forum Software