• Guru Classic: Tuning SQL Environments On i

  March 4, 2020 Paul Tuohy

  Author’s Note: This article was originally published in November 2015. This was one of the first DB2 for i Services that I used in anger. I have used a lot since.

  One of the frustrating things about being a speaker at conferences is that when you want to attend another session with a topic that piques your interest, it invariably clashes with when you are speaking. But every now and again, the scheduling gods work in your favor. Such was the case when I spoke at the excellent International i-Power 2015 conference at Wyboston Lakes Executive Centre in the UK. …

  Read more

• Latest TRs For IBM i Now Available

  November 20, 2019 Alex Woodie

  IBM last week delivered the latest IBM i operating system Technology Refreshes, giving good IBM i boys and girls around the world early Christmas presents in areas like programing, operations, database, and security. Here’s a quick recap of the new stuff in IBM i 7.4 TR1 and 7.3 TR7.

  There were several general enhancements with IBM i 7.4 TR1 and 7.3 TR7. For starters, administrators gained more control over resources available to the Integrated Web Server (the one powered by Apache) with the new capability to install it the Web server in a user-specified sub-system. Admins also get new functions …

  Read more

• Digging Into the Latest IBM i TRs

  October 23, 2019 Alex Woodie

  The fall batch of Technology Refreshes (TRs) have been revealed, and as expected, there’s a bit of new functionality available for customers who use IBM i 7.3 and 7.4. In this story, we’ll tackle enhancements in open source, systems management and monitoring, and development, which means we’ll dive deeper into other areas, like database and HA/DR, in a future story.

  Let’s start with the fun stuff: open source. With IBM i 7.3 TR7 and 7.4 TR1, IBM has brought support for two prominent open source projects, including ZeroMQ and Redis.

  ZeroMQ is a universal messaging library that allows users to …

  Read more

• IBM Bolsters ACS with Database and Administrative Goodies

  May 15, 2019 Alex Woodie

  Amid the many enhancements that IBM has delivered with IBM i 7.4 and IBM i 7.3 TR6 is a new release of Access Client Solutions (ACS), which has become the go-to client interface that many IBM i professionals use to access the system for a variety of tasks. Database engineers and system administrators are the big winners with this release.

  There’s no denying that IBM delivered a whopper of release with IBM i 7.4 and its sidekick, IBM i 7.3 TR6. There’s been so much news – starting with the availability and security enhancements in Db2 Mirror and Authority Collection …

  Read more

• R Comes To i

  May 1, 2019 Alex Woodie

  IBM is now officially supporting the language R with its IBM i operating system, the company announced last week. The open source language, which has long been a favorite of data scientists, statisticians, and others involved with scientific computing, gives IBM i an immediate boost when it comes to data mining and machine learning.

  The R language was originally developed 25 years ago by a pair of computer science professors, Ross Ihaka and Robert Gentleman, at the University of Auckland, New Zealand. The software, which was developed largely in C and Fortran, was based largely on S, a programming language …

  Read more

• Five Skills You Don’t Need To Manage IBM i (And Two You Do)

  March 25, 2019 Tom Huntington

  (Sponsored Content) Much has been said to debunk the myth of an IBM i skills shortage or decry it as a disappearing act. Yet, year after year, respondents to the annual IBM i Marketplace Survey by HelpSystems list IBM i skills as a top concern. The results also show that organizations are addressing these concerns by adding automation, modernizing development, and getting rid of obsolete technology that breeds the dreaded word: legacy.

  But why do we on IBM i continue to carry the perception that so-called “IBM i skills” are scarce? Is it because the keywords in …

  Read more

• Building Out The .NET Stack Around Mono for IBM i

  March 13, 2019 Alex Woodie

  The first release of a Mono .NET port to IBM i was issued last year. Since then, the IBM i open source community has been busy building many of the other middleware components that will make it easier for developers to build IBM i applications using Microsoft tooling.

  Mono was ported to AIX and IBM i (via the PASE AIX runtime) last year, which gave IBM i and AIX shops the capability to run the open source .NET runtime on Power Systems servers, thus opening the door to allowing Microsoft‘s highly regarded suite of development tools to be …

  Read more

• MB Software Gets A Handle On Remote SQL Jobs

  November 28, 2018 Alex Woodie

  System administrators who get frustrated with the inability to see which SQL jobs coming in through ODBC are causing problems on their IBM i server may be interested in a product called Work with Active SQL (WRKACTSQL) from MB Software and Consulting, which recently announced the tool will be free through the end of the year.

  SQL is just about as close to a universal language for business as you can get. While there are other (i.e. “native”) methods of fetching data from Db2 for i, nearly three-quarters of IBM i developers report using SQL, making it the number two …

  Read more

• What Is Happening With RFEs For IBM i?

  October 29, 2018 Alex Woodie

  IBM customers have been encouraged to vote on product enhancements for over a year as part of the Request for Enhancement (RFE) process, and a number of new features have actually made it into IBM i technology refreshes (TRs). What new or improved IBM i functionality will Big Blue work on next?

  It’s hard to say exactly which RFE items will strike a chord with IBM product managers, since the requests can be all over the board and impact a range of components, from the IBM i OS itself and the Db2 for i database to Access Client Solutions (ACS) …

  Read more

• Kisco Bolsters Network Socket Security

  October 10, 2018 Alex Woodie

  IBM i shops that are serious about security should monitor all potential ingress routes into their computer systems, including network socket connections. Now Kisco Information Systems is supporting the latest network socket technology in IBM i 7.2 with its network security tool, SafeNet/i.

  The Internet is a double-edged sword. On the one hand, the network itself and its array of supporting technologies allow companies to connect with customers on the other side of the world in powerful and potentially lucrative new ways. But on the other hand, the Internet also allow intruders on the other side of the world to …

  Read more

Previous Articles