Save 
Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

RSS Feed: IDS Forum: IDS

More IIUG RSS Feeds

The IDS Forum is a discussion forum to communicate about all aspects of the Informix Dynamic Server (IDS) Engine


URL: http://www.iiug.org/rss/ids.rss

Below is the latest content available from this feed:

Re: HDR Question
Posted by: Andreas.Legner1@de.ibm.com (Andreas Legner1) - Fri, 24 Nov 2017 14:24:32 EST
I think David already pointed it out: one diff between 11.50 and later is

Informix's own name caching (s. NS_CACHE onconfig param). Maybe this is

playing tricks on you.

-> retry your testing with this feature disabled: onmode -wm

NS_CACHE=host=0,service=0



From: "BENJI LONG" <ruggedmouse@hotmail.com>

To: ids@iiug.org

Date: 11/24/2017 06:54 PM

Subject: Re: HDR Question [40281]

Sent by: ids-bounces@iiug.org



Well, I got this working. Thanks everyone for all your help. I learned a

ton

trying to get this going.



I never did find out why the second instance wouldn't do lookup into the

/etc/services file.



So my v11.5 runs HDR and uses the /etc/services file to get the ports.



My 12.1 runs HDR but I had to hardcode the ip's and port numbers into the

sqlhosts file



















* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40282]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: HDR Question
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Fri, 24 Nov 2017 12:54:13 EST
Well, I got this working. Thanks everyone for all your help. I learned a ton

trying to get this going.



I never did find out why the second instance wouldn't do lookup into the

/etc/services file.



So my v11.5 runs HDR and uses the /etc/services file to get the ports.



My 12.1 runs HDR but I had to hardcode the ip's and port numbers into the

sqlhosts file









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40281]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: Misconceptions about Update Statistics
Posted by: Dirk.Moolman@mtn.com (Dirk Moolman [ MTN South Africa ]) - Fri, 24 Nov 2017 07:23:51 EST
hahaha



-----Original Message-----

From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Spokey

Wheeler

Sent: Thursday, 23 November 2017 3:52 PM

To: ids@iiug.org

Subject: Re: Misconceptions about Update Statistics [40255]



Have you tried running UPDATE STATISTICS?



> On 23 Nov 2017, at 12:45, Dirk Moolman [ MTN South Africa ]

<Dirk.Moolman@mtn.com> wrote:

>

> Has anyone here perhaps written an article about the Misconceptions of

Update

> Statistics ?

>

> I am getting so tired of Developers telling me how Update Stats is the fix

for

> EVERYTHING.

>

> Don't think the detail is necessary, but we run:

> IDS 12.10.FC9W1

>

> AIX 7

>

> Regards

> Dirk

>

>

>





>

>

















* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40280]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Backing up Logs
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Fri, 24 Nov 2017 06:49:55 EST
I figured it out. My directory was named 12.10.FC9 and in my onconfig file, I

had 1210FC9



WOW. That was a dumb mistake...



Thanks for the information though. That will help me in the future.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40279]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Backing up Logs
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Fri, 24 Nov 2017 06:39:22 EST
with ontape - a -d

it says could not write log tape









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40278]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Backing up Logs
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Fri, 24 Nov 2017 06:38:08 EST
When I run ontape -a -d

It says Performing automatic backup of logical logs

Please mount tape 1 on /opt/informix1210FC9/log_backups and press Return to

continue ...

could not write log tape.



Any ideas as to why that is?









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40277]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Backing up Logs
Posted by: marcus.haarmann@midoco.de (Marcus Haarmann) - Fri, 24 Nov 2017 04:38:19 EST
use ontape -a -d

You can modify the resulting filename with the env var IFX_ONTAPE_FILE_PREFIX



Marcus Haarmann



Von: "BENJI LONG" <ruggedmouse@hotmail.com>

An: "ids" <ids@iiug.org>

Gesendet: Donnerstag, 23. November 2017 21:09:38

Betreff: Backing up Logs [40274]



I haven't set up automatic backups of my logs yet, so while doing all this

troubleshooting, they have filled.



In the past, I have run ontape -a but now when I do that, it is asking me to

mount a tape, and hit continue, and of course, I just want them to write to

disk.



