zOs/SQL/EXDRDA

select location from sysibm.locations
;
select current server, count(*), max(name)
    from              sysibm.systables
;
select current server, count(*), max(name)
    from chroi00zde0g.sysibm.systables
;
select current server, count(*), max(name)
    from chroi00zdevg.sysibm.systables
;
select current server, count(*), max(name)
    from CHSKA000DP4G.sysibm.systables
;
$#out                                              20160803 14:14:28
LOCATION
CHSKA000DBII
CHSKA000DBOF
CHSKA000DP2G
CHSKA000DVBP
GR01A1P
L204AI1
L204AI5
L50A0I5
L568BI1
L6E73I1
L9517I1
LA5B8I1
LC501I1
X6482I1
XB128I1
XB129I1
XB129I2
XB129I3
XB129I4
XC930I1
20 rows fetched: select location from sysibm.locations
COL1         COL2 COL3
CHSKA000DBOL 2194 XXRVSMS
1 rows fetched: select current server, count(*), max(name) from sysibm.sys...
fatal error in WSH: SQLCODE = -950: THE LOCATION NAME SPECIFIED IN THE CONNECT
    STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE
sql = select current server, count(*), max(name)                             ...
stmt = prepare s49 into :M.SQL.49.D from :src
with into :M.SQL.49.D = M.SQL.49.D
sqlCode 0: rollback
$#out                                              20160803 14:14:02
LOCATION
IDAA7001
1 rows fetched: select location from sysibm.locations
COL1         COL2 COL3
CHSKA000DP4G 4476 XXRTSUB
1 rows fetched: select current server, count(*), max(name) from sysibm.sys...
fatal error in WSH: SQLCODE = -950: THE LOCATION NAME SPECIFIED IN THE CONNECT
    STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE
sql = select current server, count(*), max(name)                             ...
stmt = prepare s49 into :M.SQL.49.D from :src
with into :M.SQL.49.D = M.SQL.49.D
sqlCode 0: rollback
$#out                                              20160803 14:13:51
LOCATION
IDAA7001
1 rows fetched: select location from sysibm.locations
COL1         COL2 COL3
CHSKA000DP4G 4476 XXRTSUB
1 rows fetched: select current server, count(*), max(name) from sysibm.sys...
fatal error in WSH: SQLCODE = -950: THE LOCATION NAME SPECIFIED IN THE CONNECT
    STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE
sql = select current server, count(*), max(name)                             ...
stmt = prepare s49 into :M.SQL.49.D from :src
with into :M.SQL.49.D = M.SQL.49.D
sqlCode 0: rollback
$#out                                              20160729 12:58:04
LOCATION
CHROI00ZDE0G
CHROI00ZDEVG
2 rows fetched: select location from sysibm.locations
COL1          COL2 COL3
CHROI00ZDE0G 21296 YBWAHDUTDG031
1 rows fetched: select current server, count(*), max(name) from sysibm.sys...
COL1          COL2 COL3
CHROI00ZDE0G 21296 YBWAHDUTDG031
1 rows fetched: select current server, count(*), max(name) from chroi00zde...
COL1          COL2 COL3
CHROI00ZDEVG 10457 XSRPROPERTY
1 rows fetched: select current server, count(*), max(name) from chroi00zde...
fatal error in WST: SQLCODE = -950: THE LOCATION NAME SPECIFIED IN THE CONNECT
    STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE
sql = select current server, count(*), max(name)                             ...
stmt = prepare s49 into :M.SQL.49.D from :src
with into :M.SQL.49.D = M.SQL.49.D
sqlCode 0: rollback
from RZZ Z24 DE0G
$#out                                              20160729 12:57:46
LOCATION
IDAA7001
1 rows fetched: select location from sysibm.locations
COL1         COL2 COL3
CHSKA000DP4G 4512 XXRTSUB
1 rows fetched: select current server, count(*), max(name) from sysibm.sys...
fatal error in WST: SQLCODE = -950: THE LOCATION NAME SPECIFIED IN THE CONNECT
    STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE
sql = select current server, count(*), max(name)                             ...
stmt = prepare s49 into :M.SQL.49.D from :src
with into :M.SQL.49.D = M.SQL.49.D
sqlCode 0: rollback
$#out