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
