HDR not working

Newbie to Informix Cannot get HDR to work. Can anyone help? Thanks Derrick Muller Secondary stays in “Fast Recovery” mode. Here are configurations for both primary (runix) and secondary (backix) Running SLE 11, IDS 11.70 PRIMARY hostname:dm_runix Instance: ol_dm_runix service: ids_port SECONDARY hostname:dm_backix Instance: ol_dm_backix Service: ids_port onconfig the same on both servers except for DBSERVERNAME sqlhosts same on both servers as follows: #======================================================================= #DBSERVER PROTOCOL HOSTNAME SERVICE #======================================================================= ol_dm_runix onsoctcp dm_runix ids_port ol_dm_backix onsoctcp dm_backix ids_port /etc/services same on both servers: ids_port 9088/tcp informix@dm_runix:/opt$ ping dm_backix PING dm_backix (10.211.55.16) 56(84) bytes of data. 64 bytes from dm_backix (10.211.55.16): icmp_seq=1 ttl=64 time=0.466 ms 64 bytes from dm_backix (10.211.55.16): icmp_seq=2 ttl=64 time=0.405 ms informix@dm_backix:~$ ping dm_runix PING dm_runix (10.211.55.15) 56(84) bytes of data. 64 bytes from dm_runix (10.211.55.15): icmp_seq=1 ttl=64 time=0.413 ms 64 bytes from dm_runix (10.211.55.15): icmp_seq=2 ttl=64 time=0.423 ms PROCEDURE FOLLOWED: 1.) Primary On-line but NOT in HDR mode. informix@dm_runix:/opt$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line -- Up 00:48:58 --165600 Kbytes (not errors in log) Secondary off-line 2.) On primary ontape –s –L 0 Copy backup files to Secondary Do a ontape –p on secondary server informix@dm_backix:~$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery -- Up 00:00:22 -- 157408 Kbytes 3.) On Primary informix@dm_runix:/opt$ onmode -d primary ol_dm_backix informix@dm_runix:/opt$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up 01:35:35 -- 165600 Kbytes Message Log File: /var/log/informix/ol_dm_runix.log12:14:02 Tue Jan 31 - loguniq 22, logpos 0x196d018, timestamp: 0x7ad27 Interval: 240 12:14:02 Maximum server connections 0 12:14:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2 12:29:04 Checkpoint Completed: duration was 0 seconds. 12:29:04 Tue Jan 31 - loguniq 22, logpos 0x196f018, timestamp: 0x7ad36 Interval: 241 12:29:04 Maximum server connections 0 12:29:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2 12:31:19 DR: new type = primary, secondary server name = ol_dm_backix 12:31:19 DR: Cannot connect to secondary server 12:31:19 DR: Turned off on primary server 12:44:07 Checkpoint Completed: duration was 0 seconds. 12:44:07 Tue Jan 31 - loguniq 22, logpos 0x197e018, timestamp: 0x7addc Interval: 242 12:44:07 Maximum server connections 0 12:44:07 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 19, Llog used 15 informix@dm_runix:/opt$ onstat -g dri IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up 01:33:24 -- 165600 KbytesData Replication at 0x4c1691c0: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes primary off ol_dm_backix -1 / -1 NA DRINTERVAL 30 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0Backlog 0 Nothing Sent Nothing Received No Pings 4.) On Secondary informix@dm_backix:~$ onmode -d secondary ol_dm_runix informix@dm_backix:~$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) -- Up 00:03:59 -- 157408 Kbytes Message Log File: /var/log/informix/ol_dm_backix.log 12:44:21 Maximum server connections 0 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0 12:44:21 Checkpoint Completed: duration was 0 seconds. 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7625b Interval: 226 12:44:21 Maximum server connections 0 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0 12:44:21 Physical Restore of root_dbs, dm_dat_dbs, dm_idx_dbs, llogs_dbs, plogs_dbs, temp_dbs, sbspace_dbs Completed. 12:44:21 Checkpoint Completed: duration was 0 seconds. 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7627d Interval: 226 12:44:21 Maximum server connections 0 12:47:50 DR: Reservation of the last logical log for log backup turned off 12:47:50 DR: new type = secondary, primary server name = ol_dm_runix 12:47:50 DR: Trying to connect to primary server = ol_dm_runix 12:47:50 DR: Cannot connect to primary server 12:47:50 DR: Turned off on secondary server informix@dm_backix:~$ onstat -g dri IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) -- Up 00:06:22 -- 157408 Kbytes Data Replication at 0x4c1091c0: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes HDR Secondary off ol_dm_runix -1 / -1 N DRINTERVAL 30 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0Backlog 0 Last Send 2012/01/31 12:44:16 Last Receive 2012/01/31 12:44:16 Last Ping 2012/01/31 12:44:16

