[ main ] [ back ]

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

[ main ] [ back ]
  [ Websmon logo ]   websmon Web-based system monitor.
Copyright © 2003, 2004 Dmitry Lapenkov. All rights reserved.