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

application

Inventory IBM i application objects via QSYS2 SQL services and ibmi CLI.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Discover and inventory IBM i application objects using SQL services to answer questions about commands, data areas, data queues, programs, and related runtime artifacts.

Core Features & Use Cases

  • Query CL command metadata, program information (ILE/OPM), data areas, data queues, environment variables, and exit programs with a single toolkit.
  • Inspect watch sessions and user spaces/indexes to troubleshoot system behavior.
  • Use ready-made SQL examples and references to accelerate discovery across libraries and systems.

Quick Start

Use the application skill to query PROGRAM_INFO and COMMAND_INFO for a library to inventory ILE programs and CL commands.

Frequently Asked Questions about application

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

FAQPage Schema
How do I inventory IBM i application objects using SQL services?▼

You can inventory IBM i application objects by querying QSYS2 views and table functions. This approach exposes catalog data for CL commands, ILE and OPM programs, data areas, and queues across libraries using prebuilt SQL statements.

Can I query CL command metadata and program information on IBM i with a single tool?▼

Yes, you can query CL command metadata and program information together. By utilizing QSYS2 SQL services such as COMMAND_INFO and PROGRAM_INFO, you can discover and report both ILE and OPM program details within a single library scope.

What IBM i system artifacts can I inspect beyond programs and commands?▼

Beyond programs and commands, you can inspect data areas, data queues, environment variables, and exit programs. You can also inventory watch sessions, user spaces, and user indexes to troubleshoot system behavior using SQL services.

Does querying IBM i application objects require specific database dependencies?▼

Querying IBM i application objects requires the ibmi CLI to access QSYS2 SQL services. No external dependencies are needed, as the toolkit uses prebuilt references and ready-made SQL examples to interact directly with the database catalog.

What is the best way to troubleshoot IBM i system behavior using SQL?▼

The best way to troubleshoot IBM i system behavior is inspecting watch sessions and inventorying runtime artifacts. Querying user spaces, indexes, and environment variables via SQL services provides direct visibility into system state and application configurations.

Related Skills

Explore More Software Engineering Skills→
ajshedivyajshedivy
3

database-utility

Inventory and analyze IBM i database files using SQL services via ibmi CLI.

Community
Advanced
marcelodfelmanmarcelodfelman

Power BI Documentation

Extract Power BI semantic model metadata and generate structured model inventories.

Community
Advanced
RHEcosystemAppEngRHEcosystemAppEng
48

host-fact-inspector

Analyze host system facts to correlate with job failures.

Official
Advanced
ajshedivyajshedivy
3

work-management

Query and monitor IBM i jobs via SQL services.

Community
Advanced