HDR Implementaion

Hello All, Need a Fast response. Thank you Advance. On implementing HDR I have strucked at one point. My Environment: Primary Server Name : primary Secondary Server Name : hdr_secondary I had configured all the paramenters in oncongif, sqlhost, services, hosts, host.equiv. I have done the level 0 backup using ontape on primary and restored it on secondary. My primary is in primary state: IBM Informix Dynamic Server Version 12.10.FC8AEE -- On-Line (Prim) -- Up 02:29:31 -- 180852 Kbytes My Secondary server is in Fast recovery mode: IBM Informix Dynamic Server Version 12.10.FC8AEE -- Fast Recovery (Sec) -- Up 01:24:48 -- 148084 Kbytes I am not able to change the server mode to "Read-only". Not able to access the database through DBACCESS. * I used onmode -m command but no use. please help me on this. thanks in advance

Hi, onmode -m is not used to change a secondary to read-only mode. After there any errors in the online.log for the primary or the seconday? Regards, David. > On 12 June 2017 at 18:01 MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > > > Hello All, > Need a Fast response. Thank you Advance. > > On implementing HDR I have strucked at one point. > > My Environment: > > Primary Server Name : primary > Secondary Server Name : hdr_secondary > > I had configured all the paramenters in oncongif, sqlhost, services, hosts, > host.equiv. > > I have done the level 0 backup using ontape on primary and restored it on > secondary. > > My primary is in primary state: > IBM Informix Dynamic Server Version 12.10.FC8AEE -- On-Line (Prim) -- Up > 02:29:31 -- 180852 Kbytes> > My Secondary server is in Fast recovery mode: > IBM Informix Dynamic Server Version 12.10.FC8AEE -- Fast Recovery (Sec) -- Up > 01:24:48 -- 148084 Kbytes> > I am not able to change the server mode to "Read-only". > Not able to access the database through DBACCESS. > > * I used onmode -m command but no use. please help me on this. thanks in > advance > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

To complete the configuration of the secondary run the following on the primary: onmode -d primary hdr_secondary and on the secondary run the following: onmode -d secondary primary Voila! 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, Jun 12, 2017 at 1:01 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > Hello All, > Need a Fast response. Thank you Advance. > > On implementing HDR I have strucked at one point. > > My Environment: > > Primary Server Name : primary > Secondary Server Name : hdr_secondary > > I had configured all the paramenters in oncongif, sqlhost, services, hosts, > host.equiv. > > I have done the level 0 backup using ontape on primary and restored it on > secondary. > > My primary is in primary state: > IBM Informix Dynamic Server Version 12.10.FC8AEE -- On-Line (Prim) -- Up > 02:29:31 -- 180852 Kbytes> > My Secondary server is in Fast recovery mode: > IBM Informix Dynamic Server Version 12.10.FC8AEE -- Fast Recovery (Sec) --> Up > 01:24:48 -- 148084 Kbytes > > I am not able to change the server mode to "Read-only". > Not able to access the database through DBACCESS. > > * I used onmode -m command but no use. please help me on this. thanks in > advance > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Yes I am posting the Secondary server Online log 20:58:15 IBM Informix Dynamic Server Started. 20:58:15 Requested shared memory segment size rounded from 4308KB to 4796KB Mon Jun 12 20:58:17 2017 20:58:17 Requested shared memory segment size rounded from 110629KB to 110632KB 20:58:17 Successfully added a bufferpool of page size 2K. 20:58:17 Event alarms enabled. ALARMPROG = '/mnt/informix/hdr_secondary/etc/alarmprogram.sh' 20:58:17 Booting Language <c> from module <> 20:58:17 Loading Module <CNULL> 20:58:17 Booting Language <builtin> from module <> 20:58:17 Loading Module <BUILTINNULL> 20:58:22 DR: DRAUTO is 0 (Off) 20:58:22 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 20:58:22 Event notification facility epoll enabled. 20:58:22 Trusted host cache successfully built:/etc/hosts.equiv. 20:58:22 CCFLAGS2 value set to 0x200 20:58:22 SQL_FEAT_CTRL value set to 0x8008 20:58:22 SQL_DEF_CTRL value set to 0x4b0 20:58:22 IBM Informix Dynamic Server Version 12.10.FC8AEE Software Serial Number AAA#B000000 20:58:22 Bad Primary Chunk '/mnt/informix/storage/tmpsbspaces'. 20:58:23 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 20:58:23 Started 1 B-tree scanners. 20:58:23 B-tree scanner threshold set at 5000. 20:58:23 B-tree scanner range scan size set to -1. 20:58:23 B-tree scanner ALICE mode set to 6. 20:58:23 B-tree scanner index compression level set to med. 20:58:23 Physical Recovery Started at Page (1:20021). 20:58:23 Physical Recovery Complete: 79 Pages Examined, 79 Pages Restored. 20:58:24 DR: Trying to connect to primary server = hdr_primary 20:58:24 smx creates 1 transports to server hdr_primary 20:58:25 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'tmpdbspaces' 20:58:25 Dataskip is now OFF for all dbspaces 20:58:25 Restartable Restore has been ENABLED 20:58:25 Recovery Mode

