Skills
.Work. You
Rest

database-application

Community

Diagnose IBM i SQL failures and capacity.

Data & Analytics#sql#analyze#error-log#ibmi#parse-statement#sqlcode
Authorajshedivy
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Analyze IBM i SQL application behavior including error logs, statement parsing, SQLCODE lookups, and system limits to help diagnose failures and plan capacity.

Core Features & Use Cases

  • Error log analysis: inspect QSYS2.SQL_ERROR_LOG for recent errors with SQLCODE, SQLSTATE, statement text, and timestamps.
  • SQL analytics: parse statements to extract referenced objects, look up SQLCODE meanings, and delimit identifiers for safe dynamic SQL.
  • System monitoring: monitor SYSLIMITS to identify objects approaching size or capacity limits and plan proactive maintenance.
  • Use Case: A developer investigates a failing IBM i application by reviewing recent SQL errors, identifying the most frequent codes, and tracing referenced objects in the codebase.

Quick Start

Use the ibmi CLI to view SQL_ERROR_LOG entries and begin analyzing errors, SQLCODEs, and parsed references.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: database-application
Download link: https://github.com/ajshedivy/ibmi-agent-skills/archive/main.zip#database-application

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.