Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
If you are just getting started with IBM i systems or you need a solid refresher on how the database really works under the hood, you have landed in the right place. Today we are going to walk through the complete hierarchy of IBM i data structures in a clear, step by step way. We …
One of the most common headaches when you integrate your IBM i with the outside world is converting data between EBCDIC and ASCII. You get a flat file from a PC, pull JSON from a web service, or process input from another platform and suddenly your strings look like garbage. The good news is that …
If you have read my previous blogs, you probably know that I recommend we all stop guessing file sizes and switch to SIZE(*NOMAX) for all physical files! Now for something a little more radical, STOP USING DDS and start defining your database objects with SQL instead! Upgrading from legacy DDS to SQL for defining tables, …
In almost all the IBM-i shops I’ve worked at, we have always set the initial size of physical files to what seems like a reasonable value. Quite often we just accept the system default of 10,000 records with three increments of 1,000 records each. Sometimes we tweak one or more of those numbers, usually the …
If you are developing software on IBM i systems then IBM Bob has probably caught your attention by now. This AI powered coding assistant lives right inside your IDE and acts as a smart programming partner that understands your full codebase. It helps you design, refactor, review and modernize code with real expertise in RPG, …
You know the drill. You fire up the IDE full of hope, and immediately get mugged by debugging hell, fossilized 90s RPG that smells of mothballs, pointless documentation, and soul-crushing code reviews. Absolute murder. Enter IBM BOB – my cheeky AI mate who actually enjoys hoovering up all that tedious programming guff for me. In …
Restoring IBM i Libraries to Different Names : The Hidden Problems (and How to Fix Them) Cross-Logical Files • SQL Temp Objects • Triggers • Procedures • Journals • Plus the DFRID(YES) Solution Today we’re diving deep into one of those IBM i gotchas that trips up even experienced admins: restoring a library to a …
If you are an IBM i developer looking to dip your toes into modern web content management, installing WordPress on your Power System is a fantastic starting point. WordPress powers a huge chunk of the web, and running it on IBM i brings that flexibility right into your AS/400 environment. What’s WordPress? WordPress is a …
In a less technical blog entry, come with me on a soggy, scenic road trip to the legendary Costa Blanca Pub – The Black Flame. The famous tongue-twister goes: “The rain in Spain falls mainly on the plain.” But today, it feels like someone rewrote the lyrics just for us. Right… repeat after me, slowly …
Mastering TURNOVER for IBM i: Project and Worklist Management Basics If you’re knee-deep in managing software changes on the IBM i platform, you know how crucial it is to keep things organized, auditable, and efficient. Today on the blog, we’re diving into TURNOVER for iSeries, specifically focusing on project and worklist management. This tool from …
IBM-i Independent Auxiliary Storage Pool (iASP) If you’ve ever wondered how IBM i handles advanced storage isolation, high availability, or multi-tenant environments without everything living in the basic system ASP, perhaps this video is for you. In todays presentation, I will take you through 18 slides that break down Independent Auxiliary Storage Pools (iASPs) from …
