Skip to content

Running RSS #9

Description

@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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions