Top Stories and Breaking News
(Mouse over headlines to see story abstracts)
Featured Product: COMMON
Do you need to know more about Open Source
languages or Systems Management
to support your on-the-job initiatives?
The COMMON Forum
will give you the skills you need to get started.
All sessions are taught by experts that understand the work you do on Power Systems and IBM i.
Join us August 24-25 in Chicago.
June 18, 2016: Volume 18, Number 25|
June 11, 2016: Volume 18, Number 24
June 4, 2016: Volume 18, Number 23
May 28, 2016: Volume 18, Number 22
May 21, 2016: Volume 18, Number 21
May 14, 2016: Volume 18, Number 20
Copyright © 1996-2016 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034
Software migrations are the root canals of enterprise IT. Rarely do you find anyone looking forward to them. That's not to say they are not being considered. High maintenance fees and minimal enhancements have encouraged software replacement strategies to become more widespread than they were just a few years ago. In the IBM midrange community, where application and database modernization is at the top of the priority list, migration obstacles--risk and complexity--are being overcome.
What will Townsend Security do with the potentially groundbreaking technology it created to solve a thorny encryption issue in DB2 for i? While the Olympia, Washington-based company is not interested in getting into the database modernization business, it is open to the possibility of licensing its innovative technology--which essentially uses Open Access for RPG to replace record-level I/O calls in legacy RPG apps with the SQL Query Engine--to people who are.
Largely for economic reasons relating to IBM's high costs in chip manufacturing and relatively low chip volumes, the Power Systems platform left the familiar cadence of Moore's Law progress quite a while ago. IBM stretched it out to three years or more between processor cycles, and here we are in the middle of 2016 and we are still probably at least a year away from the Power9 launch. At the tail end of any product cycle revenues are bound to dip, and this is precisely what is happening to segments of the Power Systems line
With the introduction of its newest systems management software, HelpSystems is showing off what it can do by merging its traditional Robot line with an acquired product from the CCSS family of tools. Raise the curtain, please, on Robot Monitor 14, a feature enhanced version of what was formerly known as CCSS QSystem Monitor now integrated with the Robot IT operations management and infrastructure monitoring software stack
In just over two months, JD Edwards shops that run EnterpriseOne ERP software on the "Blue Stack" of IBM middleware, including DB2 and WebSphere products, will no longer be able to get technical support for those products from Oracle. Customers have had nearly six years to prepare for the September 30 deadline, but there are those who have yet to make a decision. Luckily, Blue Stack stragglers still have options available to them.
Time to shore up your Java. Last month IBM patched 13 security vulnerabilities that impact the Java Development Kit (JDK) for IBM i versions 6.1, 7.1, 7.2, and 7.3. The flaws range from being small nuisances to severe, particularly the four flaws that earned perfect 10s on the CVSS impact scale.
IBM i shops that are on the hunt for an encryption solution to protect their sensitive data may want to check out the latest from Raz-Lee Security. The New York-based software company recently announced that it's leveraging IBM's FieldProc technology to deliver field-level encryption that's unlike anything else on the IBM i market. The company also announced a new PGP encryption solution.
Life is full of surprises. For example, why would a company rely on pre-printed, continuous-form checks printed on impact printers? It would seem that simply becoming aware of impact printer prices would prod a decision maker into searching for an alternative. Every company is supposed to have a cost-cutting watch dog. And that dog is also supposed to be watching for ramifications to low cost--things like weakened security and performance degradation.
IBM i shops that are eager to get their hands on the latest release of the WebSphere Application Server can now do so. On June 24 IBM started shipping IBM Web Enablement for i version 1.1, which includes WAS version 9. Interesting bits shipped with the new release of WebSphere include support for Java 7, integration with Watson cloud services, new API features, and new containerization options, among other features.
My previous article, A First Look at SQL Descriptors, looked at how SQL descriptors can be used in constructing and processing dynamic SQL statements. This article examines how SQL descriptors can be used in processing the information returned through a dynamic SQL statement.
An end user has asked me to provide him a spreadsheet with two independent lists, one beside the other. Can I use SQL to satisfy his request?
In my last article, I promised to tell you about four new OLAP aggregate functions: FIRST_VALUE, LAST_VALUE, nTH_VALUE and RATIO_TO_REPORT. These valuable functions can reference data from other rows in a query result set relative to the current row. This tip covers the fourth function in the list, RATIO_TO_REPORT.
Recently I was asked if I knew of a way to edit character strings. For example, take a character string representing a product code such as "AX12345Q" and edit it to produce "AX-123-45 Q". My initial reaction was to reach for an edit word, but sadly they only work for numerics, for some strange reason. I set about building a subprocedure that offered the necessary flexibility in insert characters and also added a few "defenses" against mismatched parameters.
I love it when someone improves something I've produced. In this case, that someone was Barry Arnold, an A-1COBOL programmer with whom I had the privilege to work once upon a time. Barry improved my FMTDATE SQL function for use in his shop. Maybe his enhancement will help you, too.
In my last tips about the new OLAP features in DB2 for i 7.3, I discussed the OLAP Aggregation Specification and the new LAG and LEAD OLAP functions. In this article and the next one, I continue the discussion of new OLAP features by highlighting four new OLAP aggregate functions: FIRST_VALUE, LAST_VALUE, nTH_VALUE, and RATIO_TO_REPORT. The value of these functions is that they can reference data from other rows in a query result set relative to the current row.
Call me old school if you want, but I believe in Moore's Law and I believe that IT vendors have to keep giving customers more bang for the buck if they want organizations to keep investing in technology. There are basically only two levers to help push a new technology into the market, and that is increasing the performance of a device or lowering its price, the latter hopefully occurring if the cost of production comes down but sometimes not as vendors seek to maximize their profits and make it up with performance leaps.