Hi, can you check if IP port is up on both sides (netstat -an | grep 9088) and if servers trust each other (.rhosts or hosts.equiv, check via dbaccess to connect without password from sec to prim). Marcus ----- Ursprüngliche Mail ----- Von: "DERRICK MULLER" <derrick@xact.co.za> An: ids@iiug.org Gesendet: Dienstag, 31. Januar 2012 12:00:02 Betreff: HDR not working [26093] Newbie to Informix Cannot get HDR to work. Can anyone help? Thanks Derrick Muller Secondary stays in Fast Recovery mode. Here are configurations for both primary (runix) and secondary (backix) Running SLE 11, IDS 11.70 PRIMARY hostname:dm_runix Instance: ol_dm_runix service: ids_port SECONDARY hostname:dm_backix Instance: ol_dm_backix Service: ids_port onconfig the same on both servers except for DBSERVERNAME sqlhosts same on both servers as follows: #======================================================================= #DBSERVER PROTOCOL HOSTNAME SERVICE #======================================================================= ol_dm_runix onsoctcp dm_runix ids_port ol_dm_backix onsoctcp dm_backix ids_port /etc/services same on both servers: ids_port 9088/tcp informix@dm_runix:/opt$ ping dm_backix PING dm_backix (10.211.55.16) 56(84) bytes of data. 64 bytes from dm_backix (10.211.55.16): icmp_seq=1 ttl=64 time=0.466 ms 64 bytes from dm_backix (10.211.55.16): icmp_seq=2 ttl=64 time=0.405 ms informix@dm_backix:~$ ping dm_runix PING dm_runix (10.211.55.15) 56(84) bytes of data. 64 bytes from dm_runix (10.211.55.15): icmp_seq=1 ttl=64 time=0.413 ms 64 bytes from dm_runix (10.211.55.15): icmp_seq=2 ttl=64 time=0.423 ms PROCEDURE FOLLOWED: 1.) Primary On-line but NOT in HDR mode. informix@dm_runix:/opt$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line -- Up 00:48:58 --165600 Kbytes (not errors in log) Secondary off-line 2.) On primary ontape s L 0 Copy backup files to Secondary Do a ontape p on secondary server informix@dm_backix:~$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery -- Up 00:00:22 -- 157408 Kbytes 3.) On Primary informix@dm_runix:/opt$ onmode -d primary ol_dm_backix informix@dm_runix:/opt$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up 01:35:35 -- 165600 Kbytes Message Log File: /var/log/informix/ol_dm_runix.log12:14:02 Tue Jan 31 - loguniq 22, logpos 0x196d018, timestamp: 0x7ad27 Interval: 240 12:14:02 Maximum server connections 0 12:14:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2 12:29:04 Checkpoint Completed: duration was 0 seconds. 12:29:04 Tue Jan 31 - loguniq 22, logpos 0x196f018, timestamp: 0x7ad36 Interval: 241 12:29:04 Maximum server connections 0 12:29:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2 12:31:19 DR: new type = primary, secondary server name = ol_dm_backix 12:31:19 DR: Cannot connect to secondary server 12:31:19 DR: Turned off on primary server 12:44:07 Checkpoint Completed: duration was 0 seconds. 12:44:07 Tue Jan 31 - loguniq 22, logpos 0x197e018, timestamp: 0x7addc Interval: 242 12:44:07 Maximum server connections 0 12:44:07 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 19, Llog used 15 informix@dm_runix:/opt$ onstat -g dri IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up 01:33:24 -- 165600 KbytesData Replication at 0x4c1691c0: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes primary off ol_dm_backix -1 / -1 NA DRINTERVAL 30 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0Backlog 0 Nothing Sent Nothing Received No Pings 4.) On Secondary informix@dm_backix:~$ onmode -d secondary ol_dm_runix informix@dm_backix:~$ onstat -m IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) -- Up 00:03:59 -- 157408 Kbytes Message Log File: /var/log/informix/ol_dm_backix.log 12:44:21 Maximum server connections 0 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0 12:44:21 Checkpoint Completed: duration was 0 seconds. 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7625b Interval: 226 12:44:21 Maximum server connections 0 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0 12:44:21 Physical Restore of root_dbs, dm_dat_dbs, dm_idx_dbs, llogs_dbs, plogs_dbs, temp_dbs, sbspace_dbs Completed. 12:44:21 Checkpoint Completed: duration was 0 seconds. 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7627d Interval: 226 12:44:21 Maximum server connections 0 12:47:50 DR: Reservation of the last logical log for log backup turned off 12:47:50 DR: new type = secondary, primary server name = ol_dm_runix 12:47:50 DR: Trying to connect to primary server = ol_dm_runix 12:47:50 DR: Cannot connect to primary server 12:47:50 DR: Turned off on secondary server informix@dm_backix:~$ onstat -g dri IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) -- Up 00:06:22 -- 157408 Kbytes Data Replication at 0x4c1091c0: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes HDR Secondary off ol_dm_runix -1 / -1 N DRINTERVAL 30 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0Backlog 0 Last Send 2012/01/31 12:44:16 Last Receive 2012/01/31 12:44:16 Last Ping 2012/01/31 12:44:16 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Did you check the trusts between both environments? You can establish them in /etc/hosts.equiv or ~informix/.rhosts, or better yet, by creating a similar file in $INFORMIXDIR/etc (let's call it hosts_equiv and specify it in $ONCONFIG (REMOTE_SERVER_CFG) REMOTE_SERVER_CFG hosts_equiv On this file on dm_runix you should put: dm_backix informix and on dm_backix you should put: dm_runix informix If you already established the trust relations it would be interesting to see the primary online.log after running "onmode -d secondary ..." on the secondary instance. At first glance I did not spot any thing wrong in your setup, but I may have missed something... Regards On Tue, Jan 31, 2012 at 11:00 AM, DERRICK MULLER <derrick@xact.co.za> wrote: > Newbie to Informix > Cannot get HDR to work. Can anyone help? > Thanks > Derrick Muller > > Secondary stays in “Fast Recovery” mode. > Here are configurations for both primary (runix) and secondary (backix) > Running SLE 11, IDS 11.70 > > PRIMARY > hostname:dm_runix > Instance: ol_dm_runix > service: ids_port > > SECONDARY > hostname:dm_backix > Instance: ol_dm_backix > Service: ids_port > > onconfig the same on both servers except for DBSERVERNAME > > sqlhosts same on both servers as follows: > #======================================================================= > #DBSERVER PROTOCOL HOSTNAME SERVICE > #======================================================================= > ol_dm_runix onsoctcp dm_runix ids_port > ol_dm_backix onsoctcp dm_backix ids_port> > /etc/services same on both servers: > ids_port 9088/tcp > > informix@dm_runix:/opt$ ping dm_backix > PING dm_backix (10.211.55.16) 56(84) bytes of data. > 64 bytes from dm_backix (10.211.55.16): icmp_seq=1 ttl=64 time=0.466 ms > 64 bytes from dm_backix (10.211.55.16): icmp_seq=2 ttl=64 time=0.405 ms > > informix@dm_backix:~$ ping dm_runix > PING dm_runix (10.211.55.15) 56(84) bytes of data. > 64 bytes from dm_runix (10.211.55.15): icmp_seq=1 ttl=64 time=0.413 ms > 64 bytes from dm_runix (10.211.55.15): icmp_seq=2 ttl=64 time=0.423 ms > > PROCEDURE FOLLOWED: > > 1.) Primary On-line but NOT in HDR mode. > > informix@dm_runix:/opt$ onstat -m > IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line -- Up 00:48:58 > --> 165600 Kbytes > (not errors in log) > > Secondary off-line > > 2.) On primary ontape –s –L 0 > Copy backup files to Secondary > Do a ontape –p on secondary server > > informix@dm_backix:~$ onstat -m > IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery -- Up > 00:00:22 -- 157408 Kbytes > > 3.) On Primary > informix@dm_runix:/opt$ onmode -d primary ol_dm_backix > informix@dm_runix:/opt$ onstat -m > > IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up > 01:35:35 -- 165600 Kbytes > > Message Log File: /var/log/informix/ol_dm_runix.log> 12:14:02 Tue Jan 31 - loguniq 22, logpos 0x196d018, timestamp: 0x7ad27 > Interval: 240 > > 12:14:02 Maximum server connections 0 > 12:14:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 2, Llog used 2 > > 12:29:04 Checkpoint Completed: duration was 0 seconds. > 12:29:04 Tue Jan 31 - loguniq 22, logpos 0x196f018, timestamp: 0x7ad36 > Interval: 241 > > 12:29:04 Maximum server connections 0 > 12:29:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 2, Llog used 2 > > 12:31:19 DR: new type = primary, secondary server name = ol_dm_backix > 12:31:19 DR: Cannot connect to secondary server > 12:31:19 DR: Turned off on primary server > 12:44:07 Checkpoint Completed: duration was 0 seconds. > 12:44:07 Tue Jan 31 - loguniq 22, logpos 0x197e018, timestamp: 0x7addc > Interval: 242 > > 12:44:07 Maximum server connections 0 > 12:44:07 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 19, Llog used 15 > > informix@dm_runix:/opt$ onstat -g dri > > IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up > 01:33:24 -- 165600 Kbytes> Data Replication at 0x4c1691c0: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > primary off ol_dm_backix -1 / -1 NA > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> Backlog 0 > Nothing Sent > Nothing Received > No Pings > > 4.) On Secondary > informix@dm_backix:~$ onmode -d secondary ol_dm_runix > informix@dm_backix:~$ onstat -m > > IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) --> Up > 00:03:59 -- 157408 Kbytes > > Message Log File: /var/log/informix/ol_dm_backix.log > > 12:44:21 Maximum server connections 0 > 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 0, Llog used 0 > > 12:44:21 Checkpoint Completed: duration was 0 seconds. > 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7625b > Interval: 226 > > 12:44:21 Maximum server connections 0 > 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 0, Llog used 0 > > 12:44:21 Physical Restore of root_dbs, dm_dat_dbs, dm_idx_dbs, llogs_dbs, > plogs_dbs, temp_dbs, sbspace_dbs Completed. > 12:44:21 Checkpoint Completed: duration was 0 seconds. > 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7627d > Interval: 226 > > 12:44:21 Maximum server connections 0 > 12:47:50 DR: Reservation of the last logical log for log backup turned off > 12:47:50 DR: new type = secondary, primary server name = ol_dm_runix > 12:47:50 DR: Trying to connect to primary server = ol_dm_runix > 12:47:50 DR: Cannot connect to primary server > 12:47:50 DR: Turned off on secondary server > > informix@dm_backix:~$ onstat -g dri > > IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) --> Up > 00:06:22 -- 157408 Kbytes > > Data Replication at 0x4c1091c0: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > HDR Secondary off ol_dm_runix -1 / -1 N > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> Backlog 0 > Last Send 2012/01/31 12:44:16 > Last Receive 2012/01/31 12:44:16 > Last Ping 2012/01/31 12:44:16 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf300faebb9833a504b7d19f69