I have already done with that commands. so that the primary server is in (prim) and secondary is in (sec) Primary server o/p: [root@cgslhdr9 storage]# onstat -g dri IBM Informix Dynamic Server Version 12.10.FC8AEE -- On-Line (Prim) -- Up 02:56:43 -- 180852 Kbytes Data Replication at 0x45993028: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes primary off hdr_secondary -1 / -1 NA DRINTERVAL 0 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /mnt/informix/hdr_primary/etc/dr.lostfound DRIDXAUTO 1 ENCRYPT_HDR 0Backlog 0 Nothing Sent Last Receive 2017/06/12 20:58:21 No Pings Last log page applied(log id,page): 0,0 Secondary server o/p: [root@localhost storage]# onstat -g dri IBM Informix Dynamic Server Version 12.10.FC8AEE -- Fast Recovery (Sec) -- Up 01:57:03 -- 148084 Kbytes Data Replication at 0x45995028: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes HDR Secondary off hdr_primary -1 / -1 N DRINTERVAL 0 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /mnt/informix/hdr_secondary/etc/dr.lostfound DRIDXAUTO 1 ENCRYPT_HDR 0Backlog 0 Last Send 2017/06/12 20:58:23 Nothing Received No Pings Last log page applied(log id,page): 0,0

How did you perform the restore? If ontape it should have been using "ontape -p" or "onbar -r -p" rather than "ontape -r" or "onbar -r" for a physical restore. If you used "-r" then you will have to run the restore again. I notice the warning about the temp dbspace "tmpdbspaces' does the file/device for that dbspace's chunk(s) exist on the secondary? 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, Jun 12, 2017 at 1:21 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > Yes I am posting the Secondary server Online log > > 20:58:15 IBM Informix Dynamic Server Started. > 20:58:15 Requested shared memory segment size rounded from 4308KB to 4796KB > > Mon Jun 12 20:58:17 2017 > > 20:58:17 Requested shared memory segment size rounded from 110629KB to > 110632KB > 20:58:17 Successfully added a bufferpool of page size 2K. > > 20:58:17 Event alarms enabled. ALARMPROG = > '/mnt/informix/hdr_secondary/etc/alarmprogram.sh' > 20:58:17 Booting Language <c> from module <> > 20:58:17 Loading Module <CNULL> > 20:58:17 Booting Language <builtin> from module <> > 20:58:17 Loading Module <BUILTINNULL> > 20:58:22 DR: DRAUTO is 0 (Off) > 20:58:22 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 20:58:22 Event notification facility epoll enabled. > 20:58:22 Trusted host cache successfully built:/etc/hosts.equiv. > 20:58:22 CCFLAGS2 value set to 0x200 > 20:58:22 SQL_FEAT_CTRL value set to 0x8008 > 20:58:22 SQL_DEF_CTRL value set to 0x4b0 > 20:58:22 IBM Informix Dynamic Server Version 12.10.FC8AEE Software Serial > Number AAA#B000000 > 20:58:22 Bad Primary Chunk '/mnt/informix/storage/tmpsbspaces'. > 20:58:23 IBM Informix Dynamic Server Initialized -- Shared Memory > Initialized. > > 20:58:23 Started 1 B-tree scanners. > 20:58:23 B-tree scanner threshold set at 5000. > 20:58:23 B-tree scanner range scan size set to -1. > 20:58:23 B-tree scanner ALICE mode set to 6. > 20:58:23 B-tree scanner index compression level set to med. > 20:58:23 Physical Recovery Started at Page (1:20021). > 20:58:23 Physical Recovery Complete: 79 Pages Examined, 79 Pages Restored. > 20:58:24 DR: Trying to connect to primary server = hdr_primary > 20:58:24 smx creates 1 transports to server hdr_primary > 20:58:25 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed > > in DBSPACETEMP: 'tmpdbspaces' > 20:58:25 Dataskip is now OFF for all dbspaces > 20:58:25 Restartable Restore has been ENABLED > 20:58:25 Recovery Mode > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

