471,084 Members | 820 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

HADR and Federation

Using DB2 v9.1 fixpak 2 (WSE with HADR feature) on Windows 2003 Servers

We are trying to set up HADR for two production databases. The two primary databases reside on two different servers. We would like to put the two standby databases on the same server. One of the databases (we will call it NICKNM) has tables federated from the other database (we will call it OTHER). I was able to set up HADR for these two databases so that the standbys are both on the same server. Everything seems to work fine when both the original primaries are used, or when both of the standbys are used. Everything also seems to work okay if NICKNM is still the primary and OTHER fails over to the standby database. However, if OTHER is the original primary, and NICKNM fails over to the standby, the federated tables cannot be used. I receive the following error...

SQL1822N Unexpected error code " " received from data source "INFO_MREC". Associated text and tokens are "func="DriverConnect" msg=" SQL1776N The command canno". SQLSTATE=560BD

I am assuming that this is because NICKNM on the standby server is now the primary and since there is federation with OTHER, which has a standby copy of the server where NICKNM is now the primary, the federation is trying to use the local copy rather than the current primary. Since the local copy is in standby, I receive the error.

Has anyone else experienced this issue? Can I have multiple standby databases on the same server? If yes, can they have federation between each other?

May 9 '07 #1
0 1859

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

14 posts views Thread by spencer | last post: by
3 posts views Thread by bwmiller16 | last post: by
7 posts views Thread by Mark A | last post: by
4 posts views Thread by Joachim Klassen | last post: by
16 posts views Thread by gumby | last post: by
6 posts views Thread by RayRay | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.