What do the sqlhosts files look like? Can you use dbaccess on dm_backix to query data in the ol_dm_runix server? Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Tue, Jan 31, 2012 at 6:00 AM, DERRICK MULLER <derrick@xact.co.za> wrote: > Newbie to Informix > Cannot get HDR to work. Can anyone help? > Thanks > Derrick Muller > > Secondary stays in “Fast Recovery” mode. > Here are configurations for both primary (runix) and secondary (backix) > Running SLE 11, IDS 11.70 > > PRIMARY > hostname:dm_runix > Instance: ol_dm_runix > service: ids_port > > SECONDARY > hostname:dm_backix > Instance: ol_dm_backix > Service: ids_port > > onconfig the same on both servers except for DBSERVERNAME > > sqlhosts same on both servers as follows: > #======================================================================= > #DBSERVER PROTOCOL HOSTNAME SERVICE > #======================================================================= > ol_dm_runix onsoctcp dm_runix ids_port > ol_dm_backix onsoctcp dm_backix ids_port> > /etc/services same on both servers: > ids_port 9088/tcp > > informix@dm_runix:/opt$ ping dm_backix > PING dm_backix (10.211.55.16) 56(84) bytes of data. > 64 bytes from dm_backix (10.211.55.16): icmp_seq=1 ttl=64 time=0.466 ms > 64 bytes from dm_backix (10.211.55.16): icmp_seq=2 ttl=64 time=0.405 ms > > informix@dm_backix:~$ ping dm_runix > PING dm_runix (10.211.55.15) 56(84) bytes of data. > 64 bytes from dm_runix (10.211.55.15): icmp_seq=1 ttl=64 time=0.413 ms > 64 bytes from dm_runix (10.211.55.15): icmp_seq=2 ttl=64 time=0.423 ms > > PROCEDURE FOLLOWED: > > 1.) Primary On-line but NOT in HDR mode. > > informix@dm_runix:/opt$ onstat -m > IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line -- Up 00:48:58 > --> 165600 Kbytes > (not errors in log) > > Secondary off-line > > 2.) On primary ontape –s –L 0 > Copy backup files to Secondary > Do a ontape –p on secondary server > > informix@dm_backix:~$ onstat -m > IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery -- Up > 00:00:22 -- 157408 Kbytes > > 3.) On Primary > informix@dm_runix:/opt$ onmode -d primary ol_dm_backix > informix@dm_runix:/opt$ onstat -m > > IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up > 01:35:35 -- 165600 Kbytes > > Message Log File: /var/log/informix/ol_dm_runix.log> 12:14:02 Tue Jan 31 - loguniq 22, logpos 0x196d018, timestamp: 0x7ad27 > Interval: 240 > > 12:14:02 Maximum server connections 0 > 12:14:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 2, Llog used 2 > > 12:29:04 Checkpoint Completed: duration was 0 seconds. > 12:29:04 Tue Jan 31 - loguniq 22, logpos 0x196f018, timestamp: 0x7ad36 > Interval: 241 > > 12:29:04 Maximum server connections 0 > 12:29:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 2, Llog used 2 > > 12:31:19 DR: new type = primary, secondary server name = ol_dm_backix > 12:31:19 DR: Cannot connect to secondary server > 12:31:19 DR: Turned off on primary server > 12:44:07 Checkpoint Completed: duration was 0 seconds. > 12:44:07 Tue Jan 31 - loguniq 22, logpos 0x197e018, timestamp: 0x7addc > Interval: 242 > > 12:44:07 Maximum server connections 0 > 12:44:07 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 19, Llog used 15 > > informix@dm_runix:/opt$ onstat -g dri > > IBM Informix Dynamic Server Version 11.70.FC3IE -- On-Line (Prim) -- Up > 01:33:24 -- 165600 Kbytes> Data Replication at 0x4c1691c0: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > primary off ol_dm_backix -1 / -1 NA > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> Backlog 0 > Nothing Sent > Nothing Received > No Pings > > 4.) On Secondary > informix@dm_backix:~$ onmode -d secondary ol_dm_runix > informix@dm_backix:~$ onstat -m > > IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) --> Up > 00:03:59 -- 157408 Kbytes > > Message Log File: /var/log/informix/ol_dm_backix.log > > 12:44:21 Maximum server connections 0 > 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 0, Llog used 0 > > 12:44:21 Checkpoint Completed: duration was 0 seconds. > 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7625b > Interval: 226 > > 12:44:21 Maximum server connections 0 > 12:44:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 0, Llog used 0 > > 12:44:21 Physical Restore of root_dbs, dm_dat_dbs, dm_idx_dbs, llogs_dbs, > plogs_dbs, temp_dbs, sbspace_dbs Completed. > 12:44:21 Checkpoint Completed: duration was 0 seconds. > 12:44:21 Tue Jan 31 - loguniq 22, logpos 0x188a018, timestamp: 0x7627d > Interval: 226 > > 12:44:21 Maximum server connections 0 > 12:47:50 DR: Reservation of the last logical log for log backup turned off > 12:47:50 DR: new type = secondary, primary server name = ol_dm_runix > 12:47:50 DR: Trying to connect to primary server = ol_dm_runix > 12:47:50 DR: Cannot connect to primary server > 12:47:50 DR: Turned off on secondary server > > informix@dm_backix:~$ onstat -g dri > > IBM Informix Dynamic Server Version 11.70.FC3IE -- Fast Recovery (Sec) --> Up > 00:06:22 -- 157408 Kbytes > > Data Replication at 0x4c1091c0: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > HDR Secondary off ol_dm_runix -1 / -1 N > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /opt/IBM/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> Backlog 0 > Last Send 2012/01/31 12:44:16 > Last Receive 2012/01/31 12:44:16 > Last Ping 2012/01/31 12:44:16 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9399c1fcd838c04b7d1ab44

