how to do a small backup with db2

[news_account]

hello,

While evaluating db2 and oracle i have the following question...

With oracle i can use a export of a user and later restore this
dump. With oracle i create a dump-file with about 500KB...
Using db2 backup/restore produces a file with 18 MB.

Any suggestions?

Greetings and Thanks
dummy

[Dmitry]

Hello,

DB2 also has the EXPORT utility that allows to save user tables and then
recreate them in another location using the IMPORT utility.

Best regards, Dmitry

--
http://www.ispirer.com/products - Data migration tool for IBM DB2, Oracle,
MS SQL Server and MySQL.

"news_account" <code...@hotmail.com> wrote in message
news:79bb9e32.02051...@posting.google.com...

[Fred Nurk]

The Oracle export is just that an binary export of the data belonging to a
particular schema. While the backup you did in DB2 is a backup of the whole
database, including systems tables, etc.

If you wish to compare apples to apples:

1) Export the data from both databases, for a direct comparisom use db2move
not the export, as it will also create be binary essentially like that of
Oracles - in that the table schema is contained in the db2move output.

2) Do offline (cold) backups of both databases
DB2: make sure that the database is offline. then use db2 backups
database <name> to <some path/device>
Oracle: make sure the database is offline and use tar/cpio to backup the
control files, and the tablespace files.

Fred

news_account wrote in message
<79bb9e32.02051...@posting.google.com>...

[blair kenneth adamache]

Also consider incremental backup:

http://www7b.boulder.ibm.com/dmdd/library/techarticle/0205adamache/0205adamache.html