IC SunsetThe developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this community and its apps will no longer be available. More details available on our FAQ.
Topic
  • No replies
robberendt
robberendt
84 Posts

Pinned topic Where does "current server" get it's information?

‏2019-02-08T15:42:57Z |

I am following the standards as shown at Configuring RDB Names for High Availability and External System Access for my HA replication machines.  In my case GDIHQ1 looks like:

WRKRDBDIRE

                    Remote 
Entry               Location
GDIHQ               *LOCAL 
GDIHQ1              GDIHQ1
 

with GDIHQ1 simply an alias for GDIHQ

Relational database  . . . . . . :   GDIHQ
  Relational database alias  . . :   GDIHQ1

The other machine looks like this:

WRKRDBDIRE

                    Remote 
Entry               Location
GDIHQ               *LOCAL 
GDIHQ2              GDIHQ2 

With GDIHQ2 simply an alias for GDIHQ.

Works great.  Users all connect to GDIHQ and get to the machine currently set up as production in our DNS.  If, however, we need to get to a particular machine, for example BRMS and very specific system functions, we connect to that particular machine.  So far, so good.

However, when I execute this statement:

select current server, 1
from gdihq1.sysibm.sysdummy1;

It returns GDIHQ and not GDIHQ1.  I need current server to return the endpoint name, GDIHQ1 instead.

It is not returning the value from DSPNETA.

Does the IBM documentation need to be changed and have the individual system (GDIHQ1 or GDIHQ2) be the *LOCAL entry and have the generic (GDIHQ) be the alias?  Or is there some other register than current server I should be using?