Basic Network Configuration
$INFORMIXDIR/etc/sqlhosts (e.g., myserver onsoctcp 123.456.789.0 1526). This defines how clients connect to the Informix server.onstat -g to check server status and onmode -wf to apply configuration changes. Ensure the network service is running for client connectivity.firewall-cmd --permanent --add-port=1526/tcp --reload (firewalld) or iptables to allow client-server communication.jdbc:informix-sqli://myserver:1526/mydatabase:INFORMIXSERVER). Test with dbaccess mydatabase to verify connectivity.Advanced Network Optimization
/etc/sysctl.conf to improve network throughput. Key settings include:
net.core.rmem_max/net.core.wmem_max: Increase receive/send buffer sizes (e.g., 2000000 bytes) for large data transfers.net.ipv4.tcp_window_scaling: Enable window scaling for high-bandwidth networks.net.ipv4.tcp_syn_retries/net.ipv4.tcp_fin_timeout: Reduce SYN retransmissions (e.g., 3) and FIN timeout (e.g., 30 seconds) to speed up connection handling.ifenslave) to increase bandwidth (up to the sum of individual interfaces) and provide fault tolerance. Configure bonding modes (e.g., mode 0 for round-robin, mode 1 for active-backup) based on your redundancy needs.NETTYPE=SOCTCP,compress=yes in sqlhosts) to reduce data transfer volume for low-bandwidth networks, balancing CPU overhead and bandwidth savings./proc/sys/net/core/wmem_max and /proc/sys/net/core/rmem_max to increase buffer sizes. Enable TCP fast open (net.ipv4.tcp_fastopen=1) to reduce handshake latency. For multi-core systems, enable Receive Side Scaling (RSS) via ethtool -X eth0 equal to distribute network processing across CPU cores, improving throughput.iftop (real-time bandwidth usage), iperf (bandwidth testing), and onstat -g net (Informix network stats) to identify bottlenecks. Regularly analyze logs (e.g., messages, informix.log) to detect recurring network issues (e.g., dropped packets, timeouts).