I have LTAPEDEV set in onconfig file to a path.



What am I missing here in my logic?

















* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40276]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Backing up Logs
Posted by: Andreas.Legner1@de.ibm.com (Andreas Legner1) - Fri, 24 Nov 2017 04:21:37 EST
That prompt doesn't differentiate between tape/file/directory -> just hit

enter, it will tell you if it then doesn't find what it needs.

For directory backup you might have to add -d option...



From: "BENJI LONG" <ruggedmouse@hotmail.com>

To: ids@iiug.org

Date: 11/23/2017 09:12 PM

Subject: Backing up Logs [40274]

Sent by: ids-bounces@iiug.org



I haven't set up automatic backups of my logs yet, so while doing all this

troubleshooting, they have filled.



In the past, I have run ontape -a but now when I do that, it is asking me

to

mount a tape, and hit continue, and of course, I just want them to write to



disk.



I have LTAPEDEV set in onconfig file to a path.



What am I missing here in my logic?



















* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40275]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Backing up Logs
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Thu, 23 Nov 2017 15:09:40 EST
I haven't set up automatic backups of my logs yet, so while doing all this

troubleshooting, they have filled.



In the past, I have run ontape -a but now when I do that, it is asking me to

mount a tape, and hit continue, and of course, I just want them to write to

disk.



I have LTAPEDEV set in onconfig file to a path.



What am I missing here in my logic?









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40274]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: HDR Question
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Thu, 23 Nov 2017 15:07:37 EST
Back in business. Did a reboot and it must have freed up the port. Now back to

trying to get HDR going.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40273]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: HDR Question
Posted by: david@smooth1.co.uk (david@smooth1.co.uk) - Thu, 23 Nov 2017 14:00:34 EST
Your local admins need to advise why Informix canot bind to the port.



Regards,

David.



> On 23 November 2017 at 18:47 BENJI LONG <ruggedmouse@hotmail.com> wrote:

>

>

> lsof doesn't work on this server.

>

> I never touched any of these things, however, my instance v11.5 works

> perfectly. My unix admins told me there wasn't a local firewall and the two

> servers are on the same subnet or something like that so they don't hit any

> physical firewalls

>

>

>



>

>









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40272]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: HDR Question
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Thu, 23 Nov 2017 13:47:05 EST
lsof doesn't work on this server.



I never touched any of these things, however, my instance v11.5 works

perfectly. My unix admins told me there wasn't a local firewall and the two

servers are on the same subnet or something like that so they don't hit any

physical firewalls









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40271]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: HDR Question
Posted by: david@smooth1.co.uk (david@smooth1.co.uk) - Thu, 23 Nov 2017 13:46:07 EST
- Open firewall port



sudo firewall-cmd --zone=public --add-port=1211/tcp --permanent



sudo firewall-cmd --reload



- Disable SELinux



Edit /etc/selinux/config



Set to disabled, comments explain how!



Regards,

David.



> On 23 November 2017 at 18:37 Clive Eisen <clive@serendipita.com> wrote:

>

>

> > On 23 Nov 2017, at 17:49, BENJI LONG <ruggedmouse@hotmail.com> wrote:

> >

> > It is Red Hat Enterprise Linux 7.1

> >

> 1) Have you disabled firewalld or at least opened the port?

>

> 2) Have you disabled SELinux?

>

> Clive

>

>

>



>

>









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40270]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: HDR Question
Posted by: clive@serendipita.com (Clive Eisen) - Thu, 23 Nov 2017 13:37:27 EST
> On 23 Nov 2017, at 17:49, BENJI LONG <ruggedmouse@hotmail.com> wrote:

>

> It is Red Hat Enterprise Linux 7.1

>

1) Have you disabled firewalld or at least opened the port?



2) Have you disabled SELinux?



Clive









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40269]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RE: storesdemo
Posted by: david@smooth1.co.uk (david@smooth1.co.uk) - Thu, 23 Nov 2017 13:16:20 EST
NO! NO! NO! Dangerous advice!



echo "DROP DATABASE victim;" | dbaccess sysmaster@myinstance



Never rely on $INFORMIXSERVER pointing to the right server when dropping

databases unless in a play environment e.g personal laptop vm!



PS Had to check the sysdbopen could not make you switch databases before I

wrote this!



Regards,

David.



> On 15 November 2017 at 18:37 Jonathan Leffler <jonathan.leffler@gmail.com>

wrote:

>

>

> If the database won't drop via the menu, drop it via the SQL command

> language.

>

> Make sure you have no database selected, or some other database than the

> one you're trying to drop selected.

>

> DROP DATABASE victim;

>

> That should drop it. Or, if you like shell hacks, then:

>

> dbaccess - - <<'EOF'

> DROP DATABASE victim;

> EOF

>

> If you have the database as the current database when you try to drop it,

> it may fail to drop. I'd be willing to accept an argument that such

> behaviour is a bug; DB-Access should note that it is trying to drop a

> database that is currently open and close the current database before

> dropping it.

>

> On Wed, Nov 15, 2017 at 10:24 AM, BENJI LONG <ruggedmouse@hotmail.com>

> wrote:

>

> > Hi, for some reason, it will not drop.

> > I typed dbaccess and then database>Select>highlighted the database

name>hit

> > enter, and highlight Drop, hit enter, and it asks me for confirmation. I

> > choose y and hit enter, and it doesn't do anything.

> >

> >

> > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

> > * * * * * * * * * * * * * * * * ***

> >

> >

> >

>

> --

> Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>

> Guardian of DBD::Informix - v2015.1101 - http://dbi.perl.org

> "Blessed are we who can laugh at ourselves, for we shall never cease to be

> amused."

>

>

>



>

>









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40268]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RE: RE: HDR Question
Posted by: david@smooth1.co.uk (david@smooth1.co.uk) - Thu, 23 Nov 2017 13:07:59 EST
Try



lsof -P -i4 -i6 | grep 1112



Otherwise there should be an oserr or ISAM error where it cannot bind to the

port.



Regards,

David.



> On 23 November 2017 at 17:49 BENJI LONG <ruggedmouse@hotmail.com> wrote:

>

>

> It is Red Hat Enterprise Linux 7.1

>

> I can't copy and paste. Using vCenter client.

>

> unable to bind to the port 1112

> there are about 12 lines of information in between here

>

> listener-thread@tcp_be.c:309: err=-930: oserr=0:

>

>

>



>

>









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40267]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: HDR Question
Posted by: david@smooth1.co.uk (david@smooth1.co.uk) - Thu, 23 Nov 2017 12:53:39 EST
All,



I do wish people would stop saying /etc/hosts and /etc/services, it is not the

early 90's!



I prefer "your hostname resolution service" and "your servicename resolution

service".



The file /etc/nsswitch.conf shows how hostnames and services are resolved:



grep hosts /etc/nsswitch.conf

#hosts: db files nisplus nis dns

hosts: files dns myhostname



grep services /etc/nsswitch.conf

# sorted with the most-used services at the beginning.

#services: nisplus [NOTFOUND=return] files

services: files sss



man nsswitch.conf



Be aware that in Version 11.70 and higher by default Informix will cache hosts

and services information so changes may not show up immediately.



NS_CACHE host=900,service=900,user=900,group=900





https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.adref.doc/ids_adr_1105.htm



Any NS_CACHE field can be temporarily set to 0 to flush the cache:





https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.adref.doc/ids_adr_0439.htm



Regards,

David.



Regards,

David.



> On 23 November 2017 at 15:56 Marcus Haarmann <marcus.haarmann@midoco.de>

wrote:

>

>

> Ok, just some steps/checks:

>

> 1) preparation of the sqlhosts file is needed

> - you need to have minimum one entry for the primary instance, and one entry

> for the secondary instance.

> We keep the file identical on both hosts

> The lines should be like:

> prim onipcshm localhost localhost

> prim_tcp onsoctcp <IP or hostname> <PortNr or Servicename>

> sec onipcshm localhost localhost

> sec_tcp onsoctcp <IP or hostname> <PortNr or Servicename>

>

> In case you use a hostname, check with ping if the hostname is resolvable.

> You might use an IP address instead.

> It should not be localhost or 127.0.0.1

>

> In case you use a servicename instead of a portnumber, check the

/etc/services

> file for a correct mapping

> e.g. informix 1596/tcp

