Six years ago I wrote a post about using the MESSAGE_QUEUE_INFO SQL View for finding jobs that had errored, and who had answered those messages. What I would like to do today is to give an example of more efficient, faster, way to get the same results using the MESSAGE_QUEUE_INFO Table Function.
On the whole retrieving results from Table Functions tend to be faster than getting the same results from a View. Most Table Functions have parameters that are used to narrow down the results to a smaller set of results, which can then be interrogated with the Where clause. With a View I have all the results there can be, and then the Where clause has to search through all of those to find what I want.
The MESSAGE_QUEUE_INFO Table Function has four parameters. I am going to be using three in these examples:
Read more » Read More
Display event – POWERCast: 6 Key Areas for Secure IBM i Passwords & Logins members.common.org
SEA’s Lloyd Ramdarie and Joe Hertvik will outline six key areas for an effective management strategy for IBM i passwords.
Join SEA on September 21 st to learn about these key areas you need to address for effective IBM i password management. Read More
IBM i DevOps TechTalk #7 – Moving to Git – GitFlow ARCAD Software
Tune into this IBM i DevOps TechTalk on a key Git concept – Gitflow.
– How Arcad’s tooling elegantly supports Gitflow for the IBM i Developer. Read More
IBM i DevOps TechTalk #6 – Test Data Management part 1 – Data Extraction ARCAD Software
The topic of this IBM i DevOps TechTalk is Test Data Management with the focus on data extraction.It features Alan Ashley, an expert in test data management, who will answers questions by our host, Ray Bernardi:- Where/how to start a test data management plan- What are the main benefits of data extraction- How to manage data security & privacy concerns- How to automate the test data management process- How to maintain integrity between IBM i and non-IBM i databases during extraction- Listen to this episode to get started with the management of your own test data!Don’t forget to subscribe to our spotify channel to listen to more episodes of our podcast : https://open.spotify.com/show/2oKMo5folDLoNADgewzrVX Read More
Fix up the Nagios XI Wizard from IBM Chris Hird
If you are running Nagios XI and have tried to install the IBM i provided wizards only to find it complains about them not being a valid wizard and will not install, there is a Read More
