Using SQL to retrieve information about hardware resources Simon Hutchinson

​Amongst the many new additions to the latest Technology Refreshes, IBM i 7.5 TR1 and 7.4 TR7, comes a new View and Table Function that allows me to retrieve information about a partition’s hardware resources, including its status.
Both have the same name, HARDWARE_RESOURCE_INFO, and are in the library QSYS2. The View returns information for all hardware resources, the Table Function returns can be used to only return the information about one type of hardware resource or another. Both return the same columns in their results.
Before I start showing you examples of the results from these two I recommend you run the following SQL statement. This will allow you to see all the available columns, and help you decide what is useful to you.
Read more » Read More 

Connectria Key Takeaways from POWERUp 2023 Kaylin Waltrip

​Common’s POWERUp conference, the largest IBM i conference event worldwide, was held last week in Denver, Colorado. This event brings IBM executives, industry experts, and solution providers, like Connectria, together with the international IBM i community of users. Connectria’s team of IBM i experts returned energized and excited after connecting with IBM users and leaders in the
The post Connectria Key Takeaways from POWERUp 2023 appeared first on Connectria. Read More 

Verified by MonsterInsights