Problem: I need to register a INFORMIX data source and I can not. I enter the parameters, but there is always an error. What should I do?
You need to use a DRDA link to the instance, and apparently the data you are putting does not belong to one.
In order to confirm that a DRDA link exists, you can run the following query:
SELECT
dbsvrnm,
hostname,
svcname
FROM
sysmaster:syssqlhosts
WHERE
svrtype = 'dr';
After confirming that dbsvrnm
is part of the instance alias, you can execute the following query:
SELECT cf_effective
FROM sysmaster:syscfgtab
WHERE cf_name = 'DBSERVERALIASES';
Not having set up you have to follow the steps in manual .