Wednesday, October 2, 2024

Audit Journal Entry Services

I have managed to persuade the admins of the server I use to develop the code for these posts upon to give me access to the Audit Journal, QAUDJRN, this gives me the opportunity to write about several enhancements that have made to Db2 for i that makes getting information from QAUDJRN.

Over the past few releases and Technology Refreshes IBM has given us many Audit Journal Services. As QAUDJRN contains many different types of journal entries IBM has given us a specific Audit Journal Service for just about every journal entry type.

All of Audit Journal Services are called: AUDIT_JOURNAL_xx, where xx is the journal entry type. As of IBM i 7.5 TR4/IBM i 7.4 TR10 there are 41 of these Audit Journal Entry Services, out of a total of 76. That is 54% of all journal entry types covered. I do not know if the plan is to cover all of the job entry types, or not.

Tuesday, October 1, 2024

October's presentations

This month I have three events I am involved with.


On Monday October 7 I will be talking to COMMON's N2i in a presentation called "Getting Started with Modern RPG Arrays and BiFs". As this is for the N2i it is designed to be at a suitable level for people new to the IBM i platform.

Thre presentation is free, and you can register at N2i website here.


I am talking with the West Michigan IBM i User Group on Tuesday October 15 about "Maximizing the benefits of embedding SQL in your RPG code". The presentation will start at 8:00 AM (ET).

I will update this post with a link when they update their website. In the meantime you can find their website here.


I am on my travels again visiting my friends for Common Denmark's annual conference, on Tuesday 29 and Wednesday 30 October. You can learn more about, and register, for the conference here.

I hope to see you there. And if you are attending and you see me, please introduce yourself and say "Hej".