IBMi A few more little SQL's
UPDATE: 06/12/2025 - Added a summary link post to aggregate these types of posts. https://leedare-plex2e.blogspot.com/2025/12/synon-2e-sql-and-model-files-summary.html QSYS2 is a library that has lots of system data readily available. More and more data that has traditionally been the reserve of a particular command or API is now available for query. These views have been around for years and IBM are adding more and every release. The SQL view will have a long name equivalent for easier SQL readability, as well as, the standard IBM object notation for use in tools like Query/400 rather than SQL statements. (See Table as the end of this blog) For example the file for querying data area's on the system is 'DATA_AREA_INFO' in SQL parlance but 'DTAARA_INF' when referred to directly as an object. Let's take a look at some sample for the kind of data you can mine on your IBMi Who is taking up spool file space? SELECT USER_NAME, SUM(SIZE) AS TOTAL_SPOOL_SPACE FRO...