Pointing a Data Dictionary to Multiple SQL Gateway

, , , , ,
1

Does anybody know the synctax to configure a data dictionary to talk to multiple SQL Gateway (ACE) on the mainframe?

I know how to specify the ip and port of both Gateway:

ip_machine_1:port1!ip_machine_2:port2 but how do I specify the distrbute property? Do I append the !Distribute to the last port number in the series? Is the separation character an “!”?

Many thanks,
Min

2

Yes and Yes; the syntax is:

server-name:port!server-name:port!distribute

Note that you can also use this syntax in the connect string to connect to multiple JDBC servers as well.