multiple files for Backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 14 Dec 2005 19:50 GMT

I have a problem with moving the backup of my database from machine to
machine. The size is 17 Gig and my network keeps timing out when I try
to ftp it from machine to machine. I have had the situation where I
ended up with a backup that was in several pieces. the files were
xxxxx.001 xxxxxx.002 and so on.
I was thinking that if I could break up the file into smaller pieces
they would be able to move easier. Does anyone know how to break up a
backup into multiple files?

Thanks.

Reply to this Message

Mark A - 15 Dec 2005 00:42 GMT

>I have a problem with moving the backup of my database from machine to
> machine. The size is 17 Gig and my network keeps timing out when I try
[quoted text clipped - 6 lines]
>
> Thanks.

Specify multiple directories for the location of the backup. Not sure if
there is another way, but check the Command Reference.

Reply to this Message

Larry Menard - 15 Dec 2005 00:48 GMT

Or perhaps have your sysadmin increase the FTP timeout period, use
restartable FTP, or try another mechanism (e.g., NFS mount).

Signature

--------------------
Larry Menard
"Defender of Geese and of All Things Natural"

>>I have a problem with moving the backup of my database from machine to
>> machine. The size is 17 Gig and my network keeps timing out when I try
[quoted text clipped - 9 lines]
> Specify multiple directories for the location of the backup. Not sure if
> there is another way, but check the Command Reference.

Reply to this Message

Ian - 15 Dec 2005 08:35 GMT

>> I have a problem with moving the backup of my database from machine to
>> machine. The size is 17 Gig and my network keeps timing out when I try
[quoted text clipped - 9 lines]
> Specify multiple directories for the location of the backup. Not sure if
> there is another way, but check the Command Reference.

Just to add to this, when you specify multiple directories in the
backup command they do not all have to be different directories! You
can specify the same directory more than once to generate multiple
files, as in:

backup database sample to /backup,/backup,/backup,/backup

This will create 4 files (SAMPLE...001, SAMPLE...002, ..., SAMPLE...004)
in the /backup directory.

Reply to this Message

Matt Emmerton - 15 Dec 2005 05:20 GMT

> I have a problem with moving the backup of my database from machine to
> machine. The size is 17 Gig and my network keeps timing out when I try
[quoted text clipped - 4 lines]
> they would be able to move easier. Does anyone know how to break up a
> backup into multiple files?

You could also use the UNIX 'split' commands to split the file into smaller
pieces, and then use 'cat' to reassemble them. If you try this, you should
definitely calculate checksums on all files before and after transmitting --
including the single 17GB backup file -- to ensure that there is no
corruption. (md5sum or sum are good tools to use.)

This method is likely not supported by IBM, so use with caution :)

--
Matt Emmerton

Reply to this Message

hikums@gmail.com - 15 Dec 2005 06:02 GMT

did you try to compress each file and ftp them, that way you can get
atleast the size down to 25% of the original size..close to 4.5 gig, in
your case!! Also, work with you unix sysadmin.

hth..
kums

> > I have a problem with moving the backup of my database from machine to
> > machine. The size is 17 Gig and my network keeps timing out when I try
[quoted text clipped - 15 lines]
> --
> Matt Emmerton

Reply to this Message

Knut Stolze - 15 Dec 2005 12:12 GMT

Tools like "wget" are also good at picking up an interrupted transfer.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message