Replication (RSS) instance it not coming up
Posted in 2018
Hi All, I an new to the Informix anf getting below error. Please help IDS version : 12.1 OS : SUSE Linux Host Name : Server1 Server1 is hosting 17 informix RSS replication instance. we have create 1 replication instance around 1 month back. it was running fine. On one file day it went hung throwing below error in online log : 01:00:26 Dynamically allocated new virtual shared memory segment (size 32768KB) 01:00:26 Memory sizes:resident:24140 KB, virtual:363940 KB, SHMTOTAL:16777216 KB 01:22:18 Dynamically allocated new virtual shared memory segment (size 32768KB) 01:22:18 Memory sizes:resident:24140 KB, virtual:396708 KB, SHMTOTAL:16777216 KB 09:13:45 Dynamically allocated new virtual shared memory segment (size 32768KB) 09:13:45 Memory sizes:resident:24140 KB, virtual:429476 KB, SHMTOTAL:16777216 KB When I restarted the replication instance, it is not coming up. I have increased host memory but didn't work. Getting below error: 08:59:35 IBM Informix Dynamic Server Stopped. 08:59:41 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY) 08:59:41 IBM Informix Dynamic Server Started. 08:59:41 Warning: The IBM IDS Workgroup Edition license restriction limits 08:59:41 the total shared memory size for this server to 16777216 KB. 08:59:41 The maximum allowable shared memory was reset to this size to start the database server. 08:59:41 Requested shared memory segment size rounded from 23428KB to 24140KB Mon Oct 8 08:59:42 2018 08:59:42 Requested shared memory segment size rounded from 22459KB to 22460KB 08:59:42 Successfully added a bufferpool of page size 2K. 08:59:42 Requested shared memory segment size rounded from 210629KB to 210632KB 08:59:42 Successfully added a bufferpool of page size 4K. 08:59:42 Event alarms enabled. ALARMPROG = '/home4/informix12/etc/alarmprogram.sh' 08:59:42 Booting Language <c> from module <> 08:59:42 Loading Module <CNULL> 08:59:42 Booting Language <builtin> from module <> 08:59:42 Loading Module <BUILTINNULL> 08:59:42 SQLTRACE: SQL History Tracing set to 1000 SQL statements. 08:59:47 DR: DRAUTO is 0 (Off) 08:59:47 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 08:59:47 Event notification facility epoll enabled. 08:59:47 Trusted host cache successfully built:/etc/hosts.equiv. 08:59:47 CCFLAGS2 value set to 0x200 08:59:47 SQL_FEAT_CTRL value set to 0x8008 08:59:47 SQL_DEF_CTRL value set to 0x4b0 08:59:47 IBM Informix Dynamic Server Version 12.10.FC8WE Software Serial Number AAA#B000000 08:59:47 requested number of KAIO events (32768) exceeds limit (2313). using 2313. 08:59:48 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 08:59:48 Started 1 B-tree scanners. 08:59:48 B-tree scanner threshold set at 5000. 08:59:48 B-tree scanner range scan size set to -1. 08:59:48 B-tree scanner ALICE mode set to 6. 08:59:48 B-tree scanner index compression level set to med. 08:59:48 Physical Recovery Started at Page (3:731360). 08:59:49 Physical Recovery Complete: 270 Pages Examined, 135 Pages Restored. 08:59:49 smx creates 1 transports to server <replication_instance> Thanks,