Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2006

Tip: Looking for answers? Try searching our database.

Speeding up Full Online Backups

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Asphalt Blazer - 13 Jul 2006 15:54 GMT
Hi,
       I have an ODS for which I need to do a full online backup. It
is taking us 1 hour and 44 minutes to do this. The command is below:

db2 "backup database $DBNAME ONLINE to $DBPATH with 4 buffers buffer
4096 parallelism 2 compress include logs without prompting"

Well I want to bring it down to an hour atleast because this backup is
encroaching on our other scheduled jobs. So I was planning to do this

db2 "backup database $DBNAME ONLINE to
$DBPATH,$DBPATH,$DBPATH,$DBPATH,$DBPATH,$DBPATH,$DBPATH,$DBPATH with 4
buffers buffer 4096 parallelism 2 compress include logs without
prompting"

basically splitting it into 8 files.

Will this get me a significant gain in TIME? Or are any other more
effective and tried out ways to do this? Kindly let me know

(btw, incremental and delta backups are absolutely NOT an option)

thanks.
memmerto@yahoo.com - 15 Jul 2006 05:10 GMT
> Hi,
>         I have an ODS for which I need to do a full online backup. It
[quoted text clipped - 17 lines]
>
> (btw, incremental and delta backups are absolutely NOT an option)

Have you tried letting DB2 choose values for BUFFERS, BUFFER and
PARALLELISM?  If you omit them, DB2 will automatically calculate some
good values based on your system config and how many backup devices you
are using.

--
Matt Emmerton
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.