This is a discussion on Lazy IDS Onbar Backup within the Informix forums, part of the Database Server Software category; --> Hi All! I'm trying to make a 23Gb Level 0 Backup of a IDS 9.20UC2 instance, testing the new ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi All! I'm trying to make a 23Gb Level 0 Backup of a IDS 9.20UC2 instance, testing the new Tivoli Backup System, but I'm facing this issue: The dbspaces backup starts fine, but then comes the logical log backups ( one per minute ) that are fullfilled so fast, and the Tivoli stops the dbspace backup in order to backup the logs. With it, I'm not able to make a backup of the dbspaces. Here's my configs: Informix Dynamic Server 2000 Version 9.20.UC2 BUFFERED LOG TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 24000000 # Maximum amount of data to put on tape (Kbytes) LTAPEBLK 512 # Log tape block size (Kbytes) LTAPESIZE 2000000 #Max amount of data to put on log tape (Kbytes) LOGFILES 160 # Number of logical log files LOGSIZE 3000 # Logical log size (Kbytes) CCFLAGS 0x400000 #ARCHIVE PARAMETER BAR_ACT_LOG /var/tmp/informix_backup_logs/bar_act.log BAR_DEBUG_LOG /var/tmp/informix_backup_logs/bar_dbug.log BAR_BSALIB_PATH /opt/tivoli/tsm/client/informix/bin/libTDPinf.so TAPEDEV /usr/informix/rawmsg/backup_devices/tapedev LTAPEDEV /usr/informix/rawmsg/backup_devices/ltapedev BAR_DEBUG 6 #( setted to 6 just to debug the problem ) BAR_MAX_BACKUP 10 BAR_RETRY 5 BAR_NB_XPORT_COUNT 1 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE on BAR_PROGRESS_FREQ 0 Any suggestions are welcome! Thanks! Guto.- Brasil |
| |||
| On Jul 18, 9:02 am, Guto <gutom...@gmail.com> wrote: > Hi All! > I'm trying to make a 23Gb Level 0 Backup of a IDS 9.20UC2 instance, > testing the new Tivoli Backup System, but I'm facing this issue: > > The dbspaces backup starts fine, but then comes the logical log > backups ( one per minute ) > that are fullfilled so fast, and the Tivoli stops the dbspace backup > in order to backup the logs. > With it, I'm not able to make a backup of the dbspaces. > > Here's my configs: > Informix Dynamic Server 2000 Version 9.20.UC2 > BUFFERED LOG > > TAPEBLK 16 # Tape block size (Kbytes) > TAPESIZE 24000000 # Maximum amount of data to put on > tape (Kbytes) > LTAPEBLK 512 # Log tape block size (Kbytes) > LTAPESIZE 2000000 #Max amount of data to put on log tape > (Kbytes) > LOGFILES 160 # Number of logical log files > LOGSIZE 3000 # Logical log size (Kbytes) <SNIP> Martin's got the direct answer covered. The indirect answers are: 1- Increase your logical log size so that it's not backing up so frequently. 2- Do your test during a quieter period for the server. Art S. Kagel |
| |||
| On Jul 19, 11:19 am, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Jul 18, 9:02 am, Guto <gutom...@gmail.com> wrote: > > > Hi All! > > I'm trying to make a 23Gb Level 0 Backup of a IDS 9.20UC2 instance, > > testing the new Tivoli Backup System, but I'm facing this issue: > > > The dbspaces backup starts fine, but then comes the logical log > > backups ( one per minute ) > > that are fullfilled so fast, and the Tivoli stops the dbspace backup > > in order to backup the logs. > > With it, I'm not able to make a backup of the dbspaces. > > > Here's my configs: > > Informix Dynamic Server 2000 Version 9.20.UC2 > > BUFFERED LOG > > > TAPEBLK 16 # Tape block size (Kbytes) > > TAPESIZE 24000000 # Maximum amount of data to put on > > tape (Kbytes) > > LTAPEBLK 512 # Log tape block size (Kbytes) > > LTAPESIZE 2000000 #Max amount of data to put on log tape > > (Kbytes) > > LOGFILES 160 # Number of logical log files > > LOGSIZE 3000 # Logical log size (Kbytes) > > <SNIP> > > Martin's got the direct answer covered. The indirect answers are: > 1- Increase your logical log size so that it's not backing up so > frequently. > 2- Do your test during a quieter period for the server. > > Art S. Kagel Thanks Martin and Kagel, I'm working in increase the size of the logical log files, creating a separate pool at Tivoli, and reducing the BAR_MAX_BACKUP parameter to 5. I also changed the buffer mode to buffered instead of unbuffered. The only problem it's that at this server I really don't have a quieter period, it receives traps from a telecom network and it don't have a time for even breath! Thanks guys, I'll let you know about my progress! The next step will be restore this backup in a IDS 10, enviroment, which is already ready for the data. Regards, Guto |
| ||||
| On Jul 20, 11:28 am, Martin Fuerderer <MARTI...@de.ibm.com> wrote: > Hi, > > > The next step will be restore this backup in a IDS 10, enviroment, > > which is already ready for the data. > > A backup you have taken with IDS 9.20 you will have to restore with 9.20. > After that you can migrate that restored instance to 10.00. > But you cannot restore with IDS 10.00 a backup taken with IDS 9.20. > > Regards, > Martin > -- > Martin Fuerderer > IBM Informix Development Munich, Germany > Information Management > > IBM Deutschland GmbH > Chairman of the Supervisory Board: Hans Ulrich Märki > Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian > Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael > Diemer > Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, > HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 > > informix-list-boun...@iiug.org wrote on 20.07.2007 13:48:07: > > > > > On Jul 19, 11:19 am, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > On Jul 18, 9:02 am, Guto <gutom...@gmail.com> wrote: > > > > > Hi All! > > > > I'm trying to make a 23Gb Level 0 Backup of a IDS 9.20UC2 instance, > > > > testing the new Tivoli Backup System, but I'm facing this issue: > > > > > The dbspaces backup starts fine, but then comes the logical log > > > > backups ( one per minute ) > > > > that are fullfilled so fast, and the Tivoli stops the dbspace backup > > > > in order to backup the logs. > > > > With it, I'm not able to make a backup of the dbspaces. > > > > > Here's my configs: > > > > Informix Dynamic Server 2000 Version 9.20.UC2 > > > > BUFFERED LOG > > > > > TAPEBLK 16 # Tape block size (Kbytes) > > > > TAPESIZE 24000000 # Maximum amount of data to put on > > > > tape (Kbytes) > > > > LTAPEBLK 512 # Log tape block size (Kbytes) > > > > LTAPESIZE 2000000 #Max amount of data to put on log > tape > > > > (Kbytes) > > > > LOGFILES 160 # Number of logical log files > > > > LOGSIZE 3000 # Logical log size (Kbytes) > > > > <SNIP> > > > > Martin's got the direct answer covered. The indirect answers are: > > > 1- Increase your logical log size so that it's not backing up so > > > frequently. > > > 2- Do your test during a quieter period for the server. > > > > Art S. Kagel > > > Thanks Martin and Kagel, > > I'm working in increase the size of the logical log files, > > creating a separate pool at Tivoli, and reducing the BAR_MAX_BACKUP > > parameter > > to 5. I also changed the buffer mode to buffered instead of > > unbuffered. > > > The only problem it's that at this server I really don't have a > > quieter period, > > it receives traps from a telecom network and it don't have a time for > > even breath! > > > Thanks guys, I'll let you know about my progress! > > The next step will be restore this backup in a IDS 10, enviroment, > > which is already ready for the data. > > > Regards, > > Guto > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list Thanks again Martin, I'll do it, or even run a dbexport/dbimport. Thanks indeed.! Guto. |