A simple guide to SQL for AS400 Dummies You can spot my brethren fairly easily, the rare old-school AS400 developer can be found lumbering around your IT department. The trade mark style of these rare IBM Beasts is graying hair, a low-tech phone, typing with 2 fingers while muttering swear words under their breath. Counting

Read More

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

Read More

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

Read More

From AS400 to IBM POWER SYSTEM The IBM AS/400 was one of the most robust operating systems of the late 20th century. Fast forward to 2023 and the grandson of the AS/400 is the IBM Power System. This new generation of IBM BUSINESS SERVER is running the IBM i Operating System. IBM i is fully

Read More

Do you want to Create Different Subsystems for Web Services? There are a lot of positive reasons for us to create separate subsystems for each out our sets of applications. But if you read this blog entry then you already know that. So, assuming you want to do it — let’s stop blathering and dive

Read More

IBM i Subsystems IBM i Subsystems are used to control jobs and functions. A subsystem description defines how, where, and how much work enters a subsystem, and which resources the subsystem uses to do the work. IBM i is shipped with a standard set of subsystems The following subsystems are necessary for supporting user work: Interactive

Read More

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!

Read More

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

Read More

Have you got the “no authority to use system request functions” showstopper? If you are not authorized to see the System Request panel group (QGMNSYSR) you will see this error: How to Enable/Disable SysReq Menu Access The SYS/RQ function is controlled by the IBM Panel Group called QGMNSYSR. This lives in the QSYS library and this panel

Read More

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

Read More

Christmas has just finished – how do I slim down my IBM i System? I like to look in all the nooks and crannies for data that has been left behind, or simply accumulating and never being consumed. Data Queues are small and fast. The downside is that loading data queues over long periods of

Read More

AKA Command Line Access from System Request 3 If you are an IBM I software developer or power user – then that headline will make sense. In fact, I can guarantee that’s the only reason you discovered and are reading this page. System Request 3 makes every RPG programmer twitch 3 fingers ready to reach those

Read More