Hello Steffen,

>
>> That information is available in the database header, so it can be viewed
>> using "gstat".
>
> I tried about everything, but I cannot find it in any output of gstat.
> Can you tell me the correct commandline and what to look for ?
>
> I only get this:
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 65540
> Page size 16384
> ODS version 11.0
> Oldest transaction 58022
> Oldest active 65533
> Oldest snapshot 65533
> Next transaction 65534
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 24
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Oct 8, 2010 9:58:08
> Attributes

Attributes lists "forced writes" if forced writes is enabled.

> Variable header data:
> Sweep interval: 20000
> *END*

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!