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

storage

Query IBM i QSYS2 views to assess ASP, disk, and temp storage health.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i storage management can require cross-referencing multiple system views to understand capacity, usage, and health. This skill consolidates ASP, disk, NVMe, and temporary storage data into actionable insights via SQL services.

Core Features & Use Cases

  • Centralized visibility into ASP capacity, health, and vary/maintenance readiness.
  • Disk utilization and I/O health assessment across NVMe and traditional disks.
  • Temp storage and per-user storage audits for capacity planning and governance.
  • Real-world use case: a sysadmin detects a rapidly growing temp storage usage per job and triggers a cleanup plan.

Quick Start

Query ASP_INFO and SYSDISKSTAT for a quick health and utilization snapshot across all storage resources.

Frequently Asked Questions about storage

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

FAQPage Schema
How do I monitor IBM i storage health and usage via SQL?▼

You can monitor IBM i storage health via SQL by querying QSYS2 views like ASP_INFO, SYSDISKSTAT, SYSTMPSTG, and USER_STORAGE to assess ASP capacity, disk performance, and temporary storage usage.

How do I check ASP capacity and maintenance readiness on IBM i?▼

Checking ASP capacity and maintenance readiness involves querying the QSYS2.ASP_INFO view to consolidate visibility into auxiliary storage pool health, vary status, and overall disk utilization across the system.

What is the best way to audit temporary storage usage per job on IBM i?▼

Auditing temporary storage usage per job requires querying the QSYS2.SYSTMPSTG view to track rapid growth, identify consuming jobs, and trigger cleanup plans for capacity planning and governance.

Can I track NVMe disk utilization and I/O performance on IBM i using SQL services?▼

Tracking NVMe disk utilization and I/O performance requires querying the QSYS2.NVME_INFO and SYSDISKSTAT views to assess health across NVMe and traditional disks for maintenance and capacity planning.

Do I need the ibmi CLI to query per-user storage audits on IBM i?▼

Yes, per-user storage audits require access to the ibmi CLI to execute SQL queries against the QSYS2.USER_STORAGE view and parse the returned capacity tracking results.

Why does consolidating IBM i disk and ASP data require multiple system views?▼

Consolidating IBM i disk and ASP data requires multiple system views because capacity, health, and usage metrics are distributed across QSYS2 views like ASP_INFO, SYSDISKSTAT, and SYSTMPSTG for comprehensive visibility.

Related Skills

Explore More Data & Analytics Skills→
ajshedivyajshedivy
3

performance

Collect and analyze IBM i performance metrics via SQL services.

Community
Intermediate
EmmraanEmmraan

database-performance

Diagnose and optimize PostgreSQL database performance issues across the lifecycle.

Community
Advanced
ProfoundLogicProfoundLogic

ibmi-clcmd

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

Official
Basic
ajshedivyajshedivy
3

system-health

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

Community
Intermediate