Websmon - Qwerty Insurance on saturn.websmon.com: PROGRESS database status report

Qwerty Insurance database running on saturn.websmon.com (SCO UnixWare 7.1.1)

PROGRESS database status report

Database status report was created Wednesday, 28 January 2004 at 19:51,
at which time database Qwerty Insurance had been up for 20 days, 2 hours 32 minutes.

Database start time: Thu Jan 8 17:25:40 2004
Database was open: Thu Jan 8 17:25:40 2004
Schema cache stamp: Thu May 30 11:04:04 2002

Database is damaged? No

Database user connections: 4 (4 users, 0 batches)
Maximum number of connections: 43
Number of SELF clients connected: 2
Number of REMC clients connected: 2
Number of database servers running: 3
Number of Async Page Writers running: 1

Database version is 1107, code page is 1251, collation table is RUSSIAN
Number of database areas: 1
Highest database table number: 99

Database cache (buffer pool) size: 10240 buffers
Shared memory: 13M is in use, 13M allocated in 1 segment
Shared memory version: 8305
Number of semaphores used: 51

Database block sizes:

DB block size = 1 k
BI block size = 8 k, BI cluster size = 512 k
AI block size = 8 k

Database space utilization:

Database size is 554864 blocks (554864 k = 542 M)
Used DB space is 554809 blocks (554809 k = 542 M)
Empty DB space is 55 blocks (55 k), or 0.01% of the total DB size
Database has 0 free blocks (0 k), 1 RM block with free space

Before Imaging statistics:

Database integrity is enabled (-i flag)
Before Image Writer is not running
BI I/O type is reliable
BI size is 23040 k = 22 M
Total number of BI clusters: 45
Number of BI buffers (-bibufs flag): 5
Full BI buffers: 0
Free bytes in the BI cluster that is currently in use: 426628 (81.37%)
BI open time: Thu Jan 8 17:25:40 2004
Last truncated: Fri Jan 22 02:55:09 1971
BI cluster age: 60 sec
Name of the BI file (-g flag): None
Total number of BI extents: 0
BI truncate interval: 60 sec
Commit delay (delayed BI file write, -Mf flag): 3

Database Checkpoints statistics:

Number of checkpoints performed: 17
Time of the most recent checkpoint: Wed Jan 28 18:49:15 2004
64 blocks were flushed at the end of the checkpoint

After Imaging statistics:

After Imaging is enabled for the database? No
After Image Writer is not running
AI I/O type is ---
Most recent AIMAGE BEGIN: ---
Most recent AIMAGE NEW: ---
Most recent AI open time: ---
Name of the AI file (-a flag): None
Current AI extent: 0
Generation number of the current AI extent: 0
Total number of AI extents: 0
Size of the fixed-length AI extent: 0 k
Number of buffers in the AI buffer pool (-aibufs flag): 0

Database backup statistics:

Most recent full backup date: Wed Oct 23 11:34:34 2002
Most recent incremental backup: None
Incremental backup sequence: 0
Database has been changed since last backup? Yes

Database I/O statistics:

45496 DB blocks (45496 k = 44 M) read at 0.03 blk/sec:
38543 data blocks (38543 k = 38 M)
6953 index blocks (6953 k = 7 M)

4833 DB blocks (4833 k = 5 M) written at 0.00 blk/sec:
2067 data blocks (2067 k = 2 M)
2766 index blocks (2766 k = 3 M)

577 BI blocks (4616 k = 5 M) read at 0.00 blk/sec
1149 BI blocks (9192 k = 9 M) written at 0.00 blk/sec

0 AI blocks (0 k) written at 0.00 blk/sec

Database transactions statistics:

9750 transactions commited at 0.01 trans/sec
39 transactions undone at 0.00 trans/sec
Last transaction ID is 1834908

Database record and index access statistics:

4944296 records read at 2.85 rec/sec
4569 records created at 0.00 rec/sec
5158 records updated at 0.00 rec/sec
1434 records deleted at 0.00 rec/sec

25447 indexes created at 0.01 idx/sec
17045 indexes deleted at 0.01 idx/sec
0 indexes found at 0.00 idx/sec

Database record locks statistics:

Size of the database locking table: 65536
2 locks (0.0%) is currently in use
High-water mark of the locking table: 1723
75178 record locks are used since database broker started at 0.04 lk/sec (2.60 lk/min)
0 times users had to wait for record locks

PROGRESS database broker startup parameters:

Database integrity = enabled (-i = 0)
Number of BI buffers (-bibufs) = 5
Delayed BI File Write (-Mf) = 3
Delay of BI Flush (-mf) = 3
BI file I/O (-r, -R) = reliable (1)
BI truncate interval (-G) = 60
Number of buffers in AI buffer (-aibufs) = 0
Page Writer Scan (-pwscan) = 17
Page Writer Maximum Buffers (-pwwmax) = 25
Page Writer Queue Delay (-pwqdelay) = 100
Page Writer Scan Delay (-pwsdelay) = 1
Number of database buffers (-B) = 10240
Direct I/O data transfer (-directio) = No
Locking table size (-L) = 65536
Maximum clients per server (-Ma) = 9
Maximum number of servers (-Mn) = 4
Maximum number of users (-n) = 43
Number of spinlock tries before timeout occurs (-spin) = 0

Administrator: John Q Sys-Admin