# Websmon - BISquit 4.1c on terra.websmon.com: PROGRESS database status report

#### BISquit 4.1c database running on terra.websmon.com (Red Hat Linux 9)

### PROGRESS database status report

Database status report was created Friday, 16 January 2004 at 21:12,
at which time database BISquit 4.1c had been up for 2 hours 37 minutes.

Database start time: Fri Jan 16 18:35:50 2004
Database was open: Fri Jan 16 18:35:50 2004
Schema cache stamp: Mon Jun 2 00:36:30 2003

Database is damaged? No

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

Database version is 1107, code page is undefined, collation table is basic
Number of database areas: 1
Highest database table number: 11

Database cache (buffer pool) size: 168 buffers
Shared memory: 283K is in use, 452K allocated in 1 segment
Shared memory version: 8303
Number of semaphores used: 29

#### 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 592 blocks (592 k = 1 M)
Used DB space is 519 blocks (519 k = 1 M)
Empty DB space is 73 blocks (73 k), or 12.33% 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 2048 k = 2 M
Total number of BI clusters: 4
Number of BI buffers (-bibufs flag): 5
Full BI buffers: 0
Free bytes in the BI cluster that is currently in use: 516236 (98.46%)
BI open time: Fri Jan 16 18:35:50 2004
Last truncated: Tue Jan 27 10:50:10 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: Fri Jan 16 18:35:51 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 Nov 10 03:28:05 1999
Most recent incremental backup: None
Incremental backup sequence: 0
Database has been changed since last backup? Yes

#### Database I/O statistics:

148 DB blocks (148 k) read at 0.02 blk/sec:
103 data blocks (103 k)
45 index blocks (45 k)
2 DB blocks (2 k) written at 0.00 blk/sec:
2 data blocks (2 k)
0 index blocks (0 k)
13 BI blocks (104 k) read at 0.00 blk/sec
1 BI block (8 k) written at 0.00 blk/sec
0 AI blocks (0 k) written at 0.00 blk/sec

#### Database transactions statistics:

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

#### Database record and index access statistics:

13279 records read at 1.41 rec/sec
0 records created at 0.00 rec/sec
0 records updated at 0.00 rec/sec
0 records deleted at 0.00 rec/sec
0 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: 512
1 lock (0.2%) is currently in use
High-water mark of the locking table: 2
0 record locks are used since database broker started at 0.00 lk/sec (0.00 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) = 1
Page Writer Maximum Buffers (-pwwmax) = 25
Page Writer Queue Delay (-pwqdelay) = 100
Page Writer Scan Delay (-pwsdelay) = 1
Number of database buffers (-B) = 168
Direct I/O data transfer (-directio) = No
Locking table size (-L) = 512
Maximum clients per server (-Ma) = 5
Maximum number of servers (-Mn) = 4
Maximum number of users (-n) = 21
Number of spinlock tries before timeout occurs (-spin) = 0

Administrator: System Administrator

|  |  | Websmon Web-based system performance monitor, version 1.01. Copyright © 2003-2005 Dmitry Lapenkov. All rights reserved.