Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
What are Spool Files? Spooled files on an IBM i System (AS400/iSERIES) are a way to manage output data for printing or processing. They can contain basic text layouts of printed pages, or complex PDF style data streams. Here’s how they work: So, IBM i Spooled Files are virtual printouts, helping you manage input and output …
IBM i Authority In the IBM i environment, you can encounter situations where different users require varying levels of authority to access objects or applications. IBM i authority settings can seem a little daunting to new admins, but they grounded in decades of real world usage and were so well designed they really have changed …
Unicom’s TURNOVER works neatly with IBM i ASP (Auxiliary Storage Pools) “Unicom TURNOVER” can refer to different things depending on the context. In this blog I am talking about the IBM i Software Lifecycle Manager (also called Change Management). So, if that is not what you are looking for, leave now before you go blind …
IBM Tips on Cleaning Up QSPL Storage To manage and clean up QSPL storage on IBM i systems effectively, here are some best practices: IBM offers some great advice: By following these tips, you can help ensure that your IBM i system’s QSPL storage is managed efficiently and remains free of unnecessary clutter. Obviously, always …
It’s time to move MOVE out of old RPG Programs One of the biggest mistakes I’ve made while trying to modernise old RPG code, is simply importing the old code and trying to take the whole thing as one lump upgrade to modern RPG ILE. Hindsight is 2020, and something I’ve learned from the many …
Comparing Object Authorities across different libraries is easier than you think! Using the magical powers of IBM i SQL we can easily create a spreadsheet containing all the objects in any given library and showing all their authority settings. You can run this SQL statement using green screen STRSQL or from your favorite desktop SQL …
Restore and Rescope Logical Files When you restore a logical file, the system uses the description for the logical file to establish its relationship with the based-on files. For example, database views or indexes are logical files. You can restore a logical file to a library different than the library for the associated physical file. …
Lots of IBM i Deleted Records? Want to find the 100 Files with the most deleted records in them? Ready to purge those Beauties? For years us AS/400, iSeries and IBM i Techies have been using the Display File Description Command to create output files containing record counts for files. The traditional process is something …
There are a multitude of ways to check the IBM i OS version on your IBM i System (No it is NOT an AS400 or iSERIES machine – Don’t argue. Don’t!) You can do it from Control Language Programs You can do it from RPG programs You can do it from SQL You can do …
Special Authorities – What are they on IBM i? If you come from the world of IBM I you will have heard of *ALLOBJ authority. This is the ultimate level of object access authority on an IBM I system. *ALLOBJ literally means you are authorized to read, change, or delete any/all objects on the system! …
IBM i Authority is a wonderful beast with many layers of complexity. Like a big red onion, peeling back these layers is simple to do, but sometimes causes some tears, or occasionally full-on sobbing and weeping. The system can be anywhere from ultra secure to the other (naughty) end of the spectrum commonly known as …
Want to find LARGE Objects on your IBM i System? First we need to collec the information about the fat objects on our machine — The Retrieve Disk Information (RTVDSKINF) command is used to collect disk space information. Then we can print this information and/or query it — Disk space information can then be printed …
