performance

Collect and analyze IBM i performance metrics via SQL services.

3|1|Updated Feb 3, 2026
One-click install
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill performance-ajshedivy
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: performance
Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/performance
Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill performance-ajshedivy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i performance data is scattered across multiple collections and views, making it challenging for operators to quickly assess system health and spot bottlenecks.

Core Features & Use Cases

  • Consolidated visibility into Collection Services configuration, temporary storage usage, disk I/O statistics, and memory pool performance via IBM i SQL services.
  • Ideal for capacity planning, troubleshooting storage growth, and identifying hot spots in I/O and memory pressure.
  • Example: a sysadmin reviews current collection intervals and per-job temp storage to forecast capacity and adjust monitoring settings.

Quick Start

Retrieve and view performance metrics using the built-in ibmi CLI tools to fetch current configuration, storage usage, and disk I/O stats.

Frequently Asked Questions about performance

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

FAQPage Schema
How do I monitor IBM i performance metrics for troubleshooting system health?

Monitor IBM i performance metrics by retrieving data from QSYS2 SQL services like COLLECTION_SERVICES_INFO and SYSTMPSTG. This consolidates visibility into temporary storage usage, disk I/O statistics, and memory pool performance to help operators spot bottlenecks.

What is the best way to check temporary storage usage by jobs on IBM i?

Check temporary storage usage by querying the SYSTMPSTG SQL service. This approach provides consolidated visibility into per-job storage consumption, making it ideal for troubleshooting unexpected storage growth on IBM i systems.

Can I view disk I/O statistics and memory pool performance using IBM i SQL services?

View disk I/O statistics and memory pool performance by querying SYSDISKSTAT and MEMORY_POOL SQL services. These views provide tool wrappers to filter and report metrics, identifying hot spots in I/O and memory pressure.

How do I retrieve current Collection Services configuration for capacity planning on IBM i?

Retrieve current Collection Services configuration by querying QSYS2.COLLECTION_SERVICES_INFO. Operators can review collection intervals to forecast capacity needs and adjust monitoring settings for ongoing system performance tracking.

Does this performance monitoring approach require any external dependencies?

This performance monitoring approach requires no external dependencies. It relies entirely on built-in IBM i SQL services and ibmi-cli tools to fetch current configuration, storage usage, and disk I/O stats.