468,107 Members | 1,311 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

Is there a straightforward way to export/import an entire schema in DB2 UDB?

Hi,

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.

Thanks,
Michael
Nov 12 '05 #1
6 22635
If I understand correctly, you want to extract the DDL.

use this command or lookup the following command and choose your options:

db2look -d [DBName] -z [schema] -u [user] -e -l -x -c ;

Hope this helps

Christos


Michael wrote:
Hi,

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.

Thanks,
Michael

Nov 12 '05 #2
whats the nofed option do?

thanx

On Thu, 11 Nov 2004 10:35:16 -0500, Christos Kalantzis
<ch*******@intertrade.com> wrote:
If I understand correctly, you want to extract the DDL.

use this command or lookup the following command and choose your options:

db2look -d [DBName] -z [schema] -u [user] -e -l -x -c ;

Hope this helps

Christos


Michael wrote:
Hi,

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.

Thanks,
Michael


Nov 12 '05 #3
Andrew,

http://publib.boulder.ibm.com/infoce...e/r0002051.htm

The above link contains complete explanation of the command.

However to answer your question....it won't include federated objects.

Christos Kalantzis


Andrew wrote:
whats the nofed option do?

thanx

On Thu, 11 Nov 2004 10:35:16 -0500, Christos Kalantzis
<ch*******@intertrade.com> wrote:

If I understand correctly, you want to extract the DDL.

use this command or lookup the following command and choose your options:

db2look -d [DBName] -z [schema] -u [user] -e -l -x -c ;

Hope this helps

Christos


Michael wrote:
Hi,

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.

Thanks,
Michael


Nov 12 '05 #4
Andrew,

http://publib.boulder.ibm.com/infoce...e/r0002051.htm

The above link contains complete explanation of the command.

However to answer your question....it won't include federated objects.

Christos Kalantzis


Andrew wrote:
whats the nofed option do?

thanx

On Thu, 11 Nov 2004 10:35:16 -0500, Christos Kalantzis
<ch*******@intertrade.com> wrote:

If I understand correctly, you want to extract the DDL.

use this command or lookup the following command and choose your options:

db2look -d [DBName] -z [schema] -u [user] -e -l -x -c ;

Hope this helps

Christos


Michael wrote:
Hi,

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.

Thanks,
Michael


Nov 12 '05 #5
Andrew,

http://publib.boulder.ibm.com/infoce...e/r0002051.htm

The above link contains complete explanation of the command.

However to answer your question....it won't include federated objects.

Christos Kalantzis


Andrew wrote:
whats the nofed option do?

thanx

On Thu, 11 Nov 2004 10:35:16 -0500, Christos Kalantzis
<ch*******@intertrade.com> wrote:

If I understand correctly, you want to extract the DDL.

use this command or lookup the following command and choose your options:

db2look -d [DBName] -z [schema] -u [user] -e -l -x -c ;

Hope this helps

Christos


Michael wrote:
Hi,

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.

Thanks,
Michael


Nov 12 '05 #6
Ian
Michael wrote:
Hi,

Is there a straightforward way to export/import an entire schema in
DB2 UDB? I am looking for the something similar to Oracle exp/imp.


db2move is the closest analog to exp/imp, although it will not include
complete DDL for the database (The IXF format used by db2move only
keeps definitions of tables/indexes).

The best way is a combination of db2look (DDL) and db2move (data).

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Alessio Pompigna | last post: by
5 posts views Thread by funkybrown | last post: by
reply views Thread by Julie Warden | last post: by
2 posts views Thread by othellomy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.