Thanks for input We have port 9088 listening on both servers and also establishing when requested by other server. Out problem looks like trusted connections. Working on problem will give feedback Rgds Derrick Muller

Valuable input thanks. Looks like our first problem is establishing trusted connections. Setup hosts.equiv in $INFORMIXDIR/etc. We assume format is: hostname loginname Still cannot connect using dbaccess without entering username and password. Not sure how it should work? Should you be able to connect without entering username/password? We also tried adding ~/.rhosts but no luck. Will be doing some more research tonight. Is there anything else to be done to get trusted connections to work? On another issue after doing a ontape -p on the secondary server the instance fires up in Fast Recovery mode. After doing a onmode -d secondary .... the secondary server remains in Fast Recovery (Sec) mode, is this correct or should it automatically move to On-Line (Sec) mode? Thanks for help

Thanks for input Looks like trusted connections are the problem. Working on solution. Rgds Derrick Muller

On your last question, the secondary won't move to secondary mode until it syncs with the primary. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Tue, Jan 31, 2012 at 9:25 AM, DERRICK MULLER <derrick@xact.co.za> wrote: > Valuable input thanks. > > Looks like our first problem is establishing trusted connections. > > Setup hosts.equiv in $INFORMIXDIR/etc. > We assume format is: > hostname loginname > > Still cannot connect using dbaccess without entering username and password. > Not sure how it should work? > Should you be able to connect without entering username/password? > > We also tried adding ~/.rhosts but no luck. Will be doing some more > research > tonight. > > Is there anything else to be done to get trusted connections to work? > > On another issue after doing a ontape -p on the secondary server the > instance > fires up in Fast Recovery mode. > > After doing a onmode -d secondary .... the secondary server remains in Fast > Recovery (Sec) mode, is this correct or should it automatically move to > On-Line (Sec) mode? > > Thanks for help > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f3ba42905091804b7d3d780

