Faster way to find who answered a message Simon Hutchinson

​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 

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 : Read More 

Verified by MonsterInsights