Query IBM i journals, receivers, and audit data marts via QSYS2 SQL services.
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill journal-ajshedivy
Please help me install this Agent Skill. Skill: journal Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/journal Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill journal-ajshedivy
IBM i journal management can be complex and time-consuming; this skill provides centralized access to journal, journal receiver, and audit data mart information via QSYS2 SQL services.
List all journals in library QSYS and display the latest entries for QAUDJRN.
High-intent search queries and answers about installing and using this skill.
Query IBM i journals and receivers using QSYS2 SQL services by accessing JOURNAL_INFO and JOURNAL_RECEIVER_INFO views. This provides inventory, state monitoring, receiver counts, and size metrics across libraries with read-only access.
The best way to read IBM i journal entries and audit data marts is by querying the DISPLAY_JOURNAL table function and related audit views. This allows tracking security events and system changes directly via SQL services.
Yes, you can inspect remote journal configurations and SMAPP protections on IBM i by querying the REMOTE_JOURNAL_INFO view. This exposes replication configurations and helps diagnose access issues or replication lag.
No, this approach does not require write access to the IBM i system. It uses the ibmi CLI tool with predefined toolsets to perform read-only queries against QSYS2 SQL services for journal and audit data.
To list all journals in a specific IBM i library, query the QSYS2.JOURNAL_INFO view using a library filter. This returns journal names, states, and associated receiver details for centralized inventory monitoring.
Limitations of using QSYS2 SQL services for journal management include being restricted to read-only access. You cannot modify journal states, delete receivers, or alter SMAPP configurations directly through these predefined SQL views.
ajshedivyQuery and monitor IBM i jobs via SQL services.
lm93129Detect and test anomalous journal entries for fraud risk identification.
ProfoundLogicExecute IBM i Control Language commands on remote systems via SSH.
ajshedivyMonitor IBM i PTF currency, groups, and patching status via SQL views.
