Unix Technical Forum

Lazy IDS Onbar Backup

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 ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 05:03 PM
Guto
 
Posts: n/a
Default Lazy IDS Onbar Backup

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 05:04 PM
Art S. Kagel
 
Posts: n/a
Default Re: Lazy IDS Onbar Backup

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 05:04 PM
Guto
 
Posts: n/a
Default Re: Lazy IDS Onbar Backup

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-20-2008, 05:05 PM
Guto
 
Posts: n/a
Default Re: Lazy IDS Onbar Backup

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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:42 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com