Fred Here are the results of some test I ran on a large DB (See attached file: bufsize.pdf)
_____________________________________________
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
sobotka@collegene
t.com
Sent by: To
owner-db2eug@Lugw [EMAIL PROTECTED]
ash.org cc
Subject
01/17/2003 12:37 [DB2EUG] Quantifying the savings of
PM BACKUP DB with 129-page buffers
Please respond to
sobotka@collegene
t.com
Hello,
I'm very glad to see heavy-hitters like Mr. McInnis providing valuable,
detailed information about such an integral part of my job as a DB2 DBA.
His response to a recent inquiry regarding shrinking backup size was to
reduce the backup buffer size from its default of 1024 to a mere 129 pages,
which I understand to be the size of four 32-page extents (with an extra
page added on for management overhead). Is the amount of disk space saved
proportional to the number of tablespaces being backed up?
Thanks in advance,
Fred Sobotka
Database Administrator
IBM Certified Solutions Expert - DB2 UDB V7.1 Administration for Unix,
Windows, and OS/2
CollegeNET, Inc.
-
::: 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
bufsize.pdf
Description: Adobe PDF document
