DB2 for i Archives

Matillion Founder Recounts Midrange Roots

February 24, 2021 Alex Woodie

In the mad rush to build data warehouses in the cloud, there’s one group that’s doing surprisingly well: ETL tool providers. Despite the sophistication of today’s AI and analytic endeavors, ETL tools are a critical link in the chain to the cloud. And one of the up-and-coming vendors in this space is Matillion, which last week raised $100 million in venture capital.

Matillion was founded in 2011 to help companies build cloud data warehouses. The Anglo-American firm developed expertise in taking companies’ corporate data from on-premise systems and building data warehouse on emerging cloud systems, such as Amazon Web Services’ …
Read more
Guru: Prompting Stored Procedures

February 22, 2021 Paul Tuohy

In this tip I would like to touch on two items, in relation to stored procedures, that may have escaped your notice: prompting stored procedures and/or parameters (in Run SQL Scripts) and passing parameters by name.

I must admit that, as I have gotten older, my ability to remember the names and parameters for stored procedures has, shall we say, decreased. At this stage, I am lucky if I can remember which library/schema one of my stored procedures is in!

A case in point. I recently received an e-mail about a stored procedure I had written about (back in 2015) …
Read more
2021 Predictions for IBM i, Part 1

January 13, 2021 Alex Woodie

With an eventful 2020 thankfully in the rearview mirror, it’s time to start thinking about what 2021 might have in store for us. The IBM i community, like most of the world, could use a little bit of hope at the moment. We asked IBM i community leaders to deliver predictions, and they responded.

Liam Allan, who is a consultant at Seiden Group and the creator of ILE Editor, has a couple of predictions for IT Jungle.

“My focus is mainly software. I do still predict Node.js gaining traction on IBM i,” Allan writes. “The tooling is really …
Read more
Guru: SQL and QTEMP

January 4, 2021 Ted Holt

Hey, Ted.

For many years IBM i developers, operators, and others have taken advantage of an operating system feature called the QTEMP library. Through the years you have referenced it various times in IT Jungle as a useful feature of IBM i. I recently read an article in which a respected IBM expert from the Rochester lab services team told people not to use the QTEMP library when working in SQL. It would be very interesting if you could dive into this topic and explain when/if there is still a time and place for QTEMP. I think a lot of …
Read more
MariaDB Now Available Via RPM

December 7, 2020 Alex Woodie

When it comes to databases for the IBM i community, Db2 for i is, and always be, number one. But there’s no reason to limit yourself to just one database, and now IBM is making it easier for IBM i shops to get their hands on MariaDB, which could be the number two database on the platform.

MariaDB is an open source relational database that is a fork of MySQL. MySQL, of course, has been supported on the IBM i server for many years. But following Oracle’s acquisition of Sun Microsystems, which had acquired the company that developed MySQL, …
Read more
Open Source The Path To Software Riches For IBM i

December 2, 2020 Alex Woodie

For what is supposed to be a proprietary platform, the IBM i server sure has a lot of open source software running on it. In recent months, it appears that the majority of new programs introduced to IBM i are open source in nature. That pattern shows no signs of changing any time soon, according to a recent report by OpenLogic.

Open software has existed on the IBM i platform for many years. The first highly publicized dip into the open source well occurred in 2005, when IBM partnered with a company called Zend to bring its PHP runtime to …
Read more
Guru: SQL Writes CL

November 30, 2020 Ted Holt

SQL is the one tool I cannot work without. Take it away from me and I’ll start driving a truck for a living. Naturally I’m eager to find more ways to make SQL work for me. Today I’d like to share how I recently used SQL to write a huge CL command for me. This is a technique that’s good to know.

My challenge was to copy all of the several hundred physical data files in a library to a save file so that those files could be loaded onto another IBM i system. The Save Library (SAVLIB) command was …
Read more
Trinity Guard Unveils New Tools for Linux, Db2 for i

November 18, 2020 Alex Woodie

Trinity Guard is on the move. The Houston, Texas, based security software company, which is the spiritual successor to the PentaSafe products, is rolling out a full auditing solution for Linux. It’s also developing a Linux version of its security management tool, TGCentral, with an AIX version up next. Plus it’s months away from releasing an encryption solution for Db2 for i.

2020 has not been easy for anyone, but it’s not stopping the folks at Trinity Guard from moving forward on its roadmap items. Near the top of that list is increased support for running on Linux, which has …
Read more
Db2 And SQL Services Get Upgrades With TRs

October 12, 2020 Alex Woodie

Among the biggest enhancements that IBM is bringing to IBM i with the latest batch of Technology Refreshes are new capabilities added to the integrated Db2 database and, specifically, the slew of SQL-based services that retrieve all types of data from the platform for IBM i professionals.

As we previously told you, IBM has decided to rename SQL Services, which were the collection of pre-defined SQL queries that recreate traditional IBM i commands and sometimes bring something entirely new. The growing gaggle of services (or perhaps it’s a herd?) are now being officially referred to as IBM i services, …
Read more
How The Latest TRs Bolster The Core IBM i OS

October 7, 2020 Alex Woodie

Yesterday was Technology Refresh (TR) day for IBM and its IBM i operating system, and Big Blue didn’t disappoint. The company unveiled new releases of IBM i 7.4 and 7.3 that bring a slew of new capabilities to the core operating system as well as surrounding offerings like Db2 Mirror, ACS, and RDi. In this article, we’ll look at enhancements to the core OS and related key features.

During a COMMON webcast Tuesday, IBM i Chief Architect Steve Will touched broadly on a number of enhancements that soon will be available in the TRs. Most of the new capabilities will …
Read more

Content archive

Recent Posts

Subscribe

Pages

Search