SAP Note 14034 - SQL error "INF-908: Attempt to connect...failed."

Component : Database Administration with Informix -

Solution : https://service.sap.com/sap/support/notes/14034 (SAP Service marketplace login required)

Summary :
The SAP Note describes an issue where connectivity to the database via the network ('remote connect') fails. Symptoms include termination of the R/3 System with the error "R3trans test connect to the database failed, Return code: 12" and similar errors found in R3trans logs. These issues arise when the IP address and port number combinations between the client and server do not match. To resolve this, synchronize IP addresses and port numbers on both client and server. Configuration steps involve modifying files like INFORMIXSQLHOSTS, /etc/hosts, and /etc/services to ensure correct mapping, and verifying unique host and service names.

Key words :
dbhost01c11shm   onipcshm  dbhost01   sapinfc11dbhost01c11tcp   onsoctcp  dbhost01   sapinfc11dbhost02c11tcp   onsoctcp   dbhost02   sapinfc11, dbhost01c11tcp   onsoctcp   dbhost01   sapinfc11, sql error -908 performing con log, additional key words startsap, informixserver   = dbhost01c11tcpinformixsqlhosts = /informix/c11/, entered log type, file /informix/c11/, r3trans test connect, database failedreturn code, dbservername      dbhost01c11shmdbserveraliases    dbhost01c11tcp

Related Notes :

421026DB MultiConnect with Informix as a secondary database
85404
44709General info: problems with connect to Informix DB