IBM i Database Plan Cache

Explore and manage the SQL plan cache including service discovery, snapshot analysis, event monitor tracking, and management procedure references.

Available Tools

The ibmi CLI is the primary tool for executing plan cache queries. Set SKILL_DIR to this skill's installed location (the directory containing this SKILL.md file):

# SKILL_DIR = directory containing this SKILL.md
# Examples: ./skills/database-plan-cache, ~/.claude/skills/database-plan-cache

# List all plan cache tools
ibmi tools --tools "$SKILL_DIR/tools/" --toolset database_plan_cache_default

# Run a specific tool
ibmi tool list_plan_cache_services --tools "$SKILL_DIR/tools/"