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

configuration

Query IBM i configuration data via SQL across QSYS2 and SYSTOOLS views.

3|1|Updated Feb 3, 2026
Search Tags:#configuration#sql#environment-variables#ibmi#system-values#hardware-resources#jvm-info
One-click install
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill configuration-ajshedivy
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: configuration
Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/configuration
Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill configuration-ajshedivy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i system configuration data is scattered across multiple views and commands; this skill consolidates essential configuration information via SQL services to streamline audits and troubleshooting.

Core Features & Use Cases

  • Retrieve system values, hardware resource info, environment variables, and JVM details for quick health checks and compliance audits.
  • Filter results by category, status, or resource type to focus on relevant assets during reviews.
  • Use case: perform a security and performance audit by listing critical system values (QSECURITY), hardware inventory, and active JVMs, then compare against baselines.

Quick Start

Use the ibmi tool to query current configuration data such as system values, hardware resources, and environment variables.

Frequently Asked Questions about configuration

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

FAQPage Schema
How do I query IBM i system values using SQL services?▼

You can query IBM i system values through SQL services by accessing the QSYS2 SYSTEM_VALUE_INFO view to retrieve and audit security and performance settings like QSECURITY for compliance checks.

Can I retrieve IBM i hardware resource information via SQL?▼

Yes, you can retrieve IBM i hardware resource information via SQL by querying the HARDWARE_RESOURCE_INFO view to inventory assets and perform performance checks across system configurations.

What is the best way to audit environment variables on IBM i?▼

Auditing IBM i environment variables is best done by querying the ENVIRONMENT_VARIABLE_INFO SQL view to list active variables for troubleshooting and configuration reviews.

Does querying IBM i JVM information require special SQL services?▼

Querying IBM i JVM information requires accessing the JVM_INFO SQL view to monitor active Java Virtual Machines, check performance status, and review runtime configurations during system audits.

How do I filter IBM i configuration data when querying SQL views?▼

Filter IBM i configuration data in SQL views by applying optional filters for category, status, or resource type to narrow results and focus on relevant assets during security and performance reviews.

Do I need the ibmi CLI to monitor IBM i system configuration via SQL?▼

Yes, you need the ibmi CLI to query IBM i system configuration data via SQL, as it provides the required access to QSYS2 and SYSTOOLS views for auditing system values and hardware resources.

Related Skills

Explore More Software Engineering Skills→
ajshedivyajshedivy
3

security

Audit IBM i security posture via QSYS2 and SYSTOOLS SQL services.

Community
Advanced
tan-yong-shengtan-yong-sheng
1

gstack-benchmark

Measure navigation timing and resource usage against baselines to detect performance regressions.

Community
Advanced
ajshedivyajshedivy
3

system-health

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

Community
Intermediate
ajshedivyajshedivy
3

application

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

Community
Intermediate