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:
with GDIHQ1 simply an alias for GDIHQ
Relational database . . . . . . : GDIHQ
Relational database alias . . : GDIHQ1
The other machine looks like this:
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
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?