Doug
The backup image includes all of the database's metadata, including the
container definitions, history file, system catalogs, ...
To decrease your backup size try using a backup buffer size of 129 - 4K
pages, the default is 1024 -4K pages.
Regards,
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
Doug Carter
<doug@webcriteria
.com> To
Sent by: [EMAIL PROTECTED]
owner-db2eug@Lugw cc
ash.org
Subject
[DB2EUG] Backup versus export sizes
01/16/2003 01:43
PM
Please respond to
Doug Carter
<doug@webcriteria
.com>
Hi all,
I've got what is probably some FAQs, but I'll ask it any way...
I see a big difference between the size of a database backup
and the size of all of the exported tables.
For example, I've backed up a database that creates a 4GB file.
If I export all of the tables for that same database (using
db2move) the total size is 1.7GB.
My questions:
Why the big difference?
Is there a way to make the backup smaller?
TIA,
Doug Carter
WebCriteria
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
