• Guru: Content Assist Plus in Run SQL Scripts

  November 29, 2021 Paul Tuohy

  By now, you should be well aware that Run SQL Scripts provides content assist (promoting) for Select statements (see Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL! ). But did you know that you can also use content assist for stored procedures, table functions and parameters? Let’s see how it works, using some of the Integrated File System (IFS) procedures and functions provided by IBM i Services.

  Prompting a Stored Procedure

  Open Run SQL Scripts, type in:

  call qsys2.
  

  Then press F4 (or Ctrl+Space). You will be presented with a list of all the stored procedures in the schema …

  Read more

• New LTO 9 Gear, SAN Switch On Tap From IBM

  November 29, 2021 Alex Woodie

  IBM i shops facing a storage crunch may be interested in new tape products unveiled by IBM last week, including a new LTO 9 tape drive and LTO 9 compatibility for an existing tape autoloader and an existing tape library. Big Blue also announced LTO 9 compatibility for an existing storage enclosure, and a new 48-port c-type switch for connecting SAN environments.

  IBM’s LTO fun starts with the IBM TS2290 SAS Tape Drive Model H9S, a half-height drive based on the new LTO 9 Ultrium specification. The TS2290 connects to hosts – including Power servers running IBM i, AIX, …

  Read more

• A Shot Across The Bow For Power8 Upgrades

  November 29, 2021 Timothy Prickett Morgan

  Sales of new Power8-based Power Systems machines by Big Blue have not been possible for years, but customers with existing Power8 iron have been able to get what IBM calls miscellaneous equipment specification, or MES, upgrades of their existing systems to add processing capacity to those vintage machines.

  The Power8 lineup, launched in April 2014, and the entry machines in the Power8 lineup were withdrawn at the end of February in 2019, an announcement that IBM made in October 2018 to give customers fair warning. In February 2019, IBM said that it was going to withdraw high-end Power8 machinery …

  Read more

• Security Threats, They Are a Changin’

  November 17, 2021 Alex Woodie

  Ransomware came into 2021 like a lion, but rather than going out like a lamb, it seemed to get bigger and meaner. Even IBM i shops, which so often are protected from the wider security storm, felt the panic and sense of helplessness of having their previous data held for ransom. But early indications are that the security threat we’re talking about this time next year may be entirely different.

  It’s tough to overestimate the impact that ransomware had on American businesses and other institutions through the course of the year. We had indications that something big was unfolding a …

  Read more

• A Year Later: Diving Deeper into How Connectria Brings IBM i Workloads Closer to AWS

  November 17, 2021 David Wilderman

  Connectria has worked in the IBM i and AIX hosting business since 2000. We have strong expertise in both IBM and cloud; we’ve offered IBM i private cloud services and support for more than a decade. We work with a great deal of Power Systems users who are making strides toward the cloud, as many have in the last year thanks to soaring cloud demand in the wake of the pandemic.

  Traditionally, we have helped IBM users by augmenting their existing staff as they retire or turnover by handling production workloads and delivering managed services with capability, not just hardware. …

  Read more

• New OpenLegacy Product Creates ‘Tech-Agnostic’ Services

  November 17, 2021 Alex Woodie

  OpenLegacy recently announced OpenLegacy Hub, or OL Hub, a new offering designed to help customers create technology agnostic digital services from existing legacy applications and infrastructure. The offering supports IBM i and z/OS assets, among other platforms that are commonly grouped under the “legacy” banner.

  Since it appeared on the midrange scene back in 2015, OpenLegacy has been looking to help IBM i and mainframe customers extend their existing systems in new and profitable ways. Led by tech veterans from IBM and Software AG, the Israeli company created a development environment that could analyze legacy programs, such as 5250 …

  Read more

• Four Hundred Monitor, November 17

  November 17, 2021 Jenny Thomas

  While those of us in the Jungle are looking forward to the Thanksgiving break next week here in the U.S., which brings some much-needed downtime to recharge before the race to the end of the year, the folks at IBM are charging forward in the week following its formal separation from Kyndryl. Much of the news this week is focused on the aftermath and what we can expect from IBM now that it can redirect its all of its energies toward itself once again. Hopefully this refocus will result in good news for our little slice in the week and …

  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

• Bang For The Buck For Big Power Iron Over Time

  November 15, 2021 Timothy Prickett Morgan

  With the shipments of the “Denali” Power E1080 server ramping at IBM, we have also been ramping up our analysis of the machine to help the relative few of you IBM i shops – on the order of hundreds – who will need to upgrade your Power 795, Power 770, Power 780, Power E870, Power E880, and even possibly your Power E980 machines to the new top-end Power Systems NUMA server.

  But make no mistake. What IBM is doing with the Power E1080 in terms of performance and price/performance bears relevance, indirectly and somewhat more directly, on each and every …

  Read more

• Talking Certified Pre-Owned Equipment With Arrow

  November 15, 2021 Timothy Prickett Morgan

  Arrow Electronics is one of the three master distributors of IBM Power Systems machines and related storage in North America, and it also has decades of experience selling secondhand equipment as well as new gear through its partnership with IBM.

  Recently, Arrow has partnered with IBM so its resellers can offer their Power Systems and Storage customers certified pre-owned equipment that has been put through the remanufacturing processes of IBM’s Global Asset Recovery Services business. This is now the sole means by which Arrow is helping its resellers bring CPO machinery to Power Systems and Storage shops that, for many …

  Read more

Previous Articles Next Articles