Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
IBM i HTTP Web Server Authentication using an IBM i User Profile and Password We tend to think of consuming a webservice (“connecting and reading from a webservice”) as something that is open to the public. But what if we want to add an extra level of authentication? How about we force the connection to …
Hey IBM i System Admins, do you sometimes have stress filled, worrying and just plain weird dreams of being chased by gremlins, goblins and goobers? Are you losing sleep over the thought of your precious IBM i platform becoming a hacker’s piñata? Fear not! The IBM i is built like a digital fortress, guarding your …
If I don’t like poetry. I especially don’t like it when people call it ‘Poyetrey‘ in that weird pronunciation way… but… this poem, just blows me away: IF – Rudyard Kipling If you can keep your head when all about you Are losing theirs and blaming it on you, If you can trust yourself when …
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 …
Control Command Line Access Here is a brief guide on how to control command line access for IBM i users: IBM i User Limited Capability Feature The Limit Capabilities feature in IBM i allows you to control the ability of a user to run CL commands at a command line by specifying the LMTCPB (Limit …
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. …
Have you ever seen a ‘Library QTEMP not found’ error? Weird Huh? After some head scratching we figured it out – this IBM i Power System is using an Independent Auxiliary Storage Pool (aka iASP). The previous administrators had installed and configured the iASP, but then decided to change the core IBM i System commands …
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 …
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 …
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 …
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 …
