Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Bill Dare — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.