IDS 11.5 HADR Parameters tuning
Posted in 2009
Topics: High Availability & Replication, Performance & Tuning, Logging & Checkpoints, Networking & sqlhosts Configuration
Dear All,
I have setup HADR on IDS 11.5 on HPUnix. The secondary server is in a remote
location, every other day the network trips and secondary server goes offline.
Below entries are notice in online.log of secondary server -
23:08:52 DR: Receive error
23:08:52 ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = : Networ
k connection is broken.
System error = 4.
23:08:52 DR_ERR set to -1
23:08:52 DR: Turned off on secondary server
23:10:21 DR: Secondary server connected
23:12:08 DR: Receive error
23:12:08 ASF Echo-Thread Server: asfcode = -25582: oserr = 0: errstr = : Networ
k connection is broken.
23:12:08 DR_ERR set to -1
23:12:08 IBM Informix Dynamic Server Stopped.
Below entries are noticed in online.log on Primary server -
23:08:51 DR: ping timeout
23:08:51 DR: Receive error
23:08:51 ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = :
Network connection is br
oken.
System error = 4.
23:08:51 DR_ERR set to -1
23:08:52 DR: Turned off on primary server
23:08:52 DR: Cannot connect to secondary server
23:12:08 DR: Cannot connect to secondary server
23:12:08 DR: Turned off on primary server
23:13:44 Logical Log 19166 Complete, timestamp: 0xf39b05c3.
23:46:30 DR: Cannot connect to secondary server
My HADR parameters are set to -
DRAUTO 0
DRINTERVAL -1
DRTIMEOUT 30
Please advise.
Regards,
Lloyd
Sounds like a job for an RSS server.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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, Aug 11, 2009 at 6:58 AM, LloydS <lloyd_s@rediffmail.com> wrote:
> Dear All,
>
> I have setup HADR on IDS 11.5 on HPUnix. The secondary server is in a
> remote
> location, every other day the network trips and secondary server goes
> offline.
> Below entries are notice in online.log of secondary server -
>
> 23:08:52 DR: Receive error
> 23:08:52 ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = :
> Networ
> k connection is broken.
> System error = 4.
> 23:08:52 DR_ERR set to -1
> 23:08:52 DR: Turned off on secondary server
> 23:10:21 DR: Secondary server connected
> 23:12:08 DR: Receive error
> 23:12:08 ASF Echo-Thread Server: asfcode = -25582: oserr = 0: errstr = :
> Networ
> k connection is broken.
>
> 23:12:08 DR_ERR set to -1
> 23:12:08 IBM Informix Dynamic Server Stopped.
>
> Below entries are noticed in online.log on Primary server -
>
> 23:08:51 DR: ping timeout
> 23:08:51 DR: Receive error
> 23:08:51 ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = :
> Network connection is br
> oken.
> System error = 4.
> 23:08:51 DR_ERR set to -1
> 23:08:52 DR: Turned off on primary server
> 23:08:52 DR: Cannot connect to secondary server
> 23:12:08 DR: Cannot connect to secondary server
> 23:12:08 DR: Turned off on primary server
> 23:13:44 Logical Log 19166 Complete, timestamp: 0xf39b05c3.
> 23:46:30 DR: Cannot connect to secondary server
>
> My HADR parameters are set to -
>
> DRAUTO 0
> DRINTERVAL -1
> DRTIMEOUT 30>
> Please advise.
>
> Regards,
> Lloyd
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c923d75059c80470dfee25
Related threads
- System Or Internal Error InterruptedIOException
- 25582 error on high volume of short live trans
- ASF Echo-Thread Server: asfcode = -25582 oserr = 4