• Guru: Using Identity Columns For Complex Keys

  February 17, 2020 Paul Tuohy

  In September 2019, Ted Holt published an article that demonstrated how an identity column can be used to generate a unique key in a table. In this article, I want to expand on that theme and examine another use of an identity column — replacing complex keys.

  Using an identity column in place of a complex key makes for much faster joins between tables, as you are joining based on two numbers as opposed to values of multiple columns. Identity columns also make for joins that are easier to comprehend, since they are based on just one column. This approach …

  Read more

• IBM Tweaks Prices Up And Down On Memory And Storage

  February 17, 2020 Timothy Prickett Morgan

  Big Blue usually tells customers about price changes on Power Systems hardware and related software, but we have not seen any such price changes in a long time. As it turns out, IBM is telling business partners through their normal announcement channels about any tweaks to price changes, but these are not showing up in the customer feeds that we have subscribed to for three decades.

  This could be deliberate, or accidental. We have no idea, and honestly, it would take too long to ask. But now we know, and an intrepid reseller made us aware of a recent price …

  Read more

• The Distinguished Professionals Of IBM i

  February 17, 2020 Timothy Prickett Morgan

  We use the term legacy a lot in the IBM midrange and mainframe markets, and not necessarily in the good way we talk about political leaders or business executives or sports stars all leaving a legacy behind of their body of work. I use the term when it means something precise – legacy applications, for instance, are the ones that originated back in time and that have not been modernized in any substantial way because perhaps they don’t need to be.

  I prefer the term vintage when I am talking about hardware and software releases because that conveys a …

  Read more

• Your ERP Contract is Worse Than You Thought

  February 12, 2020 Alex Woodie

  Marcus Harris knows a bit about ERP contracts and litigation. As a former lawyer for SAP and Infor, he’s the guy that ERP customers would have gone up against in court or a mediation room when a disagreement arises. But he switched sides and now he works on behalf of clients looking to hold their ERP vendors to account. He provided some worthwhile advice at the recent Digital Stratosphere 2020 conference in San Diego.

  Like most lawyers worth their salt, Harris would rather not represent you in court. Sure, it gives his firm, Taft Stettinius & Hollister LLP, lots …

  Read more

• Security Still the Top Concern as Privacy Regs Loom

  February 12, 2020 Alex Woodie

  For the fourth year in a row, security is the number one concern of the IBM i installed base, according to HelpSystems’ 2020 IBM i Marketplace Survey. IBM i shops are clearly concerned about the need to prevent unauthorized access to applications and data. But security’s first cousin, data privacy, also stands to gain more attention with the recent passage of data privacy laws, such as GDPR and CCPA.

  HelpSystems released the results of its latest marketplace survey last month, as it has done for the past six years. And just as it has for every year since 2017, security …

  Read more

• Why Koch Is Buying the Rest of Infor

  February 12, 2020 Alex Woodie

  Koch Equity Development last week announced that it has bought the remaining shares of Infor that it didn’t previously own. The move puts Koch Industries in charge of the world’s third largest ERP software company, and the IBM i market’s biggest vendor. But what, exactly, drove the $110-billion industrial conglomerate into making such an investment is the subject of some speculation.

  Infor, which has been flirting with an IPO for years, appeared to be on the fast-track for a Wall Street listing in January 2019, when it raised $1.5 billion in what, ostensibly, would be the last private equity …

  Read more

• Four Hundred Monitor, February 12

  February 12, 2020 Jenny Thomas

  We take great pride in being a respected and reliable purveyor of information in the IBM i ecosystem. But in order to distribute information, we have to find it. In the IBM i world, that data can be hard to come by. Fortunately for us, we have our editor in chief Timothy Prickett Morgan who is able to slice and dice whatever data nuggets he gets and coax out their relevance to our favorite platform. Another valuable resource for data are the surveys more and more players in the IBM i space are conducting. Your responses tell them about your …

  Read more

• IBM i PTF Guide, Volume 22, Number 6

  February 12, 2020 Doug Bidwell

  Alright people, the big news for the week is that Rational Developer for i, version 9.6.0.7, has just been released. Other than that, it has been relatively quiet on the PTF front. There are some nips and tucks for the three releases that are still being supported.

  They are as follows:

  PTF Groups 7.4

  • SAP support requited PTF list for IBM i

  PTF Groups 7.3

  • SAP support requited PTF list for IBM i

  PTF Groups 7.2

  • SAP support requited PTF list for IBM i
  • Temporary Storage PTFs

  PTF Groups 7.1

  • Nothing to see here, move along. . . .

  New …

  Read more

• The State Of The IBM i Installed Base, Part 1

  February 10, 2020 Timothy Prickett Morgan

  This is the time of the year that people assess where we are at so we can figure out where we are going. So we think it is appropriate to ponder the current state of the IBM i business.

  There isn’t just historical precedent for pondering the state of things this time of year; the pondering, in a certain way, drives history. The end of the prior year is mostly gone from memory and focus shifts toward fulfilling the promise of the current year. It is human nature to mark time this way, driven in part by the seasonal nature …

  Read more

• Thoroughly Modern: Resizing Application Fields Presents Big Challenges

  February 10, 2020 Timothy Prickett Morgan

  It sounds so simple. You need to change the size of one or more fields in one or more applications. How hard can that be? Quite time consuming and labor intensive, as it turns out, if you don’t do it right. To get a sense of the issues that companies face as they tweak the fields in their applications, we sat down with Ray Everhart, a product manager at Fresche Solutions, who knows a thing or two about this issue after many decades in the field.

  Timothy Prickett Morgan: Can you tell us a little bit about your experience in …

  Read more

Previous Articles Next Articles