Can you setup an ODBC datasource that will use a remote node?
For example, in my ODBC datasource definition, the Server specified would point to SYST1900 (which is our 19.0 Prod ‘A’ CV), but the dictname specified would not be in the dbname table of the SYST1900 CV, but would be a dbname in the Resource Name Table pointing to node SYST1901 (our 19.0 Prod ‘B’ CV). On that Prod ‘B’ CV would be the dbname specified (in this case TSTDICT).
I tried this and received:
DBname TSTSDICT is an unknown DBNAME or SEGMENT. Which is true on the frontend CV.
Release : 19.0
Component : CA IDMS Server