ajshedivy/journal
skills/journal/SKILL.md
Manage and inspect IBM i journals, journal receivers, journaled objects, journal entries, remote journals, and audit journal data marts. Use when user asks about: (1) listing journals or journal receivers, (2) which objects are journaled, (3) reading journal entries, (4) remote journal configuration and lag, (5) journal receiver sizes or chains, (6) SMAPP access path protection, (7) audit journal data marts, (8) journal storage consumption, or (9) replacing WRKJRN, DSPJRN, WRKJRNA command output.
$ install --global
skillsauthnpx skillsauth add ajshedivy/ibmi-agent-skills journalInstall 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 25, 2026, 5:33 AM53.9s4 files scanned
SKILL.md
- name:
- journal
- description:
- Manage and inspect IBM i journals, journal receivers, journaled objects, journal entries, remote journals, and audit journal data marts. Use when user asks about: (1) listing journals or journal receivers, (2) which objects are journaled, (3) reading journal entries, (4) remote journal configuration and lag, (5) journal receiver sizes or chains, (6) SMAPP access path protection, (7) audit journal data marts, (8) journal storage consumption, or (9) replacing WRKJRN, DSPJRN, WRKJRNA command output.
IBM i Journal Management
Manage and inspect journals, journal receivers, journaled objects, journal entries, remote journals, and audit data marts using QSYS2 SQL services.
Available Tools
The ibmi CLI is the primary tool for journal 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/journal, ~/.claude/skills/journal
ibmi tools --tools "$SKILL_DIR/tools/" --toolset journal_default
ibmi tool list_journals --tools "$SKILL_DIR/tools/"
ibmi sql "SELECT JOURNAL_NAME, JOURNAL_LIBRARY, JOURNAL_TYPE FROM QSYS2.JOURNAL_INFO"
Service Selection Guide
Journal Configuration
- QSYS2.JOURNAL_INFO -- Journal properties, receiver counts, object counts
- QSYS2.JOURNAL_RECEIVER_INFO -- Receiver timestamps, sizes, entry counts, chain
- QSYS2.JOURNALED_OBJECTS -- Objects being journaled and their options
Journal Entries
- QSYS2.DISPLAY_JOURNAL -- Read journal entries with filtering by time
- SYSTOOLS.AUDIT_JOURNAL_xx -- Typed audit journal entry readers (AD, AF, PW, etc.)
- QSYS2.AUDIT_JOURNAL_DATA_MART_INFO -- Audit data mart build status
Remote & Access Paths
- QSYS2.REMOTE_JOURNAL_INFO -- Remote journal state, delivery mode, lag metrics
- QSYS2.SMAPP_ACCESS_PATHS -- System-managed access path protection
Key Capabilities
Journal Inventory
- List Journals -- Show all journals with type, state, and receiver info
- Receiver Chain -- Navigate the chain of receivers for a journal
- Large Receivers -- Find receivers consuming excessive storage
- Detailed Config -- Review journal settings including ESD and cache
Entry Analysis
- Display Entries -- Read journal entries filtered by time range
- Entry Metadata -- Journal code, type, object, user, program info
- Audit Trails -- Track security-relevant events via audit journal
Journaled Objects
- Object Inventory -- List all objects journaled by a specific journal
- Journaling Options -- Image settings and omit configurations
- Remote Journals -- Monitor remote journal lag and delivery mode
Common Use Cases
- Journal inventory -- List all journals and their current state
- Receiver management -- Check receiver sizes and chain sequence
- Storage analysis -- Find largest receivers consuming disk space
- Read entries -- View recent journal entries for a journal
- Remote journal monitoring -- Check replication lag
- Audit trail -- Review audit journal data mart status
- SMAPP review -- Check access path protection status
Quick Examples
List all journals
ibmi tool list_journals --tools "$SKILL_DIR/tools/"
List receivers for a specific journal
ibmi tool list_journal_receiver_chain --tools "$SKILL_DIR/tools/" --journal-library QSYS --journal-name QAUDJRN
Read recent journal entries
ibmi tool display_journal_entries --tools "$SKILL_DIR/tools/" --journal-library QSYS --journal-name QAUDJRN --minutes-ago 30
Find largest receivers
ibmi tool list_large_journal_receivers --tools "$SKILL_DIR/tools/" --min-size-mb 100
Pre-built Tools
The tools/journal.yaml file provides 13 ready-to-use tools:
| Tool | Description |
|------|-------------|
| list_journals | List journals with type, state, and receiver info |
| list_journal_receivers | Receivers with timestamps, status, and sizes |
| list_journaled_objects | Objects journaled by a specific journal |
| display_journal_entries | Read journal entries filtered by time |
| list_remote_journals | Remote journal config and lag metrics |
| list_journal_receiver_chain | Receiver chain for a specific journal |
| list_large_journal_receivers | Find largest receivers by size |
| get_journal_detail | Detailed journal configuration |
| list_smapp_access_paths | SMAPP access path protection status |
| get_audit_journal_data_mart_info | Audit data mart build status |
| audit_security_events | Security-relevant audit journal entries (SYSTOOLS.AUDIT_JOURNAL_AF) |
| audit_object_changes | Object create/delete/change entries (SYSTOOLS.AUDIT_JOURNAL_CO) |
| audit_system_changes | System value / auditing change entries (SYSTOOLS.AUDIT_JOURNAL_SV) |
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
- Journal Services Catalog -- Available SQL services
- Example SQL Patterns -- Working query examples
- IBM JOURNAL_INFO -- View documentation
- IBM DISPLAY_JOURNAL -- Table function documentation
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