• Guru: Keeping Track Of IBM i System Limits

  January 17, 2022 Dawn May

  Every complex system has limits, and computer systems are no different. During my work with clients over the years I’ve seen many shops push their systems as far as they can go until performance breaks down. The limits I encounter are generally numbers of things: How many objects can exist in a library? How many rows can be inserted into a table? How large can a file in the IFS be?

  Typically, these limits are large and you may think you do not need to worry about them, especially after an upgrade. But as the workload on your system …

  Read more

• IBM Preconfigures Power System Racks Running Oracle Database

  January 17, 2022 Timothy Prickett Morgan

  If you are one of the suppliers who still sells Unix and Linux servers for supporting back-end relational databases or platforms that compete against Unix and Linux iron, then Oracle is something you have to contend with either directly or indirectly. As the dominant database platform for running ERP, CRM, SCM, and other applications, you have to partner with Oracle even if you have to compete against the company.

  The good news is that at least Oracle no longer is selling big iron machinery based on the Solaris Unix and the Sparc processors that the company acquired when it bought …

  Read more

• IBM i Community Predictions For 2022, Part 1

  January 10, 2022 Alex Woodie

  While the month and year ostensibly are just values in the date field, when the calendar flips over from December to January, things feel different. There’s a greater sense of hope and optimism for what the new year will bring. Coming off another calamitous year filled with COVID-19, perhaps it’s we need that even more so this year.

  It has become an IT Jungle tradition to ask members of the IBM i community at the start of the year for their predictions. This year is no different, and so we’ll kick off the first part of our (most likely) two-part …

  Read more

• IBM i PTF Guide, Volume 23, Number 46

  November 17, 2021 Doug Bidwell

  If you are on older releases of IBM i 7, you are getting a breather this week when it comes to PTF patches for your systems. There just ain’t a lot going on, and in the operating system and security world, you take that as a win. Those of you on the IBM i 7.4 release, you have a few things to think about but it is fairly straightforward and related to the Db2 for i database and for those of you who have it, the Db2 Mirror for i database clustering software.

  Here is the rundown of PTF Groups …

  Read more

• Db2 PTF Group Enhancements Target Web Services, Audit Journal

  October 4, 2021 Alex Woodie

  It is indisputable that the Db2 for i database is the beating heart of the IBM i platform. There were no earthshattering enhancements to this database in the latest batch of Technology Refreshes for IBM i 7.3 and 7.4 that IBM announced and shipped last month. But there were a few items worth mentioning that shipped in the Db2 PTF Group, including new HTTP commands for calling the database via REST and new SQL-based commands for querying the security audit journal.

  The top new Db2 for i feature arguably is the new set of functions for HTTP requests to consume …

  Read more

• Calling All IBM i Platforms. . .

  August 16, 2021 Daniel Magid

  In a microservices world, all elements of what used to be monolithic application programs are now chunks of code linked to each other using any number of application programming interfaces, or APIs. Those APIs can be based on a remote procedure call, or RPC, architecture, which is a kind of generic distributed client/server approach, or the REST – short for representational state transfer – architecture favored by parts of the commercial Web software stack that has dramatically grown in popularity in the past two decades. Either way – and in fact, there are more than two ways – APIs are …

  Read more

• Innovating And Thriving with IBM i

  July 26, 2021 Alex Woodie

  You may have noticed that the IBM i server has developed a certain reputation, and it’s not always a good one. There are folks among us who consider IBM i to be a “legacy” platform, something that should be invested in as little as possible and moved away from at the earliest convenience. But as a panel of experts at the recent OCEAN conference demonstrated, it is possible to not only innovate on the IBM i, but to create a culture where the business and its employees can thrive.

  The Orange County Educational Advancement Network, or OCEAN, pulled together …

  Read more

• Altova Updates Db2 for i Support Across Product Line

  July 14, 2021 Alex Woodie

  IBM i shops that use data and development tools from Altova will be happy to know that the software vendor has added support for the latest release of Db2 for i among several of its tools.

  Altova is a Beverley, Massachusetts, company that develops a series of software tools and utilities for developers. The company is arguably best known as the creator of XMLSpy, an IDE that allows developers to create XML-based Web services using standards like WSDL; it later added support for JSON data and the modern SOAP protocol.

  In 2010, Altova added support for IBM i in MissionKit, …

  Read more

• Guru: Understanding Database Performance Using The Performance Data Investigator, Part 2

  June 28, 2021 Dawn May

  This is the second in a two-part series on how you can use the Performance Data Investigator (PDI) to investigate performance of Db2 for i. While the SQL Performance Center in Access Client Solutions is more commonly known than PDI, using both tools is a good way to analyze database performance.

  In Part 1, I reviewed the Database content package, focusing on the charts for I/O reads and writes, SQL CPU utilization, and database locks. In this tech tip, I continue by reviewing the charts related to SQL Cursor and Native DB Opens as well as the SQL Performance …

  Read more

• Guru: Understanding Database Performance Using The Performance Data Investigator, Part 1

  June 21, 2021 Dawn May

  This is a two-part series on how to use the Performance Data Investigator (PDI) for investigating performance of Db2 for i. While the SQL Performance Center in Access Client Solutions is the tool of choice for Db2 performance analysis, there is valuable information that you can get from using PDI. PDI is often a useful starting point to help guide you in the correct direction when trying to identify performance issues. In my experience, PDI is under-utilized for Db2 investigation. For those not familiar with PDI, you may want to read the article, Getting Started with the Performance Data Investigator …

  Read more

Previous Articles