--- In ib-support@y..., Aage Johansen <aagjohan@o...> wrote:

> a_x_e
>
> Are you monitoring the process from IBConsole (or some other tool)?
> If so, maybe IBConsole is keeping tx 105 open all the time.
>
> Regards,
> Aage J.

yes I use IBCOnsole sometimes to look if everything is ok and to check
that all data is INSERTED / UPDATED correctly in the DB!

But now the best:

thanks to all who tried to help me, the problem is now gone! but dont
ask me how, today in the evening suddenly the "hanging" transaction
disappeared :))) today in the morning I had the following header-stats:

#################

Service started at 12.02.2002 12:39:18

Database header page information:
Flags 0
Checksum 12345
Generation 12975
Page size 4096
ODS version 10.0
Oldest transaction 104
Oldest active 105
Oldest snapshot 105
Next transaction 12969
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Feb 11, 2002 19:33:14
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

Service ended at 12.02.2002 12:39:18

#################

with the help of all who tried to help, we came to the result that
transaction 105 is "hanging"/open.
today in the evening i just stopped/started the server a few times,
tried to backup with ignoring limbo transactions and now the
header-stats look like

#################

Service started at 12.02.2002 21:45:47

Database header page information:
Flags 0
Checksum 12345
Generation 19573
Page size 4096
ODS version 10.0
Oldest transaction 19480
Oldest active 19561
Oldest snapshot 19561
Next transaction 19566
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Feb 11, 2002 19:33:14
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

Service ended at 12.02.2002 21:45:48

######################

the open transaction 105 is gone!!! I really dont know why it is now
gone and why it took many days until it disappeared today, but now my
db-file-size does not grow so quickly anymore :))

THANKS!!