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

Ready to run

npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill configuration-ajshedivy

💬 Prompt for ChatGPT / Claude Chat▼

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.