The only DR message I see on the secondary is: "DR: Trying to connect to primary server = hdr_primary" On the seconday machine export INFORMIXSERVER=name_of_primary_instance and run echo "select count(*) from systables" | dbaccess sysmaster What messages does this give? Regards, David. > On 12 June 2017 at 18:21 MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > > > Yes I am posting the Secondary server Online log > > 20:58:15 IBM Informix Dynamic Server Started. > 20:58:15 Requested shared memory segment size rounded from 4308KB to 4796KB > > Mon Jun 12 20:58:17 2017 > > 20:58:17 Requested shared memory segment size rounded from 110629KB to > 110632KB > 20:58:17 Successfully added a bufferpool of page size 2K. > > 20:58:17 Event alarms enabled. ALARMPROG = > '/mnt/informix/hdr_secondary/etc/alarmprogram.sh' > 20:58:17 Booting Language <c> from module <> > 20:58:17 Loading Module <CNULL> > 20:58:17 Booting Language <builtin> from module <> > 20:58:17 Loading Module <BUILTINNULL> > 20:58:22 DR: DRAUTO is 0 (Off) > 20:58:22 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 20:58:22 Event notification facility epoll enabled. > 20:58:22 Trusted host cache successfully built:/etc/hosts.equiv. > 20:58:22 CCFLAGS2 value set to 0x200 > 20:58:22 SQL_FEAT_CTRL value set to 0x8008 > 20:58:22 SQL_DEF_CTRL value set to 0x4b0 > 20:58:22 IBM Informix Dynamic Server Version 12.10.FC8AEE Software Serial > Number AAA#B000000 > 20:58:22 Bad Primary Chunk '/mnt/informix/storage/tmpsbspaces'. > 20:58:23 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. > > 20:58:23 Started 1 B-tree scanners. > 20:58:23 B-tree scanner threshold set at 5000. > 20:58:23 B-tree scanner range scan size set to -1. > 20:58:23 B-tree scanner ALICE mode set to 6. > 20:58:23 B-tree scanner index compression level set to med. > 20:58:23 Physical Recovery Started at Page (1:20021). > 20:58:23 Physical Recovery Complete: 79 Pages Examined, 79 Pages Restored. > 20:58:24 DR: Trying to connect to primary server = hdr_primary > 20:58:24 smx creates 1 transports to server hdr_primary > 20:58:25 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed > > in DBSPACETEMP: 'tmpdbspaces' > 20:58:25 Dataskip is now OFF for all dbspaces > 20:58:25 Restartable Restore has been ENABLED > 20:58:25 Recovery Mode > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

OK, then you are good to go. 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, Jun 12, 2017 at 1:24 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > I have already done with that commands. so that the primary server is in > (prim) and secondary is in (sec) > > Primary server o/p: > > [root@cgslhdr9 storage]# onstat -g dri > > IBM Informix Dynamic Server Version 12.10.FC8AEE -- On-Line (Prim) -- Up > 02:56:43 -- 180852 Kbytes> > Data Replication at 0x45993028: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > primary off hdr_secondary -1 / -1 NA > > DRINTERVAL 0 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /mnt/informix/hdr_primary/etc/dr.lostfound > DRIDXAUTO 1 > ENCRYPT_HDR 0> Backlog 0 > Nothing Sent > Last Receive 2017/06/12 20:58:21 > No Pings > Last log page applied(log id,page): 0,0 > > Secondary server o/p: > [root@localhost storage]# onstat -g dri > > IBM Informix Dynamic Server Version 12.10.FC8AEE -- Fast Recovery (Sec) --> Up > 01:57:03 -- 148084 Kbytes > > Data Replication at 0x45995028: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > HDR Secondary off hdr_primary -1 / -1 N > > DRINTERVAL 0 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /mnt/informix/hdr_secondary/etc/dr.lostfound > DRIDXAUTO 1 > ENCRYPT_HDR 0> Backlog 0 > Last Send 2017/06/12 20:58:23 > Nothing Received > No Pings > Last log page applied(log id,page): 0,0 > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

