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

database-plan-cache

Manage IBM i SQL plan cache snapshots, event monitors, and maintenance procedures.

3|1|Updated Feb 3, 2026
Search Tags:#maintenance#sql#database-management#snapshot#ibmi#plan-cache#event-monitor
One-click install
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill database-plan-cache
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-plan-cache
Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/database-plan-cache
Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill database-plan-cache

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i SQL plan cache management and discovery, including service catalogs, plan cache snapshots, event monitors, and maintenance procedures, to keep plan cache usage predictable and auditable.

Core Features & Use Cases

  • Service discovery: list available plan cache procedures from QSYS2.SERVICES_INFO.
  • Snapshot management: dump, import, and query plan cache snapshots and properties.
  • Event monitoring: start, stop, and monitor plan cache event monitors.
  • Plan cache control: resize, clear, and manage plan cache memory.
  • Reference & queries: access parameter references and ready-to-run SQL patterns for common tasks.

Quick Start

Install the Database Plan Cache Tools and start by listing available services with ibmi tool list_plan_cache_services.

Frequently Asked Questions about database-plan-cache

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

FAQPage Schema
How do I manage IBM i SQL plan cache snapshots?▼

IBM i SQL plan cache snapshots can be dumped, imported, and queried using cataloged procedures and ready-to-run SQL statements. This Skill provides parameter references and syntax for snapshot management and property examination.

What is an IBM i plan cache event monitor and how do I control it?▼

An IBM i plan cache event monitor tracks SQL plan cache activities. You can start, stop, and monitor event monitors using generated SQL maintenance statements designed for writable database connections.

How do I list available plan cache services on IBM i?▼

Available IBM i plan cache services are listed by querying QSYS2.SERVICES_INFO. The Skill discovers and catalogs these procedures to provide a reference for plan cache management tasks.

Can I resize or clear IBM i plan cache memory using SQL?▼

Yes, IBM i plan cache memory can be resized and cleared using SQL. The Skill generates ready-to-run SQL syntax for plan cache control tasks, including memory management on writable connections.

Do I need a writable database connection to perform IBM i plan cache maintenance?▼

Yes, a writable database connection is required to execute generated SQL statements for IBM i plan cache maintenance tasks such as importing snapshots, resizing memory, and controlling event monitors.

Related Skills

Explore More Software Engineering Skills→
ajshedivyajshedivy
3

work-management

Query and monitor IBM i jobs via SQL services.

Community
Advanced
michaelladymichaellady
4

tiktok-stats

Fetch TikTok per-post engagement metrics and export weekly snapshot JSON files.

Community
Intermediate
ajshedivyajshedivy
3

performance

Collect and analyze IBM i performance metrics via SQL services.

Community
Intermediate
ProfoundLogicProfoundLogic

ibmi-clcmd

Execute IBM i Control Language commands on remote systems via SSH.

Official
Basic