Hello Olaf,

> i’ve a problem with out database. The size of the file increase and
> increase. Here are the status:
>
>
>
> flags: 0
>
> checksum: 12345
>
> generation: 3311
>
> page size: 4096
>
> ods version: 11.1
>
> oldest transaction: 86
>
> oldest active: 87
>
> oldest snapshot: 87
>
> next transaction: 3303
>
> bumped transaction: 1
>
> sequence number: 0
>
> next attachement ID: 9
>
> implementation ID: 16
>
> shadow count: 0
>
> page puffers: 0
>
> next header page: 0
>
> database dialect: 3
>
> creation date: dec. 3, 2008, 10: 30:42
>
> attributes: force write
>
>
>
> variable header data:
>
> sweep interval: 20000
>
>
>
>
>
> The firebird.log containt the follow messages:
>
>
>
> DBSRV (Server) Wed Dec 03 10:24:46 2008
>
> INET/inet_error: read errno = 10054
>
>
>
> I’m using firebird 2.1 superserver
>
>
>
> Some Clients has a connection to firebird (java netbeans). One Procedure
> does update one table 10 times in a second (state-table) Is this a problem?
>
>
>
> Please, can you help me, how can I make the database more stable? How can
> the database protect itself?
>
>
>
> This problem I have on more firebird database (upper size in a few days)

Use the MON$ tables in your ODS 11.1 database to identify a possibly
long-running transactions.

You could also try our freely available Firebird transaction statistic
logger (FTSL) to spot if the gap increases steadily or only at a
particular time. Look here for the download link:
http://blog.upscene.com/thomas/index.php?d=02&m=12&y=08&category=12




--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/