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

database-utility

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i database administrators need a unified way to inventory library files, review partition and member statistics, assess object usage, and validate catalog integrity without writing ad-hoc SQL queries.

Core Features & Use Cases

  • Inventory files and attributes (type, CCSID, member count) across libraries.
  • Analyze partition and member statistics to identify bloated objects, aging data, and usage trends.
  • Query object statistics and catalog health data to support maintenance, impact analysis, and cross-library comparisons.
  • Perform cross-library file comparisons and dependency checks to plan migrations and cleanups.

Quick Start

Run a library inventory to list all files, their types, and last-used timestamps using the database-utility tools.

Frequently Asked Questions about database-utility

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

FAQPage Schema
How do I inventory IBM i database files and attributes across libraries?▼

Inventory IBM i database files by querying QSYS2.SYSFILES to list file types, CCSID values, and member counts across libraries. The skill automates SQL services to retrieve file attributes and last-used timestamps without writing ad-hoc SQL queries.

What SQL services are available for analyzing IBM i partition and member statistics?▼

Analyze IBM i partition and member statistics using SYSPARTITIONSTAT and SYSMEMBERSTAT SQL services. The skill queries these catalog views to identify bloated objects, track aging data, and surface usage trends within a constrained library scope.

Can I check IBM i catalog health and validate data integrity without manual SQL?▼

Check IBM i catalog health and validate data using ANALYZE_CATALOG and VALIDATE_DATA SQL services. The skill executes these services via the ibmi CLI to assess catalog integrity and identify data validation issues across targeted libraries.

What's the best way to compare database files across IBM i libraries for migrations?▼

Compare IBM i database files across libraries using the COMPARE_FILE SQL service. The skill performs cross-library file comparisons and related object dependency checks via RELATED_OBJECTS to support migration planning and cleanup tasks.

Does this database utility work with all IBM i object types for usage statistics?▼

Query IBM i object statistics using the OBJECT_STATISTICS SQL service. The skill leverages this service through the ibmi CLI to retrieve object usage data, supporting maintenance planning and impact analysis within a specified library.

Related Skills

Explore More Data & Analytics Skills→
ajshedivyajshedivy
3

ptf

Monitor IBM i PTF currency, groups, and patching status via SQL views.

Community
Advanced
MGPowerlyticsMGPowerlytics

troubleshooting

Diagnose Airflow, database, API, and data integrity issues in the nhlstats system.

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