• What the Spring 2023 TR Brings Db2 for i

  April 26, 2023 Alex Woodie

  As the beating heart of the IBM i platform, the Db2 for i database received its share of attending from Rochester for the Spring 2023 Technology Refresh. Among the goodness becoming available next week are enhancements to the database proper as well as a gaggle of new and improved IBM i services.

  One database enhancement common to both IBM i 7.5 TR2 and 7.4 TR8 is an improvement to SQL-based Web services using specific data types. The database and its SQL dialect already supported working with character large object (CLOBs) from the SQL HTTP REST functions, and provided commands for …

  Read more

• PSGi Offers Field-Level Encryption for IBM i Database

  April 19, 2023 Alex Woodie

  IBM i professionals who are concerned about the disclosure of sensitive data in their legacy applications may be interested in a new field-level encryption utility from Precision Solutions Group (PSGi). The software essentially functions as an easy-to-use wrapper for IBM’s native Field Proc for database encryption, delivering flexible data protection for legacy applications.

  PSGi has made a name for itself by providing third-party maintenance and support for aging IBM i-based ERP systems. Customers running older applications like JD Edwards World, PRMS, PRISM, and KBM rely on PSGi to keep their ERP systems running well decades after they were first created. …

  Read more

• Stacking Up IBM i On Entry Power10 Iron Against Windows Servers

  April 3, 2023 Timothy Prickett Morgan

  Because of the dearth of commercial benchmarks that are run on IBM’s Power Systems machines these days, it is hard to make direct comparisons between machines based on Big Blue’s Power10 processor and the Windows Server and Linux platforms – generally an X86 system based on a processor from Intel or AMD. But it is not impossible to do.

  And it is an important exercise not because you are thinking of moving off the platform, which of course you are not contemplating, but because by doing this math you can show that it is not really much cheaper to buy …

  Read more

• LANSA Developing Business Intelligence Tool

  March 29, 2023 Alex Woodie

  LANSA is rolling out a new Web-based business intelligence tool. Dubbed LANSA BI, the new offering is based on an underlying analytics engine from Yellowfin and will be targeted predominantly at IBM i shops looking to give users greater access to actionable data.

  LANSA has used its fourth-generation language (4GL) development environment as a springboard for many other technological endeavors over the years. From Web and mobile modernization environments to application and data integration tools, from ecommerce engines to ERP suite, the Downers Grove, Illinois, company has been there and done that.

  It has even offered customers some rudimentary query …

  Read more

• VS Code Is The Full Stack IDE For IBM i

  March 15, 2023 Jeff Tickner

  Back in January, we talked a bit about the rise of the VS Code integrated development environment that was open sourced by Microsoft back in 2015 and that has been increasingly adopted by developers on all kinds of platforms, not just Windows Server. This week, we want to talk about the new features we are exposing in VS Code for users of the application development tooling available from ARCAD Software.

  First of all, we have brought the cross reference information in our ARCAD Observer tool into VS Code in a way that developers can access the object-level and field-level …

  Read more

• Db2 Web Query: Way More Than Just A Query Tool

  February 27, 2023 Alex Woodie

  You might be forgiven for thinking that Db2 Web Query is just a way to run your SQL queries on IBM i from a browser. After all, “Web” and “query” are right there in the name, aren’t they? But the product’s name belies the true nature of this multi-threat analytics application, which can do a whole lot more for IBM i shops than just run queries.

  IBM’s Doug Mack tackled this reality-assumption gap during a recent webinar on Db2 Web Query, which received a bunch of new capabilities with the recent version 2.4.0 upgrade. Mack, a longtime IBMer whose …

  Read more

• IBM i PTF Guide, Volume 25, Number 8

  February 27, 2023 Doug Bidwell

  We are playing catch up a bit here at the IBM i PTF Guide, and apologies for that but it goes that way sometime. There are a bunch of security vulnerabilities that you need to be aware of, including one that covers systems software not from IBM, as we usually track, but file transfer software from Forta (formerly known as HelpSystems). We are going to be keeping a closer eye on third party software security bulletins going forward.

  So first, we have CVE-2023-0669, which explains that GoAnywhere MFT from Fortra (formerly HelpSystems) suffers from a pre-authentication command injection …

  Read more

• RPG Use “Skyrocketed” Says IBM i Marketplace Report

  February 20, 2023 Alex Woodie

  RPG has always been the number one development language on IBM i, the platform with which it is most closely linked. But as open source languages like PHP and Java spread on IBM i, some speculated that RPG’s popularity would begin to slip. That hasn’t happened, according to Fortra’s most recent IBM i Marketplace Survey Results report. In fact, usage of RPG has “skyrocketed,” it says.

  From 2015 to 2020, the percentage of Fortra (formerly HelpSystems) Marketplace Survey-takers who chose RPG as one of their development languages stayed steady, hovering around the 84 percent to 89 percent level. Structured Query …

  Read more

• Infoview Systems Launches Lightweight CDC for IBM i

  February 13, 2023 Alex Woodie

  IBM i shops that have a need to extract the latest transactions hitting their Db2 for i database for downstream CRM, analytics, or fraud detection use cases may want to check out the new change data capture (CDC) offering unveiled recently by Infoview Systems. When coupled with a streaming data platform like Apache Kafka, CDC opens up new possibilities.

  Infoview Systems is a longtime IBM i product and services firm based in Michigan with a global customer base. The company has been active in the data and application integration space for years, first with the sale and implementation of message …

  Read more

• White Hats Completely Dismantle Menu-Based Security

  February 6, 2023 Alex Woodie

  Think menu-based security can prevent cybercriminals from accessing the most important parts of your IBM i system? Think again, as the white hat hacking group Silent Signal recently demonstrated in a real-world penetration test of a bank’s IBM i system through a seemingly restricted green-screen interface.

  Life was demonstrably simpler for midrange administrators before the Internet took off. Before we had all these different protocols providing access to applications and data – ODBC, FTP, SQL, Remote Command, etc. – an administrator could feel somewhat confident that users weren’t accessing things they shouldn’t by simply configuring their menus in a restrictive …

  Read more

Previous Articles Next Articles