ajshedivy/mirror
skills/mirror/SKILL.md
Monitor Db2 Mirror for IBM i including replication status, cluster topology, NRG communication, RDMA links, replication criteria, resynchronization, reclone readiness, and flight recorder diagnostics. Use when user asks about: (1) mirror replication status or health, (2) cluster node topology, (3) NRG or RDMA link status, (4) takeover IP addresses, (5) replication inclusion/exclusion rules, (6) resynchronization progress, (7) reclone security objects, (8) mirror version compatibility, (9) flight recorder logging, or (10) ObjectConnect state.
testing
Updated Apr 2, 2026
$ install --global
skillsauthnpx skillsauth add ajshedivy/ibmi-agent-skills mirrorInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 2, 2026, 6:42 PM60.4s10 files scanned
SKILL.md
- name:
- mirror
- description:
- Monitor Db2 Mirror for IBM i including replication status, cluster topology, NRG communication, RDMA links, replication criteria, resynchronization, reclone readiness, and flight recorder diagnostics. Use when user asks about: (1) mirror replication status or health, (2) cluster node topology, (3) NRG or RDMA link status, (4) takeover IP addresses, (5) replication inclusion/exclusion rules, (6) resynchronization progress, (7) reclone security objects, (8) mirror version compatibility, (9) flight recorder logging, or (10) ObjectConnect state.
IBM i Db2 Mirror Monitoring
Monitor Db2 Mirror replication, cluster topology, NRG communication, RDMA links, replication criteria, and diagnostics using QSYS2 SQL services.
Available Tools
The ibmi CLI is the primary tool for mirror monitoring. 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/mirror, ~/.claude/skills/mirror
ibmi tools --tools "$SKILL_DIR/tools/" --toolset mirror_default
ibmi tool list_mirror_status --tools "$SKILL_DIR/tools/"
ibmi sql "SELECT IASP_NAME, REPLICATION_STATE FROM QSYS2.MIRROR_INFO"
Service Selection Guide
Product Status (MIRROR-PRODUCT)
- QSYS2.MIRROR_INFO -- Replication state, node roles, auto-resume
- QSYS2.MIRROR_CLUSTER_INFO -- Cluster topology and IP addresses
- QSYS2.MIRROR_HEALTH_MONITOR_INFO -- Health monitor configuration
- QSYS2.MIRROR_TAKEOVER_INFO -- Takeover IP groups and addresses
- QSYS2.MIRROR_VERSION_LIST -- Version compatibility tracking
- QSYS2.MIRROR_OBJECTCONNECT_INFO -- ObjectConnect subsystem state
Communication (MIRROR-COMMUNICATION)
- QSYS2.NRG_INFO -- Network redundancy group configuration and stats
- QSYS2.NRG_LINK_INFO -- Individual NRG link state and priority
- QSYS2.RDMA_LINK_INFO -- RDMA link traffic and error statistics
- QSYS2.RDMA_CONNECTION_INFO -- RDMA connection details
Replication (MIRROR-REPLICATION)
- QSYS2.REPLICATION_CRITERIA_INFO -- Inclusion/exclusion rules
Reclone (MIRROR-RECLONE)
- QSYS2.CONFIRM_RECLONE_SECURITY_OBJECTS -- Security objects for reclone
Serviceability (MIRROR-SERVICEABILITY)
- QSYS2.MIRROR_FLIGHT_RECORDER_INFO -- Flight recorder config and logging levels
Key Capabilities
Replication Health
- Status Check -- Replication state per IASP (ACTIVE, SUSPENDED, etc.)
- Node Roles -- Primary/secondary node identification
- Auto-Resume -- Whether replication auto-resumes after interruption
- NRG State -- Network redundancy group health
Cluster Topology
- Node Info -- Cluster name, device domain, node names
- IP Addresses -- Primary and secondary IPs for each node
- Takeover Groups -- IP takeover configuration and current placement
- Version Tracking -- Mirror version compatibility between nodes
Communication Monitoring
- NRG Health -- Link counts, active links, load balancing
- NRG Links -- Individual link state, priority, and type
- RDMA Traffic -- Bytes in/out, message counts, error statistics
- Link Failures -- Dropped packets, sequence errors
Replication Management
- Criteria Rules -- Which objects are included or excluded
- Rule State -- Applied vs pending criteria
- Reclone Readiness -- Security objects that need confirmation
Common Use Cases
- Health check -- Verify replication is active and healthy
- Topology review -- Understand cluster nodes and IPs
- Network diagnosis -- Check NRG/RDMA link status and errors
- Takeover readiness -- Verify IP groups on preferred nodes
- Replication audit -- Review inclusion/exclusion criteria
- Version check -- Ensure mirror versions are compatible
- Diagnostics -- Review flight recorder settings
Quick Examples
Check replication status
ibmi tool list_mirror_status --tools "$SKILL_DIR/tools/"
View cluster topology
ibmi tool list_mirror_cluster --tools "$SKILL_DIR/tools/"
Check NRG link health
ibmi tool list_nrg_links --tools "$SKILL_DIR/tools/"
Review replication criteria
ibmi tool list_replication_criteria --tools "$SKILL_DIR/tools/"
Pre-built Tools
The tools/mirror.yaml file provides 12 ready-to-use tools:
| Tool | Description |
|------|-------------|
| list_mirror_status | Replication state per IASP |
| list_mirror_cluster | Cluster topology and IPs |
| list_mirror_health_monitor | Health monitor configuration |
| list_mirror_takeover | Takeover IP groups |
| list_mirror_versions | Version compatibility tracking |
| list_nrg_info | NRG configuration and stats |
| list_nrg_links | Individual NRG link state |
| list_rdma_links | RDMA link traffic and errors |
| list_replication_criteria | Inclusion/exclusion rules |
| list_mirror_flight_recorder | Flight recorder config |
| list_confirm_reclone_security | Reclone security objects |
| get_mirror_objectconnect_info | ObjectConnect state |
ibmi tool <tool_name> --tools "$SKILL_DIR/tools/" # Execute
ibmi tool <tool_name> --tools "$SKILL_DIR/tools/" --dry-run # Preview SQL
ibmi tools show <tool_name> --tools "$SKILL_DIR/tools/" # View details
Reference Documentation
- Mirror Services Catalog -- All mirror SQL services
- Example SQL Patterns -- Working query examples
- Mirror Product -- MIRROR-PRODUCT services
- Mirror Communication -- MIRROR-COMMUNICATION services
- Mirror Replication -- MIRROR-REPLICATION services
- Mirror Reclone -- MIRROR-RECLONE services
- Mirror Serviceability -- MIRROR-SERVICEABILITY services
- Mirror Resynchronization -- MIRROR-RESYNCHRONIZATION services
Related Skills
ajshedivy/work-management
tools
VerifiedTrustedCommunity
Query, monitor, and analyze jobs on IBM i using SQL table functions via the ibmi CLI. Use when user asks about: (1) finding jobs by status, user, subsystem, or type, (2) monitoring active job performance (CPU, I/O, memory), (3) detecting long-running SQL statements, (4) analyzing lock contention, (5) checking job queues, (6) scheduled jobs, (7) job logs, (8) replacing WRKACTJOB, WRKUSRJOB, WRKSBSJOB, WRKSBMJOB commands, or (9) any IBM i work management task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/system-health
testing
VerifiedTrustedCommunity
Monitor IBM i system health including CPU, memory, disk, ASPs, system limits, and network status via SQL services. Use when user asks about: (1) CPU utilization or system status, (2) memory pool sizes or page faults, (3) disk capacity or ASP usage, (4) system limits approaching thresholds, (5) TCP/IP connections and network status, (6) system activity overview, (7) replacing WRKSYSSTS, WRKDSKSTS, WRKTCPSTS commands, or (8) any system health monitoring task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/storage
development
VerifiedTrustedCommunity
Monitor and analyze IBM i storage resources including ASPs, disk units, temporary storage, user storage consumption, and NVMe devices via SQL services. Use when user asks about: (1) ASP capacity, usage, or health, (2) disk unit status or I/O performance, (3) temporary storage consumption by jobs, (4) storage used per user profile, (5) NVMe device health, (6) IASP vary operations, or (7) replacing WRKDSKSTS, WRKSYSSTS storage info, or WRKSTG commands.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/spool
testing
VerifiedTrustedCommunity
Manage and analyze spooled files, output queues, and printer configurations on IBM i via SQL services. Use when user asks about: (1) listing or searching output queues, (2) viewing spooled file entries by queue, user, or status, (3) reading spool file content, (4) identifying top spool consumers or old spool files, (5) printer file definitions, (6) spool storage analysis, (7) replacing WRKSPLF, WRKOUTQ, WRKOBJLCK commands, or (8) any spool file management task.
2SKILL.mdUpdated Apr 2, 2026