Informing the IBM Community

Author: Andy Youens

  • Service Commander on IBM i

    In this article I will talk about another great open-source utility for our IBM i. Firstly, what a great name! Service commander was developed by Jesse Gorsinski, the business architect of open source on IBM i. The github repository for Service Commander can be found at https://github.com/ThePrez/ServiceCommander-IBMi Check-out this repository, not only to see the…

  • Logrotate on IBM i

    In this article I will talk about an open-source utility that hasn’t got much airspace since it was released on our IBM i. Its called logrotate, a handly utility that can help us manage the many logs we have on our IFS.  As we all know, log files can easily get out of hand.  How…

  • 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…

  • 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…

  • 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…

  • Open-Source Package Management Signon

    For those of you who follow either my articles on PowerWire or my videos at learning.formaserve.co.uk you will know my inclination over the past few years is in Open-sourceon the IBM i, and one of the easiest ways of obtaining packages is via the Access for Client Solutions (ACS) application from IBM, unless you are…

  • ODBC & Node.js on IBM i

    In this article I will be looking at database access using Node.js on our favourite platform the IBM i. A bit of background info first. One of the first applications we wrote in Node.js had to access an audit log that was stored as a traditional table, physical file.  It had to both read and…

  • A Java on IBM i Intro

    A bit different this one.  I was recently asked by a fellow IBM Champion to give him a quick run through on Java on the IBM i, so I thought I would write a quick article on this topic for others out there. Installation of Java Java has to be installed on our IBM i…

  • IBM Champion Tweets

    As you will hopefully know, in my last few arcticles for PowerWire, I have been writing about retreiving tweets and storing them in a SQLite database on the IBM i. I have a scheduled job on my IBM i that finds the tweets that have the hash tag #IBMChampion. Now we have a few weeks…

  • SQLite and a Node API

    my previous article, we went through how easy it was to call a Twitter API, searching for a string and storing that tweet in a SQLite database stored on the IBM i using Node.js. Before we get around to analysing the records we have stored over the last month or so, we need a method…

  • SQLite – Store Tweets

    In my previous article, I revealed how easy it is to use an open source database called SQLite on our IBM i server. If you need a refresher, that article can be found on the link here. In this article, I’ll show you all how easy it is to use this lightweight database.  Including it…

  • SQLite – What is that?

    In this article, I’m going to show you another database option we now have on our IBM i. All these choices!  Little did we think we would have any alternative for a database, we expected only to have the excellent DB2 for i. So, what is it? SQLite is a serverless database, self-contained and is…