Websmon - Bank 101 on sun.websmon.com: PROGRESS database status report

Bank 101 database running on sun.websmon.com (Sun Solaris 9)

PROGRESS database status report

Database status report was created Wednesday, 28 January 2004 at 19:50,
at which time database Bank 101 had been up for 14 hours 52 minutes.

Database start time: Wed Jan 28 05:00:21 2004
Database was open: Wed Jan 28 05:00:21 2004
Schema cache stamp: Fri May 24 18:41:46 2002

Database is damaged? No

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

Database version is 8275, code page is ibm866, collation table is RUSSIAN
Number of database areas: 1
Highest database table number: 95

Database cache (buffer pool) size: 4096 buffers
Shared memory: 34M is in use, 36M allocated in 3 segments
Shared memory version: 8307
Number of semaphores used: 109

Database block sizes:

DB block size = 8 k
BI block size = 16 k, BI cluster size = 2048 k
AI block size = 8 k

Database space utilization:

Database size is 683946 blocks (5471568 k = 5343 M)
Used DB space is 666323 blocks (5330584 k = 5206 M)
Empty DB space is 45 blocks (360 k), or 0.01% of the total DB size
Database has 17578 free blocks (140624 k = 137 M), 346807 RM blocks 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 34816 k = 34 M
Total number of BI clusters: 17
Number of BI buffers (-bibufs flag): 20
Full BI buffers: 0
Free bytes in the BI cluster that is currently in use: 1794278 (85.56%)
BI open time: Wed Jan 28 05:00:21 2004
Last truncated: Tue Feb 10 02:36:47 1970
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: 0
Time of the most recent checkpoint: Wed Jan 28 05:00:21 2004
0 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 Aug 29 08:55:03 2001
Most recent incremental backup: None
Incremental backup sequence: 0
Database has been changed since last backup? Yes

Database I/O statistics:

869 DB blocks (6952 k = 7 M) read at 0.02 blk/sec:
314 data blocks (2512 k = 2 M)
555 index blocks (4440 k = 4 M)

3 DB blocks (24 k) written at 0.00 blk/sec:
3 data blocks (24 k)
0 index blocks (0 k)

203 BI blocks (3248 k = 3 M) read at 0.00 blk/sec
4 BI blocks (64 k) written at 0.00 blk/sec

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

Database transactions statistics:

3 transactions commited at 0.00 trans/sec
0 transactions undone at 0.00 trans/sec
Last transaction ID is 16335399

Database record and index access statistics:

170390 records read at 3.18 rec/sec
2 records created at 0.00 rec/sec
3 records updated at 0.00 rec/sec
0 records deleted at 0.00 rec/sec

6 indexes created at 0.00 idx/sec
0 indexes deleted at 0.00 idx/sec
0 indexes found at 0.00 idx/sec

Database record locks statistics:

Size of the database locking table: 65536
1 lock (0.0%) is currently in use
High-water mark of the locking table: 2
13 record locks are used since database broker started at 0.00 lk/sec (0.01 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) = 20
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) = 6
Page Writer Maximum Buffers (-pwwmax) = 25
Page Writer Queue Delay (-pwqdelay) = 100
Page Writer Scan Delay (-pwsdelay) = 1
Number of database buffers (-B) = 4096
Direct I/O data transfer (-directio) = No
Locking table size (-L) = 65536
Maximum clients per server (-Ma) = 21
Maximum number of servers (-Mn) = 4
Maximum number of users (-n) = 101
Number of spinlock tries before timeout occurs (-spin) = 8000

Administrator: John Q Sys-Admin