With all the news of recent #ransomware. Here are 5 things you can do to help increase your #cybersecurity #IBMi #AS400 #ITSecurity hubs.ly/H0Pr5P00 pic.twitter.com/DolFiM3oth
– Briteskies (@nobrowncow)07:09 – Jun 17, 2021
Join our chief architect @Steve_Will_IBMi on June 30th as he shines some headlights on the road ahead for software development on IBM i. Register here:
Join our chief architect @Steve_Will_IBMi on June 30th as he shines some headlights on the road ahead for software development on IBM i. Register here: bit.ly/2TYT0sX
– Brandon Pederson (@BPED07)10:00 – Jun 11, 2021
IBM i & IBM Power Grundkurs
Datum 18 – 22 Oktober
Kostnad 25.000 SEK ex Moms (10% Rabatt för medlemmar i Common Sweden & Common Norge)
Kursen sker online
Anmälan genom mail till [email protected]
Innehåll i kursen:
AGENDA
- Introduction
- IBM Power and IBM i history
- IBM i architecture from System/38 to IBM i
- Operating systems, Licensed Internal Code and the integrated database
- Command structure, menus and prompting
- Demo – Menu structure and help functions
- User profiles & authorities
- Communication, terminals, printers etc.
- Console, system startup / IPL
- Power Systems, hardware, storage
- Virtualization, PowerVM and related software
- Installation of IBM i & licensed programs
- PTF management
- Programming languages, compilators and applications
- Management interfaces, ACS & iNavigator
- Authority / security
- Job management, job queues, out queues
- CL-Programming
- Backup/BRMS
Huvudlärare är gurun Gunnar Elmgren
Specialistlärare CL-Programmering är Åke H Olsson
Bakgrund och historia körs av Torbjörn Appehl
#hmc for #ibmi may be on it final generation… #Power10 may not require an #hmc
#hmc for #ibmi may be on it final generation… #Power10 may not require an #hmc pic.twitter.com/BlFpXvuZtF
– SQL iQuery for #IBMi (@sqliquery)05:35 – Jun 15, 2021
Getting to message queue data faster
Prior to the latest round of Technology Refreshes for 7.4 and 7.3 if I wanted to get the data from a particular message queue I would need to use the MESSAGE_QUEUE_INFO SQL View. Being a View it contains all the data from all of the message queues, not just the one I would be interested. If I wanted to retrieve the messages from one message queue it would take a while for the results to be found and returned.
There is now a MESSAGE_QUEUE_INFO Table function. Table functions are faster than Views as they are sort of like an API, I pass the message queue name to the Table function and only that message queue is searched for the information I want.
The results returned by the View and Table function are almost identical. The only difference is that the View returns columns for the name of the message queue and the library it resides. As I pass that information to the Table function it is irrelevant to its results.
MESSAGE_QUEUE_INFO Table function has four parameters:
