Timothy Prickett Morgan
-
Paging Cursors And Position To
June 2, 2015 Paul Tuohy
… Read moreNote: The code accompanying this article is available for download here.
I had a reader email in relation to my article Paging Cursors. The article described a method for paging large lists using embedded SQL in RPG, and the reader was wondering if there was a way to position the list at a certain value. Of course there is!
Please refer to the original article for all of the gruesome details but the basic concept is that you have a subprocedure that returns a “page” of rows from a result set. A page can be any number of
-
Thoughts On The Power E850 And I/O Contraction
June 1, 2015 Hey, TPM
… Read moreSorry to be so late making my comment about your very good article concerning the Power E850 and IBM i. I agree with most of what you said in the article. I have had a couple of exciting conversations about the Power E850 with Mark Olson, who is an old friend from my Rochester days. The E850 brings back memories of when I worked for Rochester as the interface with Software Group and we were always two years behind on support for all the WebSphere products. It was all about the optics of being behind, not about the immediate need
-
Power8 Iron Gets New I/O Options
June 1, 2015 Timothy Prickett Morgan
… Read moreAs part of the rollout of slightly faster processors for the entry Power8 processors and the fleshing out of the high-end of the Power Systems line a month ago, IBM rolled out a bunch of new peripheral features and a new set of peripheral expansion units that will allow for Power8 shops both high and low to expand the amount of PCI-Express 3.0 peripherals that companies can attach to their systems than is currently possible on these machines.
Such I/O and storage expansion is important, given the ever-increasing amount of compute and memory that is being put into ever-smaller system
-
Job User Name And Current Job User
May 19, 2015 Patrick Botz
… Read moreI see developers make one mistake way more often than any other. They assume that the job user name also represents the user profile under which a job is currently executing. This is, and always has been, an invalid assumption. The job user name only represents the userID under which the job was originally started. The user profile that a job is executing under at any given point in time (i.e., the current user) may or may not be the same as the job user. This may seem like a trivial and harmless mistake. But it often isn’t.
In previous
-
Prevent Overlapping In Range Tables
May 19, 2015 Ted Holt
… Read moreIn Joining On Ranges, I demonstrated that range tables are a practical replacement for attribute columns. As a rule, ranges should not overlap. (Perhaps there are exceptions.) Here’s why, and also what to do to prevent overlapping values.
Overlapping ranges cause too many rows of the range table to join to a single row of another table, which in turn causes too many rows in the result set. For example, assume the following range table.
FROMITEMNUMBER THRUITEMNUMBER ITEMCATEGORY 134 134999 1 1341 134199 1 488 488999 2 2 299999 3Item 134120 would join to the first two rows
-
Is There No Midrange In The IBM i Midrange?
May 18, 2015 Timothy Prickett Morgan
… Read moreAs we reported in last week’s issue, IBM has indeed launched the four-socket Power E850 server that has Power8 engines. They run AIX. And of course they run Linux. The have support for the PowerVM hypervisor and they do not require the PowerKVM hypervisor that only supports Linux. The one thing that they do not support is the IBM i operating system and integrated database.
This is a remarkable moment in the history of the IBM midrange, and it is perhaps one that reflects the reality of the IBM i market or one that shows IBM is, once again, giving
-
New Power8 Midrange, PurePower Kicker To PureSystems
May 11, 2015 Timothy Prickett Morgan
… Read moreIBM is hosting its Edge2015 Power and System z conference in Las Vegas this week, and with the System z13 mainframes already launched in January to help that ramp get underway and bolster the company’s hardware sales, that leaves the final rounding out of the Power Systems line with Power8 processors as the star of the show. As expected, IBM is indeed launching its Power E850 four-socket midrange system, complementing the Power E880 high-end system that IBM let fly early (for some reason) ahead of the event. IBM is also including a new preconfigured cluster called the PurePower System, something
-
Ruby And Existing Databases
May 5, 2015 Aaron Bartell
… Read moreRecently I came across a scenario for a customer where I was asked, “How do we interact with our existing DDS-based, composite key, database tables?” That’s going to be a very common trait of most all IBM i shops using Ruby, and this article will cover some common situations you will come across as you use Ruby to interact with existing DB2 for i tables.
First things first, let’s lay out two tables defined with DDS, as shown below. Note how the ORDDTL table has a composite key. The ibm_db Gem follows the ActiveRecord pattern and that pattern expects surrogate
-
An Open Letter To IBM From A Developer
May 4, 2015 Garry Taylor
… Read moreThe only thing that I request from IBM, is the ability to develop software for their IBM i platform. Am I asking too much? I don’t think so. Allow me to elaborate. I have been developing on IBM i since 2008. In that time, I’ve used public systems, had the use of business partner’s machines, and way back in time I had my own 9401/150 developer system with all compilers installed. Recently though, I have been wishing to ramp up my efforts on IBM i, to develop more software, more seriously.
Now, on any other computer platform I can
-
IBM Upgrades High-End And Low-End Power8 Machines
May 4, 2015 Timothy Prickett Morgan
… Read moreIn last week’s issue, we told you that IBM was working on rounding out the Power8-based Power Systems lineup with a four-socket midrange machine rumored to be called the Power E850 and that it was also expected to expand the high-end Power E880 line with its full complement of Power8 processors. We didn’t expect hardware announcements at the COMMON midrange conference in Anaheim, but on Tuesday last week Big Blue went and put out some of the new Power8 iron anyway without doing a formal announcement.
Specifically, in announcement letter 115-021, IBM has added some processor options for low-end,