Category: IBM i
-
PostgreSQL on IBM i
In this article I will show you how we can install and use the very popular PostgreSQL database on our IBM i. PostgreSQL is an open source relational database management system, a DBMS developed by a worldwide team of developers. It has been around since 1986 and now available on the IBM i. Install To…
-
A screen a story – Custom Charts. Is it a hidden gem?
If disk space fills up completely on IBM i, the system will eventually come to a stop. Before doing that it will get slower and slower. It is your task as a system administrator to prevent that from happening, In the past I have seen a wide variety of monitoring software keeping an eye on…
-
A screen a story – now you see me, now you do not
The life of a system administrator can be full of surprises. Things you have taken for granted, turn out to be completely different. Let me get directly to the point. All jobs being started on IBM i are logged in the history log, right?If you want to know the answer, you need to read on.…
-
Say hello to Power10 and go buy a POWER9
IBM has just announced the all new Power10 based E1080 model and it looks great! I recently wrote an article highlighting 10 things you should know about Power10, if you missed that, click here to check it out. At the moment we only have the enterprise version of the Power10 available to us which is…
-
Backup Performance
A while ago, I was asked to look at the performance during a Save 21 ‘Save the entire system’. Basically it took a little bit longer, as time went by, due to an increase in both the size and number of objects. However there were a couple of days when the backup took much longer.…
-
Northdoor plc partners with Skytap to help organisations get business critical applications into the cloud
Partnership offers unrivalled expertise in running on-premises IBM Power workloads in their native format on Microsoft Azure Northdoor plc and Skytap are delighted to announce a new strategic relationship which will offer organisations unrivalled levels of expertise in moving business critical applications that still reside in on-premises data centres into cloud environments. Some critical business…
-
Data-Queues with ODBC
In my last couple of PowerWire articles, I have written about using data-queues and about ODBC connectivity. If you need to refresh yourself of either of the articles, the data- queues article can be found here, with the ODBC article in the link here. In this article, we are going to combine those two features…
-
A screen a story – may the path be with you
In the life of system administrator SQL now a necessity. It can no longer be seen as something for developers only. The new Navigator for i is the living proof for that. When working with IBM i Access Client Solutions (ACS) Run SQL Scripts (RSS) you have the option to JDBC Configuration Default settings. The…
-
How to get the New Navigator for i
There has been a lot of positive feedback about the New Navigator for i (NewNav) interface and this is for good reason as this new IBM i Administration Interface really is a blueprint for what a modern interface should be like. As there are so many articles telling you why it’s better, I thought I’d…
-
Data-Queues and DB2 Services
In this article I will be taking a look at how DB2 SQL Services can help with using data-queues. Data-queues are a great way for open source to communicate with traditional objects on the IBM i. For example, an RPG program may place order details on a data-queue, where a Node.js program will pick up…
-
The new new in the New Navigator for i
The New Navigator for i has the potential to change the way people work with IBM i. If you are a developer or a system administrator, it does not matter here. Up to now we have all been using 5250 emulation, some of us on a daily basis. This New Navigator for i brings DB2…
-
Overview of New Navigator for i
The NEW Navigator for i is a great improvement on the present Navigator. It is modern (just look at the screen shots), responsive (3 seconds vs 10 seconds), and fairly comprehensive (Active Job columns 126 vs 31). Click the icon top left (looks like a stack of books) and you get a list view. Notice…