database-plan-cache
CommunityControl and analyze IBM i SQL plan cache.
Authorajshedivy
Version1.0.0
Installs0
System Documentation
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.
Dependency Matrix
Required Modules
None requiredComponents
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-plan-cache Download link: https://github.com/ajshedivy/ibmi-agent-skills/archive/main.zip#database-plan-cache Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.