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 

Environment Variables Andy Youens

​The IBM i operating system is highly dependent on environmental variables, which can have a significant impact on its performance. In this article, we will dive into the various environmental variables and their effects on the IBM i. What are environment variables? Let me start at the beginning, what are environment variables? Environment variables allow
The post Environment Variables appeared first on PowerWire.eu. Read More 

Verified by MonsterInsights