Top Stories and Breaking News
(Mouse over headlines to see story abstracts)
IT Jungle was created to help you figure out how to survive, adapt, and thrive in this complex IT ecosystem, whether you are an end user of information technology or a vendor of information technology products. We craft a set of online publications that focus on the core information technology platforms in use by enterprises the world over to do daily data processing, from the front-end Web systems to back-end accounting systems. IT Jungle publications are free to our subscribers.
Surviving A Change Management Migration
Townsend Ponders Future Of DB2 Modernization Tech
At The End Of The Power8 Long Tail
Systems Monitoring Made Easier, Better, GUI-er
Blue Stack Deadline Looms for JD Edwards Shops
IBM Patches 13 Security Vulnerabilities in IBM i JDK
Raz-Lee Claims Technological Edge with IBM i Encryption
DRV Check Printing Software A Laser Sharp Cost Cutter
IBM Delivers WebSphere 9 with Web Enablement for IBM i 1.1
A Second Look At SQL Descriptors
Side-By-Side Lists
New OLAP Aggregate Functions In DB2 For i, Part 2
A Generic Character Editing Routine
Formatting Dates With SQL, Take 3
New OLAP Aggregate Functions In DB2 for i, Part 1
What Price Power (Eight And Maybe Nine)?


The Platform

First, Kill All The Servers

Mesos Reaches Milestone, Adds Native Docker

Google Fosters Another OpenStack Kubernetes Mashup

Intel Broadwell Rollout Complete With Xeon E5 Quads

MIT Research Pushes Latency Limits with Distributed Flash

A Thirst For Petabyte Scale All-Flash Arrays

Are ARM Virtualization Woes Overstated?

Datacenters, Poised To Spend, Take A Breather From Intel

Stacking Up Oracle S7 Against Intel Xeon

Systems Are The Table Stakes For IBM's Evolution

HPC Flows Into Hyperscale With Dell Triton

IBM Quantum Computing Push Gathering Steam


Hit this link to see a full chronological listing of The Platform stories.


Columns


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.

Visit www.common.org/forum for details.




Discontinued Newsletters
TPM at The Reg
The Linux Beacon Big Iron The Windows Observer The Unix Guardian Four Hundred Stuff


Sponsored Links

System i Developer:  RPG & DB2 Summit - October 4-6 2016 in Chicago. Register now!
COMMON:  Open Source and Systems Management at the COMMON Forum. August 24-25 in Chicago.
LaserVault:  Webinar → Simplify IBM i backup and recovery. July 27, 2pm EST. Enter to win a drone!


Copyright © 1996-2016 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement
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.