Server Info
Server Type: Standard
Version: 14.10.FC1IE
Server Time: 04:12:40
Boot Time: 2020-08-08 06:13
Up Time: 21:58
Sessions: 6
Max Sessions: 108
Operating System
Total Mem: 3.86 GB
Free Mem: 3.42 GB
# of CPUs: 1
Collapse Menu

Alert Report

 
Alert List (max. 500 rows)
SeverityAlert TypeIDObject TypeObject NameMessageTimeAlert StateAction DBSAction
YELLOWINFO31714ALARM 23Logical Log 3690 Complete, timestamp: 0x7f4b55ba.2020-08-09 03:30:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31713SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 47.2519 Duration in seconds
Additional Info: at Time: 2020-08-09 01:21:21
mon_checkpoint Status: YELLOW with value: 30.1353 Duration in seconds
Additional Info: at Time: 2020-08-09 01:10:37
2020-08-09 02:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31712SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 91.0575 Duration in seconds
Additional Info: at Time: 2020-08-09 00:13:04
mon_checkpoint Status: RED with value: 79.7539 Duration in seconds
Additional Info: at Time: 2020-08-09 00:23:39
mon_checkpoint Status: RED with value: 106.1891 Duration in seconds
Additional Info: at Time: 2020-08-09 00:18:50
2020-08-09 01:16:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31711DATABASE Auto Update StatisticsFound 49 table(s) in database tpcc which need statistics updated.2020-08-09 01:03:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31710DATABASE Auto Update StatisticsFound 91 table(s) in database sysadmin which need statistics updated.2020-08-09 01:03:06NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31709DATABASE Auto Update StatisticsFound 49 table(s) in database sysuser which need statistics updated.2020-08-09 01:02:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31708DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-08-09 01:01:55NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31707DATABASE Auto Update StatisticsFound 186 table(s) in database sysmaster which need statistics updated.2020-08-09 01:01:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31706SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 31.7920 Duration in seconds
Additional Info: at Time: 2020-08-08 23:50:41
2020-08-09 00:16:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31705ALARM 23Logical Log 3689 Complete, timestamp: 0x7f43c404.2020-08-08 22:59:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31704ALARM 23Logical Log 3688 Complete, timestamp: 0x7f3a7bc1.2020-08-08 15:51:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31703TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 597 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-08 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31702SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 855 20:10:22. Recommend taking a level 0 backup immediately.2020-08-08 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31701SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 855 20:10:22. Recommend taking a level 0 backup immediately.2020-08-08 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31700SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 855 20:10:22. Recommend taking a level 0 backup immediately.2020-08-08 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31698SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 855 20:10:22. Recommend taking a level 0 backup immediately.2020-08-08 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31697SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 855 20:10:22. Recommend taking a level 0 backup immediately.2020-08-08 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31699SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 855 20:10:22. Recommend taking a level 0 backup immediately.2020-08-08 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31696ALARM 23Logical Log 3687 Complete, timestamp: 0x7f32399c.2020-08-08 10:17:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31695SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 34.4688 Duration in seconds
Additional Info: at Time: 2020-08-08 06:30:04
mon_checkpoint Status: YELLOW with value: 31.0194 Duration in seconds
Additional Info: at Time: 2020-08-08 06:19:45
2020-08-08 07:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31694MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-08-08 06:15:11NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31693SERVER scout-demo-1 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:33 IBM Informix Dynamic Server Stopped.

06:13:44 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:13:45 IBM Informix Dynamic Server Started.
06:13:45 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:13:45 the total shared memory size for this server to 2097152 KB.
06:13:45 The maximum allowable shared memory was reset to this size to start the database server.
06:13:45 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:45 Requested shared memory segment size rounded from 15636KB to 16256KB
06:13:45 Segment locked: addr=0x44000000, size=16646144
06:13:45 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:45 Segment locked: addr=0x44fe0000, size=524288000

Sat Aug 8 06:13:52 2020

06:13:52 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:52 Requested shared memory segment size rounded from 221001KB to 221004KB
06:13:52 Segment locked: addr=0x643e0000, size=226308096
06:13:52 Successfully added a bufferpool of page size 2K.

06:13:53 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:13:57 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:13:58 Secure Sockets Layer (SSL) initialized.
06:13:59 Booting Language from module <>
06:13:59 Loading Module
06:13:59 Booting Language from module <>
06:13:59 Loading Module
06:14:05 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:14:05 Ev
2020-08-08 06:14:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31692SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 362.3600 Duration in seconds
Additional Info: at Time: 2020-08-08 04:17:25
mon_checkpoint Status: YELLOW with value: 35.1021 Duration in seconds
Additional Info: at Time: 2020-08-08 04:50:38
mon_checkpoint Status: YELLOW with value: 32.3773 Duration in seconds
Additional Info: at Time: 2020-08-08 04:55:40
mon_checkpoint Status: YELLOW with value: 31.4067 Duration in seconds
Additional Info: at Time: 2020-08-08 04:18:26
2020-08-08 05:16:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31691SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 60955 Number of session locks
Additional Info: Username: informix
Session Id: 7039
2020-08-08 04:16:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31690SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 62.6330 Duration in seconds
Additional Info: at Time: 2020-08-08 03:46:05
mon_checkpoint Status: RED with value: 52.5205 Duration in seconds
Additional Info: at Time: 2020-08-08 03:40:31
mon_checkpoint Status: RED with value: 43.7400 Duration in seconds
Additional Info: at Time: 2020-08-08 03:50:48
mon_checkpoint Status: YELLOW with value: 31.0842 Duration in seconds
Additional Info: at Time: 2020-08-08 03:35:09
mon_checkpoint Status: RED with value: 134.0134 Duration in seconds
Additional Info: at Time: 2020-08-08 04:08:22
2020-08-08 04:16:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31689ALARM 23Logical Log 3686 Complete, timestamp: 0x7f282c7e.2020-08-08 04:09:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31688SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 53.4728 Duration in seconds
Additional Info: at Time: 2020-08-08 01:27:06
mon_checkpoint Status: RED with value: 45.3874 Duration in seconds
Additional Info: at Time: 2020-08-08 01:37:38
mon_checkpoint Status: YELLOW with value: 36.8610 Duration in seconds
Additional Info: at Time: 2020-08-08 01:21:42
mon_checkpoint Status: YELLOW with value: 32.8491 Duration in seconds
Additional Info: at Time: 2020-08-08 01:42:40
mon_checkpoint Status: YELLOW with value: 32.3580 Duration in seconds
Additional Info: at Time: 2020-08-08 01:11:09
2020-08-08 02:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31687SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 86.1168 Duration in seconds
Additional Info: at Time: 2020-08-08 00:24:08
mon_checkpoint Status: RED with value: 135.6803 Duration in seconds
Additional Info: at Time: 2020-08-08 00:30:23
mon_checkpoint Status: RED with value: 125.0704 Duration in seconds
Additional Info: at Time: 2020-08-08 00:19:41
mon_checkpoint Status: RED with value: 114.6097 Duration in seconds
Additional Info: at Time: 2020-08-08 00:14:06
2020-08-08 01:16:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31686ALARM 23Logical Log 3685 Complete, timestamp: 0x7f1f9039.2020-08-08 01:07:05NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31685DATABASE Auto Update StatisticsFound 50 table(s) in database tpcc which need statistics updated.2020-08-08 01:05:10NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31684DATABASE Auto Update StatisticsFound 111 table(s) in database sysadmin which need statistics updated.2020-08-08 01:04:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31683DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-08-08 01:03:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31682DATABASE Auto Update StatisticsFound 41 table(s) in database sysutils which need statistics updated.2020-08-08 01:02:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31681DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-08-08 01:02:06NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31680SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.7758 Duration in seconds
Additional Info: at Time: 2020-08-08 00:02:18
2020-08-08 00:16:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31679SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 44.6681 Duration in seconds
Additional Info: at Time: 2020-08-07 21:31:06
2020-08-07 22:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31678ALARM 23Logical Log 3684 Complete, timestamp: 0x7f16cb04.2020-08-07 19:07:04NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31677SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 30.9524 Duration in seconds
Additional Info: at Time: 2020-08-07 12:44:22
2020-08-07 13:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31676ALARM 23Logical Log 3683 Complete, timestamp: 0x7f0df115.2020-08-07 12:41:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31675TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 596 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-07 12:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31674SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 854 20:10:25. Recommend taking a level 0 backup immediately.2020-08-07 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31669SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 854 20:10:25. Recommend taking a level 0 backup immediately.2020-08-07 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31673SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 854 20:10:25. Recommend taking a level 0 backup immediately.2020-08-07 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31672SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 854 20:10:25. Recommend taking a level 0 backup immediately.2020-08-07 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31671SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 854 20:10:25. Recommend taking a level 0 backup immediately.2020-08-07 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31670SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 854 20:10:25. Recommend taking a level 0 backup immediately.2020-08-07 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31668SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 35.1282 Duration in seconds
Additional Info: at Time: 2020-08-07 06:38:15
2020-08-07 07:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31667ALARM 23Logical Log 3682 Complete, timestamp: 0x7f0521a0.2020-08-07 06:21:48NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31666MISC SQL TraceIncrease SQL-Trace-Buffer to 40000 SQLs - used Memory per SQL 2k.2020-08-07 06:19:01NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31665MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-08-07 06:18:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31664SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:25 IBM Informix Dynamic Server Stopped.

06:16:31 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:16:33 IBM Informix Dynamic Server Started.
06:16:33 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:16:33 the total shared memory size for this server to 2097152 KB.
06:16:33 The maximum allowable shared memory was reset to this size to start the database server.
06:16:33 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:16:33 Requested shared memory segment size rounded from 15636KB to 16256KB
06:16:33 Segment locked: addr=0x44000000, size=16646144
06:16:33 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:16:33 Segment locked: addr=0x44fe0000, size=524288000

Fri Aug 7 06:16:39 2020

06:16:39 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:16:39 Requested shared memory segment size rounded from 221001KB to 221004KB
06:16:39 Segment locked: addr=0x643e0000, size=226308096
06:16:39 Successfully added a bufferpool of page size 2K.

06:16:41 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:16:50 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:16:52 Secure Sockets Layer (SSL) initialized.
06:16:53 Booting Language from module <>
06:16:53 Loading Module
06:16:53 Booting Language from module <>
06:16:53 Loading Module
06:17:00 CCFLAGS2 value set to 0x200
06:17:00 SQL_FEAT_CTRL value set to 0x8008
06:17:00 SQL_DEF_CTRL value set to 0x4b0
06:17:00 Waiting 600 seconds for startu
2020-08-07 06:17:42NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31663SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 86.4666 Duration in seconds
Additional Info: at Time: 2020-08-07 04:20:47
mon_checkpoint Status: RED with value: 44.0175 Duration in seconds
Additional Info: at Time: 2020-08-07 04:46:30
mon_checkpoint Status: RED with value: 395.2016 Duration in seconds
Additional Info: at Time: 2020-08-07 04:18:51
mon_checkpoint Status: YELLOW with value: 34.4901 Duration in seconds
Additional Info: at Time: 2020-08-07 04:41:17
mon_checkpoint Status: YELLOW with value: 34.3777 Duration in seconds
Additional Info: at Time: 2020-08-07 04:30:45
mon_checkpoint Status: YELLOW with value: 33.3093 Duration in seconds
Additional Info: at Time: 2020-08-07 05:01:35
mon_checkpoint Status: YELLOW with value: 31.9856 Duration in seconds
Additional Info: at Time: 2020-08-07 04:51:31
mon_checkpoint Status: YELLOW with value: 30.5532 Duration in seconds
Additional Info: at Time: 2020-08-07 05:06:36
mon_checkpoint Status: YELLOW with value: 30.1007 Duration in seconds
Additional Info: at Time: 2020-08-07 04:56:32
mon_checkpoint Status: RED with value: 188.3937 Duration in seconds
Additional Info: at Time: 2020-08-07 04:10:16
2020-08-07 05:16:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31662SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 55912 Number of session locks
Additional Info: Username: informix
Session Id: 7051
2020-08-07 04:16:25NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31661SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 75.1701 Duration in seconds
Additional Info: at Time: 2020-08-07 03:42:52
mon_checkpoint Status: RED with value: 73.1650 Duration in seconds
Additional Info: at Time: 2020-08-07 03:48:04
mon_checkpoint Status: RED with value: 43.1222 Duration in seconds
Additional Info: at Time: 2020-08-07 03:37:07
mon_checkpoint Status: YELLOW with value: 32.8322 Duration in seconds
Additional Info: at Time: 2020-08-07 03:52:38
mon_checkpoint Status: YELLOW with value: 30.0640 Duration in seconds
Additional Info: at Time: 2020-08-07 03:57:38
2020-08-07 04:16:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31660ALARM 23Logical Log 3681 Complete, timestamp: 0x7efa7c76.2020-08-07 02:35:01NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31659SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 99.9431 Duration in seconds
Additional Info: at Time: 2020-08-07 00:20:42
mon_checkpoint Status: RED with value: 88.0708 Duration in seconds
Additional Info: at Time: 2020-08-07 00:25:41
mon_checkpoint Status: RED with value: 164.1426 Duration in seconds
Additional Info: at Time: 2020-08-07 00:32:26
mon_checkpoint Status: RED with value: 102.4714 Duration in seconds
Additional Info: at Time: 2020-08-07 00:15:33
2020-08-07 01:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31658DATABASE Auto Update StatisticsFound 50 table(s) in database tpcc which need statistics updated.2020-08-07 01:04:59NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31657DATABASE Auto Update StatisticsFound 111 table(s) in database sysadmin which need statistics updated.2020-08-07 01:04:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31656DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-08-07 01:03:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31655DATABASE Auto Update StatisticsFound 41 table(s) in database sysutils which need statistics updated.2020-08-07 01:02:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31654DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-08-07 01:02:09NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31653SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 33.0375 Duration in seconds
Additional Info: at Time: 2020-08-06 23:53:52
mon_checkpoint Status: YELLOW with value: 32.2361 Duration in seconds
Additional Info: at Time: 2020-08-06 23:58:54
mon_checkpoint Status: YELLOW with value: 31.4514 Duration in seconds
Additional Info: at Time: 2020-08-07 00:09:21
2020-08-07 00:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31652SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.6181 Duration in seconds
Additional Info: at Time: 2020-08-06 21:11:40
2020-08-06 22:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31651ALARM 23Logical Log 3680 Complete, timestamp: 0x7ef1ba46.2020-08-06 20:34:02NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31650ALARM 23Logical Log 3679 Complete, timestamp: 0x7ee8753b.2020-08-06 13:24:05NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31649SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 36.0032 Duration in seconds
Additional Info: at Time: 2020-08-06 12:42:50
2020-08-06 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31648TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 581 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-06 12:16:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31647SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 853 20:10:30. Recommend taking a level 0 backup immediately.2020-08-06 12:08:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31646SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 853 20:10:29. Recommend taking a level 0 backup immediately.2020-08-06 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31644SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 853 20:10:29. Recommend taking a level 0 backup immediately.2020-08-06 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31645SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 853 20:10:29. Recommend taking a level 0 backup immediately.2020-08-06 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31642SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 853 20:10:28. Recommend taking a level 0 backup immediately.2020-08-06 12:08:37NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31643SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 853 20:10:28. Recommend taking a level 0 backup immediately.2020-08-06 12:08:37NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31641ALARM 23Logical Log 3678 Complete, timestamp: 0x7ee029be.2020-08-06 07:48:02NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31640SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 43.6755 Duration in seconds
Additional Info: at Time: 2020-08-06 06:21:31
2020-08-06 07:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31639MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-08-06 06:16:54NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31638SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:28 IBM Informix Dynamic Server Stopped.

06:15:06 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:15:06 IBM Informix Dynamic Server Started.
06:15:06 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:15:06 the total shared memory size for this server to 2097152 KB.
06:15:06 The maximum allowable shared memory was reset to this size to start the database server.
06:15:06 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:06 Requested shared memory segment size rounded from 15636KB to 16256KB
06:15:06 Segment locked: addr=0x44000000, size=16646144
06:15:06 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:06 Segment locked: addr=0x44fe0000, size=524288000

Thu Aug 6 06:15:12 2020

06:15:12 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:12 Requested shared memory segment size rounded from 221001KB to 221004KB
06:15:12 Segment locked: addr=0x643e0000, size=226308096
06:15:12 Successfully added a bufferpool of page size 2K.

06:15:13 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:15:24 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:15:25 Secure Sockets Layer (SSL) initialized.
06:15:28 Booting Language from module <>
06:15:28 Loading Module
06:15:28 Booting Language from module <>
06:15:28 Loading Module
06:15:34 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:15:34 Ev
2020-08-06 06:16:44NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31637SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 34.8056 Duration in seconds
Additional Info: at Time: 2020-08-06 04:30:05
mon_checkpoint Status: YELLOW with value: 34.3255 Duration in seconds
Additional Info: at Time: 2020-08-06 04:35:09
mon_checkpoint Status: RED with value: 331.4594 Duration in seconds
Additional Info: at Time: 2020-08-06 04:18:17
mon_checkpoint Status: YELLOW with value: 31.5108 Duration in seconds
Additional Info: at Time: 2020-08-06 04:40:10
mon_checkpoint Status: RED with value: 197.6799 Duration in seconds
Additional Info: at Time: 2020-08-06 04:10:46
2020-08-06 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31636SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 73179 Number of session locks
Additional Info: Username: informix
Session Id: 7045
2020-08-06 04:16:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31635SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 69.0132 Duration in seconds
Additional Info: at Time: 2020-08-06 03:42:33
mon_checkpoint Status: RED with value: 53.1047 Duration in seconds
Additional Info: at Time: 2020-08-06 03:47:27
mon_checkpoint Status: YELLOW with value: 38.2339 Duration in seconds
Additional Info: at Time: 2020-08-06 03:36:54
mon_checkpoint Status: YELLOW with value: 32.0910 Duration in seconds
Additional Info: at Time: 2020-08-06 03:57:31
mon_checkpoint Status: YELLOW with value: 30.9921 Duration in seconds
Additional Info: at Time: 2020-08-06 03:52:28
2020-08-06 04:16:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31634ALARM 23Logical Log 3677 Complete, timestamp: 0x7ed586ff.2020-08-06 04:04:57NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31633SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.8115 Duration in seconds
Additional Info: at Time: 2020-08-06 01:39:07
2020-08-06 02:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31632SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 65.4400 Duration in seconds
Additional Info: at Time: 2020-08-06 00:15:51
mon_checkpoint Status: RED with value: 54.3872 Duration in seconds
Additional Info: at Time: 2020-08-06 00:20:45
mon_checkpoint Status: RED with value: 127.9583 Duration in seconds
Additional Info: at Time: 2020-08-06 00:32:44
mon_checkpoint Status: RED with value: 109.6443 Duration in seconds
Additional Info: at Time: 2020-08-06 00:27:04
2020-08-06 01:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31631DATABASE Auto Update StatisticsFound 50 table(s) in database tpcc which need statistics updated.2020-08-06 01:04:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31630DATABASE Auto Update StatisticsFound 101 table(s) in database sysadmin which need statistics updated.2020-08-06 01:03:44NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31629DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-08-06 01:02:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31628DATABASE Auto Update StatisticsFound 41 table(s) in database sysutils which need statistics updated.2020-08-06 01:02:09NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31627DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-08-06 01:01:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31626ALARM 23Logical Log 3676 Complete, timestamp: 0x7ecce183.2020-08-05 22:03:11NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31625ALARM 23Logical Log 3675 Complete, timestamp: 0x7ec37d37.2020-08-05 14:53:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31624SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 37.2142 Duration in seconds
Additional Info: at Time: 2020-08-05 12:40:08
2020-08-05 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31623TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 600 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-05 12:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31622SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 852 20:10:27. Recommend taking a level 0 backup immediately.2020-08-05 12:08:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31619SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 852 20:10:27. Recommend taking a level 0 backup immediately.2020-08-05 12:08:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31621SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 852 20:10:27. Recommend taking a level 0 backup immediately.2020-08-05 12:08:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31620SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 852 20:10:27. Recommend taking a level 0 backup immediately.2020-08-05 12:08:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31617SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 852 20:10:26. Recommend taking a level 0 backup immediately.2020-08-05 12:08:35NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31618SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 852 20:10:26. Recommend taking a level 0 backup immediately.2020-08-05 12:08:35NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31616ALARM 23Logical Log 3674 Complete, timestamp: 0x7ebb32de.2020-08-05 09:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31615MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-08-05 06:17:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31614SERVER scout-demo-2 - Found:stop,warning,shared,added,load,mode,errMessage from PRIMARY-instance: ol_scout

06:00:59 IBM Informix Dynamic Server Stopped.

06:15:56 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:15:59 IBM Informix Dynamic Server Started.
06:15:59 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:15:59 the total shared memory size for this server to 2097152 KB.
06:15:59 The maximum allowable shared memory was reset to this size to start the database server.
06:15:59 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:59 Requested shared memory segment size rounded from 15636KB to 16256KB
06:15:59 Segment locked: addr=0x44000000, size=16646144
06:15:59 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:59 Segment locked: addr=0x44fe0000, size=524288000

Wed Aug 5 06:16:07 2020

06:16:07 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:16:07 Requested shared memory segment size rounded from 221001KB to 221004KB
06:16:07 Segment locked: addr=0x643e0000, size=226308096
06:16:07 Successfully added a bufferpool of page size 2K.

06:16:09 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:16:23 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:16:24 Secure Sockets Layer (SSL) initialized.
06:16:25 Booting Language from module <>
06:16:25 Loading Module
06:16:25 Booting Language from module <>
06:16:25 Loading Module
06:16:33 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:16:33 Ev
2020-08-05 06:17:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31613SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 381.2001 Duration in seconds
Additional Info: at Time: 2020-08-05 04:16:14
2020-08-05 05:16:26NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31612SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 161745 Number of session locks
Additional Info: Username: informix
Session Id: 7051
2020-08-05 04:16:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31611SERVER CAS: mon_users - upf_logspuse - log space currently used in byteThe amount of log space consumed in bytes by the current transaction
Threshold Red : 30000000
Threshold Yellow : 10000000

mon_users Status: YELLOW with value: 13909972.0000 log space currently used in byte
Additional Info: Username: informix
Session Id: 7051
2020-08-05 04:16:17NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31610SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 66.2728 Duration in seconds
Additional Info: at Time: 2020-08-05 03:39:27
mon_checkpoint Status: RED with value: 64.1981 Duration in seconds
Additional Info: at Time: 2020-08-05 03:44:31
mon_checkpoint Status: RED with value: 42.7455 Duration in seconds
Additional Info: at Time: 2020-08-05 03:49:14
2020-08-05 04:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31609ALARM 23Logical Log 3673 Complete, timestamp: 0x7eb0dbc8.2020-08-05 04:07:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31608SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.4368 Duration in seconds
Additional Info: at Time: 2020-08-05 02:39:53
2020-08-05 03:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31607SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 98.6594 Duration in seconds
Additional Info: at Time: 2020-08-05 00:17:27
mon_checkpoint Status: RED with value: 75.3706 Duration in seconds
Additional Info: at Time: 2020-08-05 00:22:14
mon_checkpoint Status: YELLOW with value: 31.4852 Duration in seconds
Additional Info: at Time: 2020-08-05 00:11:19
mon_checkpoint Status: RED with value: 107.3907 Duration in seconds
Additional Info: at Time: 2020-08-05 00:28:02
mon_checkpoint Status: RED with value: 104.6273 Duration in seconds
Additional Info: at Time: 2020-08-05 00:33:18
2020-08-05 01:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31606DATABASE Auto Update StatisticsFound 50 table(s) in database tpcc which need statistics updated.2020-08-05 01:05:35NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31605DATABASE Auto Update StatisticsFound 97 table(s) in database sysadmin which need statistics updated.2020-08-05 01:04:51NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31604DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-08-05 01:03:11NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31603DATABASE Auto Update StatisticsFound 41 table(s) in database sysutils which need statistics updated.2020-08-05 01:02:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31602DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-08-05 01:02:01NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31601SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 40.9321 Duration in seconds
Additional Info: at Time: 2020-08-05 00:01:15
mon_checkpoint Status: YELLOW with value: 32.9845 Duration in seconds
Additional Info: at Time: 2020-08-04 23:56:04
mon_checkpoint Status: YELLOW with value: 31.6227 Duration in seconds
Additional Info: at Time: 2020-08-05 00:06:17
2020-08-05 00:17:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31600ALARM 23Logical Log 3672 Complete, timestamp: 0x7ea7d90f.2020-08-04 23:04:57NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31599ALARM 23Logical Log 3671 Complete, timestamp: 0x7e9e4fb3.2020-08-04 15:26:35NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31598SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 37.3245 Duration in seconds
Additional Info: at Time: 2020-08-04 12:41:57
2020-08-04 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31597TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 321 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-04 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31593SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 851 20:10:29. Recommend taking a level 0 backup immediately.2020-08-04 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31592SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 851 20:10:29. Recommend taking a level 0 backup immediately.2020-08-04 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31591SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 851 20:10:29. Recommend taking a level 0 backup immediately.2020-08-04 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31594SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 851 20:10:29. Recommend taking a level 0 backup immediately.2020-08-04 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31595SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 851 20:10:29. Recommend taking a level 0 backup immediately.2020-08-04 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31596SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 851 20:10:29. Recommend taking a level 0 backup immediately.2020-08-04 12:08:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31590ALARM 23Logical Log 3670 Complete, timestamp: 0x7e95f6ac.2020-08-04 09:31:11NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31589MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-08-04 06:16:47NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31588SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:38 IBM Informix Dynamic Server Stopped.

06:15:02 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:15:04 IBM Informix Dynamic Server Started.
06:15:04 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:15:04 the total shared memory size for this server to 2097152 KB.
06:15:04 The maximum allowable shared memory was reset to this size to start the database server.
06:15:04 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:04 Requested shared memory segment size rounded from 15636KB to 16256KB
06:15:04 Segment locked: addr=0x44000000, size=16646144
06:15:04 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:04 Segment locked: addr=0x44fe0000, size=524288000

Tue Aug 4 06:15:12 2020

06:15:12 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:12 Requested shared memory segment size rounded from 221001KB to 221004KB
06:15:12 Segment locked: addr=0x643e0000, size=226308096
06:15:12 Successfully added a bufferpool of page size 2K.

06:15:13 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:15:32 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:15:37 Secure Sockets Layer (SSL) initialized.
06:15:39 Booting Language from module <>
06:15:39 Loading Module
06:15:39 Booting Language from module <>
06:15:39 Loading Module
06:15:47 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:15:47 Ev
2020-08-04 06:16:44NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31587SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 491.5813 Duration in seconds
Additional Info: at Time: 2020-08-04 04:20:41
mon_checkpoint Status: YELLOW with value: 38.8360 Duration in seconds
Additional Info: at Time: 2020-08-04 04:48:24
mon_checkpoint Status: YELLOW with value: 34.5102 Duration in seconds
Additional Info: at Time: 2020-08-04 04:37:50
mon_checkpoint Status: RED with value: 162.6455 Duration in seconds
Additional Info: at Time: 2020-08-04 04:23:54
2020-08-04 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31586SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 2375 Number of session locks
Additional Info: Username: informix
Session Id: 7173
2020-08-04 04:16:26NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31585SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 81.5231 Duration in seconds
Additional Info: at Time: 2020-08-04 03:42:42
mon_checkpoint Status: RED with value: 67.0850 Duration in seconds
Additional Info: at Time: 2020-08-04 03:47:49
mon_checkpoint Status: RED with value: 40.9402 Duration in seconds
Additional Info: at Time: 2020-08-04 03:36:50
mon_checkpoint Status: YELLOW with value: 37.6092 Duration in seconds
Additional Info: at Time: 2020-08-04 03:57:32
mon_checkpoint Status: YELLOW with value: 34.5590 Duration in seconds
Additional Info: at Time: 2020-08-04 03:52:25
mon_checkpoint Status: YELLOW with value: 30.9269 Duration in seconds
Additional Info: at Time: 2020-08-04 04:02:33
mon_checkpoint Status: RED with value: 143.9764 Duration in seconds
Additional Info: at Time: 2020-08-04 04:09:27
2020-08-04 04:16:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31584ALARM 23Logical Log 3669 Complete, timestamp: 0x7e8b778f.2020-08-04 04:11:46NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31583ALARM 23Logical Log 3668 Complete, timestamp: 0x7e80f5ab.2020-08-04 02:04:59NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31582SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 90.7696 Duration in seconds
Additional Info: at Time: 2020-08-04 00:26:51
mon_checkpoint Status: RED with value: 87.5739 Duration in seconds
Additional Info: at Time: 2020-08-04 00:31:52
mon_checkpoint Status: RED with value: 137.1923 Duration in seconds
Additional Info: at Time: 2020-08-04 00:11:53
mon_checkpoint Status: RED with value: 105.1429 Duration in seconds
Additional Info: at Time: 2020-08-04 00:16:38
mon_checkpoint Status: RED with value: 101.1958 Duration in seconds
Additional Info: at Time: 2020-08-04 00:21:50
2020-08-04 01:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31581DATABASE Auto Update StatisticsFound 49 table(s) in database tpcc which need statistics updated.2020-08-04 01:03:49NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31580DATABASE Auto Update StatisticsFound 94 table(s) in database sysadmin which need statistics updated.2020-08-04 01:03:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31579DATABASE Auto Update StatisticsFound 47 table(s) in database sysuser which need statistics updated.2020-08-04 01:02:26NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31578DATABASE Auto Update StatisticsFound 41 table(s) in database sysutils which need statistics updated.2020-08-04 01:01:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31577DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-08-04 01:01:25NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31576SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 35.5541 Duration in seconds
Additional Info: at Time: 2020-08-03 23:49:50
mon_checkpoint Status: YELLOW with value: 32.2041 Duration in seconds
Additional Info: at Time: 2020-08-03 23:54:52
mon_checkpoint Status: YELLOW with value: 30.3780 Duration in seconds
Additional Info: at Time: 2020-08-03 23:59:52
2020-08-04 00:17:00NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31575ALARM 23Logical Log 3667 Complete, timestamp: 0x7e785c0b.2020-08-03 20:03:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31574ALARM 23Logical Log 3666 Complete, timestamp: 0x7e6f14ec.2020-08-03 12:53:54NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31573TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 595 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-03 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31567SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 850 20:10:20. Recommend taking a level 0 backup immediately.2020-08-03 12:08:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31570SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 850 20:10:20. Recommend taking a level 0 backup immediately.2020-08-03 12:08:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31571SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 850 20:10:20. Recommend taking a level 0 backup immediately.2020-08-03 12:08:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31572SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 850 20:10:20. Recommend taking a level 0 backup immediately.2020-08-03 12:08:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31568SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 850 20:10:20. Recommend taking a level 0 backup immediately.2020-08-03 12:08:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31569SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 850 20:10:20. Recommend taking a level 0 backup immediately.2020-08-03 12:08:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31566SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 53.7474 Duration in seconds
Additional Info: at Time: 2020-08-03 06:23:59
mon_checkpoint Status: RED with value: 131.4638 Duration in seconds
Additional Info: at Time: 2020-08-03 06:20:04
2020-08-03 07:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31565ALARM 23Logical Log 3665 Complete, timestamp: 0x7e66bfb5.2020-08-03 07:14:07NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31564DATABASE Auto Update StatisticsFound 46 table(s) in database tpcc which need statistics updated.2020-08-03 06:24:41NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31563DATABASE Auto Update StatisticsFound 92 table(s) in database sysadmin which need statistics updated.2020-08-03 06:23:50NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31562DATABASE Auto Update StatisticsFound 47 table(s) in database sysuser which need statistics updated.2020-08-03 06:21:56NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31561DATABASE Auto Update StatisticsFound 41 table(s) in database sysutils which need statistics updated.2020-08-03 06:21:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31560TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 54 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-03 06:20:37NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31559DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-08-03 06:19:47NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31555SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 850 14:19:11. Recommend taking a level 0 backup immediately.2020-08-03 06:17:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31556SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 850 14:19:11. Recommend taking a level 0 backup immediately.2020-08-03 06:17:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31558SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 850 14:19:11. Recommend taking a level 0 backup immediately.2020-08-03 06:17:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31557SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 850 14:19:11. Recommend taking a level 0 backup immediately.2020-08-03 06:17:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31553SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 850 14:19:10. Recommend taking a level 0 backup immediately.2020-08-03 06:17:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31554SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 850 14:19:10. Recommend taking a level 0 backup immediately.2020-08-03 06:17:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31552MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-08-03 06:14:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31551SERVER scout-demo-2 - Found:stop,warning,shared,added,load,mode,errMessage from PRIMARY-instance: ol_scout

06:00:58 IBM Informix Dynamic Server Stopped.

06:12:19 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:12:21 IBM Informix Dynamic Server Started.
06:12:21 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:12:21 the total shared memory size for this server to 2097152 KB.
06:12:21 The maximum allowable shared memory was reset to this size to start the database server.
06:12:21 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:12:21 Requested shared memory segment size rounded from 15636KB to 16256KB
06:12:21 Segment locked: addr=0x44000000, size=16646144
06:12:21 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:12:21 Segment locked: addr=0x44fe0000, size=524288000

Mon Aug 3 06:12:26 2020

06:12:26 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:12:26 Requested shared memory segment size rounded from 221001KB to 221004KB
06:12:26 Segment locked: addr=0x643e0000, size=226308096
06:12:26 Successfully added a bufferpool of page size 2K.

06:12:28 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:12:31 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:12:32 Secure Sockets Layer (SSL) initialized.
06:12:33 Booting Language from module <>
06:12:33 Loading Module
06:12:33 Booting Language from module <>
06:12:33 Loading Module
06:12:39 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:12:39 Ev
2020-08-03 06:13:57NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31550SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 37.9027 Duration in seconds
Additional Info: at Time: 2020-08-02 04:42:25
mon_checkpoint Status: YELLOW with value: 36.2273 Duration in seconds
Additional Info: at Time: 2020-08-02 04:26:46
mon_checkpoint Status: YELLOW with value: 35.4450 Duration in seconds
Additional Info: at Time: 2020-08-02 05:08:05
mon_checkpoint Status: YELLOW with value: 34.7487 Duration in seconds
Additional Info: at Time: 2020-08-02 05:03:00
mon_checkpoint Status: YELLOW with value: 33.9573 Duration in seconds
Additional Info: at Time: 2020-08-02 04:31:49
mon_checkpoint Status: RED with value: 328.4417 Duration in seconds
Additional Info: at Time: 2020-08-02 04:14:31
mon_checkpoint Status: RED with value: 326.1892 Duration in seconds
Additional Info: at Time: 2020-08-02 04:20:28
mon_checkpoint Status: YELLOW with value: 32.8312 Duration in seconds
Additional Info: at Time: 2020-08-02 04:57:55
mon_checkpoint Status: YELLOW with value: 30.3462 Duration in seconds
Additional Info: at Time: 2020-08-02 04:47:26
mon_checkpoint Status: RED with value: 162.5644 Duration in seconds
Additional Info: at Time: 2020-08-02 04:23:40
2020-08-02 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31549SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 71041 Number of session locks
Additional Info: Username: informix
Session Id: 7063
2020-08-02 04:16:51NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31548SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 76.1398 Duration in seconds
Additional Info: at Time: 2020-08-02 03:43:58
mon_checkpoint Status: RED with value: 54.3036 Duration in seconds
Additional Info: at Time: 2020-08-02 03:38:12
mon_checkpoint Status: RED with value: 52.0554 Duration in seconds
Additional Info: at Time: 2020-08-02 03:54:11
mon_checkpoint Status: RED with value: 50.8765 Duration in seconds
Additional Info: at Time: 2020-08-02 03:48:48
mon_checkpoint Status: RED with value: 44.0248 Duration in seconds
Additional Info: at Time: 2020-08-02 03:59:24
mon_checkpoint Status: YELLOW with value: 38.0816 Duration in seconds
Additional Info: at Time: 2020-08-02 04:04:33
mon_checkpoint Status: YELLOW with value: 36.6922 Duration in seconds
Additional Info: at Time: 2020-08-02 03:12:12
mon_checkpoint Status: YELLOW with value: 35.5953 Duration in seconds
Additional Info: at Time: 2020-08-02 03:22:18
mon_checkpoint Status: YELLOW with value: 34.6801 Duration in seconds
Additional Info: at Time: 2020-08-02 03:27:22
mon_checkpoint Status: YELLOW with value: 31.5332 Duration in seconds
Additional Info: at Time: 2020-08-02 03:17:13
2020-08-02 04:16:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31547ALARM 23Logical Log 3664 Complete, timestamp: 0x7e5d208f.2020-08-02 04:13:17NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31546SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 35.8152 Duration in seconds
Additional Info: at Time: 2020-08-02 02:18:39
mon_checkpoint Status: YELLOW with value: 34.8112 Duration in seconds
Additional Info: at Time: 2020-08-02 02:13:33
2020-08-02 03:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31545SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 84.8755 Duration in seconds
Additional Info: at Time: 2020-08-02 01:26:05
mon_checkpoint Status: RED with value: 80.9955 Duration in seconds
Additional Info: at Time: 2020-08-02 01:42:13
mon_checkpoint Status: YELLOW with value: 36.6016 Duration in seconds
Additional Info: at Time: 2020-08-02 01:20:11
mon_checkpoint Status: YELLOW with value: 32.7164 Duration in seconds
Additional Info: at Time: 2020-08-02 01:10:03
mon_checkpoint Status: YELLOW with value: 31.9476 Duration in seconds
Additional Info: at Time: 2020-08-02 01:15:04
mon_checkpoint Status: YELLOW with value: 30.8528 Duration in seconds
Additional Info: at Time: 2020-08-02 01:46:44
2020-08-02 02:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31544SERVER CAS: cas_mon_slow_stmt - count - Count of slow statementsThe slow statement sensor has found new statements, the number is above the threshold value.
Threshold Red : 10
Threshold Yellow : 5

cas_mon_slow_stmt Status: YELLOW with value: 5 Count of slow statements
2020-08-02 01:26:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31543SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 61.3339 Duration in seconds
Additional Info: at Time: 2020-08-02 00:18:50
mon_checkpoint Status: YELLOW with value: 34.3987 Duration in seconds
Additional Info: at Time: 2020-08-02 00:28:39
mon_checkpoint Status: RED with value: 129.0226 Duration in seconds
Additional Info: at Time: 2020-08-02 00:14:49
mon_checkpoint Status: RED with value: 128.2379 Duration in seconds
Additional Info: at Time: 2020-08-02 00:25:01
2020-08-02 01:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31542DATABASE Auto Update StatisticsFound 47 table(s) in database tpcc which need statistics updated.2020-08-02 01:04:48NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31541DATABASE Auto Update StatisticsFound 91 table(s) in database sysadmin which need statistics updated.2020-08-02 01:03:46NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31540ALARM 23Logical Log 3663 Complete, timestamp: 0x7e548fba.2020-08-02 01:03:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31539DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-08-02 01:02:50NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31538DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-08-02 01:02:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31537DATABASE Auto Update StatisticsFound 185 table(s) in database sysmaster which need statistics updated.2020-08-02 01:01:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31536ALARM 23Logical Log 3662 Complete, timestamp: 0x7e4bba34.2020-08-01 18:44:58NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31535ALARM 23Logical Log 3661 Complete, timestamp: 0x7e433ae0.2020-08-01 12:39:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31534TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 607 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-08-01 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31533SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 848 20:10:21. Recommend taking a level 0 backup immediately.2020-08-01 12:08:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31532SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 848 20:10:21. Recommend taking a level 0 backup immediately.2020-08-01 12:08:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31529SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 848 20:10:21. Recommend taking a level 0 backup immediately.2020-08-01 12:08:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31528SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 848 20:10:21. Recommend taking a level 0 backup immediately.2020-08-01 12:08:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31531SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 848 20:10:21. Recommend taking a level 0 backup immediately.2020-08-01 12:08:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31530SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 848 20:10:21. Recommend taking a level 0 backup immediately.2020-08-01 12:08:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31527SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 33.0038 Duration in seconds
Additional Info: at Time: 2020-08-01 06:19:41
2020-08-01 07:16:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31526MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-08-01 06:15:11NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31525SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:24 IBM Informix Dynamic Server Stopped.

06:13:41 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:13:42 IBM Informix Dynamic Server Started.
06:13:42 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:13:42 the total shared memory size for this server to 2097152 KB.
06:13:42 The maximum allowable shared memory was reset to this size to start the database server.
06:13:44 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:44 Requested shared memory segment size rounded from 15636KB to 16256KB
06:13:44 Segment locked: addr=0x44000000, size=16646144
06:13:44 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:44 Segment locked: addr=0x44fe0000, size=524288000

Sat Aug 1 06:13:50 2020

06:13:50 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:50 Requested shared memory segment size rounded from 221001KB to 221004KB
06:13:50 Segment locked: addr=0x643e0000, size=226308096
06:13:51 Successfully added a bufferpool of page size 2K.

06:13:51 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:13:56 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:13:56 Secure Sockets Layer (SSL) initialized.
06:13:56 Booting Language from module <>
06:13:56 Loading Module
06:13:56 Booting Language from module <>
06:13:56 Loading Module
06:14:02 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:14:02 Ev
2020-08-01 06:14:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31524ALARM 23Logical Log 3660 Complete, timestamp: 0x7e39faff.2020-08-01 05:52:05NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31523SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 407.8272 Duration in seconds
Additional Info: at Time: 2020-08-01 04:14:33
mon_checkpoint Status: YELLOW with value: 36.0259 Duration in seconds
Additional Info: at Time: 2020-08-01 04:46:37
mon_checkpoint Status: YELLOW with value: 33.5577 Duration in seconds
Additional Info: at Time: 2020-08-01 05:02:06
mon_checkpoint Status: YELLOW with value: 32.8365 Duration in seconds
Additional Info: at Time: 2020-08-01 04:31:04
mon_checkpoint Status: YELLOW with value: 31.9968 Duration in seconds
Additional Info: at Time: 2020-08-01 04:36:05
mon_checkpoint Status: YELLOW with value: 31.6194 Duration in seconds
Additional Info: at Time: 2020-08-01 04:51:38
mon_checkpoint Status: YELLOW with value: 31.5669 Duration in seconds
Additional Info: at Time: 2020-08-01 04:26:01
mon_checkpoint Status: YELLOW with value: 31.2095 Duration in seconds
Additional Info: at Time: 2020-08-01 05:07:07
mon_checkpoint Status: RED with value: 121.2588 Duration in seconds
Additional Info: at Time: 2020-08-01 04:17:04
2020-08-01 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31522SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 89.2805 Duration in seconds
Additional Info: at Time: 2020-08-01 03:43:33
mon_checkpoint Status: RED with value: 62.4632 Duration in seconds
Additional Info: at Time: 2020-08-01 03:48:06
mon_checkpoint Status: RED with value: 51.6612 Duration in seconds
Additional Info: at Time: 2020-08-01 03:37:32
mon_checkpoint Status: RED with value: 41.4970 Duration in seconds
Additional Info: at Time: 2020-08-01 03:52:48
mon_checkpoint Status: YELLOW with value: 31.1726 Duration in seconds
Additional Info: at Time: 2020-08-01 03:57:49
mon_checkpoint Status: YELLOW with value: 30.4359 Duration in seconds
Additional Info: at Time: 2020-08-01 03:32:11
2020-08-01 04:16:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31521SERVER scout-demo-2 - Found:err,warningMessage from PRIMARY-instance: ol_scout

03:03:46 SCHAPI: [cas_check_onlinelog 64-242073] Error -244 Could not do a physical-order read to fetch next row.

03:03:46 SCHAPI: [cas_check_onlinelog 64-242073] Error -101 ISAM error: file is not open.

03:03:46 SCHAPI: Warning!!! dbWorker thread is cleaning up temp tables for task 64.
03:04:59 Checkpoint Completed: duration was 20 seconds.
03:04:59 Sat Aug 1 - loguniq 3660, logpos 0x857348, timestamp: 0x7e302f31 Interval: 233371

03:04:59 Maximum server connections 8
03:04:59 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 486, Llog used 281

2020-08-01 03:08:46NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31520ALARM 23Logical Log 3659 Complete, timestamp: 0x7e2f664f.2020-08-01 02:26:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31519SERVER CAS: mon_checkpoint - crit_time - Critical wait time in secondsThe wait time of sessions in critical section by a checkpoint is above the threshold value.
Threshold Red : 3
Threshold Yellow : 2

mon_checkpoint Status: YELLOW with value: 2.5457443796088404 Critical wait time in seconds
2020-08-01 02:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31518SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 66.6149 Duration in seconds
Additional Info: at Time: 2020-08-01 01:19:05
mon_checkpoint Status: YELLOW with value: 39.0866 Duration in seconds
Additional Info: at Time: 2020-08-01 01:28:52
mon_checkpoint Status: YELLOW with value: 37.1324 Duration in seconds
Additional Info: at Time: 2020-08-01 01:23:43
mon_checkpoint Status: YELLOW with value: 31.2634 Duration in seconds
Additional Info: at Time: 2020-08-01 01:39:18
mon_checkpoint Status: YELLOW with value: 30.7055 Duration in seconds
Additional Info: at Time: 2020-08-01 01:13:29
2020-08-01 02:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31517SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 71.4851 Duration in seconds
Additional Info: at Time: 2020-08-01 00:21:23
mon_checkpoint Status: RED with value: 119.5463 Duration in seconds
Additional Info: at Time: 2020-08-01 00:16:41
mon_checkpoint Status: RED with value: 104.5248 Duration in seconds
Additional Info: at Time: 2020-08-01 00:32:25
mon_checkpoint Status: RED with value: 101.3348 Duration in seconds
Additional Info: at Time: 2020-08-01 00:27:08
2020-08-01 01:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31516DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-08-01 01:05:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31515DATABASE Auto Update StatisticsFound 112 table(s) in database sysadmin which need statistics updated.2020-08-01 01:04:42NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31514DATABASE Auto Update StatisticsFound 49 table(s) in database sysuser which need statistics updated.2020-08-01 01:03:25NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31513DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-08-01 01:02:49NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31512DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-08-01 01:01:54NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31511SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 35.4351 Duration in seconds
Additional Info: at Time: 2020-07-31 23:59:18
mon_checkpoint Status: YELLOW with value: 32.2304 Duration in seconds
Additional Info: at Time: 2020-07-31 23:54:13
2020-08-01 00:16:52NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31510ALARM 23Logical Log 3658 Complete, timestamp: 0x7e27d848.2020-07-31 22:04:59NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31509ALARM 23Logical Log 3657 Complete, timestamp: 0x7e1e9473.2020-07-31 14:54:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31508SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.8166 Duration in seconds
Additional Info: at Time: 2020-07-31 12:40:08
2020-07-31 13:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31507TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 586 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-31 12:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31505SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 847 20:10:24. Recommend taking a level 0 backup immediately.2020-07-31 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31504SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 847 20:10:24. Recommend taking a level 0 backup immediately.2020-07-31 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31503SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 847 20:10:24. Recommend taking a level 0 backup immediately.2020-07-31 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31506SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 847 20:10:24. Recommend taking a level 0 backup immediately.2020-07-31 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31502SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 847 20:10:24. Recommend taking a level 0 backup immediately.2020-07-31 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31501SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 847 20:10:24. Recommend taking a level 0 backup immediately.2020-07-31 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31500ALARM 23Logical Log 3656 Complete, timestamp: 0x7e164df1.2020-07-31 09:14:57NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31499SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:29 IBM Informix Dynamic Server Stopped.

06:15:01 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:15:03 IBM Informix Dynamic Server Started.
06:15:03 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:15:03 the total shared memory size for this server to 2097152 KB.
06:15:03 The maximum allowable shared memory was reset to this size to start the database server.
06:15:03 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:03 Requested shared memory segment size rounded from 15636KB to 16256KB
06:15:03 Segment locked: addr=0x44000000, size=16646144
06:15:03 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:03 Segment locked: addr=0x44fe0000, size=524288000

Fri Jul 31 06:15:11 2020

06:15:11 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:11 Requested shared memory segment size rounded from 221001KB to 221004KB
06:15:11 Segment locked: addr=0x643e0000, size=226308096
06:15:11 Successfully added a bufferpool of page size 2K.

06:15:15 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:15:25 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:15:26 Secure Sockets Layer (SSL) initialized.
06:15:27 Booting Language from module <>
06:15:27 Loading Module
06:15:27 Booting Language from module <>
06:15:27 Loading Module
06:15:32 CCFLAGS2 value set to 0x200
06:15:32 SQL_FEAT_CTRL value set to 0x8008
06:15:32 SQL_DEF_CTRL value set to 0x4b0
06:15:32 Waiting 600 seconds for startu
2020-07-31 06:16:12NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31498MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-31 06:16:08NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31497SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 74.6793 Duration in seconds
Additional Info: at Time: 2020-07-31 04:18:38
mon_checkpoint Status: RED with value: 254.8332 Duration in seconds
Additional Info: at Time: 2020-07-31 04:16:24
mon_checkpoint Status: RED with value: 214.0297 Duration in seconds
Additional Info: at Time: 2020-07-31 04:10:40
2020-07-31 05:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31496SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 93671 Number of session locks
Additional Info: Username: informix
Session Id: 7055
2020-07-31 04:16:25NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31495SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 84.4893 Duration in seconds
Additional Info: at Time: 2020-07-31 03:41:29
mon_checkpoint Status: RED with value: 54.6414 Duration in seconds
Additional Info: at Time: 2020-07-31 03:46:23
mon_checkpoint Status: RED with value: 48.5892 Duration in seconds
Additional Info: at Time: 2020-07-31 03:51:42
mon_checkpoint Status: RED with value: 42.1073 Duration in seconds
Additional Info: at Time: 2020-07-31 03:35:35
2020-07-31 04:16:22NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31494ALARM 23Logical Log 3655 Complete, timestamp: 0x7e0bf9c5.2020-07-31 04:07:50NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31493SERVER CAS: mon_checkpoint - crit_time - Critical wait time in secondsThe wait time of sessions in critical section by a checkpoint is above the threshold value.
Threshold Red : 3
Threshold Yellow : 2

mon_checkpoint Status: RED with value: 3.6064804526055325 Critical wait time in seconds
2020-07-31 02:16:17NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31492SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 41.1959 Duration in seconds
Additional Info: at Time: 2020-07-31 01:37:44
2020-07-31 02:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31491SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 78.8638 Duration in seconds
Additional Info: at Time: 2020-07-31 00:24:15
mon_checkpoint Status: RED with value: 208.1389 Duration in seconds
Additional Info: at Time: 2020-07-31 00:31:48
mon_checkpoint Status: RED with value: 149.0147 Duration in seconds
Additional Info: at Time: 2020-07-31 00:14:33
mon_checkpoint Status: RED with value: 109.3196 Duration in seconds
Additional Info: at Time: 2020-07-31 00:19:23
2020-07-31 01:16:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31490DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-31 01:04:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31489DATABASE Auto Update StatisticsFound 112 table(s) in database sysadmin which need statistics updated.2020-07-31 01:03:51NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31488DATABASE Auto Update StatisticsFound 49 table(s) in database sysuser which need statistics updated.2020-07-31 01:02:52NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31487DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-31 01:02:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31486DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-31 01:01:56NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31485SERVER CAS: cas_mon_slow_stmt - count - Count of slow statementsThe slow statement sensor has found new statements, the number is above the threshold value.
Threshold Red : 10
Threshold Yellow : 5

cas_mon_slow_stmt Status: YELLOW with value: 6 Count of slow statements
2020-07-31 00:36:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31484SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 31.1371 Duration in seconds
Additional Info: at Time: 2020-07-31 00:02:15
2020-07-31 00:16:58NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31483SERVER CAS: cas_mon_slow_stmt - count - Count of slow statementsThe slow statement sensor has found new statements, the number is above the threshold value.
Threshold Red : 10
Threshold Yellow : 5

cas_mon_slow_stmt Status: YELLOW with value: 5 Count of slow statements
2020-07-31 00:16:25NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31482ALARM 23Logical Log 3654 Complete, timestamp: 0x7e030801.2020-07-30 23:29:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31481ALARM 23Logical Log 3653 Complete, timestamp: 0x7df9cb6c.2020-07-30 16:19:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31480SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 30.7608 Duration in seconds
Additional Info: at Time: 2020-07-30 14:11:11
2020-07-30 15:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31479SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 33.7482 Duration in seconds
Additional Info: at Time: 2020-07-30 12:41:16
2020-07-30 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31478TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 586 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-30 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31477SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 30.1846 Duration in seconds
Additional Info: at Time: 2020-07-30 11:11:14
2020-07-30 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31475SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 846 20:10:58. Recommend taking a level 0 backup immediately.2020-07-30 12:09:07NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31474SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 846 20:10:58. Recommend taking a level 0 backup immediately.2020-07-30 12:09:07NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31473SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 846 20:10:58. Recommend taking a level 0 backup immediately.2020-07-30 12:09:07NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31476SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 846 20:10:58. Recommend taking a level 0 backup immediately.2020-07-30 12:09:07NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31472SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 846 20:10:58. Recommend taking a level 0 backup immediately.2020-07-30 12:09:07NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31471SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 846 20:10:57. Recommend taking a level 0 backup immediately.2020-07-30 12:09:06NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31470ALARM 23Logical Log 3652 Complete, timestamp: 0x7df1919d.2020-07-30 10:47:44NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31469SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.3455 Duration in seconds
Additional Info: at Time: 2020-07-30 07:13:52
2020-07-30 08:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31468SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 48.9333 Duration in seconds
Additional Info: at Time: 2020-07-30 06:25:59
2020-07-30 07:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31467MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-30 06:15:50NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31466SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:37 IBM Informix Dynamic Server Stopped.

06:14:00 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:14:02 IBM Informix Dynamic Server Started.
06:14:02 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:14:02 the total shared memory size for this server to 2097152 KB.
06:14:02 The maximum allowable shared memory was reset to this size to start the database server.
06:14:03 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:03 Requested shared memory segment size rounded from 15636KB to 16256KB
06:14:03 Segment locked: addr=0x44000000, size=16646144
06:14:03 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:03 Segment locked: addr=0x44fe0000, size=524288000

Thu Jul 30 06:14:10 2020

06:14:10 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:10 Requested shared memory segment size rounded from 221001KB to 221004KB
06:14:10 Segment locked: addr=0x643e0000, size=226308096
06:14:10 Successfully added a bufferpool of page size 2K.

06:14:12 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:14:19 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:14:20 Secure Sockets Layer (SSL) initialized.
06:14:21 Booting Language from module <>
06:14:21 Loading Module
06:14:21 Booting Language from module <>
06:14:21 Loading Module
06:14:28 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:14:29 Ev
2020-07-30 06:15:12NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31465SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 35.9162 Duration in seconds
Additional Info: at Time: 2020-07-30 04:45:09
mon_checkpoint Status: YELLOW with value: 35.2292 Duration in seconds
Additional Info: at Time: 2020-07-30 04:34:36
mon_checkpoint Status: YELLOW with value: 34.4377 Duration in seconds
Additional Info: at Time: 2020-07-30 04:50:14
mon_checkpoint Status: YELLOW with value: 30.6036 Duration in seconds
Additional Info: at Time: 2020-07-30 05:00:44
mon_checkpoint Status: RED with value: 290.4875 Duration in seconds
Additional Info: at Time: 2020-07-30 04:17:13
2020-07-30 05:16:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31464SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 44058 Number of session locks
Additional Info: Username: informix
Session Id: 7055
2020-07-30 04:16:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31463SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 60.4670 Duration in seconds
Additional Info: at Time: 2020-07-30 03:47:05
mon_checkpoint Status: RED with value: 58.2255 Duration in seconds
Additional Info: at Time: 2020-07-30 03:41:35
mon_checkpoint Status: RED with value: 41.7244 Duration in seconds
Additional Info: at Time: 2020-07-30 03:36:05
mon_checkpoint Status: RED with value: 41.3256 Duration in seconds
Additional Info: at Time: 2020-07-30 03:52:18
mon_checkpoint Status: YELLOW with value: 30.0910 Duration in seconds
Additional Info: at Time: 2020-07-30 04:02:38
mon_checkpoint Status: RED with value: 131.9196 Duration in seconds
Additional Info: at Time: 2020-07-30 04:09:21
2020-07-30 04:16:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31462ALARM 23Logical Log 3651 Complete, timestamp: 0x7de79cd1.2020-07-30 04:10:17NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31461SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 47.7546 Duration in seconds
Additional Info: at Time: 2020-07-30 02:10:36
2020-07-30 03:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31460SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 39.2779 Duration in seconds
Additional Info: at Time: 2020-07-30 01:38:34
2020-07-30 02:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31459SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 90.5455 Duration in seconds
Additional Info: at Time: 2020-07-30 00:25:59
mon_checkpoint Status: YELLOW with value: 35.3841 Duration in seconds
Additional Info: at Time: 2020-07-30 01:06:57
mon_checkpoint Status: YELLOW with value: 33.0102 Duration in seconds
Additional Info: at Time: 2020-07-30 01:01:51
mon_checkpoint Status: RED with value: 149.0022 Duration in seconds
Additional Info: at Time: 2020-07-30 00:31:58
mon_checkpoint Status: RED with value: 132.9518 Duration in seconds
Additional Info: at Time: 2020-07-30 00:16:03
mon_checkpoint Status: RED with value: 110.8506 Duration in seconds
Additional Info: at Time: 2020-07-30 00:20:54
2020-07-30 01:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31458DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-30 01:06:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31457DATABASE Auto Update StatisticsFound 112 table(s) in database sysadmin which need statistics updated.2020-07-30 01:05:06NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31456DATABASE Auto Update StatisticsFound 49 table(s) in database sysuser which need statistics updated.2020-07-30 01:03:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31455DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-30 01:03:08NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31454DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-30 01:02:28NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31453ALARM 23Logical Log 3650 Complete, timestamp: 0x7dde5268.2020-07-30 01:00:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31452SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 33.0645 Duration in seconds
Additional Info: at Time: 2020-07-29 23:59:01
mon_checkpoint Status: YELLOW with value: 31.9068 Duration in seconds
Additional Info: at Time: 2020-07-30 00:09:21
mon_checkpoint Status: YELLOW with value: 31.4062 Duration in seconds
Additional Info: at Time: 2020-07-29 23:53:58
2020-07-30 00:16:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31451ALARM 23Logical Log 3649 Complete, timestamp: 0x7dd4f922.2020-07-29 17:50:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31450SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.3542 Duration in seconds
Additional Info: at Time: 2020-07-29 12:44:19
2020-07-29 13:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31449TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 593 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-29 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31448ALARM 23Logical Log 3648 Complete, timestamp: 0x7dccb48e.2020-07-29 12:09:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31446SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 845 20:10:37. Recommend taking a level 0 backup immediately.2020-07-29 12:08:46NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31444SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 845 20:10:37. Recommend taking a level 0 backup immediately.2020-07-29 12:08:46NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31447SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 845 20:10:37. Recommend taking a level 0 backup immediately.2020-07-29 12:08:46NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31445SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 845 20:10:37. Recommend taking a level 0 backup immediately.2020-07-29 12:08:46NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31443SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 845 20:10:36. Recommend taking a level 0 backup immediately.2020-07-29 12:08:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31442SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 845 20:10:36. Recommend taking a level 0 backup immediately.2020-07-29 12:08:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31441SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 58.8875 Duration in seconds
Additional Info: at Time: 2020-07-29 06:26:32
mon_checkpoint Status: RED with value: 43.1902 Duration in seconds
Additional Info: at Time: 2020-07-29 06:21:04
mon_checkpoint Status: YELLOW with value: 39.9484 Duration in seconds
Additional Info: at Time: 2020-07-29 06:31:42
2020-07-29 07:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31440MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-29 06:16:04NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31439SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:31 IBM Informix Dynamic Server Stopped.

06:14:36 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:14:37 IBM Informix Dynamic Server Started.
06:14:37 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:14:37 the total shared memory size for this server to 2097152 KB.
06:14:37 The maximum allowable shared memory was reset to this size to start the database server.
06:14:37 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:37 Requested shared memory segment size rounded from 15636KB to 16256KB
06:14:37 Segment locked: addr=0x44000000, size=16646144
06:14:37 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:37 Segment locked: addr=0x44fe0000, size=524288000

Wed Jul 29 06:14:44 2020

06:14:44 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:44 Requested shared memory segment size rounded from 221001KB to 221004KB
06:14:44 Segment locked: addr=0x643e0000, size=226308096
06:14:44 Successfully added a bufferpool of page size 2K.

06:14:46 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:14:56 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:14:57 Secure Sockets Layer (SSL) initialized.
06:14:59 Booting Language from module <>
06:14:59 Loading Module
06:14:59 Booting Language from module <>
06:14:59 Loading Module
06:15:07 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:15:07 Ev
2020-07-29 06:15:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31438SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 431.1135 Duration in seconds
Additional Info: at Time: 2020-07-29 04:17:42
mon_checkpoint Status: YELLOW with value: 34.4920 Duration in seconds
Additional Info: at Time: 2020-07-29 04:55:52
mon_checkpoint Status: YELLOW with value: 31.9610 Duration in seconds
Additional Info: at Time: 2020-07-29 04:45:22
mon_checkpoint Status: YELLOW with value: 31.5883 Duration in seconds
Additional Info: at Time: 2020-07-29 04:18:43
2020-07-29 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31437ALARM 23Logical Log 3647 Complete, timestamp: 0x7dc3502a.2020-07-29 05:00:06NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31436SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 127547 Number of session locks
Additional Info: Username: informix
Session Id: 7061
2020-07-29 04:16:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31435SERVER CAS: mon_users - upf_logspuse - log space currently used in byteThe amount of log space consumed in bytes by the current transaction
Threshold Red : 30000000
Threshold Yellow : 10000000

mon_users Status: YELLOW with value: 10968968.0000 log space currently used in byte
Additional Info: Username: informix
Session Id: 7061
2020-07-29 04:16:25NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31434SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 92.0508 Duration in seconds
Additional Info: at Time: 2020-07-29 03:40:14
mon_checkpoint Status: RED with value: 87.5375 Duration in seconds
Additional Info: at Time: 2020-07-29 04:06:31
mon_checkpoint Status: RED with value: 68.0598 Duration in seconds
Additional Info: at Time: 2020-07-29 03:44:53
mon_checkpoint Status: RED with value: 56.7630 Duration in seconds
Additional Info: at Time: 2020-07-29 03:49:50
mon_checkpoint Status: RED with value: 48.2769 Duration in seconds
Additional Info: at Time: 2020-07-29 03:55:10
mon_checkpoint Status: YELLOW with value: 31.6058 Duration in seconds
Additional Info: at Time: 2020-07-29 03:34:12
2020-07-29 04:16:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31433SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.2098 Duration in seconds
Additional Info: at Time: 2020-07-29 03:02:10
2020-07-29 03:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31432SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 41.3199 Duration in seconds
Additional Info: at Time: 2020-07-29 01:36:51
2020-07-29 02:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31431ALARM 23Logical Log 3646 Complete, timestamp: 0x7db8d377.2020-07-29 01:25:35NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31430SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 66.9229 Duration in seconds
Additional Info: at Time: 2020-07-29 00:13:27
mon_checkpoint Status: RED with value: 182.7545 Duration in seconds
Additional Info: at Time: 2020-07-29 00:31:18
mon_checkpoint Status: RED with value: 117.4247 Duration in seconds
Additional Info: at Time: 2020-07-29 00:24:45
mon_checkpoint Status: RED with value: 103.2222 Duration in seconds
Additional Info: at Time: 2020-07-29 00:19:18
2020-07-29 01:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31429DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-29 01:03:28NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31428DATABASE Auto Update StatisticsFound 99 table(s) in database sysadmin which need statistics updated.2020-07-29 01:02:58NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31427DATABASE Auto Update StatisticsFound 49 table(s) in database sysuser which need statistics updated.2020-07-29 01:02:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31426DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-29 01:01:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31425DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-29 01:01:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31424SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 34.9369 Duration in seconds
Additional Info: at Time: 2020-07-28 23:51:42
2020-07-29 00:16:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31423ALARM 23Logical Log 3645 Complete, timestamp: 0x7db04219.2020-07-28 19:25:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31422SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 33.7856 Duration in seconds
Additional Info: at Time: 2020-07-28 12:44:17
2020-07-28 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31421ALARM 23Logical Log 3644 Complete, timestamp: 0x7da7336a.2020-07-28 12:42:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31420TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 598 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-28 12:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31418SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 844 20:10:24. Recommend taking a level 0 backup immediately.2020-07-28 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31419SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 844 20:10:24. Recommend taking a level 0 backup immediately.2020-07-28 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31417SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 844 20:10:23. Recommend taking a level 0 backup immediately.2020-07-28 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31416SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 844 20:10:23. Recommend taking a level 0 backup immediately.2020-07-28 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31414SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 844 20:10:23. Recommend taking a level 0 backup immediately.2020-07-28 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31415SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 844 20:10:23. Recommend taking a level 0 backup immediately.2020-07-28 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31413SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.9932 Duration in seconds
Additional Info: at Time: 2020-07-28 08:42:46
2020-07-28 09:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31412ALARM 23Logical Log 3643 Complete, timestamp: 0x7d9eb1b5.2020-07-28 06:44:42NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31411MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-28 06:14:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31410SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:25 IBM Informix Dynamic Server Stopped.

06:13:09 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:13:10 IBM Informix Dynamic Server Started.
06:13:10 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:13:10 the total shared memory size for this server to 2097152 KB.
06:13:10 The maximum allowable shared memory was reset to this size to start the database server.
06:13:10 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:10 Requested shared memory segment size rounded from 15636KB to 16256KB
06:13:10 Segment locked: addr=0x44000000, size=16646144
06:13:10 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:10 Segment locked: addr=0x44fe0000, size=524288000

Tue Jul 28 06:13:16 2020

06:13:16 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:16 Requested shared memory segment size rounded from 221001KB to 221004KB
06:13:16 Segment locked: addr=0x643e0000, size=226308096
06:13:16 Successfully added a bufferpool of page size 2K.

06:13:17 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:13:23 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:13:25 Secure Sockets Layer (SSL) initialized.
06:13:25 Booting Language from module <>
06:13:25 Loading Module
06:13:25 Booting Language from module <>
06:13:25 Loading Module
06:13:33 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:13:34 Ev
2020-07-28 06:14:17NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31409SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 47.6995 Duration in seconds
Additional Info: at Time: 2020-07-28 04:19:26
mon_checkpoint Status: RED with value: 421.0686 Duration in seconds
Additional Info: at Time: 2020-07-28 04:18:09
mon_checkpoint Status: YELLOW with value: 37.6426 Duration in seconds
Additional Info: at Time: 2020-07-28 04:30:02
2020-07-28 05:16:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31408SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 63516 Number of session locks
Additional Info: Username: informix
Session Id: 7055
2020-07-28 04:16:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31407SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 67.2050 Duration in seconds
Additional Info: at Time: 2020-07-28 03:46:04
mon_checkpoint Status: RED with value: 64.9661 Duration in seconds
Additional Info: at Time: 2020-07-28 03:40:57
mon_checkpoint Status: RED with value: 53.3939 Duration in seconds
Additional Info: at Time: 2020-07-28 03:50:59
mon_checkpoint Status: YELLOW with value: 30.0311 Duration in seconds
Additional Info: at Time: 2020-07-28 04:01:25
mon_checkpoint Status: RED with value: 102.2027 Duration in seconds
Additional Info: at Time: 2020-07-28 04:07:37
2020-07-28 04:16:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31406ALARM 23Logical Log 3642 Complete, timestamp: 0x7d942d99.2020-07-28 03:00:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31405SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 94.1791 Duration in seconds
Additional Info: at Time: 2020-07-28 00:25:47
mon_checkpoint Status: RED with value: 69.3025 Duration in seconds
Additional Info: at Time: 2020-07-28 00:20:12
mon_checkpoint Status: RED with value: 47.2436 Duration in seconds
Additional Info: at Time: 2020-07-28 00:30:09
mon_checkpoint Status: RED with value: 129.0295 Duration in seconds
Additional Info: at Time: 2020-07-28 00:16:03
2020-07-28 01:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31404DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-28 01:03:48NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31403DATABASE Auto Update StatisticsFound 97 table(s) in database sysadmin which need statistics updated.2020-07-28 01:03:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31402DATABASE Auto Update StatisticsFound 49 table(s) in database sysuser which need statistics updated.2020-07-28 01:02:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31401DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-28 01:02:02NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31400DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-28 01:01:38NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31399SERVER CAS: cas_mon_slow_stmt - count - Count of slow statementsThe slow statement sensor has found new statements, the number is above the threshold value.
Threshold Red : 10
Threshold Yellow : 5

cas_mon_slow_stmt Status: YELLOW with value: 5 Count of slow statements
2020-07-28 00:26:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31398SERVER CAS: mon_checkpoint - crit_time - Critical wait time in secondsThe wait time of sessions in critical section by a checkpoint is above the threshold value.
Threshold Red : 3
Threshold Yellow : 2

mon_checkpoint Status: RED with value: 4.0552732398067741 Critical wait time in seconds
2020-07-28 00:16:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31397SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 113.7585 Duration in seconds
Additional Info: at Time: 2020-07-28 00:10:23
2020-07-28 00:16:28NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31396ALARM 23Logical Log 3641 Complete, timestamp: 0x7d8b6704.2020-07-27 20:56:58NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31395ALARM 23Logical Log 3640 Complete, timestamp: 0x7d82234f.2020-07-27 13:44:56NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31394SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 31.2143 Duration in seconds
Additional Info: at Time: 2020-07-27 12:43:15
2020-07-27 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31393TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 588 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-27 12:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31389SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 843 20:10:23. Recommend taking a level 0 backup immediately.2020-07-27 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31388SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 843 20:10:23. Recommend taking a level 0 backup immediately.2020-07-27 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31391SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 843 20:10:23. Recommend taking a level 0 backup immediately.2020-07-27 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31392SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 843 20:10:23. Recommend taking a level 0 backup immediately.2020-07-27 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31390SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 843 20:10:23. Recommend taking a level 0 backup immediately.2020-07-27 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31387SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 843 20:10:22. Recommend taking a level 0 backup immediately.2020-07-27 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31386ALARM 23Logical Log 3639 Complete, timestamp: 0x7d79d145.2020-07-27 08:09:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31385MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-27 06:15:11NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31384SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:32 IBM Informix Dynamic Server Stopped.

06:13:31 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:13:31 IBM Informix Dynamic Server Started.
06:13:31 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:13:31 the total shared memory size for this server to 2097152 KB.
06:13:31 The maximum allowable shared memory was reset to this size to start the database server.
06:13:32 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:32 Requested shared memory segment size rounded from 15636KB to 16256KB
06:13:32 Segment locked: addr=0x44000000, size=16646144
06:13:32 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:32 Segment locked: addr=0x44fe0000, size=524288000

Mon Jul 27 06:13:36 2020

06:13:36 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:36 Requested shared memory segment size rounded from 221001KB to 221004KB
06:13:36 Segment locked: addr=0x643e0000, size=226308096
06:13:37 Successfully added a bufferpool of page size 2K.

06:13:39 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:13:45 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:13:46 Secure Sockets Layer (SSL) initialized.
06:13:46 Booting Language from module <>
06:13:46 Loading Module
06:13:46 Booting Language from module <>
06:13:46 Loading Module
06:13:53 CCFLAGS2 value set to 0x200
06:13:53 SQL_FEAT_CTRL value set to 0x8008
06:13:53 SQL_DEF_CTRL value set to 0x4b0
06:13:53 Waiting 600 seconds for startu
2020-07-27 06:14:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31383SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 344.8441 Duration in seconds
Additional Info: at Time: 2020-07-27 04:16:39
mon_checkpoint Status: YELLOW with value: 34.5788 Duration in seconds
Additional Info: at Time: 2020-07-27 04:17:43
mon_checkpoint Status: YELLOW with value: 32.1321 Duration in seconds
Additional Info: at Time: 2020-07-27 04:38:36
mon_checkpoint Status: YELLOW with value: 31.8821 Duration in seconds
Additional Info: at Time: 2020-07-27 04:22:44
mon_checkpoint Status: YELLOW with value: 31.7370 Duration in seconds
Additional Info: at Time: 2020-07-27 04:43:37
2020-07-27 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31382SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 112019 Number of session locks
Additional Info: Username: informix
Session Id: 7059
2020-07-27 04:16:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31381SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 80.7659 Duration in seconds
Additional Info: at Time: 2020-07-27 04:06:53
mon_checkpoint Status: RED with value: 75.9805 Duration in seconds
Additional Info: at Time: 2020-07-27 03:40:54
mon_checkpoint Status: RED with value: 65.0821 Duration in seconds
Additional Info: at Time: 2020-07-27 03:51:06
mon_checkpoint Status: RED with value: 64.9145 Duration in seconds
Additional Info: at Time: 2020-07-27 03:45:59
mon_checkpoint Status: YELLOW with value: 30.4996 Duration in seconds
Additional Info: at Time: 2020-07-27 03:55:37
2020-07-27 04:16:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31380ALARM 23Logical Log 3638 Complete, timestamp: 0x7d6f8f81.2020-07-27 03:34:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31379SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 35.2554 Duration in seconds
Additional Info: at Time: 2020-07-27 01:37:32
2020-07-27 02:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31378SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 98.6073 Duration in seconds
Additional Info: at Time: 2020-07-27 00:19:29
mon_checkpoint Status: RED with value: 141.3029 Duration in seconds
Additional Info: at Time: 2020-07-27 00:31:09
mon_checkpoint Status: RED with value: 138.4964 Duration in seconds
Additional Info: at Time: 2020-07-27 00:25:48
mon_checkpoint Status: RED with value: 121.3432 Duration in seconds
Additional Info: at Time: 2020-07-27 00:14:21
2020-07-27 01:16:22NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31377DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-27 01:03:57NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31376DATABASE Auto Update StatisticsFound 94 table(s) in database sysadmin which need statistics updated.2020-07-27 01:03:29NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31375DATABASE Auto Update StatisticsFound 49 table(s) in database sysuser which need statistics updated.2020-07-27 01:02:37NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31374DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-27 01:02:08NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31373DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-27 01:01:35NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31372SERVER scout-demo-2 - Found:errMessage from PRIMARY-instance: ol_scout

00:29:34 SCHAPI: [cas_mon_locks 63-240648] Error -244 Could not do a physical-order read to fetch next row.

00:29:34 SCHAPI: [cas_mon_locks 63-240648] Error -154 ISAM error: Lock Timeout Expired

00:30:39 SCHAPI: [cas_mon_ddl 67-599525] Error -244 Could not do a physical-order read to fetch next row.

00:30:39 SCHAPI: [cas_mon_ddl 67-599525] Error -154 ISAM error: Lock Timeout Expired

2020-07-27 00:30:47NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31371ALARM 23Logical Log 3637 Complete, timestamp: 0x7d66f0d1.2020-07-26 21:32:41NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31370ALARM 23Logical Log 3636 Complete, timestamp: 0x7d5db6da.2020-07-26 14:23:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31369TABLE CAS: mon_table_profile - pf_lockwait - Count of Lock WaitsThe number of waits system-wide.
Threshold Red : 50
Threshold Yellow : 25

mon_table_profile Status: YELLOW with value: 28 Count of Lock Waits
2020-07-26 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31368TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 603 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-26 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31367SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 842 20:10:22. Recommend taking a level 0 backup immediately.2020-07-26 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31362SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 842 20:10:22. Recommend taking a level 0 backup immediately.2020-07-26 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31363SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 842 20:10:22. Recommend taking a level 0 backup immediately.2020-07-26 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31364SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 842 20:10:22. Recommend taking a level 0 backup immediately.2020-07-26 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31365SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 842 20:10:22. Recommend taking a level 0 backup immediately.2020-07-26 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31366SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 842 20:10:22. Recommend taking a level 0 backup immediately.2020-07-26 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31361ALARM 23Logical Log 3635 Complete, timestamp: 0x7d557d9d.2020-07-26 08:53:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31360MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-26 06:15:05NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31359SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:28 IBM Informix Dynamic Server Stopped.

06:13:26 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:13:26 IBM Informix Dynamic Server Started.
06:13:26 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:13:26 the total shared memory size for this server to 2097152 KB.
06:13:26 The maximum allowable shared memory was reset to this size to start the database server.
06:13:26 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:26 Requested shared memory segment size rounded from 15636KB to 16256KB
06:13:26 Segment locked: addr=0x44000000, size=16646144
06:13:26 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:26 Segment locked: addr=0x44fe0000, size=524288000

Sun Jul 26 06:13:30 2020

06:13:30 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:30 Requested shared memory segment size rounded from 221001KB to 221004KB
06:13:30 Segment locked: addr=0x643e0000, size=226308096
06:13:30 Successfully added a bufferpool of page size 2K.

06:13:31 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:13:36 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:13:39 Secure Sockets Layer (SSL) initialized.
06:13:39 Booting Language from module <>
06:13:39 Loading Module
06:13:39 Booting Language from module <>
06:13:39 Loading Module
06:13:46 CCFLAGS2 value set to 0x200
06:13:46 SQL_FEAT_CTRL value set to 0x8008
06:13:46 SQL_DEF_CTRL value set to 0x4b0
06:13:46 Waiting 600 seconds for startu
2020-07-26 06:14:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31358SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.7487 Duration in seconds
Additional Info: at Time: 2020-07-26 04:18:42
mon_checkpoint Status: YELLOW with value: 31.1925 Duration in seconds
Additional Info: at Time: 2020-07-26 04:13:40
mon_checkpoint Status: RED with value: 197.2813 Duration in seconds
Additional Info: at Time: 2020-07-26 04:11:09
2020-07-26 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31357SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 73.7018 Duration in seconds
Additional Info: at Time: 2020-07-26 03:42:47
mon_checkpoint Status: RED with value: 64.4496 Duration in seconds
Additional Info: at Time: 2020-07-26 03:47:51
mon_checkpoint Status: RED with value: 51.3566 Duration in seconds
Additional Info: at Time: 2020-07-26 03:37:02
mon_checkpoint Status: YELLOW with value: 37.9149 Duration in seconds
Additional Info: at Time: 2020-07-26 03:52:28
2020-07-26 04:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31356ALARM 23Logical Log 3634 Complete, timestamp: 0x7d4bd390.2020-07-26 02:29:36NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31355SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 59.0619 Duration in seconds
Additional Info: at Time: 2020-07-26 01:19:10
mon_checkpoint Status: YELLOW with value: 32.1781 Duration in seconds
Additional Info: at Time: 2020-07-26 01:13:40
mon_checkpoint Status: YELLOW with value: 30.7762 Duration in seconds
Additional Info: at Time: 2020-07-26 01:39:44
2020-07-26 02:16:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31354SERVER CAS: cas_mon_slow_stmt - count - Count of slow statementsThe slow statement sensor has found new statements, the number is above the threshold value.
Threshold Red : 10
Threshold Yellow : 5

cas_mon_slow_stmt Status: YELLOW with value: 5 Count of slow statements
2020-07-26 01:26:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31353SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 71.7484 Duration in seconds
Additional Info: at Time: 2020-07-26 00:17:00
mon_checkpoint Status: RED with value: 57.0631 Duration in seconds
Additional Info: at Time: 2020-07-26 00:27:00
mon_checkpoint Status: RED with value: 132.2937 Duration in seconds
Additional Info: at Time: 2020-07-26 00:12:49
mon_checkpoint Status: RED with value: 118.1756 Duration in seconds
Additional Info: at Time: 2020-07-26 00:22:58
2020-07-26 01:16:17NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31352DATABASE Auto Update StatisticsFound 47 table(s) in database tpcc which need statistics updated.2020-07-26 01:03:41NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31351DATABASE Auto Update StatisticsFound 91 table(s) in database sysadmin which need statistics updated.2020-07-26 01:03:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31350DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-07-26 01:02:07NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31349DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-26 01:01:43NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31348DATABASE Auto Update StatisticsFound 185 table(s) in database sysmaster which need statistics updated.2020-07-26 01:01:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31347SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 31.3419 Duration in seconds
Additional Info: at Time: 2020-07-25 23:50:13
2020-07-26 00:16:54NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31346ALARM 23Logical Log 3633 Complete, timestamp: 0x7d4438cf.2020-07-25 21:54:56NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31345ALARM 23Logical Log 3632 Complete, timestamp: 0x7d3b067f.2020-07-25 14:45:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31344TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 596 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-25 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31342SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 841 20:10:24. Recommend taking a level 0 backup immediately.2020-07-25 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31343SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 841 20:10:24. Recommend taking a level 0 backup immediately.2020-07-25 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31341SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 841 20:10:24. Recommend taking a level 0 backup immediately.2020-07-25 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31340SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 841 20:10:24. Recommend taking a level 0 backup immediately.2020-07-25 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31339SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 841 20:10:24. Recommend taking a level 0 backup immediately.2020-07-25 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31338SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 841 20:10:24. Recommend taking a level 0 backup immediately.2020-07-25 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31337ALARM 23Logical Log 3631 Complete, timestamp: 0x7d32c207.2020-07-25 09:14:02NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31336MISC SQL TraceIncrease SQL-Trace-Buffer to 40000 SQLs - used Memory per SQL 2k.2020-07-25 06:15:04NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31335MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-25 06:14:54NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31334SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:23 IBM Informix Dynamic Server Stopped.

06:13:27 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:13:28 IBM Informix Dynamic Server Started.
06:13:28 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:13:28 the total shared memory size for this server to 2097152 KB.
06:13:28 The maximum allowable shared memory was reset to this size to start the database server.
06:13:29 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:29 Requested shared memory segment size rounded from 15636KB to 16256KB
06:13:29 Segment locked: addr=0x44000000, size=16646144
06:13:29 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:29 Segment locked: addr=0x44fe0000, size=524288000

Sat Jul 25 06:13:35 2020

06:13:35 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:35 Requested shared memory segment size rounded from 221001KB to 221004KB
06:13:35 Segment locked: addr=0x643e0000, size=226308096
06:13:36 Successfully added a bufferpool of page size 2K.

06:13:37 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:13:42 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:13:42 Secure Sockets Layer (SSL) initialized.
06:13:43 Booting Language from module <>
06:13:43 Loading Module
06:13:43 Booting Language from module <>
06:13:43 Loading Module
06:13:49 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:13:49 Ev
2020-07-25 06:14:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31333SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 49.7558 Duration in seconds
Additional Info: at Time: 2020-07-25 04:14:44
mon_checkpoint Status: RED with value: 378.4383 Duration in seconds
Additional Info: at Time: 2020-07-25 04:13:25
mon_checkpoint Status: YELLOW with value: 31.2817 Duration in seconds
Additional Info: at Time: 2020-07-25 04:30:32
2020-07-25 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31332SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 89.5615 Duration in seconds
Additional Info: at Time: 2020-07-25 03:42:04
mon_checkpoint Status: RED with value: 54.2241 Duration in seconds
Additional Info: at Time: 2020-07-25 03:46:59
mon_checkpoint Status: RED with value: 51.8980 Duration in seconds
Additional Info: at Time: 2020-07-25 03:36:03
mon_checkpoint Status: YELLOW with value: 36.7996 Duration in seconds
Additional Info: at Time: 2020-07-25 03:30:41
mon_checkpoint Status: YELLOW with value: 35.7381 Duration in seconds
Additional Info: at Time: 2020-07-25 03:52:04
mon_checkpoint Status: YELLOW with value: 34.6105 Duration in seconds
Additional Info: at Time: 2020-07-25 03:57:08
mon_checkpoint Status: YELLOW with value: 34.4508 Duration in seconds
Additional Info: at Time: 2020-07-25 03:25:35
2020-07-25 04:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31331ALARM 23Logical Log 3630 Complete, timestamp: 0x7d289c02.2020-07-25 04:05:52NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31330SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 57.2348 Duration in seconds
Additional Info: at Time: 2020-07-25 01:13:47
mon_checkpoint Status: YELLOW with value: 32.0307 Duration in seconds
Additional Info: at Time: 2020-07-25 01:18:49
2020-07-25 02:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31329SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 62.8678 Duration in seconds
Additional Info: at Time: 2020-07-25 00:16:55
mon_checkpoint Status: RED with value: 156.5125 Duration in seconds
Additional Info: at Time: 2020-07-25 00:28:37
mon_checkpoint Status: RED with value: 124.5863 Duration in seconds
Additional Info: at Time: 2020-07-25 00:23:00
mon_checkpoint Status: RED with value: 119.0267 Duration in seconds
Additional Info: at Time: 2020-07-25 00:12:23
2020-07-25 01:16:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31328DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-25 01:04:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31327DATABASE Auto Update StatisticsFound 112 table(s) in database sysadmin which need statistics updated.2020-07-25 01:03:41NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31326DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-07-25 01:02:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31325DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-25 01:01:52NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31324DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-25 01:01:30NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31323ALARM 23Logical Log 3629 Complete, timestamp: 0x7d212400.2020-07-25 00:15:04NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31322ALARM 23Logical Log 3628 Complete, timestamp: 0x7d17eb9a.2020-07-24 17:06:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31321SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.9251 Duration in seconds
Additional Info: at Time: 2020-07-24 12:41:33
2020-07-24 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31320TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 597 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-24 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31315SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 840 20:10:31. Recommend taking a level 0 backup immediately.2020-07-24 12:08:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31314SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 840 20:10:31. Recommend taking a level 0 backup immediately.2020-07-24 12:08:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31319SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 840 20:10:31. Recommend taking a level 0 backup immediately.2020-07-24 12:08:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31318SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 840 20:10:31. Recommend taking a level 0 backup immediately.2020-07-24 12:08:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31317SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 840 20:10:31. Recommend taking a level 0 backup immediately.2020-07-24 12:08:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31316SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 840 20:10:31. Recommend taking a level 0 backup immediately.2020-07-24 12:08:40NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31313ALARM 23Logical Log 3627 Complete, timestamp: 0x7d0fc5de.2020-07-24 11:33:47NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31312MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-24 06:15:56NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31311SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:29 IBM Informix Dynamic Server Stopped.

06:14:29 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:14:30 IBM Informix Dynamic Server Started.
06:14:30 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:14:30 the total shared memory size for this server to 2097152 KB.
06:14:30 The maximum allowable shared memory was reset to this size to start the database server.
06:14:30 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:30 Requested shared memory segment size rounded from 15636KB to 16256KB
06:14:30 Segment locked: addr=0x44000000, size=16646144
06:14:30 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:30 Segment locked: addr=0x44fe0000, size=524288000

Fri Jul 24 06:14:36 2020

06:14:36 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:36 Requested shared memory segment size rounded from 221001KB to 221004KB
06:14:36 Segment locked: addr=0x643e0000, size=226308096
06:14:36 Successfully added a bufferpool of page size 2K.

06:14:39 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:14:46 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:14:46 Secure Sockets Layer (SSL) initialized.
06:14:47 Booting Language from module <>
06:14:47 Loading Module
06:14:47 Booting Language from module <>
06:14:47 Loading Module
06:14:53 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:14:53 Ev
2020-07-24 06:15:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31310SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 30.7000 Duration in seconds
Additional Info: at Time: 2020-07-24 04:22:13
mon_checkpoint Status: YELLOW with value: 30.2382 Duration in seconds
Additional Info: at Time: 2020-07-24 04:17:13
mon_checkpoint Status: RED with value: 201.3367 Duration in seconds
Additional Info: at Time: 2020-07-24 04:14:42
2020-07-24 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31309SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 67.4860 Duration in seconds
Additional Info: at Time: 2020-07-24 03:46:41
mon_checkpoint Status: RED with value: 59.7533 Duration in seconds
Additional Info: at Time: 2020-07-24 04:06:51
mon_checkpoint Status: RED with value: 54.8760 Duration in seconds
Additional Info: at Time: 2020-07-24 03:41:02
mon_checkpoint Status: RED with value: 42.1538 Duration in seconds
Additional Info: at Time: 2020-07-24 03:35:35
mon_checkpoint Status: YELLOW with value: 37.4675 Duration in seconds
Additional Info: at Time: 2020-07-24 03:51:19
mon_checkpoint Status: YELLOW with value: 33.4495 Duration in seconds
Additional Info: at Time: 2020-07-24 04:01:22
mon_checkpoint Status: YELLOW with value: 32.6648 Duration in seconds
Additional Info: at Time: 2020-07-24 03:30:23
mon_checkpoint Status: YELLOW with value: 30.5361 Duration in seconds
Additional Info: at Time: 2020-07-24 03:56:19
2020-07-24 04:16:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31308ALARM 23Logical Log 3626 Complete, timestamp: 0x7d062fee.2020-07-24 04:10:23NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31307SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 63.3061 Duration in seconds
Additional Info: at Time: 2020-07-24 01:38:24
2020-07-24 02:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31306SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 88.3811 Duration in seconds
Additional Info: at Time: 2020-07-24 00:20:41
mon_checkpoint Status: RED with value: 182.2323 Duration in seconds
Additional Info: at Time: 2020-07-24 00:27:17
mon_checkpoint Status: RED with value: 105.6986 Duration in seconds
Additional Info: at Time: 2020-07-24 00:15:42
2020-07-24 01:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31305DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-24 01:04:11NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31304DATABASE Auto Update StatisticsFound 112 table(s) in database sysadmin which need statistics updated.2020-07-24 01:03:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31303DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-07-24 01:02:42NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31302DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-24 01:02:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31301DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-24 01:01:53NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31300SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 113.1912 Duration in seconds
Additional Info: at Time: 2020-07-24 00:10:27
2020-07-24 00:16:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31299ALARM 23Logical Log 3625 Complete, timestamp: 0x7cfd3fd7.2020-07-23 23:06:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31298ALARM 23Logical Log 3624 Complete, timestamp: 0x7cf3f66c.2020-07-23 15:57:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31297TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 305 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-23 12:16:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31296SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 839 20:10:22. Recommend taking a level 0 backup immediately.2020-07-23 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31294SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 839 20:10:22. Recommend taking a level 0 backup immediately.2020-07-23 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31295SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 839 20:10:22. Recommend taking a level 0 backup immediately.2020-07-23 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31293SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 839 20:10:22. Recommend taking a level 0 backup immediately.2020-07-23 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31291SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 839 20:10:22. Recommend taking a level 0 backup immediately.2020-07-23 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31292SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 839 20:10:22. Recommend taking a level 0 backup immediately.2020-07-23 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31290ALARM 23Logical Log 3623 Complete, timestamp: 0x7cebba3c.2020-07-23 10:23:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31289SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.4195 Duration in seconds
Additional Info: at Time: 2020-07-23 06:19:56
2020-07-23 07:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31288MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-23 06:15:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31287SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:26 IBM Informix Dynamic Server Stopped.

06:13:51 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:13:52 IBM Informix Dynamic Server Started.
06:13:52 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:13:52 the total shared memory size for this server to 2097152 KB.
06:13:52 The maximum allowable shared memory was reset to this size to start the database server.
06:13:52 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:52 Requested shared memory segment size rounded from 15636KB to 16256KB
06:13:52 Segment locked: addr=0x44000000, size=16646144
06:13:52 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:52 Segment locked: addr=0x44fe0000, size=524288000

Thu Jul 23 06:13:57 2020

06:13:57 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:13:57 Requested shared memory segment size rounded from 221001KB to 221004KB
06:13:57 Segment locked: addr=0x643e0000, size=226308096
06:13:58 Successfully added a bufferpool of page size 2K.

06:13:59 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:14:04 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:14:04 Secure Sockets Layer (SSL) initialized.
06:14:05 Booting Language from module <>
06:14:05 Loading Module
06:14:05 Booting Language from module <>
06:14:05 Loading Module
06:14:11 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:14:11 Ev
2020-07-23 06:14:37NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31286SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 461.8332 Duration in seconds
Additional Info: at Time: 2020-07-23 04:17:38
mon_checkpoint Status: YELLOW with value: 32.5252 Duration in seconds
Additional Info: at Time: 2020-07-23 04:35:00
2020-07-23 05:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31285SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 5625 Number of session locks
Additional Info: Username: informix
Session Id: 7055
2020-07-23 04:16:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31284SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 82.8749 Duration in seconds
Additional Info: at Time: 2020-07-23 03:45:07
mon_checkpoint Status: RED with value: 63.3450 Duration in seconds
Additional Info: at Time: 2020-07-23 03:39:45
mon_checkpoint Status: RED with value: 41.1547 Duration in seconds
Additional Info: at Time: 2020-07-23 03:49:49
mon_checkpoint Status: YELLOW with value: 39.3765 Duration in seconds
Additional Info: at Time: 2020-07-23 04:05:26
mon_checkpoint Status: YELLOW with value: 32.4941 Duration in seconds
Additional Info: at Time: 2020-07-23 04:00:16
2020-07-23 04:16:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31283ALARM 23Logical Log 3622 Complete, timestamp: 0x7ce1caed.2020-07-23 04:07:55NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31282SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 92.2537 Duration in seconds
Additional Info: at Time: 2020-07-23 00:18:55
mon_checkpoint Status: RED with value: 120.3980 Duration in seconds
Additional Info: at Time: 2020-07-23 00:29:44
mon_checkpoint Status: RED with value: 111.2263 Duration in seconds
Additional Info: at Time: 2020-07-23 00:13:53
mon_checkpoint Status: RED with value: 105.0408 Duration in seconds
Additional Info: at Time: 2020-07-23 00:24:12
2020-07-23 01:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31281DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-23 01:03:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31280DATABASE Auto Update StatisticsFound 112 table(s) in database sysadmin which need statistics updated.2020-07-23 01:03:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31279DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-07-23 01:02:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31278DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-23 01:01:49NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31277DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-23 01:01:26NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31276ALARM 23Logical Log 3621 Complete, timestamp: 0x7cd8808e.2020-07-23 00:40:12NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31275ALARM 23Logical Log 3620 Complete, timestamp: 0x7ccf4f3c.2020-07-22 17:29:55NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31274SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 31.7044 Duration in seconds
Additional Info: at Time: 2020-07-22 12:39:44
2020-07-22 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31273TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 593 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-22 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31269SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 838 20:10:23. Recommend taking a level 0 backup immediately.2020-07-22 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31271SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 838 20:10:23. Recommend taking a level 0 backup immediately.2020-07-22 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31270SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 838 20:10:23. Recommend taking a level 0 backup immediately.2020-07-22 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31272SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 838 20:10:23. Recommend taking a level 0 backup immediately.2020-07-22 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31267SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 838 20:10:22. Recommend taking a level 0 backup immediately.2020-07-22 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31268SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 838 20:10:22. Recommend taking a level 0 backup immediately.2020-07-22 12:08:31NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31266ALARM 23Logical Log 3619 Complete, timestamp: 0x7cc6fe85.2020-07-22 11:57:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31265SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 32.6497 Duration in seconds
Additional Info: at Time: 2020-07-22 06:25:59
2020-07-22 07:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31264MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-22 06:16:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31263SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:24 IBM Informix Dynamic Server Stopped.

06:14:32 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:14:33 IBM Informix Dynamic Server Started.
06:14:33 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:14:33 the total shared memory size for this server to 2097152 KB.
06:14:33 The maximum allowable shared memory was reset to this size to start the database server.
06:14:33 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:33 Requested shared memory segment size rounded from 15636KB to 16256KB
06:14:33 Segment locked: addr=0x44000000, size=16646144
06:14:33 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:33 Segment locked: addr=0x44fe0000, size=524288000

Wed Jul 22 06:14:40 2020

06:14:40 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:14:40 Requested shared memory segment size rounded from 221001KB to 221004KB
06:14:40 Segment locked: addr=0x643e0000, size=226308096
06:14:40 Successfully added a bufferpool of page size 2K.

06:14:44 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:14:50 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:14:51 Secure Sockets Layer (SSL) initialized.
06:14:52 Booting Language from module <>
06:14:52 Loading Module
06:14:52 Booting Language from module <>
06:14:52 Loading Module
06:14:59 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0.
This configuration parameter is not supported
in IDS Innovator-C Edition.
06:14:59 Ev
2020-07-22 06:15:28NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31262SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 31.3281 Duration in seconds
Additional Info: at Time: 2020-07-22 04:34:32
mon_checkpoint Status: RED with value: 286.3698 Duration in seconds
Additional Info: at Time: 2020-07-22 04:17:18
mon_checkpoint Status: RED with value: 260.4463 Duration in seconds
Additional Info: at Time: 2020-07-22 04:11:31
2020-07-22 05:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31261ALARM 23Logical Log 3618 Complete, timestamp: 0x7cbd7d47.2020-07-22 04:34:56NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31260SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 127783 Number of session locks
Additional Info: Username: informix
Session Id: 7048
2020-07-22 04:16:27NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31259SERVER CAS: mon_users - upf_logspuse - log space currently used in byteThe amount of log space consumed in bytes by the current transaction
Threshold Red : 30000000
Threshold Yellow : 10000000

mon_users Status: YELLOW with value: 10989136.0000 log space currently used in byte
Additional Info: Username: informix
Session Id: 7048
2020-07-22 04:16:25NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31258SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 63.8039 Duration in seconds
Additional Info: at Time: 2020-07-22 03:42:17
mon_checkpoint Status: RED with value: 46.0804 Duration in seconds
Additional Info: at Time: 2020-07-22 03:52:12
mon_checkpoint Status: YELLOW with value: 39.8130 Duration in seconds
Additional Info: at Time: 2020-07-22 03:46:56
mon_checkpoint Status: YELLOW with value: 38.3754 Duration in seconds
Additional Info: at Time: 2020-07-22 03:36:43
mon_checkpoint Status: YELLOW with value: 32.5779 Duration in seconds
Additional Info: at Time: 2020-07-22 03:15:48
mon_checkpoint Status: YELLOW with value: 31.3228 Duration in seconds
Additional Info: at Time: 2020-07-22 03:26:12
mon_checkpoint Status: YELLOW with value: 30.1105 Duration in seconds
Additional Info: at Time: 2020-07-22 04:02:41
2020-07-22 04:16:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31257SERVER CAS: cas_mon_slow_stmt - count - Count of slow statementsThe slow statement sensor has found new statements, the number is above the threshold value.
Threshold Red : 10
Threshold Yellow : 5

cas_mon_slow_stmt Status: YELLOW with value: 6 Count of slow statements
2020-07-22 03:46:15NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31256SERVER scout-demo-2 - Found:err,warningMessage from PRIMARY-instance: ol_scout

03:03:46 SCHAPI: [cas_check_onlinelog 64-239213] Error -244 Could not do a physical-order read to fetch next row.

03:03:46 SCHAPI: [cas_check_onlinelog 64-239213] Error -101 ISAM error: file is not open.

03:03:46 SCHAPI: Warning!!! dbWorker thread is cleaning up temp tables for task 64.
03:04:51 Checkpoint Completed: duration was 18 seconds.
03:04:51 Wed Jul 22 - loguniq 3618, logpos 0x1bfe348, timestamp: 0x7cb5a9b1 Interval: 230633

03:04:51 Maximum server connections 8
03:04:51 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 500, Llog used 257

2020-07-22 03:08:47NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31255SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 99.6890 Duration in seconds
Additional Info: at Time: 2020-07-22 00:22:22
mon_checkpoint Status: RED with value: 59.5976 Duration in seconds
Additional Info: at Time: 2020-07-22 00:16:12
mon_checkpoint Status: RED with value: 123.0159 Duration in seconds
Additional Info: at Time: 2020-07-22 00:11:42
mon_checkpoint Status: RED with value: 109.3382 Duration in seconds
Additional Info: at Time: 2020-07-22 00:27:45
2020-07-22 01:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31254ALARM 23Logical Log 3617 Complete, timestamp: 0x7cb31d65.2020-07-22 01:04:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31253DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-22 01:04:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31252DATABASE Auto Update StatisticsFound 98 table(s) in database sysadmin which need statistics updated.2020-07-22 01:03:45NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31251DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-07-22 01:02:28NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31250DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-22 01:02:03NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31249DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-22 01:01:37NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31248SERVER CAS: cas_mon_slow_stmt - count - Count of slow statementsThe slow statement sensor has found new statements, the number is above the threshold value.
Threshold Red : 10
Threshold Yellow : 5

cas_mon_slow_stmt Status: YELLOW with value: 6 Count of slow statements
2020-07-22 00:16:16NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31247ALARM 23Logical Log 3616 Complete, timestamp: 0x7caa82c0.2020-07-21 19:03:24NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31246SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 38.8925 Duration in seconds
Additional Info: at Time: 2020-07-21 12:39:47
2020-07-21 13:16:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31245ALARM 23Logical Log 3615 Complete, timestamp: 0x7ca1b062.2020-07-21 12:41:12NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31244TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 595 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-21 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31243SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 837 20:10:25. Recommend taking a level 0 backup immediately.2020-07-21 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31242SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 837 20:10:25. Recommend taking a level 0 backup immediately.2020-07-21 12:08:34NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31241SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 837 20:10:24. Recommend taking a level 0 backup immediately.2020-07-21 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31238SERVER rootdbsDbspace [rootdbs] has not had a level 0 backup for 837 20:10:24. Recommend taking a level 0 backup immediately.2020-07-21 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31240SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 837 20:10:24. Recommend taking a level 0 backup immediately.2020-07-21 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31239SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 837 20:10:24. Recommend taking a level 0 backup immediately.2020-07-21 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31237ALARM 23Logical Log 3614 Complete, timestamp: 0x7c98bb53.2020-07-21 06:17:20NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
GREENINFO31236MISC SQL TraceActivation of SQL-Trace-Buffer to 40000 - used Memory per SQL 2k.2020-07-21 06:17:10NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDERROR31235SERVER scout-demo-2 - Found:stop,warning,shared,added,load,modeMessage from PRIMARY-instance: ol_scout

06:00:25 IBM Informix Dynamic Server Stopped.

06:15:37 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
06:15:38 IBM Informix Dynamic Server Started.
06:15:38 Warning: The IBM IDS Innovator-C Edition license restriction limits
06:15:38 the total shared memory size for this server to 2097152 KB.
06:15:38 The maximum allowable shared memory was reset to this size to start the database server.
06:15:38 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 16646144 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:38 Requested shared memory segment size rounded from 15636KB to 16256KB
06:15:38 Segment locked: addr=0x44000000, size=16646144
06:15:38 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 524288000 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:38 Segment locked: addr=0x44fe0000, size=524288000

Tue Jul 21 06:15:43 2020

06:15:43 Insufficient free huge pages in /proc/meminfo for shared memory segment.
Requested: 226308096 bytes. Available: 0 bytes.
The default memory page size will be used.
06:15:43 Requested shared memory segment size rounded from 221001KB to 221004KB
06:15:43 Segment locked: addr=0x643e0000, size=226308096
06:15:43 Successfully added a bufferpool of page size 2K.

06:15:43 Event alarms enabled. ALARMPROG = '/opt/informix_demo/etc/alarmprogram.sh'
06:15:49 IBM Global Security Kit (GSKit) version 8.0.50.89.
06:15:49 Secure Sockets Layer (SSL) initialized.
06:15:50 Booting Language from module <>
06:15:50 Loading Module
06:15:50 Booting Language from module <>
06:15:50 Loading Module
06:15:56 CCFLAGS2 value set to 0x200
06:15:56 SQL_FEAT_CTRL value set to 0x8008
06:15:56 SQL_DEF_CTRL value set to 0x4b0
06:15:56 Waiting 600 seconds for startu
2020-07-21 06:16:28NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31234SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 441.8194 Duration in seconds
Additional Info: at Time: 2020-07-21 04:18:52
mon_checkpoint Status: YELLOW with value: 38.2396 Duration in seconds
Additional Info: at Time: 2020-07-21 04:30:26
mon_checkpoint Status: YELLOW with value: 35.9719 Duration in seconds
Additional Info: at Time: 2020-07-21 04:35:32
mon_checkpoint Status: YELLOW with value: 31.3905 Duration in seconds
Additional Info: at Time: 2020-07-21 04:19:53
2020-07-21 05:16:13NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31233SERVER CAS: mon_users - nlocks - Number of session locksThe number of locks a session holds
Threshold Red : 500
Threshold Yellow : 100

mon_users Status: RED with value: 58648 Number of session locks
Additional Info: Username: informix
Session Id: 7055
2020-07-21 04:16:26NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31232SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 82.6819 Duration in seconds
Additional Info: at Time: 2020-07-21 03:40:47
mon_checkpoint Status: RED with value: 74.8331 Duration in seconds
Additional Info: at Time: 2020-07-21 03:46:03
mon_checkpoint Status: RED with value: 69.1165 Duration in seconds
Additional Info: at Time: 2020-07-21 03:51:13
mon_checkpoint Status: YELLOW with value: 33.0831 Duration in seconds
Additional Info: at Time: 2020-07-21 03:34:55
mon_checkpoint Status: RED with value: 115.6095 Duration in seconds
Additional Info: at Time: 2020-07-21 04:08:01
2020-07-21 04:16:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31231ALARM 23Logical Log 3613 Complete, timestamp: 0x7c8e4179.2020-07-21 02:29:39NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31230SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 71.5119 Duration in seconds
Additional Info: at Time: 2020-07-21 00:19:36
mon_checkpoint Status: RED with value: 52.7671 Duration in seconds
Additional Info: at Time: 2020-07-21 00:24:35
mon_checkpoint Status: RED with value: 115.0509 Duration in seconds
Additional Info: at Time: 2020-07-21 00:14:54
2020-07-21 01:16:21NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31229DATABASE Auto Update StatisticsFound 48 table(s) in database tpcc which need statistics updated.2020-07-21 01:03:41NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31228DATABASE Auto Update StatisticsFound 96 table(s) in database sysadmin which need statistics updated.2020-07-21 01:03:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31227DATABASE Auto Update StatisticsFound 48 table(s) in database sysuser which need statistics updated.2020-07-21 01:02:26NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31226DATABASE Auto Update StatisticsFound 42 table(s) in database sysutils which need statistics updated.2020-07-21 01:01:58NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31225DATABASE Auto Update StatisticsFound 184 table(s) in database sysmaster which need statistics updated.2020-07-21 01:01:35NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31224SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: RED with value: 100.2996 Duration in seconds
Additional Info: at Time: 2020-07-21 00:09:26
2020-07-21 00:16:18NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31223ALARM 23Logical Log 3612 Complete, timestamp: 0x7c856d14.2020-07-20 20:25:19NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31222SERVER CAS: mon_checkpoint - cp_time - Duration in secondsThe duration of a checkpoint is above the threshold value.
Threshold Red : 40
Threshold Yellow : 30

mon_checkpoint Status: YELLOW with value: 33.4158 Duration in seconds
Additional Info: at Time: 2020-07-20 12:44:23
2020-07-20 13:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
YELLOWINFO31221ALARM 23Logical Log 3611 Complete, timestamp: 0x7c7c39c6.2020-07-20 13:15:04NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDINFO31220TABLE CAS: mon_table_profile - 10000 pf_seqscans - Count of seq. ScansThe number of sequential scans on tables with more than 10000 records exceeds the threshold value. High values degrade the performance of the instance.
Threshold Red : 10
Threshold Yellow : 4

mon_table_profile Status: RED with value: 588 Count of seq. Scans
Additional Info: Database: sysadmin
Tablename: ph_run
2020-07-20 12:16:14NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31219SERVER sbspaceDbspace [sbspace] has not had a level 0 backup for 836 20:10:24. Recommend taking a level 0 backup immediately.2020-07-20 12:08:33NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31218SERVER datadbsDbspace [datadbs] has not had a level 0 backup for 836 20:10:23. Recommend taking a level 0 backup immediately.2020-07-20 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31217SERVER sysadmindbsDbspace [sysadmindbs] has not had a level 0 backup for 836 20:10:23. Recommend taking a level 0 backup immediately.2020-07-20 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31215SERVER physdbsDbspace [physdbs] has not had a level 0 backup for 836 20:10:23. Recommend taking a level 0 backup immediately.2020-07-20 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
REDWARNING31216SERVER logdbsDbspace [logdbs] has not had a level 0 backup for 836 20:10:23. Recommend taking a level 0 backup immediately.2020-07-20 12:08:32NEW sysadmin
Set to ignore
All by object type
All by sensor (Object Name)
Language: