Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / June 2006

Tip: Looking for answers? Try searching our database.

HDR problem with Windows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ben Thompson - 28 Jun 2006 15:44 GMT
Hi, I wonder if anyone could help. We're having a problem with HDR with
two identical machines running Windows 2003 and IDS 10.00.TC3. We cannot
get these machines to replicate. I have an open case with OpenPSL for
some weeks who have escalated it to IBM and I am hoping I will get a
solution by that route, but the customer and us are now desperate for a
solution.

Here is the log from the primary server showing a level 0 archive being
taken, this is restored on the secondary and replication initiated.

16:09:24  Level 0 Archive started on rootdbs, maindbs, physdbs, logsdbs,
rawdbs, mediadbs, sbspace
16:11:09  Archive on rootdbs, maindbs, physdbs, logsdbs, rawdbs,
mediadbs, sbspace Completed.
16:19:45  Checkpoint Completed:  duration was 2 seconds.
16:19:45  Checkpoint loguniq 1117, logpos 0xa5e018, timestamp: 0x6f30165c

16:19:45  Maximum server connections 21
16:29:45  Checkpoint Completed:  duration was 0 seconds.
16:29:45  Checkpoint loguniq 1117, logpos 0xb35018, timestamp: 0x6f306186

16:29:45  Maximum server connections 21
16:39:45  Checkpoint Completed:  duration was 0 seconds.
16:39:45  Checkpoint loguniq 1117, logpos 0xc0a018, timestamp: 0x6f30ac85

16:39:45  Maximum server connections 21
16:49:45  Checkpoint Completed:  duration was 0 seconds.
16:49:45  Checkpoint loguniq 1117, logpos 0xcdd018, timestamp: 0x6f30f6e0

16:49:45  Maximum server connections 21
16:58:30  (53) Unable to initiate asynchronous read operation
16:58:30  DR: Cannot connect to secondary server
16:58:30  DR: Turned off on primary server

The secondary's log isn't that interesting. We just get:

16:58:26  DR: Reservation of the last logical log for log backup turned off
16:58:26  DR: new type = secondary, primary server name = ol_server1
16:58:27  DR: Trying to connect to primary server = ol_server1

I think the important part is the "(53) Unable to initiate asynchronous
read operation". We ought to be "experts" at setting up HDR by now as
we've been doing it for years on several platforms for a lot of
customers and have never seen this message. The sequence of events is as
follows:

On primary: run "onmode -d standard", perform level 0 backup with
"ontape -s -L 0".
On secondary: restore tape using "ontape -p", don't restore level 1
archive. Issue command: "onmode -d secondary ol_server1"
On primary: issue command "onmode -d primary ol_server2". It is shortly
after this that the asychronous read operation fails.

Any ideas? I can supply onconfig, "onstat -a", "onstat -g all" and
environment details from registry and ol_server1.cmd file - all of these
are with IBM. At the moment I have nothing to go on and my only option
is to upgrade to 10.00.TC4 which is disruptive for the customer.

Many thanks in advance, Ben.
Guy Bowerman - 28 Jun 2006 17:44 GMT
Hi Ben,
I think the 53 error is being returned from the OS. Windows error 53 is
"The network path was not found". Is as far as you know connectivity
good between the machines (connect via dbaccess from one to the other etc)?

Out of curiosity, what is the root dbspace location on each machine?

Guy

> Hi, I wonder if anyone could help. We're having a problem with HDR with
> two identical machines running Windows 2003 and IDS 10.00.TC3. We cannot
[quoted text clipped - 55 lines]
>
> Many thanks in advance, Ben.
Ben Thompson - 29 Jun 2006 15:38 GMT
> I think the 53 error is being returned from the OS. Windows error 53 is
> "The network path was not found". Is as far as you know connectivity
> good between the machines (connect via dbaccess from one to the other etc)?

Just to add that I think this is a red herring. I have seen other
numbers such as 26 or 28 before the asynchronous read operation error.

Ben.
Alexey Sonkin - 28 Jun 2006 22:56 GMT
Hi, Ben,

Please, check the fillowing:
- Are you able to connect from 'informix' windows session
on Secondary machine to Primary database server without password?
With password? From Primary to Secondary?
- Did you create the hosts.equiv file under
C:\winnt\system32\drivers\etc
on both machines (file format should be same, as on UNIX)?

-Alexey


> -----Original Message-----
> From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]
> On Behalf Of Ben Thompson
> Sent: Wednesday, June 28, 2006 10:45 AM
[quoted text clipped - 64 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
Alexey Sonkin - 29 Jun 2006 19:41 GMT
Ben,

Don't you see something strange on one of machines,
like an abrupt increase of CPU usage?
Are there some strange messages in Windows system
and application logs (in 'Event viewer')?
Is Firewall started on Windows?
Is IPV6 started?

For safety, try to configure al least two CPU VP's on each
machine and move NETTYPE to NET VP

-Alexey


> -----Original Message-----
> From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]
> On Behalf Of Ben Thompson
> Sent: Thursday, June 29, 2006 12:15 PM
[quoted text clipped - 6 lines]
> >
> > You've moved the root dbspace to D:\IFMXDATA\ol_server1 on
ol_server2 as
> > well right?
>
> Yes, the directory name is the same on both servers. That is to say
> server2 has a ol_server1 directory and the files in exactly the same
> location. If it didn't I don't think the archive would restore
correctly.

> >  > NUMAIOVPS    4          # Number of IO vps
> >
> > Not relevant to your problem, but this seems a bit high on Windows
which
> > uses KAIO unless you're doing lots of sqexplain type logging.
>
> It's mostly there for things like that and the online log. I'm told
AIO
> VPs don't consume many resources simply by being there. 1 or 2 would
> probably be enough for most of the time I agree.
[quoted text clipped - 4 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.