Sept 5, 2025
| Description: Users are leaving their "Run SQL Scripts" sessions open for an extended period of time. | ||
| Although there is a configurable option to "automatically close cursor to release locks", | ||
| this does not disconnect the session. This can present a security risk if physical access | ||
| to the connected workstation is compromised. | ||
| How can we use SQL to identify ODBC/JDBC connections that have been idling for a long time | ||
| and proactively disconnect them? |
@Steve Riedmuller of KISCO Systems has a Gist Site containing SQL code that can assist you with this task. His Gist site can be found here. | |
Sept 3, 2025
"Your IBM i contractor may have walked out last spring, but their user profile still lives on the system..."
This article, courtesy of @JohnFlack of CareCentrix, is an excellent reminder of things needed to be done on IBM i systems. The article is available here.
Sept 2, 2025
IBM's Power Software and Solutions by ISV's worldwide. The page can be filtered by "Operating System, Deployment Type, Industry, Market and Workload". ISV's can also apply to have their software / solutions added to the list.
The Power Solutions Catalog Page can be found here
