This transaction displays details about this instance and server.

Click BACK to return.

DBAmon Informix-UX Instance Details: jaguar:SAP-MPP

This page was programatically recreated by DBAmon - Wed Mar 21 17:48:43 MST 2001

Informix Instance Data

ParameterValueComments
INFORMIXDIR:/informix/MPP
INFORMIXSERVER:jaguarmppshm
INFORMIXSQLHOSTS:/informix/MPP/etc/sqlhosts.soc
ONCONFIG:onconfig.jaguar.mpp
Informix Version:7.31.UC7A
Informix Serial Number:ACM#J758089
Number of Databases:3
Number of DBSpaces:43
Number of Tables:-1(-1 if dbamonrc Count_Tables: = N)
Number of Disks Containing Informix Data:124
Number of Informix Shared Memory Segments:(Shared Segments are BAD)
INFORMIXDIR FS Name:/informix
INFORMIXDIR FS Size(MB):512
INFORMIXDIR FS Used(MB):255
INFORMIXDIR FS Available(MB):240
INFORMIXDIR FS Percent Full:52
INFORMIXDIR FS Status Flag:OK

Server Data

ParameterValueComments
OS Type:UX
OS Version:11.00
OS Mode:64(64 or Blank)
Server Type:V2500
Server Memory (MB):8188
Server Processor Count:12

Informix DBSpaces

DBSpaceChunksSize (MB)Free (MB)Used (MB)Percent FullStatus:
W=Warning
C=Critical
logdbs
1
2080
1
2079
99
logdbs1
2
3137
0
3137
100
physdbs
2
221
67
154
69
psapacctit
37
20933
3689
17244
82
psapapqd
4
650
87
563
86
psapausp
15
3337
418
2919
87
psapbkpf
11
1352
193
1159
85
psapbsis
32
11390
855
10535
92
psapbtab
47
87323
1922
85401
97
psapclu
30
9552
2733
6819
71
psapcoep
26
8970
1001
7969
88
psapcosp
33
29966
1717
28249
94
psapcospi
3
2753
377
2376
86
psapcoss
3
1415
288
1127
79
psapddic
2
647
174
473
73
psapdocu
2
66
35
31
46
psapel31h
9
1399
190
1209
86
psapes31h
5
3463
470
2993
86
psapglsp
1
1056
800
256
24
psapjest
10
3436
757
2679
77
psapjsto
5
972
102
870
89
psapload
1
204
204
0
0
psapmoni
1
512
153
359
70
psapmseg
32
9884
5004
4880
49
psapmsta
1
512
307
205
40
psappool
8
3874
911
2963
76
psapprot
1
256
107
149
58
psapresb
16
6586
442
6144
93
W
psapresi
3
698
81
617
88
psaprfblg
19
3174
427
2747
86
psapsis
28
11473
861
10612
92
psapsnap
3
1551
322
1229
79
psapsource
1
819
716
103
12
psapstab
12
10527
1614
8913
84
psapstxh
15
2069
169
1900
91
W
psapstxl
4
388
55
333
85
psaptst03
4
1594
314
1280
80
psapuser1
11
2946
518
2428
82
psapvbfa
11
1619
435
1184
73
psapwflow
15
2122
2122
0
0
rootdbs
2
256
124
132
51
tmpdbs1
2
1024
1018
6
0
tmpdbs2
3
1466
1461
5
0
Totals:
473
257672
33241
224431
87

Informix Page Cleaner Data

ParameterValueComments
Current CLEANERS ONCONFIG Value:114
Current LRUS ONCONFIG value:32
Current Number of Disks:124
% of Disks That Have a Cleaner:91
% of Disks ... Threshold:75

Informix Logical Log Status

ParameterValueComments
Number of Logical Log Files:327
Number of Full Logical Log Files:1
Percent of Logical Log Files That Are Full:0.305810397553517

Informix Backup History - Backup Method: ONArchive - All Backups During the Last 45 Days

