RE: onbar error message
I'd increase the size of the logical log files. 512K is a very small
number. The default in 9.40 is 2000K. I've got an OLTP database with about
800+ users and I use 100MB logfiles. I get about 1 log filling an hour. I
have enough of them so I can always go at least 24 hours without a backup,
in case of a storage manager failure. Check out the admin guide for the
Informix recommendations.
http://www-306.ibm.com/software/data/informix/pubs/library/ids_94.html
Regards,
Bill
> -----Original Message-----
> From: Davorin Kremenjas [SMTP:davorin.kremenjas@inet.hr]
> Sent: Wednesday, May 26, 2004 10:01 AM
> To: informix-list@iiug.org
> Subject: onbar error message
>
> Hello!
> I have an Informix backup configured as an onbar + Legato Networker
> combination with IDS 9.40 UC3 on Solaris 9 machine. We take dbspace
> backups
> every night and continously backup logical logs using log_full.sh script.
> All works well except one thing: if logical logs start to fill very quick
> (around 50 logs in 2 minutes) error messages start to appear in
> bar_act.log:
>
> "The logical logs are full. ON-Bar may encounter errors writing to the
> sysutils database."
>
> Weird thing is that logs do back up, which can also be seen from
> bar_act.log:
>
> ...
> 2004-05-26 04:15:17 29921 29919 Begin backup logical log 9234.
> 2004-05-26 04:15:18 29976 29974 /usr/informix/bin/onbar_d -b -l
> 2004-05-26 04:15:18 29921 29919 Completed backup logical log 9234
> (Storage
> Manager copy ID: 1085537717 1085537720).
> 2004-05-26 04:15:18 29921 29919 Begin backup logical log 9235.
> 2004-05-26 04:15:18 29976 29974 A log backup is already running. Can't
> start another.
> 2004-05-26 04:15:19 29921 29919 The logical logs are full. ON-Bar may
> encounter errors writing to the sysutils database.
> 2004-05-26 04:15:19 29921 29919 Completed backup logical log 9235
> (Storage
> Manager copy ID: 1085537718 1085537722).
> 2004-05-26 04:15:19 29921 29919 Begin backup logical log 9236.
> ...etc...
>
>
> I thought of increasing the size of logs so they don't fill up so quickly
> but I'm not sure whether it will solve the problem.
> At this moment onconfig looks like this:
>
> # Logical Log Configuration
> LOGFILES 256 # Number of logical log files
> LOGSIZE 512 # Logical log size (Kbytes)>
> The reason why the logs start to fill so quickly is that we have update
> statistics for tables and procedures run every morning at 04:15.
>
> Any ideas?
> Thanks everyone.
>
sending to informix-list