multiple files for Backup

[Steven]

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.

[Mark A]

"Steven" <st**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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.

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

[Larry Menard]

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

--
--------------------
Larry Menard
"Defender of Geese and of All Things Natural"
"Mark A" <no****@nowhere.com> wrote in message
news:oY******************************@comcast.com. ..

"Steven" <st**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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.

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

[Matt Emmerton]

"Steven" <st**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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?

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

[hikums]

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
Matt Emmerton wrote:

"Steven" <st**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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?

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

[Ian]

Mark A wrote:

"Steven" <st**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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.

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.

[Knut Stolze]

Steven wrote:

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?

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

--
Knut Stolze
DB2 Information Integration Development
IBM Germany