• 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

• The Fall Technology Refreshes Are Almost Here

  October 5, 2020 Timothy Prickett Morgan

  There has been a spring-fall rhythm to the cadence of software updates for along time, but the creation of the OpenStack cloud controller by NASA and Rackspace Hosting really snapped the commercial Linux distros into an April and October cycle of commercial rollups. And so, after many years of Technology Refreshes that follow the same rhythm, we come to expect updates to IBM i about now.

  And starting tomorrow, IBM will be rolling out the fall Technology Refreshes for the current releases. That would be IBM i 7.3 TR9 and IBM i 7.4 TR3. And these, unlike those partial Technology …

  Read more

• Does IBM i Need Its Own Zowe?

  September 30, 2020 Alex Woodie

  Getting open source software onto platforms like IBM i and System z is a big focus of IBM, its big iron customers, and the ecosystem of tool and service providers that tread these waters. In 2018, IBM, CA Technologies, and Rocket Software collaborated to create the Zowe framework as a part of the Linux Foundation’s Open Mainframe Project, with the goal to extend System z-based services into the greater open source IT landscape. Is it time for a similar effort on IBM i?

  When Zowe launched two years ago, the Open Mainframe Project (OMP) boasted that Zowe would “serve as …

  Read more

• IBM Rolls Out ACS 1.1.8.5

  August 12, 2020 Alex Woodie

  IBM last week introduced a new release of Access Client Solutions (ACS), the popular IBM i client that’s used by administrators, programmers, and engineers alike. There are enhancements to Run SQL Scripts, new 5250 viewing options, and a performance boost for viewing selected files on the IFS with version 1.1.8.5, among other mostly minor updates.

  According to the release notes associated with the new iteration of ACS, IBM made a handful of changes with version 1.1.8.5.

  Let’s start with the improvements to Run SQL Scripts, which is an increasingly popular utility in ACS that leverages the power of SQL and …

  Read more

• IBM i PTF Guide, Volume 22, Number 32

  August 12, 2020 Doug Bidwell

  It is another busy week here in the summer of 2020, there is a lot of activity among our IBM i customers, and this is a blessing indeed. Better to be too busy than not busy enough.

  In the interest of time, we will get right to the point. This week there is a new release of Access Client Solutions: 1.1.8.5. There is also new release of SPT (System Planning Tool): V211.

  Here’s the PTF rundown by release:

  PTF Groups 7.4:

  • Temporary Storage PTFs

  PTF Groups 7.3:

  • Temporary Storage PTFs

  PTF Groups 7.2:

  • Temporary Storage PTFs

  PTF Groups 7.1:

  • Nothing

  …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

• More Open Source Databases Coming To IBM i

  June 15, 2020 Alex Woodie

  IBM is in the process of bringing several new open source databases to the IBM i platform, including schema-less NoSQL databases as well traditional relational systems. Among the databases that Rochester is targeting are MongoDB, arguably the most popular NoSQL database and a favorite among Web and mobile developers, as well as PostgreSQL, one of the industry’s oldest and most widely used relational databases.

  Databases today almost are like programming languages, with developers mixing and matching databases to handle different functions, often within the same application. DB-Engines.com tracks more than 330 distinct databases, while there are somewhere around 700 programming …

  Read more

• Guru: Calling RPG Programs From Python, Part 1

  March 30, 2020 Mike Larsen

  In a prior article, I showed how to pass parameters to a Python script and execute the script from an RPG program. Based on feedback and my own curiosity, I wanted to see how I could pass parameters to an RPG program and call it from Python. After a bit of research, I found the Python interface itoolkit.

  itoolkit is an open source project provided by IBM as an interface to the XMLSERVICE toolkit, which allows us to call RPG programs, service programs, CL programs, and PASE Shell commands. itoolkit can be installed using an SSH terminal with …

  Read more

• Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL!

  February 10, 2020 Birgitta Hauser

  STRSQL, the green-screen facility for executing SQL Statements, has had its days. Nevertheless, many SQL users still prefer this legacy interface over the Access Client Solutions (ACS) Run SQL Scripts facility. Others use third-party tools to execute SQL statements. The common excuse has been that the Run SQL Script facility does not include a way to prompt SQL commands, tables, and columns. In ACS version 1.1.8.3, Content Assist includes prompting for SQL statements.

  Before ACS Version 1.1.8.3, no prompting was available within the Run SQL Scripts Facility. To access tables, views or materialized query tables (MQTs), we needed to know …

  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

Previous Articles Next Articles