the backup utility works on extents, the default extentsize is 32 - 4K
pages. So this will give you 4 extents (128 -4k pages) + 1 4Kpage for the
buffer overhead. This has shown very good performance and size
characterestics in our benchmarking.
If you change the extentsize of the tablespaces always use a multiple of
the largest extentsize + 1.
_____________________________________________
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
"Pierre
Saint-Jacques"
<sescons@attgloba To
l.net> Dale McInnis/Toronto/IBM@IBMCA,
"Doug Carter"
01/16/2003 02:51 <[EMAIL PROTECTED]>
PM cc
<[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
Subject
Re: [DB2EUG] Backup versus export
sizes
Why 129? Or could there be a typo??
Regards, Pierre.
Pierre Saint-Jacques IBM Certified Solutions Expert - Administration
SES Consultants Inc. [EMAIL PROTECTED]
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Doug Carter" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 1:59 PM
Subject: Re: [DB2EUG] Backup versus export sizes
> 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
-
::: 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