the ouput put i got is [root@localhost storage]# export INFORMIXSERVER=hdr_primary [root@localhost storage]# echo "select count(*) from systables" | dbaccess sysmaster 951: Incorrect password or user root@localhost.localdomain is not known on thedatabase server. No such file or directory

That usually means that the secondary isn't successfully receiving the logs from the primary. Can you use dbaccess to access the primary's database from the secondary? --EEM -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH TANUKU Sent: Monday, June 12, 2017 12:01 PM To: ids@iiug.org Subject: HDR Implementaion [39329] Hello All, Need a Fast response. Thank you Advance. On implementing HDR I have strucked at one point. My Environment: Primary Server Name : primary Secondary Server Name : hdr_secondary I had configured all the paramenters in oncongif, sqlhost, services, hosts, host.equiv. I have done the level 0 backup using ontape on primary and restored it on secondary. My primary is in primary state: IBM Informix Dynamic Server Version 12.10.FC8AEE -- On-Line (Prim) -- Up 02:29:31 -- 180852 Kbytes My Secondary server is in Fast recovery mode: IBM Informix Dynamic Server Version 12.10.FC8AEE -- Fast Recovery (Sec) -- Up 01:24:48 -- 148084 Kbytes I am not able to change the server mode to "Read-only". Not able to access the database through DBACCESS. * I used onmode -m command but no use. please help me on this. thanks in advance ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

But the issue is not solved still my secondary server is in Fast Recovery mode. I had run onmode -m. but still no use. I had used ontape -p to restore in secondary. Could you help me to move forward.

No I am not able to access the database of primary from secondary. find the below: 951: Incorrect password or user root@localhost.localdomain is not known onNo such file or directory Im getting the error

You don't ever use onmode -m, -j, or -s on a secondary! They don't do anything there. I agree with others that this looks like a connectivity issue. There's some reason why the primary and secondary are not communicating. 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, Jun 12, 2017 at 1:39 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > But the issue is not solved > still my secondary server is in Fast Recovery mode. > I had run onmode -m. but still no use. > > I had used ontape -p to restore in secondary. > > Could you help me to move forward. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

4 issues: 1. The sqlhosts entries cannot be for localhost.localdomain. The sqlhosts entries for each servername need to be for the fully qualified hostname for the machine. 2. Run the onmode commands as user informix rather than root. 3. On each machine create ~informix/.rhosts and add the hostname of the other machine. Permissions should be: -rw------- 1 informix informix 28 May 11 22:42 /home/informix/.rhosts 4. You may need to open firewall ports between the 2 machines to allow the connections in both directions. Regards, David. > On 12 June 2017 at 18:36 MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > > > the ouput put i got is > > [root@localhost storage]# export INFORMIXSERVER=hdr_primary > [root@localhost storage]# echo "select count(*) from systables" | dbaccess > sysmaster > > 951: Incorrect password or user root@localhost.localdomain is not known onthe > database server. > > No such file or directory > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

I am not able to find the reason where i went wrong.

Thanks david. I will reconfigure the secondary once again and get you back if any issues. thanks a lot But what is ~informix/.rhosts it should be with in the path where sqlhost resides. how to create the .rhosts and what should i mention in that file. it should be on both servers.

