skills.rest
ajshedivy
ajshedivyCOMMUNITY
Explore all skills by this author →
GitHub

communication

Monitor IBM i network resources via SQL-based QSYS2 views.

3|1|Updated Feb 3, 2026
Search Tags:#sql#network#dns#http-server#ibmi#tcpip#netstat
One-click install
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill communication-ajshedivy
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: communication
Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/communication
Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill communication-ajshedivy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i administrators need a unified way to monitor and analyze network and communication resources (TCP/IP, interfaces, routing, HTTP servers, DNS) via SQL services to troubleshoot connectivity, performance, and configuration.

Core Features & Use Cases

  • Monitor active TCP/IP connections and traffic using QSYS2.NETSTAT_INFO
  • Inspect interfaces, routing, HTTP server status, and TCP/IP configuration
  • Validate DNS and time protocol settings, and review system network attributes
  • Use pre-built tools (NETSTAT_INFO, NETSTAT_INTERFACE_INFO, NETSTAT_ROUTE_INFO, HTTP_SERVER_INFO, TCPIP_INFO, TIME_PROTOCOL_INFO, etc.) for common tasks

Quick Start

Run a quick network health check by listing active connections, interfaces, routing, and HTTP server status using the ibmi CLI tools.

Frequently Asked Questions about communication

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I monitor active TCP/IP connections on IBM i using SQL?▼

Monitor active TCP/IP connections on IBM i by querying the QSYS2.NETSTAT_INFO view to surface connection status, traffic, and protocol details using read-only SQL statements.

What's the best way to audit IBM i network interfaces and routing tables via SQL services?▼

Audit IBM i network interfaces and routing tables by running pre-built SQL tool queries against QSYS2 views like NETSTAT_INTERFACE_INFO and NETSTAT_ROUTE_INFO to validate configuration and diagnose routing issues.

How do I check HTTP server status and configuration on IBM i with SQL?▼

Check HTTP server status and configuration on IBM i by querying the HTTP_SERVER_INFO view to inspect active server instances and validate their operational settings using SQL services.

Does this SQL approach require special permissions to view DNS and time protocol settings on IBM i?▼

Viewing DNS and time protocol settings requires access to IBM i SQL services and read-only QSYS2 views like TCPIP_INFO and TIME_PROTOCOL_INFO, which surface system configuration without needing command-line access.

Can I diagnose IBM i TCP/IP connectivity issues without using the NETSTAT command line?▼

Diagnose IBM i TCP/IP connectivity issues without the command line by running read-only SQL queries against QSYS2 views to inspect network attributes, routing, and active connections for troubleshooting.

Why use SQL services instead of native IBM i commands for network monitoring?▼

SQL services provide a unified way to monitor IBM i network resources by querying QSYS2 views, allowing you to audit active connections, validate DNS settings, and inspect HTTP servers within a single SQL interface.

Related Skills

Explore More Software Engineering Skills→
ajshedivyajshedivy
3

system-health

Monitor IBM i CPU, memory, disk, ASP, and network metrics via QSYS2 views.

Community
Intermediate
SufficientDaikonSufficientDaikon
8

windows-network-optimizer

Apply PowerShell optimizations to Windows network settings and validate results.

Community
Advanced
ajshedivyajshedivy
3

performance

Collect and analyze IBM i performance metrics via SQL services.

Community
Intermediate
ProfoundLogicProfoundLogic

ibmi-clcmd

Execute IBM i Control Language commands on remote systems via SSH.

Official
Basic