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

[Michael]

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

[Christos Kalantzis]

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

[Andrew]

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

[Christos Kalantzis]

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

[Christos Kalantzis]

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

[Christos Kalantzis]

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

[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 =---