Be carefull... $INFORMIX/etc/hosts.equiv is not the default place for Informix to validate trusts. For replication only connections (when you use "s=6" option in $INFORMIXSQLHOSTS) it will look there. But for normal ports (which can also be used for replication) be default it will use /etc/hosts.equiv and ~/.rhosts In my first email I recommended $INFORMIXDIR/etc/hosts_equiv (note the underscore) to avoid conflicts with the other files. But in this case you must configure the REMOTE_SERVER_CFG parameter in $INFORMIXDIR/etc/$ONCONFIG. By default if you just specify the file name it will be looked in $INFORMIXDIR/etc And yes, the format is "hostname login" I suggest you do this: 1- setup the file and eventually the parameter on primary server 2- Goto secondary server and setup the normal Informix environment. Then change the INFORMIXSERVER to the primary informix intance. Then run dbaccess sysmaster. If it works replicate the idea on secondary server. If you receive error -951 go to primary server and look at the error message in online.log. You may find something like: * error -956: informix@something[something_else] is not trusted....* If this is the case (something != something_else) and you're using 11.50.xC9 or 11.70.xC4 (sorry, I know you told us, but not visible at this moment :) ) then you need to put: something informix something_else informix on the file where you specify the trusts. Or you may try to use the IP addresses. Regards. On Tue, Jan 31, 2012 at 2:25 PM, DERRICK MULLER <derrick@xact.co.za> wrote: > Valuable input thanks. > > Looks like our first problem is establishing trusted connections. > > Setup hosts.equiv in $INFORMIXDIR/etc. > We assume format is: > hostname loginname > > Still cannot connect using dbaccess without entering username and password. > Not sure how it should work? > Should you be able to connect without entering username/password? > > We also tried adding ~/.rhosts but no luck. Will be doing some more > research > tonight. > > Is there anything else to be done to get trusted connections to work? > > On another issue after doing a ontape -p on the secondary server the > instance > fires up in Fast Recovery mode. > > After doing a onmode -d secondary .... the secondary server remains in Fast > Recovery (Sec) mode, is this correct or should it automatically move to > On-Line (Sec) mode? > > Thanks for help > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf303b42d3f11d0804b7da1d19