• 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

• In Search of Multi-Modal Data Integration

  May 5, 2021 Alex Woodie

  As the number of data sources that companies use goes up, so too does the complexity of the data pipelines that bring it all together. Instead of using a mix of different tools and technologies for ETL, ELT, and batch integration, some users are seeking a single multi-modal data integration tool that can deliver multiple integration approaches.

  One company providing multi-modal data integration is Equalum. The company’s DataOps offering works in various methodologies, including capturing real-time database updates using change data capture (CDC) technology; batch-based extract, transform, and load (ETL) and ELT; and REST- and SOAP-based data integration using …

  Read more

• Query Supervisor Gives Database Engineers New Power

  April 14, 2021 Alex Woodie

  One of the most exciting new features in the upcoming releases of IBM i 7.4 Technology Release (TR4) and 7.3 TR10 is the Query Supervisor. We recently caught up with Scott Forstie, IBM’s Db2 for i business architect, who gave us the low down on the new tech for controlling the database.

  Forstie told IT Jungle said that the Query Supervisor was the biggest new feature added to Db2 for i with IBM i 7.4 TR4 and 7.3 TR10, which IBM announced yesterday (see “IBM Unveils Spring 2021 Batch of TRs” for more news about the TRs).

  So, …

  Read more

Previous Articles Next Articles