ajshedivy/performance
skills/performance/SKILL.md
Monitor IBM i performance including collection services, temporary storage, disk I/O metrics, and memory pool performance via SQL services. Use when user asks about: (1) collection services configuration or categories, (2) temporary storage usage by bucket or job, (3) disk I/O performance per unit, (4) memory pool page fault rates, (5) performance data collection settings, (6) replacing WRKSYSSTS performance views, or (7) any performance analysis or capacity planning task.
$ install --global
skillsauthnpx skillsauth add ajshedivy/ibmi-agent-skills performanceInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 25, 2026, 5:34 AM67.0s4 files scanned
SKILL.md
- name:
- performance
- description:
- Monitor IBM i performance including collection services, temporary storage, disk I/O metrics, and memory pool performance via SQL services. Use when user asks about: (1) collection services configuration or categories, (2) temporary storage usage by bucket or job, (3) disk I/O performance per unit, (4) memory pool page fault rates, (5) performance data collection settings, (6) replacing WRKSYSSTS performance views, or (7) any performance analysis or capacity planning task.
IBM i Performance Monitoring
Monitor system performance including collection services configuration, temporary storage usage, disk I/O metrics, and memory pool performance using SQL services from QSYS2.
Available Tools
The ibmi CLI is the primary tool for executing performance 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/performance, ~/.claude/skills/performance
# List all performance tools
ibmi tools --tools "$SKILL_DIR/tools/" --toolset performance_default
# Run a specific tool
ibmi tool get_collection_services_config --tools "$SKILL_DIR/tools/"
# Ad-hoc SQL for custom queries
ibmi sql "SELECT * FROM QSYS2.COLLECTION_SERVICES_INFO"
Service Selection Guide
Collection Services
- QSYS2.COLLECTION_SERVICES_INFO -- Configuration, intervals, retention, categories
Temporary Storage
- QSYS2.SYSTMPSTG -- Temporary storage per bucket and per job
Disk I/O
- QSYS2.SYSDISKSTAT -- Elapsed I/O statistics per disk unit
Memory Performance
- QSYS2.MEMORY_POOL() -- Page faults, thread transitions, tuning settings
Key Capabilities
Collection Services Management
- Configuration -- Active collection, library, profile, intervals
- Categories -- What data categories are collected and at what interval
- Retention -- How long performance data is kept
- Monitoring -- Whether system monitoring is enabled
Temporary Storage Analysis
- Named Buckets -- System-level named temporary storage areas with current/peak sizes
- Unnamed Storage -- Aggregate usage of unnamed temporary storage
- Per-job Usage -- Which jobs consume the most temporary storage
- Limit Tracking -- Job-level storage limits vs current usage
Disk I/O Performance
- Per-unit Metrics -- Read/write requests, data transferred, busy percentage
- Elapsed Statistics -- I/O during the measurement interval
- Hot Spots -- Identify the busiest disk units
Memory Pool Performance
- Fault Rates -- Database and non-database page faults per pool
- Thread Transitions -- Active-to-wait, wait-to-ineligible counts
- Tuning Parameters -- Priority, min/max size, fault thresholds
Common Use Cases
- Collection services audit -- Verify performance data is being collected
- Temp storage investigation -- Find jobs using excessive temporary storage
- Named bucket monitoring -- Track system temp storage bucket growth
- Disk I/O hot spots -- Identify the busiest disk units
- Memory pressure detection -- Find pools with high page fault rates
- Performance baseline -- Capture metrics for trend analysis
- Capacity planning -- Analyze storage and I/O trends
Quick Examples
Check collection services configuration
ibmi tool get_collection_services_config --tools "$SKILL_DIR/tools/"
View collection categories
ibmi tool get_collection_categories --tools "$SKILL_DIR/tools/"
Top temp storage consumers by job
ibmi tool get_temp_storage_by_job --tools "$SKILL_DIR/tools/"
Disk I/O performance
SELECT UNIT_NUMBER, ASP_NUMBER,
ELAPSED_READ_REQUESTS, ELAPSED_WRITE_REQUESTS,
ELAPSED_PERCENT_BUSY
FROM QSYS2.SYSDISKSTAT
WHERE ELAPSED_IO_REQUESTS > 0
ORDER BY ELAPSED_PERCENT_BUSY DESC
FETCH FIRST 10 ROWS ONLY;
Named temp storage buckets
SELECT GLOBAL_BUCKET_NAME, BUCKET_CURRENT_SIZE, BUCKET_PEAK_SIZE
FROM QSYS2.SYSTMPSTG
WHERE GLOBAL_BUCKET_NAME IS NOT NULL
ORDER BY BUCKET_CURRENT_SIZE DESC;
Pre-built Tools
The tools/performance.yaml file provides 7 ready-to-use tools:
| Tool | Description |
|------|-------------|
| get_collection_services_config | Collection services configuration and settings |
| get_collection_categories | Collection categories with their intervals |
| get_temp_storage_buckets | Named temporary storage bucket usage |
| get_unnamed_temp_storage | Aggregate unnamed temporary storage usage |
| get_temp_storage_by_job | Temporary storage consumption by job |
| get_disk_io_performance | Disk I/O performance stats per unit |
| get_memory_pool_performance | Memory pool fault rates and tuning metrics |
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
- Performance Services Catalog -- Available SQL services
- Example SQL Patterns -- Working query examples
- IBM COLLECTION_SERVICES_INFO -- View documentation
- IBM SYSTMPSTG -- View documentation
Related Skills
ajshedivy/work-management
tools
VerifiedTrustedCommunity
Query, monitor, and analyze jobs on IBM i using SQL table functions via the ibmi CLI. Use when user asks about: (1) finding jobs by status, user, subsystem, or type, (2) monitoring active job performance (CPU, I/O, memory), (3) detecting long-running SQL statements, (4) analyzing lock contention, (5) checking job queues, (6) scheduled jobs, (7) job logs, (8) replacing WRKACTJOB, WRKUSRJOB, WRKSBSJOB, WRKSBMJOB commands, or (9) any IBM i work management task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/system-health
testing
VerifiedTrustedCommunity
Monitor IBM i system health including CPU, memory, disk, ASPs, system limits, and network status via SQL services. Use when user asks about: (1) CPU utilization or system status, (2) memory pool sizes or page faults, (3) disk capacity or ASP usage, (4) system limits approaching thresholds, (5) TCP/IP connections and network status, (6) system activity overview, (7) replacing WRKSYSSTS, WRKDSKSTS, WRKTCPSTS commands, or (8) any system health monitoring task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/storage
development
VerifiedTrustedCommunity
Monitor and analyze IBM i storage resources including ASPs, disk units, temporary storage, user storage consumption, and NVMe devices via SQL services. Use when user asks about: (1) ASP capacity, usage, or health, (2) disk unit status or I/O performance, (3) temporary storage consumption by jobs, (4) storage used per user profile, (5) NVMe device health, (6) IASP vary operations, or (7) replacing WRKDSKSTS, WRKSYSSTS storage info, or WRKSTG commands.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/spool
testing
VerifiedTrustedCommunity
Manage and analyze spooled files, output queues, and printer configurations on IBM i via SQL services. Use when user asks about: (1) listing or searching output queues, (2) viewing spooled file entries by queue, user, or status, (3) reading spool file content, (4) identifying top spool consumers or old spool files, (5) printer file definitions, (6) spool storage analysis, (7) replacing WRKSPLF, WRKOUTQ, WRKOBJLCK commands, or (8) any spool file management task.
2SKILL.mdUpdated Apr 2, 2026