It looks like the two servers are not trusted by each other. The servers require a trusted host relationship. 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, Jun 12, 2017 at 1:44 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > No I am not able to access the database of primary from secondary. > find the below: > > 951: Incorrect password or user root@localhost.localdomain is not known on> No such file or directory > > Im getting the error > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Hi, The .rhosts file is a seperate security file to allow trust between the user informix for both machines. It sits in the home directory for user informix. The file can be in a different location on newer Informix versions but lets keep it simple for now. In each file put the fully qualified hostname of the other machine. Regards, David. > On 12 June 2017 at 18:54 MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > > > Thanks david. I will reconfigure the secondary once again and get you back if > any issues. thanks a lot > > But what is ~informix/.rhosts > it should be with in the path where sqlhost resides. > how to create the .rhosts and what should i mention in that file. > it should be on both servers. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Look up "trusted host" on the internet. The format of the .rhosts file is the same as the /etc/hosts.equiv file, but it is more secure. The .rhosts file resides in the user informix's home directory. 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, Jun 12, 2017 at 1:54 PM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > Thanks david. I will reconfigure the secondary once again and get you back > if > any issues. thanks a lot > > But what is ~informix/.rhosts > it should be with in the path where sqlhost resides. > how to create the .rhosts and what should i mention in that file. > it should be on both servers. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Do we need the port numbers to be same for both primary and secondary. in /etc/Services.

No. Art On Jun 13, 2017 02:17, "MUKESH TANUKU" <mukeshbt1328@gmail.com> wrote: > Do we need the port numbers to be same for both primary and secondary. > > in /etc/Services. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Please give the detail steps for trusted connection of hosts

Hi, this was already answered multiple times to your request. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_1407.htm create a text file named hosts.equiv with a notepad editor in \\\\%WINDIR%\\\\system32\\\\drivers\\\\etc You will need to become admin for this, because otherwise you have no rights. The file should contain the hostnames which are trusted and the user who is trusted as stated on the above page. They recommend to put the hostname with and without the domain suffix. e.g. #trustedhost username host1 informix host1.example.com informix If you trust all users from the remote machine, leave out the username column. As a result, you should be able to do dbaccess from the other machine without password. The HDR servers should trust each other, so you have to have this file on both sides, containing the opposite server name. Optionally, you can state in the onconfig a different location for the hosts.equiv file, which might be more comfortable to be edited e.g. by a non-Admin user. That can be done by using the REMOTE_SERVER_CFG setting in onconfig. Marcus Haarmann Von: "MUKESH TANUKU" <mukeshbt1328@gmail.com> An: "ids" <ids@iiug.org> Gesendet: Mittwoch, 28. Juni 2017 13:22:13 Betreff: Re: RE: HDR Implementaion [39468] Please give the detail steps for trusted connection of hosts ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

MUKESH: You can also try connecting from one IDS instance to the other via DBACCESS. When the connection fails due to authentication look in the target instance's IDS message log. The message log should show an "unknown user or bad password" entry. That entry will tell you what your originating system is sending (username and hostname). That is what you want to put in the hosts.equiv file that Marcus has described in detail. Cheers! Best regards, Martin M. Graney Queues Enforth Development, Inc. This electronic message contains information which may be privileged, confidential, or otherwise protected from disclosure. The information contained herein is intended for the addressee or recipient only. If you are not the addressee, or not the intended recipient, any disclosure, copying, distribution, or use of the contents of this message (including any attachments) is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies. (Queues Enforth Development, Inc.) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marcus Haarmann Sent: Wednesday, June 28, 2017 9:13 AM To: ids@iiug.org Subject: Re: HDR Implementaion [39469] Hi, this was already answered multiple times to your request. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin .doc/ids_admin_1407.htm create a text file named hosts.equiv with a notepad editor in \\\\%WINDIR%\\\\system32\\\\drivers\\\\etc You will need to become admin for this, because otherwise you have no rights. The file should contain the hostnames which are trusted and the user who is trusted as stated on the above page. They recommend to put the hostname with and without the domain suffix. e.g. #trustedhost username host1 informix host1.example.com informix If you trust all users from the remote machine, leave out the username column. As a result, you should be able to do dbaccess from the other machine without password. The HDR servers should trust each other, so you have to have this file on both sides, containing the opposite server name. Optionally, you can state in the onconfig a different location for the hosts.equiv file, which might be more comfortable to be edited e.g. by a non-Admin user. That can be done by using the REMOTE_SERVER_CFG setting in onconfig. Marcus Haarmann Von: "MUKESH TANUKU" <mukeshbt1328@gmail.com> An: "ids" <ids@iiug.org> Gesendet: Mittwoch, 28. Juni 2017 13:22:13 Betreff: Re: RE: HDR Implementaion [39468] Please give the detail steps for trusted connection of hosts ************************************************************************** ***** Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************** ***** Forum Note: Use "Reply" to post a response in the discussion forum.