It used to be that IBM i administrators had to rely on commands, displays, outfiles, APIs, and the Navigator GUI to view IBM i management information, but no more.
Many system services are now accessible through system-provided SQL views, procedures, and functions that provide additional flexibility and allow you to determine what data you want to see and how you want it organized—all without needing to code to a system API!
In this recorded webinar, Dawn May shows you where to find example SQL statements to get you started and explains how to use the SQL interface to access, transform, order, and subset the vital system information you depend on, including:
- Information on active jobs and system status
- Easy ways to search the history log
- Routing work to subsystems by user profile
- Tracking storage consumption—including IASP—and system limits
You’ll also see a live demonstration of how Robot Monitor can automate this data collection, summarization, and system reporting across IBM i and VIOS partitions to make systems management even easier.
Learn how Robot Monitor helps you take a proactive approach to system threats by resolving problems before they impact performance and productivity. Request a live demonstration and we’ll show you.