Timothy Prickett Morgan
-
Tuning SQL Environments On i
November 3, 2015 Paul Tuohy
… Read moreOne of the frustrating things about being a speaker at conferences is that when you want to attend another session with a topic that peaks your interest, it invariably clashes with when you are speaking. But every now and again, the scheduling gods work in your favor. Such was the case recently, when I was speaking at the excellent International i-Power 2015 conference.
Scott Forstie, IBM‘s DB2 for i business architect, was giving a presentation, “IBM i Services – SQL interfaces into the IBM i operating system.” I had recently done an iTalk with Scott where we had chatted
-
Reflections Upon The RPG & DB2 Summit
November 2, 2015 Ted Holt
… Read moreReflections Upon The RPG & DB2 Summit
I just returned home from Chicago and another enjoyable learning experience at the RPG & DB2 Summit. This was the fourth consecutive Summit for me as a member of the session speakers group. I consider it an honor and a privilege to be teaching alongside people like Jon Paris, Susan Gantner, Paul Tuohy, Scott Klement, Barbara Morris, and many others. Each Summit has been very beneficial to me, and I suspect it is the same for others who attend.
Meeting and talking with the conference attendees is a treat for me. These are
-
How To Join The Power Linux Evolution
November 2, 2015 Timothy Prickett Morgan
… Read moreIt is hard to remember that IBM was not exactly sitting on the sidelines when Linux swept over the datacenter in the early 2000s in the wake of the dot-com bust. Big Blue saw the rise of Linux early on, among its supercomputer customers, and it was unsure how to preserve its revenue streams from AIX and OS/400 systems while at the same time embracing Linux. Here we are 15 years later, and it looks like IBM finally has its Linux act together on Power.
The question we all have is this: Will it make a difference? Hope springs eternal,
-
Let One Row Represent A Group, Take Three
October 27, 2015 Ted Holt
… Read moreFaithful reader Bill Cisne sent me an email with an SQL SELECT query. No comment, no explanation, just code. Bill had figured out how to use a lateral join to solve a problem and was kind enough to share his success with me. I have been aware of lateral joins for some time, but have not found a need for them in my work. Today I revisit a problem to illustrate one way that lateral joins can be useful.
LATERAL is a type of for-each loop within a query. For each row that a SELECT statement (the “outer” query) returns,
-
Using Adopted Authority Wisely
October 27, 2015 Patrick Botz
… Read moreIn my previous tip I explained adopted authority and admonished developers to use it wisely. This tip identifies some rules of thumb you should bear in mind when contemplating the use of adopted authority.
User profile to adopt: If you’re not used to using adopted authority in your applications, one of the first questions that comes to mind might be “which user profile should I adopt?” The most straightforward way to use adopted authority is to adopt the authority of the owner of the objects used by the application.
Rule: Create a user profile with ENABLED *NO, PWD *NONE, Initial
-
It Is Time To Tell Us What You Are Up To
October 26, 2015 Timothy Prickett Morgan
… Read moreNone of us in the IBM i community can do well by driving down the road at dawn without the headlights on, and without market research, we can’t tell where we are at and where we are going. Back in the early days of The Four Hundred, when having a midrange system at all made you cutting edge, rich data about the customers using these systems was available, for the clever at least.
We were among the clever, but we were dependent on other organizations to do the demographics and survey work that brought us those rich datasets, and
-
Power Systems Shows Growth Again For Big Blue
October 26, 2015 Timothy Prickett Morgan
… Read moreThe good news is that the Power Systems division of IBM‘s Systems Group turned in its third consecutive quarter of revenue growth, something that the Power community of customers, resellers, and software developers most certainly want to see. The bad news is that the rising U.S. dollar compared to other foreign currencies means that overseas sales translate into fewer greenbacks when sales are brought back to IBM’s New York headquarters, masking that growth.
IBM does not report revenue figures for the its Power Systems and System z server lines separately in its financial presentations, but chief financial officer Martin
-
CONST Doesn’t Mean You Can’t Change It
October 20, 2015 Ted Holt
… Read moreYou can pass parameters to an RPG subprocedure in three ways: by reference, by read-only reference, and by value. (I have written about this before.) My favorite method is read-only reference. I use it as often as I can. Would you believe that it is possible to change the value of a variable that is passed to a subprocedure by read-only reference? Since you would probably do so only inadvertently, it’s good to understand how it can happen.
To pass a parameter by read-only reference, include the CONST keyword in the procedure prototype and the procedure interface.
D Process pr
-
Developers Can Improve Security and Reduce the Administrative Cost of Security
October 20, 2015 Patrick Botz
… Read moreOne simple tool allows developers to improve the security of their applications and associated resources and reduce the administrative cost of managing security for the whole system. That tool is adopted authority. Adopted authority is an important tool for developers to have in their toolkit because it allows them to build applications that ensure users never encounter an authority failure even when administrators use PUBLIC(*EXCLUDE) authority on all sensitive resources. The combination of adopted authority and PUBLIC(*EXCLUDE) significantly increases the level of security and decreases the cost of managing security.
It’s true that system administrators can change programs to adopt
-
IBM Updates PowerVM Hypervisor, PowerVC OpenStack
October 19, 2015 Timothy Prickett Morgan
… Read moreIt may seem like the only thing that IBM cares about lately in the Power Systems business is boosting its Linux-based L and LC series lines. But as the latest Technology Refresh updates from October 5 demonstrate (which we have reported on extensively at IT Jungle in the past two weeks), Big Blue is keen on updating the software stack on which IBM i shops depend. And in some cases, this also includes the hypervisor and management tools, as well as Linux running next to IBM i.
In announcement letter 215-262, IBM is updating the PowerVM hypervisor that it