IDS 12.10 on Ubuntu 14.04 LTS Server

Hi, I'm installing Informix DS Innovator-C Edition on Ubuntu 14.04 LTS Server. After the installation I get a message some warnings/errors happened during install (logfile). However the server is working fine. - Are there any specific settings I need? - Do I need to add/change kernel parameter values? Thanks. Guy

What errors are you getting? Sometimes the sysmaster or sysadmin database do not get created correctly during a server initialization. That may be the errors you saw and the server doesn't need these setup, but they will help you as a user and DBA. There are procedures to correct those problems if they happen. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Mar 23, 2015 at 5:16 PM, GUY DILLEN <guy.dillen@hotmail.com> wrote: > Hi, > > I'm installing Informix DS Innovator-C Edition on Ubuntu 14.04 LTS Server. > > After the installation I get a message some warnings/errors happened during > install (logfile). However the server is working fine. > > - Are there any specific settings I need? > - Do I need to add/change kernel parameter values? > > Thanks. > Guy > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bd757d27b0ca90511fb3ed1

Hi, The logfile after install, see below. Thanks. Guy 19:28:20 Parameter's user-configured value was adjusted. (DS_MAX_SCANS) 19:28:20 Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM) 19:28:20 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY) 19:28:20 IBM Informix Dynamic Server Started. 19:28:20 Warning: The IBM IDS Innovator-C Edition license restriction limits 19:28:20 the total shared memory size for this server to 2097152 KB. 19:28:20 The maximum allowable shared memory was reset to this size to start the database server. 19:28:20 Requested shared memory segment size rounded from 8308KB to 8836KB Mon Mar 23 19:28:23 2015 19:28:23 Successfully added a bufferpool of page size 2K. 19:28:23 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh' 19:28:26 Booting Language <c> from module <> 19:28:26 Loading Module <CNULL> 19:28:26 Booting Language <builtin> from module <> 19:28:26 Loading Module <BUILTINNULL> 19:28:31 DR: Cannot set the value of the onconfig parameter DRINTERVAL to 0. This configuration parameter is not supported in IDS Innovator-C Edition. 19:28:31 Event notification facility epoll enabled. 19:28:31 Waiting 600 seconds for startup to complete. 19:28:31 IBM Informix Dynamic Server Version 12.10.FC4IE Software Serial Number AAA#B000000 19:28:49 Performance Advisory: The physical log size is smaller than the recommended size for a server configured with RTO_SERVER_RESTART. 19:28:49 Results: Fast recovery performance might not be optimal. 19:28:49 Action: For best fast recovery performance when RTO_SERVER_RESTART is enabled, increase the physical log size to at least 56155 KB. For servers configured with a large buffer pool, this might not be necessary. 19:28:49 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized. 19:28:49 Started 1 B-tree scanners. 19:28:49 B-tree scanner threshold set at 5000. 19:28:49 B-tree scanner range scan size set to -1. 19:28:49 B-tree scanner ALICE mode set to 6. 19:28:49 B-tree scanner index compression level set to med. 19:28:49 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'tempdbs' 19:28:49 Dataskip is now OFF for all dbspaces 19:28:49 CDR: Cannot set the value of the onconfig parameter CDR_SERIAL to 0. This configuration parameter is not supported in IDS Innovator-C Edition. 19:28:49 Building 'sysmaster' database ... 19:28:49 Checkpoint Completed: duration was 0 seconds. 19:28:49 Mon Mar 23 - loguniq 1, logpos 0x3e0, timestamp: 0xaf Interval: 2 19:28:49 Maximum server connections 0 19:28:49 Checkpoint Statistics - Avg. Txn Block Time 0.003, # Txns blocked 2, Plog used 5, Llog used 1 19:28:49 Performance Advisory: Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool. 19:28:49 Results: The server might block transactions during checkpoints. 19:28:49 Action: If transactions are blocked during the checkpoint, increase the size of the physical log to at least 14000 KB. 19:28:49 Performance Advisory: The physical log is too small for automatic checkpoints. 19:28:49 Results: Automatic checkpoints are disabled. 19:28:49 Action: To enable automatic checkpoints, increase the physical log to at least 14000 KB. 19:28:49 On-Line Mode 19:29:09 Logical Log 1 Complete, timestamp: 0x1109a. 19:29:09 Process exited with return code 127: /bin/sh /bin/sh -c /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 1 Complete, timestamp: 0x1109a." "Logical Log 1 Complete, timestamp: 0x1109a." "" 23001 19:29:16 Booting Language <spl> from module <> 19:29:16 Loading Module <SPLNULL> 19:29:27 Unloading Module <SPLNULL> 19:29:27 Loading Module <SPLNULL> 19:29:33 Checkpoint Completed: duration was 0 seconds. 19:29:33 Mon Mar 23 - loguniq 2, logpos 0x639018, timestamp: 0x1396e Interval: 3 19:29:33 Maximum server connections 1 19:29:33 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 13, Llog used 4665 19:29:35 Performance Advisory: Logical log file size might be too small for a checkpoint to complete. 19:29:35 Results: The size of individual logical log files is too small for the current workload, resulting in each log file filling very quickly. If log files fill in less than 30 seconds, the checkpoint might remain blocked because the last log file fills during the time needed to perform the checkpoint. 19:29:35 Action: Increase the size of the individual logical log files so that it takes at least 30 seconds to fill each one. Look at the online log to determine how quickly the log files are filling, and then increase the size of the files proportionately. 19:29:36 Logical Log 2 Complete, timestamp: 0x1a379. 19:29:36 Process exited with return code 127: /bin/sh /bin/sh -c /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 2 Complete, timestamp: 0x1a379." "Logical Log 2 Complete, timestamp: 0x1a379." "" 23001 19:29:39 Checkpoint Completed: duration was 1 seconds. 19:29:39 Mon Mar 23 - loguniq 3, logpos 0xd3018, timestamp: 0x1a7d1 Interval: 4 19:29:39 Maximum server connections 1 19:29:39 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 55, Llog used 1690 19:29:45 Checkpoint Completed: duration was 0 seconds. 19:29:45 Mon Mar 23 - loguniq 3, logpos 0x76d018, timestamp: 0x215b8 Interval: 5 19:29:45 Maximum server connections 1 19:29:45 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 59, Llog used 1690 19:29:45 'sysmaster' database built successfully. 19:29:46 'sysutils' database built successfully. 19:29:46 'sysuser' database built successfully. 19:29:53 Building 'sysadmin' database ... 19:29:55 Logical Log 3 Complete, timestamp: 0x28650. 19:29:55 Process exited with return code 127: /bin/sh /bin/sh -c /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 3 Complete, timestamp: 0x28650." "Logical Log 3 Complete, timestamp: 0x28650." "" 23001 19:30:10 SCHAPI: Using (/opt/informix/etc/sysadmin/sch_init_ol_informix1210.sql) to initialize this instance. 19:30:16 Checkpoint Completed: duration was 0 seconds. 19:30:16 Mon Mar 23 - loguniq 4, logpos 0xbf92e4, timestamp: 0x2faf3 Interval: 6 19:30:16 Maximum server connections 1 19:30:16 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 153, Llog used 4236 19:30:28 Checkpoint Completed: duration was 0 seconds. 19:30:28 Mon Mar 23 - loguniq 4, logpos 0xbfc084, timestamp: 0x2fb01 Interval: 7 19:30:28 Maximum server connections 1 19:30:28 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 17, Llog used 3 19:30:29 Checkpoint Completed: duration was 0 seconds. 19:30:29 Mon Mar 23 - loguniq 4, logpos 0xbfe0d0, timestamp: 0x2fb0b Interval: 8 19:30:29 Maximum server connections 1 19:30:29 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 2 19:30:30 Logical Log 4 Complete, timestamp: 0x2fb0e. 19:30:30

OK, the only outright errors I see are when the logical logs fill the ALARMPROGRAM is being executed to back them up, but there was some problem. Most likely the default in the default ALARMPROGRAM is to use onbar to back up the logical logs and you probably did not configure any storage manager parameters so that is failing. Not a real issue, except that if you don't back up the logical logs manually instead (ontape -a or the equivalent onbar command once a storage manager is configured) the server will block updates to disk when all of the logs are filled. There are warning about the logical logs being too small, but that's a small thing. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Mar 23, 2015 at 5:37 PM, GUY DILLEN <guy.dillen@hotmail.com> wrote: > Hi, > > The logfile after install, see below. > > Thanks. > Guy > > 19:28:20 Parameter's user-configured value was adjusted. (DS_MAX_SCANS) > 19:28:20 Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM) > 19:28:20 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY) > 19:28:20 IBM Informix Dynamic Server Started. > 19:28:20 Warning: The IBM IDS Innovator-C Edition license restriction > limits > 19:28:20 the total shared memory size for this server to 2097152 KB. > 19:28:20 The maximum allowable shared memory was reset to this size to > start > the database server. > 19:28:20 Requested shared memory segment size rounded from 8308KB to 8836KB > > Mon Mar 23 19:28:23 2015 > > 19:28:23 Successfully added a bufferpool of page size 2K. > > 19:28:23 Event alarms enabled. ALARMPROG = > '/opt/informix/etc/alarmprogram.sh' > 19:28:26 Booting Language <c> from module <> > 19:28:26 Loading Module <CNULL> > 19:28:26 Booting Language <builtin> from module <> > 19:28:26 Loading Module <BUILTINNULL> > 19:28:31 DR: Cannot set the value of the onconfig parameter DRINTERVAL to > 0. > > This configuration parameter is not supported > > in IDS Innovator-C Edition. > 19:28:31 Event notification facility epoll enabled. > 19:28:31 Waiting 600 seconds for startup to complete. > 19:28:31 IBM Informix Dynamic Server Version 12.10.FC4IE Software Serial > Number AAA#B000000 > 19:28:49 Performance Advisory: The physical log size is smaller than the > recommended size for a > server configured with RTO_SERVER_RESTART. > 19:28:49 Results: Fast recovery performance might not be optimal. > 19:28:49 Action: For best fast recovery performance when > RTO_SERVER_RESTART is > enabled,> increase the physical log size to at least 56155 KB. For servers > configured with a large buffer pool, this might not be necessary. > 19:28:49 IBM Informix Dynamic Server Initialized -- Complete Disk > Initialized. > 19:28:49 Started 1 B-tree scanners. > 19:28:49 B-tree scanner threshold set at 5000. > 19:28:49 B-tree scanner range scan size set to -1. > 19:28:49 B-tree scanner ALICE mode set to 6. > 19:28:49 B-tree scanner index compression level set to med. > 19:28:49 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed > > in DBSPACETEMP: 'tempdbs' > 19:28:49 Dataskip is now OFF for all dbspaces > 19:28:49 CDR: Cannot set the value of the onconfig parameter CDR_SERIAL to > 0. > > This configuration parameter is not supported > > in IDS Innovator-C Edition. > 19:28:49 Building 'sysmaster' database ... > 19:28:49 Checkpoint Completed: duration was 0 seconds. > 19:28:49 Mon Mar 23 - loguniq 1, logpos 0x3e0, timestamp: 0xaf Interval: 2 > > 19:28:49 Maximum server connections 0 > 19:28:49 Checkpoint Statistics - Avg. Txn Block Time 0.003, # Txns blocked > 2, > Plog used 5, Llog used 1 > > 19:28:49 Performance Advisory: Based on the current workload, the physical > log > might be too small to > accommodate the time it takes to flush the buffer pool. > 19:28:49 Results: The server might block transactions during checkpoints. > 19:28:49 Action: If transactions are blocked during the checkpoint, > increase > the size of the > physical log to at least 14000 KB. > 19:28:49 Performance Advisory: The physical log is too small for automatic > checkpoints. > 19:28:49 Results: Automatic checkpoints are disabled. > 19:28:49 Action: To enable automatic checkpoints, increase the physical > log to > at least 14000 KB. > 19:28:49 On-Line Mode > 19:29:09 Logical Log 1 Complete, timestamp: 0x1109a. > 19:29:09 Process exited with return code 127: /bin/sh /bin/sh -c > /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 1 Complete, timestamp: > 0x1109a." "Logical Log 1 Complete, timestamp: 0x1109a." "" 23001 > 19:29:16 Booting Language <spl> from module <> > 19:29:16 Loading Module <SPLNULL> > 19:29:27 Unloading Module <SPLNULL> > 19:29:27 Loading Module <SPLNULL> > 19:29:33 Checkpoint Completed: duration was 0 seconds. > 19:29:33 Mon Mar 23 - loguniq 2, logpos 0x639018, timestamp: 0x1396e > Interval: > 3 > > 19:29:33 Maximum server connections 1 > 19:29:33 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 13, Llog used 4665 > > 19:29:35 Performance Advisory: Logical log file size might be too small > for a > > checkpoint to complete. > 19:29:35 Results: The size of individual logical log files is too small for > > the current workload, resulting in each log file filling very > > quickly. If log files fill in less than 30 seconds, the checkpoint > > might remain blocked because the last log file fills during the time > > needed to perform the checkpoint. > 19:29:35 Action: Increase the size of the individual logical log files so > > that it takes at least 30 seconds to fill each one. Look at the > > online log to determine how quickly the log files are filling, and > > then increase the size of the files proportionately. > 19:29:36 Logical Log 2 Complete, timestamp: 0x1a379. > 19:29:36 Process exited with return code 127: /bin/sh /bin/sh -c > /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 2 Complete, timestamp: > 0x1a379." "Logical Log 2 Complete, timestamp: 0x1a379." "" 23001 > 19:29:39 Checkpoint Completed: duration was 1 seconds. > 19:29:39 Mon Mar 23 - loguniq 3, logpos 0xd3018, timestamp: 0x1a7d1 > Interval: > 4 > > 19:29:39 Maximum server connections 1 > 19:29:39 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 55, Llog used 1690 > > 19:29:45 Checkpoint Completed: duration was 0 seconds. > 19:29:45 Mon Mar 23 - loguniq 3, logpos 0x76d018, timestamp: 0x215b8 > Interval: > 5 > > 19:29:45 Maximum server connections 1 > 19:29:45 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blo

Many thanks. Guy