communication

IBM i Communication & Network Services

Monitor and analyze network and communication resources on IBM i using SQL services from QSYS2.

Available Tools

The ibmi CLI is the primary tool for executing network queries. Set SKILL_DIR to this skill's installed location (the directory containing this SKILL.md file):

# SKILL_DIR = directory containing this SKILL.md
# Examples: ./skills/communication, ~/.claude/skills/communication

ibmi tools --tools "$SKILL_DIR/tools/" --toolset communication_default
ibmi tool get_netstat_info --tools "$SKILL_DIR/tools/"
ibmi sql "SELECT * FROM QSYS2.NETSTAT_INFO WHERE TCP_STATE = 'ESTABLISHED' FETCH FIRST 20 ROWS ONLY"

Service Selection Guide

Network Connections

• QSYS2.NETSTAT_INFO — Active connections with bytes, addresses, ports, state
• QSYS2.NETSTAT_JOB_INFO — Network jobs associated with connections
• QSYS2.NETSTAT_INTERFACE_INFO — Network interface configuration and status
• QSYS2.NETSTAT_ROUTE_INFO — TCP/IP routing table

Server & Configuration

• QSYS2.HTTP_SERVER_INFO — HTTP server instances, ports, and status
• QSYS2.TCPIP_INFO — TCP/IP stack configuration (hostname, DNS, version)
• QSYS2.NETWORK_ATTRIBUTE_INFO — System-level network attributes
• QSYS2.TIME_PROTOCOL_INFO — NTP/SNTP server configuration and sync status

Key Capabilities

Network Monitoring

• List active connections sorted by traffic volume
• Identify busiest remote addresses and ports
• Monitor connection states (ESTABLISHED, LISTEN, etc.)
• Track bytes sent and received per connection

Interface & Routing

• View all network interfaces with IP addresses and status
• Check subnet masks, MTU, and line descriptions
• Review routing table entries and precedence
• Identify active vs inactive interfaces

Server Management

• List HTTP server instances with status and ports
• Check autostart configuration
• View server root directories and descriptions

Configuration Review

• Retrieve hostname, domain, and DNS settings
• Check network authentication parameters
• Verify NTP/SNTP time synchronization status

Common Use Cases

1. Connection Analysis

Identify active network connections and top bandwidth consumers

2. Network Troubleshooting

Check interface status, routing, and connection states

3. HTTP Server Monitoring

Verify web server status and port assignments

4. DNS & Network Config

Review TCP/IP settings, hostname, and DNS configuration

5. Time Sync Verification

Check NTP/SNTP server connectivity and synchronization

6. Security Audit

Identify unexpected remote connections or open ports

CL Command Migration

CL Command	SQL Service
NETSTAT	NETSTAT_INFO + NETSTAT_INTERFACE_INFO
WRKTCPSTS	NETSTAT_INFO + NETSTAT_JOB_INFO
CFGTCP (display)	NETWORK_ATTRIBUTE_INFO + TCPIP_INFO
WRKHTTPSRVR	HTTP_SERVER_INFO

Quick Examples

List established connections

SELECT REMOTE_ADDRESS, REMOTE_PORT, LOCAL_PORT, BIND_USER,
       BYTES_SENT_REMOTELY, BYTES_RECEIVED_LOCALLY
  FROM QSYS2.NETSTAT_INFO
  WHERE TCP_STATE = 'ESTABLISHED'
  ORDER BY BYTES_SENT_REMOTELY DESC
  FETCH FIRST 20 ROWS ONLY;

Check network interfaces

SELECT INTERNET_ADDRESS, LINE_DESCRIPTION, INTERFACE_STATUS
  FROM QSYS2.NETSTAT_INTERFACE_INFO
  ORDER BY INTERFACE_STATUS;

View HTTP servers

QSYS2.HTTP_SERVER_INFO is a performance-stats view — it returns per-server activity, not configuration.

SELECT SERVER_NAME, JOB_NAME, SERVER_ACTIVE_THREADS,
       SERVER_TOTAL_REQUESTS, BYTES_SENT, BYTES_RECEIVED
  FROM QSYS2.HTTP_SERVER_INFO
  ORDER BY SERVER_NAME;

Pre-built Tools

The tools/communication.yaml file provides 11 ready-to-use tools:

Tool	Description
get_netstat_info	Active network connections with traffic
get_netstat_interface_info	Network interfaces and IP addresses
get_netstat_job_info	Network jobs and their connections
get_netstat_route_info	TCP/IP routing table
get_http_server_info	HTTP server instances and per-server request stats
get_tcpip_info	TCP/IP stack configuration
get_network_attribute_info	System network attributes
get_time_protocol_info	NTP/SNTP time server status
list_active_db_connections	Active DRDA/DDM database connections
get_rdb_entry_info	Relational database directory entries
dns_lookup	Resolve a hostname to IPv4/IPv6 addresses from the IBM i

ibmi tool <tool_name> --tools "$SKILL_DIR/tools/"          # Execute
ibmi tool <tool_name> --tools "$SKILL_DIR/tools/" --dry-run # Preview SQL
ibmi tools show <tool_name> --tools "$SKILL_DIR/tools/"     # View details

Reference Documentation

• Communication Services Catalog — All COMMUNICATION services
• Communication Examples — Working SQL examples
• IBM i Services - Communication — IBM documentation