>

> If you do not use a servicename, put only the portnumber (not the trailing

> /tcp as in the services file)

>

> 2) check if the primary server is available with dbaccess locally, while

> INFORMIXSERVER env is set prim_tcp

> 3) check your machine trust, this is in a configurable file named in

onconfig

> with REMOTE_SERVER_CFG setting

>

>

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/ids_admin_1407.htm

> You should have there a trust on both sides for the other server (prim

trusts

> sec and vice versa)

> 4) check if the primary server is available with dbaccess from the secondary

> machine, INFORMIXSERVER again prim_tcp

> You should be able to connect without giving a password

> 5) set the primary instance in master mode using onmode -d primary sec_tcp

> 6) Now you are reade to start the secondary by a physical restore (ontape -p

> or the equivalent onbar mechanism) and at the end

> onmode -d secondary prim_tcp

>

> Look at the online.log of the primary. It should state something about

> "secondary connected".

> The primary will then start to send the logs which have been used since

backup

> time and inform you

> about success with "primary server operational". In the secondary log, you

> will have the opposite info "secondary server operational".

>

> This is it (normally). Things like how role change is done or setting up an

> automatic failover have to be learned late on.

>

> Marcus Haarmann

>

> Von: "BENJI LONG" <ruggedmouse@hotmail.com>

> An: "ids" <ids@iiug.org>

> Gesendet: Donnerstag, 23. November 2017 16:34:40

> Betreff: Re: RE: RE: HDR Question [40260]

>

> found something else out.

> One way, I'm getting error 908, and the other way I'm getting error 930.

>

> The 930 error is saying it cannot connect to the server name which is in the

> sqlhosts file

>

> The 908 error is saying the attempt to connect to the server failed but it

> isnt' giving me the name from the sqlhosts file. I'm not sure what it is

> giving me. It looks like it is the SERVERALIAS I have in the onconfig file.

>

>

>



>

>

>

>



>

>









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40266]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RE: RE: HDR Question
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Thu, 23 Nov 2017 12:49:12 EST
It is Red Hat Enterprise Linux 7.1



I can't copy and paste. Using vCenter client.



unable to bind to the port 1112

there are about 12 lines of information in between here



listener-thread@tcp_be.c:309: err=-930: oserr=0:









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40265]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RE: RE: HDR Question
Posted by: david@smooth1.co.uk (david@smooth1.co.uk) - Thu, 23 Nov 2017 12:39:42 EST
Which OS is this on?



What is the full error?



Regards,

David.



> On 23 November 2017 at 17:34 BENJI LONG <ruggedmouse@hotmail.com> wrote:

>

>

> in online.log, I see unable to bind to the port (1112) on the host.

>

> I ran netstat -na | grep 1112, and nothing returned.

>

> also onstat -g ntt. I need to look this command up after lunch but on this

> server, I don't se anything listed at the bottom where it says soctcplst

>

> On my secondary server, if I run onstat -g ntt, beside soctcplst, it shows

> port 1113, so I assume this is correct.

>

>

>



>

>









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40264]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RE: RE: HDR Question
Posted by: ruggedmouse@hotmail.com (BENJI LONG) - Thu, 23 Nov 2017 12:34:25 EST
in online.log, I see unable to bind to the port (1112) on the host.



I ran netstat -na | grep 1112, and nothing returned.



also onstat -g ntt. I need to look this command up after lunch but on this

server, I don't se anything listed at the bottom where it says soctcplst



On my secondary server, if I run onstat -g ntt, beside soctcplst, it shows

port 1113, so I assume this is correct.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40263]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

in online.log, I see unable to bind to the port (1112) on the host.



I ran netstat -na | grep 1112, and nothing returned.



also onstat -g ntt. I need to look this command up after lunch but on this

server, I don't se anything listed at the bottom where it says soctcplst



On my secondary server, if I run onstat -g ntt, beside soctcplst, it shows

port 1113, so I assume this is correct.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [40263]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 
Subscribe to this feed
You can subscribe to this RSS feed in a number of ways, including the following:

Drag the orange RSS button into your News Reader

Drag the URL of the RSS feed into your News Reader

Cut and paste the URL of the RSS feed into your News Reader v