Re: backing up large databse

daviddnv@my-deja.com wrote: > > Hi everyone, > Does anyone have any ideas on this? I have a database that has a > large blobspace over 200Gig and growing. We have used ontape so far > but it's get to long. It's over 24 hours and 6 DLT tapes for a full > backup. I found out from Informix that onbar will not backup a dbspace > or blobspace to more then one device at a time. So now I'm looking for > another solution. Maybe a diffrent storage manager then ISM? Any > ideas will help. A different SM is not going to help. OnBar will run parallel backups at the dbspace/blobspace level. So you really need to break that blobspace up. Why is it so big? Is it just one column? If not can different columns be stored in different blobspaces? I guess an alternative would be to store the blob column in the dbspace and fragment the table. But this could affect performance of the app. > We are running 7.30.TC7 on NT4. Well I won't hold that against you.... this time. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+

Did you think about different storage solutions? there are possibilities on EMC equipment, where you can mirror your data online without impacting your application and splitt the mirror in a few seconds at a transactionless state of the database. From this point on, you can make the backup using additional mirror volumes and there is a lot of time to do the backup, because the system is running on the original volumes without additional mirrors. "Mark D. Stock" schrieb: > daviddnv@my-deja.com wrote: > > > > Hi everyone, > > Does anyone have any ideas on this? I have a database that has a > > large blobspace over 200Gig and growing. We have used ontape so far > > but it's get to long. It's over 24 hours and 6 DLT tapes for a full > > backup. I found out from Informix that onbar will not backup a dbspace > > or blobspace to more then one device at a time. So now I'm looking for > > another solution. Maybe a diffrent storage manager then ISM? Any > > ideas will help. > > A different SM is not going to help. OnBar will run parallel backups at > the dbspace/blobspace level. So you really need to break that blobspace > up. Why is it so big? Is it just one column? If not can different > columns be stored in different blobspaces? > > I guess an alternative would be to store the blob column in the dbspace > and fragment the table. But this could affect performance of the app. > > > We are running 7.30.TC7 on NT4. > > Well I won't hold that against you.... this time. ;-) > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| > | http://www.informix.com http://www.informixhandbook.com |///// / //| > | http://www.iiug.org +-----------------------------------+//// / ///| > | |What year 2000 bug? year 2000 bug? |/// / ////| > | |year 2000 bug? year 2000 bug? year |// / /////| > | |2000 bug? year 2000 bug? year 1900 |/ ////////| > +----------------------+-----------------------------------+-----------+ -- Gerhard Eberlein MGM EDV-Beratung GmbH Frankfurter Ring 105a 80807 Muenchen Tel: +49 (89) 35 86 80 - 22 Fax: +49 (89) 35 86 80 - 88 gerhard.eberlein@mgm-edv.de Anfahrt: (1) Stadplan München (2) Parkplatz bei MGM (1) http://www.stadtplandienst.de/query;ORT=m;LL=11.586530x48.189313 (2) http://www.mgm-edv.de/Layout/strassen.gif

Another possible solution could be third party products like BMC's SqlBackTrack. SqlBackTrack will work with onbar and serve as a storage manager. SqlBackTrack for onbar backs up dbspaces/blobspaces in parallel and can go directly to disk at a pretty high compression ratio. Additionally, you might consider onbar directly to Legato Networker. Any solution that allows you to go to some form of disk as well as allow parallelism should significantly decrease your backup times. Kirk In article <38C6491E.B01279D8@mgm-edv.de>, Gerhard Eberlein <gerhard.eberlein@mgm-edv.de> wrote: > Did you think about different storage solutions? there are possibilities on > EMC equipment, where you can mirror your data online without impacting your > application and splitt the mirror in a few seconds at a transactionless state > of the database. From this point on, you can make the backup using additional > mirror volumes and there is a lot of time to do the backup, because the > system is running on the original volumes without additional mirrors. > > "Mark D. Stock" schrieb: > > > daviddnv@my-deja.com wrote: > > > > > > Hi everyone, > > > Does anyone have any ideas on this? I have a database that has a > > > large blobspace over 200Gig and growing. We have used ontape so far > > > but it's get to long. It's over 24 hours and 6 DLT tapes for a full > > > backup. I found out from Informix that onbar will not backup a dbspace > > > or blobspace to more then one device at a time. So now I'm looking for > > > another solution. Maybe a diffrent storage manager then ISM? Any > > > ideas will help. > > > > A different SM is not going to help. OnBar will run parallel backups at > > the dbspace/blobspace level. So you really need to break that blobspace > > up. Why is it so big? Is it just one column? If not can different > > columns be stored in different blobspaces? > > > > I guess an alternative would be to store the blob column in the dbspace > > and fragment the table. But this could affect performance of the app. > > > > > We are running 7.30.TC7 on NT4. > > > > Well I won't hold that against you.... this time. ;-) > > > > Cheers, > > -- > > Mark. > > > > +----------------------------------------------------------+-----------+ > > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| > > | http://www.informix.com http://www.informixhandbook.com |///// / //| > > | http://www.iiug.org +-----------------------------------+//// / ///| > > | |What year 2000 bug? year 2000 bug? |/// / ////| > > | |year 2000 bug? year 2000 bug? year |// / /////| > > | |2000 bug? year 2000 bug? year 1900 |/ ////////| > > +----------------------+-----------------------------------+-----------+ > > -- > Gerhard Eberlein > MGM EDV-Beratung GmbH > Frankfurter Ring 105a > > 80807 Muenchen > > Tel: +49 (89) 35 86 80 - 22 > Fax: +49 (89) 35 86 80 - 88 > > gerhard.eberlein@mgm-edv.de > > Anfahrt: (1) Stadplan M''nchen (2) Parkplatz bei MGM > (1) http://www.stadtplandienst.de/query;ORT=m;LL=11.586530x48.189313 > (2) http://www.mgm-edv.de/Layout/strassen.gif > > Sent via Deja.com http://www.deja.com/ Before you buy.