All ONArchive Backups During the Last 45 Days

DataTimeLevelRIDDBSpace SetDays Ago
2001-03-2119:37:06157root10
2001-03-2022:17:25175sap21
2001-03-2022:17:05174sap11
2001-03-2022:15:43171root11
2001-03-1922:09:24194sap22
2001-03-1922:09:03193sap12
2001-03-1922:07:41182root12
2001-03-1901:04:38169sap22
2001-03-1901:04:18111sap12
2001-03-1901:02:57192root12
2001-03-1722:08:30188sap24
2001-03-1722:08:09187sap14
2001-03-1722:06:48186root14
2001-03-1622:17:34030sap25
2001-03-1622:17:13029sap15
2001-03-1622:15:48067root15
2001-03-1522:15:28144sap26
2001-03-1522:13:45143root16
2001-03-1422:11:27152sap27
2001-03-1422:09:44146root17
2001-03-1415:35:04122sap27
2001-03-1415:33:22120root17
2001-03-1409:49:3415sap27
2001-03-1409:47:48164root17
2001-03-1222:12:31161sap29
2001-03-1222:10:46158root19
2001-03-1217:04:17112sap29
2001-03-1217:02:30134root19
2001-03-1107:33:33137sap210
2001-03-1107:31:51136root110
2001-03-0922:12:3206sap212
2001-03-0922:12:1104sap112
2001-03-0922:09:42060root112

Backup Parameters

ParameterValueComments
Age of Most Recent Backup (Hours):0
Age of Most Recent LVL0 Backup (Days):5
Backup Running Now?:Y

Informix Message Log


Informix Dynamic Server Version 7.31.UC7A   -- On-Line -- Up 2 days 21:42:21 -- 1681160 Kbytes

Message Log File: /informix/MPP/online.jaguar.mpp.log
19:15:22  Logical Log 283670 - Backup Started
19:15:25  Logical Log 283671 - Backup Started
19:15:28  Logical Log 283672 - Backup Started
19:15:29  Logical Log 283672 Complete.
19:15:31  Logical Log 283670 - Backup Completed
19:15:31  Logical Log 283671 - Backup Completed
19:15:31  Logical Log 283672 - Backup Completed
19:15:32  db_switch_log_big: SaveSet 00000056 successfully created - Size=68MB
19:31:26  db_backup_mgr: Level 1 Backup Starting (03/21/01-19:31:26)
19:37:32  Checkpoint Completed:  duration was 1 seconds.
19:37:32  Level 1 Archive started on rootdbs, physdbs, logdbs, logdbs1
19:37:56  Archive on rootdbs, physdbs, logdbs, logdbs1 Completed.
19:38:56  Checkpoint Completed:  duration was 0 seconds.
19:39:02  Level 1 Archive started on psapbtab, psaptst03, psapapqd, psapclu, psapresb, psappool, psapsource, psapddic, psapcoss, psapausp, psapstxl, psapbkpf, psapjsto, psapmsta, psapload, psaprfblg
19:39:14  Checkpoint Completed:  duration was 0 seconds.
19:39:26  Level 1 Archive started on psapcosp, psapstab, psapdocu, psapuser1, psapes31h, psapel31h, psapacctit, psapcoep, psapmseg, psapjest, psapvbfa, psapsis, psapglsp, psapmoni, psapsnap, psapwflow, psapbsis, psapstxh, psapprot, psapresi, psapcospi
19:45:32  Logical Log 283673 - Backup Started
19:45:32  Logical Log 283673 Complete.
19:45:34  Logical Log 283673 - Backup Completed
19:45:35  db_switch_log_big: SaveSet 00000053 successfully created - Size=14MB

Informix Performance Metrics

MetricValue
Read Hit Ratio:90.41
Write Hit Ratio:85.01
Bufreads:1041522155
Ovbuff:
Ovtbls:
Ovlock:
Ovuser: