05:05:35 Parameter's user-configured value was adjusted. (AUTO_AIOVPS) 05:05:35 IBM Informix Dynamic Server Started. 05:05:35 Requested shared memory segment size rounded from 568804KB to 575984KB Wed Sep 22 05:05:37 2021 05:05:37 Requested shared memory segment size rounded from 2197466KB to 2197468KB 05:05:37 Successfully added a bufferpool of page size 2K. 05:05:37 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh' 05:05:37 Booting Language from module <> 05:05:37 Loading Module 05:05:37 Booting Language from module <> 05:05:37 Loading Module 05:05:37 Warning: CONSOLE = /dev/console open failed. Redirecting output to '/dev/null'. 05:05:42 DR: DRAUTO is 0 (Off) 05:05:42 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 05:05:42 Event notification facility epoll enabled. 05:05:42 CCFLAGS2 value set to 0x200 05:05:42 SQL_FEAT_CTRL value set to 0x8008 05:05:42 SQL_FEAT_CTRL2 value set to 0x10 05:05:42 SQL_DEF_CTRL value set to 0x44004b0 05:05:43 IBM Informix Dynamic Server Version 14.10.FC3 05:05:43 VP 1 is requesting 32768 kaio event resources. 05:05:45 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 05:05:45 Started 1 B-tree scanners. 05:05:45 B-tree scanner threshold set at 5000. 05:05:45 B-tree scanner range scan size set to -1. 05:05:45 B-tree scanner ALICE mode set to 6. 05:05:45 B-tree scanner index compression level set to med. 05:05:45 Physical Recovery Started at Page (1:207253). 05:05:45 Physical Recovery Complete: 142 Pages Examined, 142 Pages Restored. 05:05:45 Logical Recovery Started. 05:05:45 10 recovery worker threads will be started. 05:05:47 Logical Recovery has reached the transaction cleanup phase. 05:05:47 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 05:05:48 Dataskip is now OFF for all dbspaces 05:05:48 Dropping temporary TBLspace 0x2007b0, recovering 8 pages. 05:05:48 Dropping temporary TBLspace 0x2008aa, recovering 8 pages. 05:05:49 Checkpoint Completed: duration was 0 seconds. 05:05:49 Wed Sep 22 - loguniq 174449, logpos 0x505328, timestamp: 0x3444f328 Interval: 609947 05:05:49 Maximum server connections 0 05:05:49 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 173, Llog used 1 05:05:49 On-Line Mode 05:05:50 SCHAPI: Started dbScheduler thread. 05:05:51 Booting Language from module <> 05:05:51 Loading Module 05:05:51 Auto Registration is synced 05:05:51 SCHAPI: Started 2 dbWorker threads. 05:05:53 Defragmenter cleaner thread now running 05:05:53 Defragmenter cleaner thread cleaned:0 partitions 05:06:05 Loading Module <$INFORMIXDIR/extend/ExecIt/bin/exec.bld> 05:06:05 The C Language Module loaded 05:06:05 Loading Module <$INFORMIXDIR/extend/IUtil/iutil.bld> 05:06:05 The C Language Module loaded 05:06:43 Dynamically added 1 cpu VP 05:06:43 VP 9 is requesting 16384 kaio event resources. 05:06:44 ** AUTO TUNING - Added CPU VP. 05:07:45 requested number of KAIO events (10922) exceeds limit (8192). using 8192. 05:07:45 VP 10 is requesting 8192 kaio event resources. 05:07:45 Dynamically added 1 cpu VP 05:07:46 ** AUTO TUNING - Added CPU VP. 05:08:46 Dynamically added 1 cpu VP 05:08:47 requested number of KAIO events (8192) exceeds limit (4096). using 4096. 05:08:47 VP 11 is requesting 4096 kaio event resources. 05:08:47 ** AUTO TUNING - Added CPU VP. 05:09:47 Dynamically added 1 cpu VP 05:09:48 ** AUTO TUNING - Added CPU VP. 05:09:50 requested number of KAIO events (6553) exceeds limit (2048). using 2048. 05:09:50 VP 12 is requesting 2048 kaio event resources. 05:11:17 Checkpoint Completed: duration was 0 seconds. 05:11:17 Wed Sep 22 - loguniq 174449, logpos 0x553018, timestamp: 0x344798ac Interval: 609948 05:11:17 Maximum server connections 2 05:11:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 69, Llog used 78 05:15:48 ** AUTO TUNING - Extending bufferpool 2K. 05:15:48 Requested shared memory segment size rounded from 43145KB to 43148KB 05:15:48 Extended bufferpool 2K 43145K memory, 20001 buffers 05:16:17 Checkpoint Completed: duration was 0 seconds. 05:16:17 Wed Sep 22 - loguniq 174449, logpos 0x55c018, timestamp: 0x3447ab3a Interval: 609949 05:16:17 Maximum server connections 3 05:16:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 95, Llog used 9 05:17:48 Dynamically added 1 cpu VP 05:17:49 ** AUTO TUNING - Added CPU VP. 05:17:51 requested number of KAIO events (5461) exceeds limit (1024). using 1024. 05:17:51 VP 13 is requesting 1024 kaio event resources. 05:20:49 ** AUTO TUNING - Extending bufferpool 2K. 05:20:49 Requested shared memory segment size rounded from 43145KB to 43148KB 05:20:49 Extended bufferpool 2K 43145K memory, 20001 buffers 05:21:17 Checkpoint Completed: duration was 0 seconds. 05:21:17 Wed Sep 22 - loguniq 174449, logpos 0x561018, timestamp: 0x3447bc94 Interval: 609950 05:21:17 Maximum server connections 3 05:21:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 65, Llog used 5 05:25:49 ** AUTO TUNING - Extending bufferpool 2K. 05:25:49 Requested shared memory segment size rounded from 43145KB to 43148KB 05:25:49 Extended bufferpool 2K 43145K memory, 20001 buffers 05:26:17 Checkpoint Completed: duration was 0 seconds. 05:26:17 Wed Sep 22 - loguniq 174449, logpos 0x594018, timestamp: 0x3447d7be Interval: 609951 05:26:17 Maximum server connections 3 05:26:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 300, Llog used 51 05:31:17 Checkpoint Completed: duration was 0 seconds. 05:31:17 Wed Sep 22 - loguniq 174449, logpos 0x599018, timestamp: 0x3447edb7 Interval: 609952 05:31:17 Maximum server connections 3 05:31:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 59, Llog used 5 05:35:49 ** AUTO TUNING - Extending bufferpool 2K. 05:35:49 Requested shared memory segment size rounded from 86270KB to 86272KB 05:35:49 Extended bufferpool 2K 86270K memory, 40000 buffers 05:36:17 Checkpoint Completed: duration was 0 seconds. 05:36:17 Wed Sep 22 - loguniq 174449, logpos 0x5a9018, timestamp: 0x3447ff6b Interval: 609953 05:36:17 Maximum server connections 3 05:36:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 64, Llog used 16 05:40:49 ** AUTO TUNING - Extending bufferpool 2K. 05:40:49 Requested shared memory segment size rounded from 86270KB to 86272KB 05:40:49 Extended bufferpool 2K 86270K memory, 40000 buffers 05:41:17 Checkpoint Completed: duration was 0 seconds. 05:41:17 Wed Sep 22 - loguniq 174449, logpos 0x5ae018, timestamp: 0x344812b2 Interval: 609954 05:41:17 Maximum server connections 3 05:41:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 60, Llog used 5 05:45:49 ** AUTO TUNING - Extending bufferpool 2K. 05:45:49 Requested shared memory segment size rounded from 86270KB to 86272KB 05:45:49 Extended bufferpool 2K 86270K memory, 40000 buffers 05:46:17 Checkpoint Completed: duration was 0 seconds. 05:46:17 Wed Sep 22 - loguniq 174449, logpos 0x5b3018, timestamp: 0x34482318 Interval: 609955 05:46:17 Maximum server connections 3 05:46:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 52, Llog used 5 05:50:49 ** AUTO TUNING - Extending bufferpool 2K. 05:50:49 Requested shared memory segment size rounded from 86270KB to 86272KB 05:50:49 Extended bufferpool 2K 86270K memory, 40000 buffers 05:51:17 Checkpoint Completed: duration was 0 seconds. 05:51:17 Wed Sep 22 - loguniq 174449, logpos 0x5bc018, timestamp: 0x34483432 Interval: 609956 05:51:17 Maximum server connections 3 05:51:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 61, Llog used 9 05:55:49 ** AUTO TUNING - Extending bufferpool 2K. 05:55:49 Requested shared memory segment size rounded from 172520KB to 172524KB 05:55:50 Extended bufferpool 2K 172520K memory, 80001 buffers 05:56:18 Checkpoint Completed: duration was 0 seconds. 05:56:18 Wed Sep 22 - loguniq 174449, logpos 0x5c1018, timestamp: 0x344844b6 Interval: 609957 05:56:18 Maximum server connections 3 05:56:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 59, Llog used 5 06:00:49 Performance Advisory: Unable to extend bufferpool 2K. 06:00:49 Results: Bufferpool has reached the # of extends '8' allowed. 06:00:49 Action: Increase the amount of memory the bufferpool can utilize. 06:01:18 Checkpoint Completed: duration was 0 seconds. 06:01:18 Wed Sep 22 - loguniq 174449, logpos 0x5c6018, timestamp: 0x344857f2 Interval: 609958