Running RSS

[1gn0r4nd]

I setup 2 docker hosts with the same docker image. On both hosts I run a container with a different hostname and dbinstance name. I have updated the hostname, onconfig and sqlhosts. I can access the databases on both docker images when started initially with dbaccess. I am able to connect from the dbaccess in container 1 to the database from the other container.

Trying to do a RSS replication
Perform the requirements on the primary:

$cat /opt/ibm/informix/etc/sqlhosts
############################################################
### DO NOT MODIFY THIS COMMENT SECTION 
### HOST NAME = ifxprim 
############################################################
g_mach11  group     -         -          i=10 g=g_mach11
rss_primary        onsoctcp        ifxprim         9088 g=g_mach11
rss_primary_dr     drsoctcp        ifxprim         9089 g=g_mach11
rss_replica        onsoctcp        ifxrep         9088 g=g_mach11
rss_replica_dr     drsoctcp        ifxrep         9089 g=g_mach11

$onmode -wf LOG_INDEX_BUILDS=1
$onmode -d add RSS rss_replica
$ onstat -g rss

IBM Informix Dynamic Server Version 12.10.FC10 -- On-Line -- Up 00:25:16 -- 65396 Kbytes

Local server type: Primary
Index page logging status: Enabled
Index page logging was enabled at: 2019/09/20 16:34:51
Number of RSS servers: 1

RSS Server information:

RSS Srv      RSS Srv      Connection     Next LPG to send        Supports
name         status       status           (log id,page)         Proxy Writes
rss_replica Defined      Disconnected            0,0            N

Making a backup on the primary
ontape -s -L 0 -d -t /home/informix/backup
After that I copied the data to the other host. And restored it on the second docker container.

$cat /opt/ibm/informix/etc/sqlhosts
############################################################
### DO NOT MODIFY THIS COMMENT SECTION 
### HOST NAME = ifxrep 
############################################################
g_mach11  group     -         -          i=10 g=g_mach11
rss_replica        onsoctcp        ifxrep         9088 g=g_mach11
rss_replica_dr     drsoctcp        ifxrep         9089 g=g_mach11
rss_primary        onsoctcp        ifxprim         9088 g=g_mach11
rss_primary_dr     drsoctcp        ifxprim         9089 g=g_mach11
ontape -p -d -t /home/informix/backup/
$ onstat -
IBM Informix Dynamic Server Version 12.10.FC10 -- Fast Recovery -- Up 00:01:30 -- 72764 Kbytes
$ onmode -d RSS rss_primary
RSS Server did not successfully start.
onmode: Please check the message log for errors.
$ tail -n 25 /opt/ibm/data/logs/online.log |head -n 4
Maximum server connections 0
DR: new type = RSS
DR: Trying to connect to server, rss_primary. If the specified server is not in Online mode, bring it to Online mode.
Data replication type and state information reset. To start DR, use the 'onmode -d' command and wait for the pair to be operational, before shutting down the database server

Is this an informix issue, a docker issue, or did I miss a step?

[alegner]

Two comments:
First I'm not sure the "i=10 g=g_mach11" will work, I think there's a comma (without blank) required between the two options. Also, for only getting this cluster going, you'd not even need any group definition and reference in sqlhosts files.

Secondly, you didn't mention trust - could you connect dbaccess between the two servers without providing user/pw?